Connect to Snowflake
With MOSTLY AI, you can connect to Snowflake and use it as a data source or destination for your synthetic data.
Account identifier format:
Account identifier URL format:
For more information, see the Snowflake documentation (opens in a new tab).
- 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.
- In Snowflake, select Admin > Accounts.
- Under Accounts, hover over your account identifier and click Copy account URL link.
- 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
_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
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
- Click Save.
Your Snowflake connector is now saved.
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.