Step 1. In the Delivery section, click on the Export Data tile to start setting up the connector.
Step 2. Select Database from the Integration Type dropdown list, then select Snowflake.
The next screen will show the existing connectors and an option to create a new one. Click on Add New Account to proceed.
Step 3. Fill in the following pop-up with the appropriate information.
Integration name: name of the connection in the Accern Platform. You can name this however you want, preferably match with your use case name.
Host: the URL of your Snowflake worksheets homepage
User: Snowflake account username. Please ensure that this user is assigned to the role that has sufficient access to the warehouse, database, and schema where the data resides.
Warehouse: Name of the Warehouse you want to compute power
Database: Name of the Database where your Schema resides
Schema: Name of the Schema where your data resides
Private Key: Follow this document to generate the public key and private key files on your local machine and assign a public key to your user on the Snowflake worksheet.
Copy and paste the private key into the field on the platform. Make sure to exclude “-----BEGIN RSA PRIVATE KEY-----” and “-----END RSA PRIVATE KEY-----”. Click Next to navigate to the next window.
Step 4. Fill in the following pop-up with the appropriate information.
Delivery Title: this will be the tile name that appears on the platform. You can name this however you want, preferably match with your use case and integration name.
Table: this will be the table name that appears on Snowflake under selected Schema and Database. Avoid using special characters, !#$%^&*()[email protected], instead of using “_” (underscore). Click Add and a tile will be generated in the Delivery section. This can be toggled on or off for your use cases.
In many cases, especially exporting data to Snowflake, the connector may fail due to configuration errors. This means the fields you entered were incorrect. Review the information as instructed below:
a. Ensure the host URL was copied and pasted correctly.
b. The entered user is assigned to the role that has sufficient access to the warehouse, database, and schema.
c. The entered warehouse, database, and schema match what’s on Snowflake. It is recommended to write the information in uppercase.
d. Ensure the private key was copied and pasted correctly.
e. Ensure there is no special character !#$%^&*()[email protected] in the table name. Snowflake won’t accept these characters.
f. If your user was recently created, make sure you have changed the user password because Snowflake enforces a first-time password change for a new account.
g. The entered user might not have the proper role assigned on Snowflake.
To check this information, go to Snowflake, switch the role on the top right corner to ACCOUNTADMIN.
Click on Account and view User
Click on the username and you should see a window pops up on the right as below. Review the Default Role and make sure the role has sufficient access. If not, run the query below to reassign the user to another role on Snowflake.
alteruser user_name set default_role = role_name