Datamarts - Snowflake
  • 07 Dec 2022
  • PDF

Datamarts - Snowflake

  • PDF

Article summary

Note

This is a machine-translated version of the original Japanese article.
Please understand that some of the information contained on this page may be inaccurate.

summary

This is a help page for configuring datamart definitions using Snowflake.

Setting items

STEP1 Basic settings

Itemnamerequireddefault
valuecontent
Snowflake connection informationYes-Select the connection information for Snowflake.
WarehouseYes-specify the warehouse to use for processing
Custom variablesNo-Custom variables set here can be used for queries and table names.

Query settings

Itemnamerequireddefault
valuecontent
Query Execution ModeYesData Transfer ModeYou can choose from the following two modes.
・Data transfer mode
By simply specifying the SQL and the output destination table, you can easily change and append to the table.
・Free description mode
You can freely execute arbitrary queries (DDL, DELETE, INSERT, etc.) against the connected DWH.
queryYes-Enter the SQL to retrieve the transferred data from Snowflake.
Custom variables can also be used to dynamically determine the setting value during trocco data transfer.

In addition, the following settings can only be specified when the query execution mode is data transfer mode.

Data output destination settings

Itemnamerequireddefault
valuecontent
databaseYes-Specifies the database to which the data is output.
Specify a database that exists.
schemaYes-Specifies the schema name to which the data is output.
The dataset name must consist only of letters, numbers, and underscores.
Specify a schema that exists.
tableYes-Specifies the name of the table to which the data is output.
The table name must consist only of letters, numbers, and underscores.
If the table does not exist, a new one is created during the transfer.
Write settings for the destination tableYes-You can choose the following writing methods.
・P.S.
・ Wash (Delete the table and recreate it.) )

Was this article helpful?