Transformation Components

Can I Write to an Oracle database?

Can i write the result of a Transformation to an on-premise Oracle database? A more general question is what are the possible targets of write the output of a transformation?...

Store query result to variable

Is there any way to store query result to variable in Transformation job ? I want to save single output value from SQL component to variable and the use it...

extract date from timestamp

the following query syntax is incorrect: select *, 'Y' as ISACTIVE from "Patient" where date("LastUpdated") in (select date(max("LastUpdated")) from "Patient") It keeps saying invalid date identifier. Please help Thanks,

Netezza to Snowflake

Hello! Can we use Matillion to convert Netezza to Snowflake? Couldn't find any obvious indications of this, at least as far as named source components were concerned, so just wanted...

Table Update

I'm trying to understand the Table Update component - the online support doc seems to differ from the latest version of the component. I would like to update a table...

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...