ConnectorsCreate a connectorSnowflake

Use Snowflake for synthetic data

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.

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

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

Steps

  1. From the Connectors page, click New connector. Copy Snowflake account URL
  2. From the Create a new connector window, select Snowflake. Select Snowflake and click Proceed
  3. From the New connector window, configure the Snowflake connector.
    1. For Name, enter a name that you can distinguish from other connectors.
    2. For Access type, select whether you want to use the connector as a source or destination.
    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 Database, enter the name of a Snowflake database.
    6. For Warehouse, enter the warehouse you want to use.

      By default, MOSTLY AI uses the default Snowflake warehouse COMPUTE_WH.

      Configure Snowflake connector
  4. Click Save.

    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 disregarding any errors.

Result

Your Snowflake connector is now saved.

What’s next

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