Advanced

Error Creating New Proejct

I am trying to create a new project and the process fails with error message: User [****] failed to create an Environment in the newly created Project in the Project...

API Query Component

I have a requirement to get Google search console (GSC) data through matillion.I do have API_key, which is running fine through API Explorer. Now i have seen in one of...

CDC job - Capture only INSERT/UPDATE exclude DELETE

Dear Team, Please let me know how to proceed if i want to capture only INSERT/UPDATE records in source Oracle RDS excluding DELETE record action and load into Snowflake while...

Automatic Variables

How to populate Automatic Variables like Job_Id, Environment_Id, Job_name to an Audit table? They are not shown by default for all components.

Manage permissions at project level

Hello, Is it possible to have the permissions available at "Manage Permissions" in "Admin" menu but at project level instead for all projects? If I want to give some permissions...

CDC - DELETE record reverse propagation from Oracle to Snowflake

We managed to configure CDC with Matillion and its working for record INSERT/UPDATE (In source Oracle RDS) but unfortunately DELETE records in Oracle (Source DB) are not propagated through Matillion...

Incremental Updating to S3

Hello, Currently, it's my understanding that the only way matillion can unload data to S3 is through the "Unload to S3" orchestration component. I was wondering whether there was a...

Job metrics

Is it possible to export some of the metrics availablee in the task hierarchy into JSON or an external table? Specifically the job steps, runtimes and insert/update counts.

Can data be written from Snowflake into MS SQL Server?

Hi, I'm trying to automate an import of some data that I have in the data warehouse (Snowflake) back to our internal database (MS SQL Server). I've seen the Database...

Parallelism with Matillion ETL for Snowflake

Hi, is this document valid also in Snowflake: https://redshiftsupport.matillion.com/customer/en/portal/articles/2789349-parallelism-with-matillion-etl-for-redshift So only way to use parallelism in Matillion is to use Orchestration jobs that can be launch same time? Or is...