Transformation Components

Global Variable in Calculatr

Hi, we're running Matillion ETL for Redshift Version: 1.24.6 (build 55) and I'm trying to use a variable in the expression box of a Calculator component. i defined a simple...

pattern for incremental fact table load by day

I would like to load a fact table 1 day at a time, from the latest day of data in the fact table until the current day. What is the...

URL does not point to an accessible S3 bucket.

Experiencing issue in accessing the s3 URL. when i enter the s3 URL, i get an error "That URL does not point to an accessible S3 bucket." Not sure what's...

Include task information in SNS message

Hi. Is it possible to include systeminformation or taskinforamtion in the SNS message? Perhaps if a component or transformation job fails, the error message in the tasks message flow could...

How do I replace a value in a string?

Is there a transformation component that can be used to replace a value in a string? Say I have a number provided with a comma instead of a decimal point...

Detect Changes component deliveres "ERROR: could not devise a query plan for the given query"

I want to compare 2 tables based on a varchar column using the Detect Changes component. Both (columns component_bk) are equal configured (varchar 25 RAW) I always get "ERROR: could...

Table Output - data mismatch while truncate and insert records into target table

Output generated from Table Output sql query (sample) to the data getting loaded into target Redshift table is not matching. Component A (input): Column1;Column2 -------;------- 1;2 2;3 3;4 4;5 Table...

Filter to items in list

Is it possible to filter a list down to a subset, based on a list of id's in another list? As in a query such as: SELECT id FROM table1...

Map Values Component w/ NULL Default

Using the Map Values component, is it possible to achieve any of the below outcomes using explicit mappings (Value Map) or default values (Other)? - If no explicit mapping is...

Date dimension table creation job

Does anyone have a create date dimension table job they can share? I've seen reference to one in the online documentation. I'd rather not re-invent the wheel here if there...