Snowflake

To register a Snowflake account into TrustLogix follow the below steps

1. Create a data source entry in TrustLogix

2. Run the auto generated script in Snowflake environment

3. Gather all required information about Snowflake account

4. Update the details in TrustLogix and Save

Create a Snowflake Data Source In TrustLogix

• Login to TrustLogix console and register a new Snowflake Datasource from Menu → Data sources → Register new data source

• Provide the data source name, & click on Register data source

• Form will be refreshed with additional fields and script Download option

Run the script in Snowflake environment

• Click on Download button to download the script

• Extract the downloaded script, extracted script will contain multiple files

  • Either choose to run the script as py notebook or as SQL script

• Replace the placeholder values in script, like password etc

• Run the updated script, script needs to be executed as ACCOUNTADMIN

• After successful run of the script, required objects are created in snowflake

• Capture the output of the script and also gather

  • snowflake account identifier

  • username and password if authentication type is basic auth

  • If authentication mode is Key-Pair generate keys and keep it ready

Save the captured details in TrustLogix

• Navigate back to TrustLogix data source form page

• Enter all the required details in form

• Click on save, system will validate the connection details and saves them

• If all details are valid, Snowflake data source is successfully registered & shown as active in the list