Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

SQL component

Is it possible to pass a column as a variable within a query such as:
select row_number() over (partition by ${columnvariable} order by 1,* from ${tablevariable}?


4 Community Answers

Maurizio Heller —

select row_number() over (partition by ${columnvariable} order by 1),* from "${tablevariable}"?
It doesn't recognize the column which it should.

Matillion Agent  

Paul Johnson —

Hi Maurizio,

It would be great if you could let me know which company you are working for and if you are trialling Matillion as we can provide you with some free AWS/GCP credits.

You can use variables in the SQL queries, which components are you using and how are you populating these variables?


Maurizio Heller —

Nevermind I figured it out. The default values need to match the error.

Matillion Agent  

Ian Funnell —

Hi Maurizio,

Good to know you have solved it. Matillion uses the default values for variables during validation, so you’ll usually need to provide a valid default.

Best regards,

Post Your Community Answer

To add an answer please login