Configuring Snowflake workspace data connections

Snowflake is phasing out support for using a simple username and password for authentication. For more information, go to the Snowflake documentation.

We strongly recommend that you use key pair authentication for all database connections. This is currently the default option for workspace connections.

Structural supports Snowflake on AWS and Azure Blob Storage. If you use Snowflake on Google Cloud Platform (GCP), contact Tonic.ai.

In the workspace configuration:

1. Under Connection Type, select Snowflake.
2. In the Source Settings section, under Snowflake Type:

   • To connect to a Snowflake database on AWS, click AWS.
   • To connect to a Snowflake database on Azure, click Azure.

The database connection configuration for AWS and Azure is mostly the same. The configuration for temporary file storage is slightly different.

Connect to the source database Configure the connection to the Snowflake source database.

Connect to the destination database Configure the connection to the Snowflake destination database.

Configure the temporary storage on AWS For AWS set the location and credentials to store temporary files.

Configure the temporary storage on Azure For Azure, set the location and credentials to store temporary files.