Snowflake
Snowflake
Snowflake services main features are separation of storage and compute, on-the-fly scalable compute, data sharing, data cloning, and third-party tools support in order to handle the demanding needs of growing enterprises.
Creating a Snowflake connection
Use one of the following methods to make a connection:Using an account
To create the connection you need:- Access to your Snowflake organization
- Select which database and warehouse you wish to connect to
Obtaining the credentials
Follow the Snowflake Documentation to obtain your account identifier.Creating your connection
- In the Blink platform, navigate to the Connections page > Add connection. A New Connection dialog box opens displaying icons of external service providers available.
- Select the Snowflake icon. A dialog box with name of the connection and connection methods appears.
- (Optional) Edit the name of the connection. At a later stage you cannot edit the name.
- Select Account as the method to create the connection.
-
Fill in the parameters:
- The Account Identifier
- Username of the user to use for authentication
- Password of the user to use for authentication
- Name of the Database you wish you operate on
- The name of an active Warehouse to use to execute your requests
- (Optional) Click Test Connection to test it.
- Click Create connection. The new connection appears on the Connections page.
Using a data source name
Obtaining the credentials
An alternative type of authentication is a custom Data Source Name (DSN) for Blink. View the Go Snowflake Documentation on how to format the connection string.Creating your connection
- In the Blink platform, navigate to the Connections page > Add connection. A New Connection dialog box opens displaying icons of external service providers available.
- Select the SnowFlake icon. A dialog box with name of the connection and connection methods appears.
- (Optional) Edit the name of the connection. At a later stage you cannot edit the name.
- Select DSN as the method to create the connection.
- Fill in the parameters:
- The full DSN string to use for connection
- (Optional) Click Test Connection to test it.
- Click Create connection. The new connection appears on the Connections page.