Skip to main content Skip to complementary content

Creating a Snowflake table

Configure the tSnowflakeRow component to create a new table.

Procedure

  1. Double-click the tSnowflakeRow component to open its Basic settings view on the Component tab.
  2. 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.
  3. 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!