Transformation Components

Filter value

how to use - convert_timezone('UTC',CURRENT_TIMESTAMP) in filter value

Casting when doing table update

I've loaded in some data from an external source, it comes in as varchar when I do do a table update it a column with a type variant. I get...

SQL Component - Delete

Hi Im trying to Delete rows in a table by using the SQL Component. i have two inputs to SQL component one is tables that i want to delete some...

Lookup's in Matillion ETL for snowflake

I am new to matillion and i want to know about lookup's, Can anyone tell me?

Updates not showing

Hi, The table Update step doesn't seem to show an accurate reflection of the number of updates that occurred. Is this by design? I know the JDBC makes this information...

Store a SQL result in a variable

I want to store a SQL result in a variable. There doesn't appear to be an easy way to do this in Snowflake Matillion. I have a batchid that I...

Integration with hive and EMR

We have a use case where we load raw feed data from S3 onto EMR and use hive queries to create temp tables and transform the data before loading it...