Snowflake as a source

In the data pipeline wizard or editor, select Snowflake as a source. Error reporting tables in Snowflake are created as transient tables to reduce storage costs.

Supported Account types

To provide connection information, you can enter credentials in AutoSync, Designer, or Classic Manager. Designer and Classic Manager offer multiple account types for most endpoints and not all types are compatible with AutoSync. When you create or edit a data pipeline, the existing credentials list includes only compatible account assets. AutoSync supports the following Designer and Classic Manager account types:

AutoSync supports the following IIP Account types:

  • Snowflake S3 Database Account
  • Snowflake S3 OAuth2 Account
  • Snowflake Azure Database Account

Known limitations

  • Snowflake Accounts created in the IIP can specify a JDBC driver JAR file. To use an Account that specifies a JDBC JAR in AutoSync, the JAR must be specified with an absolute path. Otherwise the connection fails.
  • When loading data from a Snowflake source to a Snowflake destination, the source schema must be different than the destination schema.
  • When using Snowflake as both a source and a target, the loaded data for some columns might be a different data type than they were in the source. This is because AutoSync maps data through a common data model.

Connection configuration

Snowflake properties include the following:

  • Account Properties
    • Credential label: A unique, meaningful name such as Sales-Shared-Snowflake. If a configuration with the same name exists, AutoSync displays an Asset conflict error message.
    • Hostname: The hostname part of the connection URL. For example, if the Snowflake URL is, the hostname is
    • Port number: The port number for Snowflake.
    • Username: A username for an account with the correct permissions for AutoSync to load and synchronize data. For example,Autosync_Snowflake_User.
    • Password: The password for the account. Multiple retries with an invalid password can cause your account to be locked.
    • Database name: The name of the destination database.
    • Warehouse name: The destination warehouse in which to load the data. You can use any existing warehouse from your Snowflake database. For example, DEMO_WH.
    • Role: If the Snowflake account has a predefined role, enter it here.
    • Share: (Optional) Select a user group to share this configuration with. Environment admins (formerly Org admins) create user groups to share credentials. If you are a member of a user group, you can select it from the dropdown. You can also select the global shared folder, which shares the credentials with everyone in your Org.
  • Validate and save: After saving and validating, AutoSync adds the configuration to the list of saved credentials.
  • Select schema: After selecting your configuration, choose the schema name to load data into. AutoSync populates the list from your Snowflake account.
  • Select a table to synchronize: After configuring a destination, choose a table to synchronize. AutoSync populates the list from your Snowflake account.