Rename columns in the "Extract" phase of the Salesforce Query component

Matillion ETL
1

Is it possible to rename columns as part of the Salesforce Query component in a Orchestration job? I know that I can rename columns using a Transformation job, but I would like to avoid creating that extra Transformation job just to rename columns. Please advise.

2

Hey @saqib​

I hope you are well 😊 I have had a conversation internally about this and it can be achieved in "Advanced Mode" and using an alias such as SELECT "column" AS "ALIAS"

I hope that helps, please keep me posted.

Thanks Joe

3

Hi @JoeCommunityManager​ . Thanks for the response. Yes, I use this strategy in certain places. However when dealing with large number of columns, this is not feasible. What I was a looking was a way to provide a grid variable to the Salesforce Query component with the original column names and the renamed column names.

4

I see, thank you for your reply. An option here would be to head back to basic mode and copy the SQL from the SQL Tab and add the As XXX part to the specific columns you want.

 

Thanks Joe