Step 1. In the Data Source section, click on the Import Data tile to start setting up the connector.
Step 2. The Import Data Source window will pop up. Enter the Connection Name and select a data category from the dropdown list or create a new category. Data Category is very useful for organizing your data.
Step 3. Click on Data Connectors and 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 4. 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 5. Fill out the following pop-up with appropriate information.
Data Store Title: this will be the data tile name that appears on the platform.
Table: the table you want to import data from
Tracking Column Type: numeric or time
Tracking Column: Name of the column used to track the loading process
Field Mapping: match the column names on the table to the Accern platform field accordingly.
Click Add and a tile will be generated in the Data Store section. This can be toggled on or off for your use cases.