Snowflake
Adding Snowflake to your decube connections helps your team to find relevant datasets, understand their quality via incident monitoring and apply governance policies via our data catalog.
Last updated
Adding Snowflake to your decube connections helps your team to find relevant datasets, understand their quality via incident monitoring and apply governance policies via our data catalog.
Last updated
Freshness
Volume
Schema Drift
Field Health
Custom SQL
Job Failure
Data Profiling
Data Preview
Below are the steps to Connect snowflake to Decube with key pair authentication method.
Refer to the for more information on how to generate a key pair. Please provide only the unencrypted version of private keys as the key is encrypted on Decube's end. The following credentials are required upon adding new connection:
Username
Public Key File
Warehouse Name
Role Name
The source name
will be for you to differentiate and recognize particular sources within the decube application.
To ensure a smooth experience configuring the connection.
The user decubeuser
and role decuberole
is created and given the proper privileges for monitoring.
Steps 4 or 5 below needs to be repeated for every database
that needs to be monitored.
Account Identifier can be found by clicking on your profile icon in Snowflake and going to account details.
Copy the Account Identifier which is shown below. This should look like <org-name>-<account-name>
1. On a Snowflake worksheet, copy the commands below and modify as necessary. We have the user called DECUBEUSER
and role called DECUBEROLE
2. The source
type for the database has to be known. To get this information, from Snowflake dashboard click on Data
-> Databases
. On the left panel, a list of Databases
can be seen along with Source
.
3. If Source
if local, modify database_name
, copy into a worksheet and run the commands.
4. Steps 3 needs to be repeated for every database
that needs to be monitored.
If your Snowflake UI differ, please refer to on how to get your Account Identifier.