With MOSTLY AI, you can connect to Snowflake and use it as a data source or destination for your synthetic data.
Prerequisites
To create a Snowflake connector, you need either your Snowflake account identifier or your account URL.
-
Account identifier format:
<org_name>-<account_name>
-
Account identifier URL format:
https://<org_name>-<account_name>.snowflakecomputing.com
For more information, see Snowflake documentation.
Create a Snowflake connector
Steps
-
From the Connectors tab, click Create connector.
The Create connector drawer appears on the right.
-
On the Connect to database tab, select Snowflake.
-
Click Proceed.
-
Configure the Snowflake connector.
-
For Connector name, enter a name for the Snowflake connector.
A combination of Snowflake
+_DATABASE_
+_SCHEMA_
might help you identify this connector among other Snowflake connectors. -
For Account, enter your Snowflake account identifier. For more information, see the Prerequisites above.
-
For Username and Password, enter your Snowflake credentials.
-
For Warehouse, enter the warehouse you want to use.
If you leave Warehouse empty, MOSTLY AI uses the default warehouse value COMPUTE_WH. -
For Database, enter the name of a Snowflake database.
-
For Schema, enter the schema you want to use.
If you leave Schema empty, MOSTLY AI uses the default schema PUBLIC.
-
-
Click Save.
Result
Your Snowflake connector is now saved.