Creating the Job for querying data through a Snowflake external table - 7.3

Snowflake
Version
7.3
Language
English
Product
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Data Governance > Third-party systems > Cloud storages > Snowflake components
Data Quality and Preparation > Third-party systems > Cloud storages > Snowflake components
Design and Development > Third-party systems > Cloud storages > Snowflake components
Last publication date
2024-02-21

Procedure

  1. Create a standard Job.
  2. Drop the components listed in the following table onto the design workspace.
    A component is assigned a default name automatically in the format of <component name>_<sequence number> when it is dropped onto the design workspace. This scenario refers the components in the Jobs using their default names. The following table also lists the default component names.
    Component Default component name
    tDBConnection tDBConnection_1
    tDBRow tDRRow_1
    tDBRow tDBRow_2
    tDBRow tDBRow_3
    tDBInput tDBInput_1
    tLogRow tLogRow_1
    tDBClose tDBClose_1
  3. Connect the components:
    1. tDBConnection_1 to tDBRow_1 using a Trigger > On Subjob OK connection
    2. tDBRow_1 to tDBRow_2 using a Trigger > On Subjob OK connection
    3. tDBRow_2 to tDBRow_3 using a Trigger > On Subjob OK connection
    4. tDBRow_3 to tDBInput_1 using a Trigger > On Subjob OK connection
    5. tDBInput to tLogRow using a Row > Main connection
    6. tDBInput_1 to tDBClose using a Trigger > On Subjob OK connection