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.
Get your Snowflake account identifier
- 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.
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
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.
- MOSTLY AI tests the connection. If you see an error, check the connection details, update them, and click Save again.
What’s next
Depending on whether you created a source or a destination connector, you can use the connector as:
- Data source for a new generator
- Data destination for a new synthetic dataset