Authenticating in Snowflake

Stream Pipelines supports the use of a key pair (public-private key pair) authentication method for the purposes of enhanced authentication security.

  1. Select Data Fabric > Pipelines > Destinations.
  2. To create a Snowflake destination, click Create new.
  3. In the Create a destination dialog box, click Snowflake.
  4. Specify this information:
    Name
    Specify the name of the destination.
    Description
    Optionally, specify the description for the destination.
    Account URL
    Specify the Snowflake account URL.
    Database
    Specify the Snowflake database.
    Username
    Specify the Snowflake user name.
    Role
    Specify the Snowflake role of the user.
  5. To generate a public-private key pair, click Generate public key.
  6. Copy the generated public key.
  7. In your Snowflake instance, assign the generated public key to the user.
  8. Return to the Create a destination dialog box in Data Fabric and click Test to ensure that the connection to the database can be established.
  9. To save the destination, click Save.
    The destination is displayed on the Destinations page.