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 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.
    Get Snowflake account identifier

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

Steps

  1. From the Connectors tab, click Create connector. Click Create connector button 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. Configure 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 Account, enter your Snowflake account identifier. For more information, see the Prerequisites above.

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

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

      If you leave Warehouse empty, MOSTLY AI uses the default warehouse value COMPUTE_WH.
    5. For Database, enter the name of a Snowflake database.

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

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

Result

Your Snowflake connector is now saved.