Data Mart - Snowflake

Article summary

Did you find this summary helpful?

Thank you for your feedback

summary

Help page for setting up data mart definitions using Snowflake.

Only connection information for which key pair authentication is selected as the authentication method can be used in Datamart Snowflake.

item name	indispensable	default value	Contents
Snowflake Connection Information	Yes	-	From the pre-registered Snowflake connection information, select the one that has the necessary permissions for this data mart definition.
warehouse	Yes	-	Specify the warehouse to be used for processing.
custom variable	No	-	Custom variables set here can be used for query and table names.

item name	indispensable	default value	Contents
query execution mode	Yes	Data Transfer Mode	You can choose from the following two modes Data transfer mode 　You can easily perform rewashing and appending to tables by simply specifying SQL and the destination table. Free description mode 　You are free to execute any query (DDL, DELETE, INSERT, etc.) against the DWH to which you are connected.
query	Yes	-	Enter SQL to retrieve transfer data from Snowflake. Custom variables can be used to dynamically determine set values during TROCCO data transfer.

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

item name	indispensable	default value	Contents
Output Destination Database	Yes	-	Specify the database to which the data will be output. Specify a database that exists.
destination schema	Yes	-	Specifies the name of the schema to which the data will be output. Data set names must consist of only letters, numbers, and underscores. Specify a schema that exists.
output table	Yes	-	Specify the name of the table to which the data will be output. Table names must consist of only letters, numbers, and underscores. If the table does not exist, a new one will be created at the time of transfer.
Write settings for output destination table	Yes	-	You can choose from the following writing methods Append: The result of the query execution is appended after the records of the existing table. All records are `TRUNCATED`(TRUNCATE INSERT): records in the existing table are `TRUNCATED` and replaced with the results of the query execution. In this case, the schema of the existing table is not deleted. REPLACE ALL: Existing tables are `DROPPED` and replaced with the results of the query execution. In this case, the schema of the existing table will be deleted.

item name	indispensable	default value	Contents
Parallel execution of jobs	✓	No parallel job execution.	Select whether or not to run a job if another job with the same data mart definition is running at the time the job is run. No parallel job execution: jobs are not executed and skipped. Allow jobs to run in parallel: Jobs will run.

Was this article helpful?

Table of contents