Create a Snowflake Connection

This guide will demonstrate how to create a Snowflake connection in Ascend.

Prerequisites

• Credentials for a Snowflake account (see: Creating credentials in a vault)

info

Currently, only username and password authentication is supported for Snowflake connections.

• An existing Ascend project (see: Create a Project)
• An existing Ascend Workspace (see: Setting Up a Workspace)

UI

Locate Your Project Folder

1. From your Ascend Instance Homepage, click on your Workspace to open it.
2. From here, click on the Files icon on the left navigation bar. This will open the File Tree in the left panel.
3. In your File Tree, locate your top-level project folder and open it.
4. Within the project folder, locate the connections folder.

Add a New Connection File

1. Right-click on the connections folder, and select New File.
2. Provide the file with a name and a .yaml extension, such as snowflake_connection.yaml. This will open the empty file in the build pane.
3. From here, you can enter the details for your connection.

Enter Connection Details

Enter the following YAML configuration, replacing the placeholder values with your Snowflake connection details:

/my_project/connections/snowflake_connection.yaml

connection:
  snowflake:
    account: <account-name>
    database: <database>
    schema: <schema>
    user: <username>
    password: ${secrets.<your_vault>.<secret_key>}
    warehouse: <warehouse>

To view all available Connection options, see the Snowflake Connection Reference.

Once you have entered your Connection details, click "Save" to save the file, and click "Build Project" to apply the changes.

CLI

Now that you have created a Snowflake Connection you can start ingesting data from Snowflake or writing data out to Snowflake. You may also learn how to configure this Connection as the Dataplane for your Deployment.