Creating the Job for querying data through a Snowflake external table
Procedure
- Create a standard Job.
-
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 -
Connect the components:
- tDBConnection_1 to tDBRow_1 using a Trigger > On Subjob OK connection
- tDBRow_1 to tDBRow_2 using a Trigger > On Subjob OK connection
- tDBRow_2 to tDBRow_3 using a Trigger > On Subjob OK connection
- tDBRow_3 to tDBInput_1 using a Trigger > On Subjob OK connection
- tDBInput to tLogRow using a Row > Main connection
- 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!