Tutorials

Migration from Redshift to Snowflake

Hey Matillion, I was wondering if there were any advancements in either functionality, best practices, documentation on migrating from Redshift to Snowflake? Would you be able to point me in...

Azure Active Directory integration

HI I have came across the article : https://snowflakesupport.matillion.com/customer/portal/articles/2945147. Here i could see OpenId connect can be used for connecting Azure AD to the Matillion user configuration. But for my...

Google Analytics

I have a problem with Google Analytics. I want to query traffic data, but only get the data of a specific view. How can I change this view? I've already...

SNS-Message with job status and error message

Hi :) I want to send a SNS Message if a job (transformation) has failed. The Mail should include the job status and the job (error) message. I use the...

s3 tag

Hi, I want to give permission to s3 files to a specific group of users. Is permission bucket specific or file specific? I also want to know the process of...

Export variable in SNS

Hi All, I have a orchestration job 'ABC'. inside ABC, I have a sql script component 'SQL'. If SQL fails---> SNS component. in the SNS, I have used variable $component_name...

Alias in update query

Hi All, I have a redshift based question. I need to execute the below query in sql script component: UPDATE GHHUSDW_SANDBOX.GPO_ION_WK_PUB T1 SET STATUS_CD='RESTATED', --EXPRTN_DT=CURRENT_DATE WHERE STATUS_CD='ACTIVE' AND EXISTS (...

compare sql queries.

Hi All, Please help me with the below requirement: I have 2 queries: 1. select count(data38) from ghhusdw_sandbox.gnrc_stage_load_test 2. select cntrl_file_cnt from ghhusdw_sandbox.claim_batch where ddw_batch_id=(select max(ddw_batch_id) from ghhusdw_sandbox.claim_batch where job_status_cd='Running')...

Or condition failing in calculator

Hi All, I am doing integer validation using calculator and filter component. column to be validated : src_id in source table src_id is varchar field. Here is what I did:...

Generate sequence

I am loading date from a file in S3 to redshift staging table. The table has record_id field in it. I want to generate a sequence for each record. The...