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'"
Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!