Creating a Job for writing and reading Snowflake data
read data from the table, finally close the connection to Snowflake.
The Snowflake data warehouse to be used is started but not in the Suspended
status, and the Snowflake role assigned to you has read and write
permissions to the database to be connected. If you are not sure about these
requirements, ask the administrator of your Snowflake system.
The table EMPLOYEE with four columns,
ID of INT type, NAME of
VARCHAR type, ONBOARD of DATE type, and
SALARY of VARIANT type, has been created in
perspective of the Studio, create a new Job from the Job Designs node in the Repository tree view.
Add a tSnowflakeConnection component, a
tFixedFlowInput component, a
tSnowflakeOutput component, a
tSnowflakeInput component, a
tLogRow component, and a
tSnowflakeClose component to the Job.
- Connect the tFixedFlowInput component to the tSnowflakeOutput component using a Row > Main connection.
Do the same to connect the tSnowflakeInput component to
the tLogRow component.
Connect the tSnowflakeConnection component to the
tFixedFlowInput component using a Trigger > On Subjob Ok connection.
Do the same to connect the
tFixedFlowInput component to the tSnowflakeInput component, and the
tSnowflakeInput component to the