The Snowflake connector

Note

This connector is based on Airbyte .

You can use this connector for source endpoints.

Source endpoint

  1. Under Endpoint parameters:

    1. Specify your Snowflake Host name in the following format:

      https://<Your_snowflake_account_id>.<availability_zone>.snowflakecomputing.com

    2. Provide the user Role that has access to your Snowflake database.

    3. Enter the name of the data Warehouse. For more information on warehouses, see the Snowflake documentation .

    4. Specify the name of the Database to which you want to connect.

    5. Provide the database Schema.

    6. Specify the JDBC URL Params. For more information on available parameters, see the JDBC Driver Connection Parameter Reference in the official Snowflake documentation.

  2. Under Credentials, select and configure the authentication method:

    OAuth 2.0

    • Provide your OAuth 2.0 Client ID.

    • Paste your OAuth 2.0 Client Secret.

    • Provide the Access token used to authorize requests to your Snowflake instance. For more information on security key management in Snowflake, see the official documentation .

    • Paste the Refresh token. It automatically refreshes the expired token.

    Username/Password

    Specify the Username and Password for your Snowflake instance.

Airbyte type Transfer type
integer int64
— int32
— int16
— int8
— uint64
— uint32
— uint16
— uint8
— float
number double
— string
time_without_timezone, time_with_timezone, string utf8
boolean boolean
date date
date-time datetime
timestamp, timestamp_with_timezone, timestamp_without_timezone timestamp
object, array, REST... any

See also

Previous
MongoDB
Next
ElasticSearch
In this article: