Snowflake Setup Guide

To connect Snowflake and enable Aleph to query its data directly, Aleph needs a Snowflake user that Aleph will use to read the tables and data.

We suggest creating a separate database user for Aleph, with only access to the tables you need to consume in Aleph. If you already have a database user for the finance team, we recommend assigning that user and the Aleph user the same role, so that any table that is made available to the finance user is also available in Aleph.

Once the user is created, you would need to provide your Aleph Account Manager with the following information:

• Account

  • Depending on your Snowflake setup, your account ID may be:

    • <orgname>-<account-name>

    • <orgname>-<connection-name>

    • <accountlocator>.<region>.<cloud>

    • What you send us as the account ID should match the snowflake URL, i.e., we need the <account-id> in https://<account-id>.snowflakecomputing.com

• Username

• Password

• Database

• Schema (optional)

• Role

• Warehouse

• Query tag (optional)

If you have an IP whitelist, you must add our server IP 35.202.250.148 to the whitelist

To share this information securely, you can use Doppler Share or your preferred alternative. For security reasons, we recommend choosing an appropriate expiration time for the share link.

Important: the credential information is sensitive so only share it with authorized individuals.