Configure the tSnowflakeRow component to create a new
table.
Procedure
- Double-click the tSnowflakeRow component to open its Basic settings view on the Component tab.
- From the Connection Component drop-down list, select the tSnowflakeConnection component to reuse the connection created by it. In this example, it is tSnowflakeConnection_1.
-
In the Query field, enter the SQL statement used to
create a new table into which the data will be written.
In this example, the following SQL statement is used to create or replace a table EMPLOYEE with four columns, ID of INT type, NAME of VARCHAR type, ONBOARD of DATE type, and SALARY of VARIANT type.
"CREATE OR REPLACE TABLE EMPLOYEE (" + "ID INT NOT NULL primary key," + "NAME VARCHAR (50), " + "ONBOARD DATE," + "SALARY VARIANT" + ") COMMENT = 'Created By Doc Team'"