August 15, 2023

Reading data from Snowflake – Docs for ESB 6.x

Reading data from Snowflake

Configure the tSnowflakeInput component and the
tLogRow component to retrieve data from Snowflake and output
the data on the console.

  1. Double-click the tSnowflakeInput component to open its Basic settings view.
  2. From the Connection
    drop-down list, select the tSalesforceConnection component to reuse the connection created
    by it.
  3. Click the […] button next to the
    Table field and in the pop-up dialog box, select the
    Use custom object check box and enter the name of the
    table from which the data will be retrieved in the Object
    field. In this example, it is
    EMPLOYEE. When done, click OK
    to close the dialog box.
  4. Click the […] button
    next to Edit schema and in the pop-up
    schema dialog box, define the schema by adding four columns,
    ID of int type, NAME and
    SALARY of String type, and
    ONBOARD of Date type. This schema is the same as the
    schema of the tSnowflakeOutput component.
  5. Click OK to validate
    these changes and accept the propagation prompted by the pop-up dialog
  6. Double-click the tLogRow
    component to open its Component
  7. In the Mode area, select
    Vertical (each row is a key/value
    for better readability of the results.

Document get from Talend
Thank you for watching.
Notify of
Inline Feedbacks
View all comments
Would love your thoughts, please comment.x