Using User-Specific Keys for Snowflake Data Sources

If your Snowflake data source requires individual users to authenticate with their own keys, you can configure this using a simple variable-based approach.

Step 1: Create a Token File
Create a file containing only the variable placeholder for the user’s key. For example: $c9_SNOWFLAKE_KEY$ This token will be dynamically replaced with the user's specific key at runtime.

Step 2: Upload that Token file in the Datasource connection
Create a file containing only the variable placeholder for the user’s key. For example: $c9_SNOWFLAKE_KEY$ This token will be dynamically replaced with the user's specific key at runtime.


Step 3: Configure the User Filter
For each user who needs access, add a user filter with the Base64-encoded version of their key as the value.

• Field Name: $c9_SNOWFLAKE_KEY$

• Value: (Base64-encoded Snowflake key specific to the user)

This approach allows you to securely manage and authenticate user access to Snowflake while keeping your connection logic centralized and dynamic. This method will only work for direct queries.