Use Snowflake for synthetic data

To use Snowflake as a data source or destination for your synthetic data, you need to create a Snowflake connector.

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.

In Snowflake, open the Account menu.
Copy the organization name and account name and put them together in an account identifier, separated with a - dash character.

In Snowflake, select Admin > Accounts.
Under Accounts, hover over your account identifier and click Copy account URL link.

If you use the web application, create a new Databricks connector from the Connectors page.

Steps

From the Connectors page, select Snowflake under the Connect your data header.
On the New connector modal, configure the connector.

Field	Description
Name	Enter a name that you can distinguish from other connectors.
Access type	Select whether you want to use the connector as a source or destination.
Account	The Snowflake account identifier.
Username	The Snowflake username.
Password	The Snowflake password.
Database	The name of a Snowflake database.
Warehouse	The warehouse you want to use.

Click Save to save your new Snowflake connector.
- MOSTLY AI tests the connection. If you see an error, check the connection details, update them, and click Save again.
- You can click Save anyway to save the connector and disregard any errors.

What’s next

Depending on whether you created a source or a destination connector, you can use the connector as: