⚠️ DEPRECATED: Typed connector configuration models are deprecated and will be removed in v1.1.0. Pass configuration as a plain dict with a required 'destinationType' key instead..
| Field | Type | Required | Description | Example |
|---|---|---|---|---|
cdc_deletion_mode |
Optional[models.DestinationSnowflakeCDCDeletionMode] | ➖ | Whether to execute CDC deletions as hard deletes (i.e. propagate source deletions to the destination), or soft deletes (i.e. leave a tombstone record in the destination). Defaults to hard deletes. | |
credentials |
Optional[models.DestinationSnowflakeAuthorizationMethod] | ➖ | Determines the type of authentication that should be used. | |
database |
str | ✔️ | Enter the name of the database you want to sync data into | AIRBYTE_DATABASE |
destination_type |
models.DestinationSnowflakeSnowflake | ✔️ | N/A | |
disable_type_dedupe |
Optional[bool] | ➖ | Write the legacy "raw tables" format, to enable backwards compatibility with older versions of this connector. | |
host |
str | ✔️ | Enter your Snowflake account's locator (in the format <account_locator>...snowflakecomputing.com) | Example 1: accountname.us-east-2.aws.snowflakecomputing.com Example 2: accountname.snowflakecomputing.com |
jdbc_url_params |
Optional[str] | ➖ | Enter the additional properties to pass to the JDBC URL string when connecting to the database (formatted as key=value pairs separated by the symbol &). Example: key1=value1&key2=value2&key3=value3 | |
raw_data_schema |
Optional[str] | ➖ | Airbyte will use this dataset for various internal tables. In legacy raw tables mode, the raw tables will be stored in this dataset. Defaults to "airbyte_internal". | |
retention_period_days |
Optional[int] | ➖ | The number of days of Snowflake Time Travel to enable on the tables. See Snowflake's documentation for more information. Setting a nonzero value will incur increased storage costs in your Snowflake instance. | |
role |
str | ✔️ | Enter the role that you want to use to access Snowflake | AIRBYTE_ROLE |
schema_ |
str | ✔️ | Enter the name of the default schema | AIRBYTE_SCHEMA |
username |
str | ✔️ | Enter the name of the user you want to use to access the database | AIRBYTE_USER |
warehouse |
str | ✔️ | Enter the name of the warehouse that you want to use as a compute cluster | AIRBYTE_WAREHOUSE |