IBM Information Server provides a native Snowflake Connector to write, read and load data into Snowflake datawarehouse and integrate the same into the ETL job design.
This recipe demonstrates a simple use case of writing(inserting) enterprise data (DB2 database as source) into Snowflake tables using Snowflake Connector.
Designing the datastage job
To create a job that writes data into Snowflake datawarehouse the Snowflake connector should be on the target side , as we are reading data from DB2 using DB2 connector , DB2 Connector should be on the source side. The job design should look as below-
Configure Snowflake connector properties and running the job
1. Put in the values for Account name, Region, Username and Password that correspond to your Snowflake datawarehouse account details.
2. Provide values for Database and Schema where the table, into which data is to be written is present.
3. Alternatively by selecting the property ‘Use connection URL‘ to ‘Yes‘ , the ‘URL‘ property would be enabled and other connection properties would be disabled and in the URL property the snowflake jdbc URL can be specified. The Snowflake jdbc URL should be like –
4. Select ‘Write mode’ = Insert and specify the table name in ‘Table name’ property.
5. Select ‘Table action’ = Append to append data into an existing table.
6. Configure the columns page with the table schema.
7. Compile and run the job.
Writing data using Snowflake Connector –
Configuring Snowflake Connector as target –