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.
Supported Capabilities
Freshness
Volume
Schema Drift
Field Health
Custom SQL
Job Failure
Data Profiling
Data Preview
Add Recon
Connecting to decube is as easy as providing us with credentials to your Snowflake instance. There are currently 2 authentication options, Password and Key-pair authentication.
Authentication via Password will be deprecated by 1 April 2025, please refer to the Snowflake press release here. Hence, please add new connections via the Key-pair authentication method which is the recommended method for all new connections.
Password
username
password
account_name
warehouse_name
role_name
Key Pair
Refer to the Snowflake documentation 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
private_key upload
account_name
warehouse_name
role_name
The source name
will be for you to differentiate and recognize particular sources within the decube application.
Prerequisite
To ensure a smooth experience configuring the connection.
The user
decubeuser
and roledecuberole
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 Name
Copy the account url and it should look like
https://<account_number>.<region>.snowflakecomputing.com
.
Your account name will be the <account_number>.<region>
Configuring User, Role and Privileges
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.
Migrate from Password to Key-pair authentication
This section is applicable for you if you are currently using the Password authentication method to connect Snowflake to the decube platform before 31 March 2025 and will need to migrate to the Key-pair authentication method before the Password method is deprecated.
You will need to generate the key-pair based on this section Key Pair.
Go to My Account > Data sources tab. Click on Modify button.
In the Modify Data Source, change the Authentication method selection from
Password
toKey-pair
.
Click on
Upload file for Key-pair authentication
to upload the file. Once the file has been uploaded, then click onTest this connection
.
Once the
Test this connection
operation is successful, you can now click on Modify button. The new credential will now be saved.
Last updated