Skip to main content

Snowflake

This guide shows you how to create a Snowflake Connection in Ascend.

Prerequisites​

  • Ascend Project
  • Ascend Workspace
  • Credentials for a Snowflake account
    • Username: Username of the account used to connect to Snowflake
    • Password: Password of the account used to connect to Snowflake
  • Currently, only username and password authentication is supported for Snowflake Connections.

Create a Snowflake Connection

From your workspace Super Graph view, follow these steps:

  1. Create a Connection by either:
    • Clicking the + button next to Connections in the left Build panel
    • add-connection
    • Right-clicking in the Super Graph and selecting Create Connection
    • menu
  2. Enter a descriptive name like `data_plane_snowflake`
  3. Select Snowflake from the available options
  4. Fill in the required fields (and any optional fields as needed)
  5. Click Save at the bottom to create your Connection
  6. form

For complete configuration options, see our Connection reference guide.

Example​

Use the following YAML template for your Snowflake Connection. Customize the highlighted values with your specific Connection details:

/my_project/connections/snowflake_connection.yaml
connection:
snowflake:
account: <account-name>
database: <database>
schema: <schema>
user: <username>
password: ${vaults.<your_vault>.<secret_key>}
warehouse: <warehouse>

🎉 Congratulations, you just set up a Snowflake Connection in Ascend!