Connect to Snowflake
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 the Snowflake documentation (opens in a new tab).
Get your Snowflake account identifier
- In Snowflake, open the Account menu in the lower left.
- Copy the organization name and account name and put them together in an account identifier, separated with a dash.
Get your Snowflake account URL
- In Snowflake, select Admin > Accounts.
- Under Accounts, hover over your account identifier and click Copy account URL link.
Create a Snowflake connector
- 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 Connection type, select whether you want to use the connector as a source or destination.
You can select only data source connectors when you create a new catalog.
Similarly, you can select only data destination connectors when you configure a destination for the new synthetic dataset.
-
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.
What’s next
You can now use the Snowflake connector as a data source when you create a new catalog.
You can also use the Snowflake connector as a destination.
You can use different types of data sources and destinations for a synthetic dataset. For example, if your data source is a Snowflake database, you can deliver the generated synthetic to any of the supported databases or cloud storage providers.