Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Go to Treasure Data Connections and search and select Snowflake.Image Removed

Image Added


The following dialog opens.

...

Image Added

Select Authentication Method:

  • Basic: Provide the required credentials: UserPassword, and Account to authenticate Treasure Data to Snowflake.
    • User: Snowflake login username.

    • Password: Snowflake login password.

  • Key Pair: Provide the Private Key and its Passphrase if it is the encrypted private key
    • Private Key: Your generated private key. See configuring-key-pair-authentication
    • Passphrase: The Private Key passphrase, or leave it empty if the Private Key is unencrypted.
    • User: Snowflake login username.
  • Account: Snowflake provided the account name. See how to find your account name in Snowflake.

  • OPTIONS: This option is not supported for this connector.


Provide the required credentials: User, Password, and Snowflake Account to authenticate Treasure Data to Snowflake.

...

Here is the table for 1-1 mapping from the type in TD results to the target table in case target table does not exist or new columns are added:

TD results

Snowflake

string

STRING

double

FLOAT

long

BIGINT

timestamp

TIMESTAMP

boolean

BOOLEAN

You might want to set the different type as the default. Data Type Mapping is used to explicitly set a specific type (for example, VARCHAR) to a specific column. Data Type Mapping applies a type only to columns in your target table.

...

The syntax for data type mapping parameter is: col_name_1: VARCHAR; col_name2: BIGINT, You must provide: column name and Snowflake data type.

JSON is not fully supported when you export data using a Treasure Data Presto or Hive query. Therefore when a target table does not exist and is created, a JSON data type value is saved as VARCHAR by default in the newly created target table. If you want to save a JSON value as a semi-structured type instead, then you must update the type mapping. Use the Data Mapping syntax to specify a semi-structured data type.

For example, in the query:

...

Here is the table for 1-1 mapping from the type in TD results to the target table in case target table does not exist or new columns are added:

TD results

Snowflake

string

STRING

double

FLOAT

long

BIGINT

timestamp

TIMESTAMP

boolean

BOOLEAN

You might want to set the different type as the default. Data Type Mapping is used to explicitly set a specific type (for example, VARCHAR) to a specific column. Data Type Mapping applies a type only to columns in your target table.

...

The syntax for data type mapping parameter is: col_name_1: VARCHAR; col_name2: BIGINT, You must provide: column name and Snowflake data type.

JSON is not fully supported when you export data using a Treasure Data Presto or Hive query. Therefore when a target table does not exist and is created, a JSON data type value is saved as VARCHAR by default in the newly created target table. If you want to save a JSON value as a semi-structured type instead, then you must update the type mapping. Use the Data Mapping syntax to specify a semi-structured data type.

For example, in the query:

...