Documentation / Product / Integrations / Snowflake

Snowflake Authorization

If you haven't already done so, you will need to set up a Snowflake account before you begin the process described below. For imports, you will need to provide the credentials and role for a user who has access to the data you wish to import. For exports, you will need to provide the credentials and role for a user who has access to the database and schema you wish to export to.

If you are new to creating authorizations in Lytics, see the Authorizations Dashboard documentation for more information.

  1. Select Snowflake from the list of providers.
  2. Select the method for authorization. Note that different methods may support different job types. Snowflake supports the following authorization methods:
  3. Enter a Label to identify your authorization.
  4. (Optional) Enter a Description for further context on your authorization.
  5. Complete the configuration steps needed for your authorization. These steps will vary by method.
  6. Click Save Authorization.

Snowflake Direct Authorization

  1. Enter the Snowflake Account that contains the data you want to import.
  2. Enter the Snowflake Warehouse you will run the extraction queries against. For more information, see Snowflake's Warehouse documentation.
  3. Enter the Snowflake Database that contains the data you want to import.
  4. Enter the Snowflake Username of a Snowflake user who has access to the data you want to import.
  5. Enter the Snowflake Role you will run extraction queries with. Make sure this role has access to the data you want to import. For more information, see Snowflake's Roles documentation.
  6. Enter your user's Snowflake Password. snowflake-auth-0321

Snowflake Direct Authorization for Bulk Export

  1. Enter the Snowflake Account you wish to export to.
  2. Enter the Snowflake Warehouse you will run the load queries against. For more information, see Snowflake's Warehouse documentation.
  3. Enter the Snowflake Database you wish to export to.
  4. Enter the Username of a Snowflake user who has access to the schema you wish to export to.
  5. Enter the Snowflake Role you will run load queries with. Make sure this role has write permissions on the database and schema you wish to export to. For export, the role will need usage on the database, and usage and create table on the schema. For more information, see Snowflake's Roles documentation.
  6. Enter your user's Snowflake Password.
  7. In the GCS Stage Service Account text box, enter your GCS Stage Service Account.