Need to set up Incremental extract from Marketing Cloud and load data to Snowflake

Matillion ETL
1

Hi All,

I need to set up Incremental extract from Marketing Cloud and load data to Snowflake.

I have already loaded the data to Snowflake using "Salesforce Marketing Cloud Query" component using ServiceType as SOAP.

 

Can someone please help me how to use the "Query result to Scalar" for setting up of incremental extract from SFMC and load data to snowflake.

 

Thanks,

Mahesh

2

Hi Mahesh,

 

I don't aware of "Salesforce Marketing Cloud Query" but i will help how to use incremental load.

 

As you said have data in snowflake with delta load key column.

Step1: Create environmental variable.

Step2: Add query result to scalar component before your cloud query component.

Step3: Write a query in query result to scalar component to get the maximum deltaload key column from snowflake and map the query result column and variable which you created in step1.

Step4:Now you can use the variable in "Salesforce Marketing Cloud Query" like select * from table where column. >= '${}'

 

Hope this helps!