Creating the Job
![](/en-US/components/8.0/Subsystems/elt-mssql/Content/Resources/images/elt_snowflake_using_variables_job.png)
Before you begin
-
A new Job has been created and the context variables SourceTableS with the value STUDENT, SourceTableT with the value TEACHER, and TargetTable with the value FULLINFO have been added to the Job. For more information about how to use context variables, see the related documentation about using contexts and variables.
-
The source table STUDENT with three columns, SID and TID of NUMBER(38,0) type and SNAME of VARCHAR(50) type, has been created in Snowflake, and the following data has been written into the table.
#SID;SNAME;TID 11;Alex;22 12;Mark;23 13;Stephane;21 14;Cedric;22 15;Bill;21 16;Jack;23 17;John;22 18;Andrew;23
-
The source table TEACHER with three columns, TID of NUMBER(38,0) type and TNAME and TPHONE of VARCHAR(50) type, has been created in Snowflake, and the following data has been written into the table.
#TID;TNAME;TPHONE 21;Peter;+86 15812343456 22;Michael;+86 13178964532 23;Candice;+86 13923187456