Creating a Snowflake table

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'"
```

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!