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.
- Select Snowflake from the list of providers.
- Select the method for authorization. Note that different methods may support different job types. Snowflake supports the following authorization methods:
- Enter a Label to identify your authorization.
- (Optional) Enter a Description for further context on your authorization.
- Complete the configuration steps needed for your authorization. These steps will vary by method.
- Click Save Authorization.
Snowflake Direct Authorization
- Enter the Snowflake Account that contains the data you want to import. See Snowflake's Account Identifier documentation for details on account name format.
- Enter the Snowflake Warehouse you will run the extraction queries against. For more information, see Snowflake's Warehouse documentation.
- Enter the Snowflake Database that contains the data you want to import.
- Enter the Snowflake Username of a Snowflake user who has access to the data you want to import.
Enter the Snowflake Role you will run extraction queries with. Make sure this role has access to the data you want to import. For import, the role will need
usage
on the databaseusage
on the schemaoperate
on the warehouseFor more information, see Snowflake's Roles documentation.
Enter your user's Snowflake Password.
Snowflake Direct Authorization for Bulk Export
- Enter your Snowflake Account account locator, ex.
xy12345.us-east-aws
. Be sure to format the locator according to your cloud platform and region, as described here: https://docs.snowflake.com/en/user-guide/admin-account-identifier.html#locator-formats-by-cloud-platform-and-region - Enter the Snowflake Warehouse you will run the load queries against. For more information, see Snowflake's Warehouse documentation.
- Enter the Snowflake Database you wish to export to.
- Enter the Username of a Snowflake user who has access to the schema you wish to export to.
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 databaseusage
andcreate table
on the schemaoperate
on the warehouseFor more information, see Snowflake's Roles documentation.
Enter your user's Snowflake Password.
- In the GCS Stage Service Account text box, enter your GCS Stage Service Account.