...
Sink Properties
Option 1
| Section | User Configuration Label | Label Description | Options | Default | Variable | User Widget |
|---|---|---|---|---|---|---|
| General | Label | Label for UI. | textbox | |||
| Reference Name | Uniquely identified name for lineage. | referenceName | textbox | |||
| Account Name | Full name of Snowflake account. | accountName | textbox | |||
| Database | Database name to connect to connect to. | database | textbox | |||
| Table Name | Name of a database table to write to. | table | textbox | |||
| Credentials | Username | User identity for connecting to the specified database. | username | textbox | ||
| Password | Password to use to connect to the specified database. | password | password | |||
| Key Pair Authentication | Key Pair Authentication Enabled | If true, plugin will perform Key Pair authentication. |
| False | keyPairEnabled | toggle |
| Key File Path | Path to the private key file. | path | textbox | |||
| OAuth2 | OAuth2 Enabled | If true, plugin will perform OAuth2 authentication. |
| False | oauth2Enabled | toggle |
| Auth URL | Endpoint for the authorization server used to retrieve the authorization code. | authUrl | textbox | |||
| Token URL | Endpoint for the resource server, which exchanges the authorization code for an access token. | tokenUrl | textbox | |||
| Client ID | Client identifier obtained during the Application registration process. | clientId | textbox | |||
| Client Secret | Client secret obtained during the Application registration process. | clientSecret | password | |||
| Scopes | Scope of the access request, which might have multiple space-separated values. | scopes | textbox | |||
| Refresh Token | Token used to receive accessToken, which is end product of OAuth2. | refreshToken | textbox | |||
| Advanced | Connection Arguments | A list of arbitrary string tag/value pairs as connection arguments. See: https://docs.snowflake.net/manuals/user-guide/jdbc-configure.html#jdbc-driver-connection-string | connectionArguments | keyvalue |
Option 2
...
Sink Data Types Mapping
| CDAP Schema Data Type | Snowflake Data Types | Comment |
|---|---|---|
| boolean | BOOLEAN | |
| bytes | BINARY | |
| date | DATE | |
| double | FLOAT | Snowflake uses double-precision (64 bit) IEEE 754 floating point numbers. |
| decimal | NUMBER(s, p) | |
| float | FLOAT | |
| int | NUMBER(s, p) | Where p >= 10. It's safe to write primitives as values of decimal logical type in the case of valid precision. |
| long | NUMBER(s, p) | Where p >= 19. It's safe to write primitives as values of decimal logical type in the case of valid precision. |
| string | VARCHAR | |
| time | TIME | |
| timestamp | TIMESTAMP_NTZ | |
| array | ARRAY | |
| record | OBJECT | |
| enum | VARCHAR | |
| map | OBJECT | |
| union | VARIANT |
...