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

Snowflake

Version
7.3
Language
English (United States)
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 Open Studio for Big Data
Talend Open Studio for Data Integration
Talend Open Studio for ESB
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

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