Data Load from Transformation Job to Orchestration table created in SNowflake

Matillion ETL
1

I have created a transformation job and running few sql query where Iam getting the output 

 

And for the same output I have created a table in snowflake through Matillion orchestration with same output fields the query is generating results

 

Now how do I load data from transformation query Iam getting into orchestration table created in snowflake

2

You have two options here :

 

  1. You can create your Orchestration job in following order
    1. Create Table Component - to create the table by predefined definition
    2. Call Transformation job to insert data(Using Table Output component) into the table created in previous step.

0694G00000NRmYAQA1_0D74G000006d89QSAQ

  1. The other option is to use Rename component to tidy up the columns in your transformation job and then use Table Output to create the table after the sql query