August 15, 2023

Creating a Job for writing and reading Snowflake data – Docs for ESB 6.x

  2. Talend for ESB Docs
  3. Docs 6.x
  4. Creating a Job for writing and reading Snowflake data – Docs for ESB 6.x

Creating a Job for writing and reading Snowflake data

Create a Job to connect to Snowflake, write data into a Snowflake table and then
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
    Snowflake.

    snowflake-table_schema.png
  1. In the
    Integration
     perspective of the Studio, create a new Job from the Job Designs node in the Repository tree view.
  2. Add a tSnowflakeConnection component, a
    tFixedFlowInput component, a
    tSnowflakeOutput component, a
    tSnowflakeInput component, a
    tLogRow component, and a
    tSnowflakeClose component to the Job.
  3. Connect the tFixedFlowInput component to the tSnowflakeOutput component using a Row > Main connection.
  4. Do the same to connect the tSnowflakeInput component to
    the tLogRow component.
  5. Connect the tSnowflakeConnection component to the
    tFixedFlowInput component using a Trigger > On Subjob Ok connection.
  6. Do the same to connect the
    tFixedFlowInput component to the tSnowflakeInput component, and the
    tSnowflakeInput component to the
    tSnowflakeClose component.
Document get from Talend https://help.talend.com
Thank you for watching.
Docs 6.x
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x