Skip to main content Skip to complementary content

Creating the Job for querying data through a Snowflake external table

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

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!

Leave your feedback here