Filter IN / NOT IN

1 Agent Answer  |  1 Community Answer  |  Jul 19, 2017 11:03AM UTC

Hi, would be great to add IN / NOT IN support for filter component. Better yet, please allow free-style filter expressions without being limited to a predefined list of comparison...

Transpose rows component

1 Agent Answer  |  1 Community Answer  |  Jul 17, 2017 03:27PM UTC

Hi, I saw the tutorial for pivoting tables that uses Transpose rows followed by Split. The issue with this approach is that it is highly inefficient and does not scale...

How to see SQL ran by components?

3 Agent Answers  |  3 Community Answers  |  Jul 17, 2017 03:21PM UTC

Hi, I am exploring the Matillion functionality. One thing that is not obvious to me – how do I debug the actual SQL ran by the Matillion components? I know I...

Matillion not being able to access UDF

7 Agent Answers  |  8 Community Answers  |  Jul 13, 2017 04:24PM UTC

Hi everyone, I have created a number of UDF on Redshift but it seems like they cannot be called in Matillion. Error being the typical one: ERROR: function FUNCTION_NAME(bigint) does...

Database Query Concurrency max value

1 Agent Answer  |  0 Community Answers  |  Jun 06, 2017 06:59AM UTC

Hi, how I can increase the "Database Query" component's property "Concurrency"? Currently it only allows a maximum number of 16 and if I input more than that, it shows the...

How to start with a custom SELECT statement?

1 Agent Answer  |  1 Community Answer  |  Jun 01, 2017 07:41PM UTC

I'm new to Matillion. I've started with an Orchestration job that stages some data from my source. Now, say I want to create a Transformation job, and start it with...

Missing Examples?

2 Agent Answers  |  0 Community Answers  |  May 24, 2017 02:14PM UTC

I've noticed that a number of the articles about Transformation Components (and Orchestration Components, too) don't include the examples that are referenced. Map Values, Table Input, Generate Sequence, S3 Load,...

Error creating view: ERROR: relation "XXX" does not exist

1 Agent Answer  |  0 Community Answers  |  May 14, 2017 12:51AM UTC

I'm periodically seeing transform components invalidate with this error message. Sometimes I can clear it by rebuilding tables and sometimes by removing connections and recreating them. Does anyone know the...

Transform component leaves view artifacts

2 Agent Answers  |  1 Community Answer  |  May 09, 2017 07:45PM UTC

I have a transform component set up that contains a SQL Source query going to a Rewrite Table component. The source query is basically a union on two tables, and...

Export row count

2 Agent Answers  |  2 Community Answers  |  Apr 27, 2017 11:06AM UTC

Example. I want to know the total number of rows in a physical table after my transformations is done. Iam using a table update component where I export the row...