Guides
Connectors
Databases
Snowflake

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

  1. In Snowflake, open the Account menu in the lower left. Open Snowflake account menu
  2. Copy the organization name and account name and put them together in an account identifier, separated with a dash. Open Snowflake account menu

Get your Snowflake account URL

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

Create a Snowflake connector

  1. From the Connectors tab, click Create connector. Copy Snowflake account URL The Create connector drawer appears on the right.
  2. On the Connect to database tab, select Snowflake.
  3. Click Proceed. Select Snowflake and click Proceed
  4. Configure the Snowflake connector.

    1. 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.

    2. 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.

    3. For Account, enter your Snowflake account identifier.
      For more information, see the Prerequisites above.

    4. For Username and Password, enter your Snowflake credentials.

    5. For Warehouse, enter the warehouse you want to use.

      If you leave Warehouse empty, MOSTLY AI uses the default warehouse value COMPUTE_WH.

    6. For Database, enter the name of a Snowflake database.

    7. For Schema, enter the schema you want to use.

      If you leave Schema empty, MOSTLY AI uses the default schema PUBLIC.

      Configure Snowflake connector
  5. 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.