Showing results for 
Search instead for 
Did you mean: 

Passing table name dynamically in SQL Transform

Former Member
0 Kudos

Hello Guys,

I am looking for the way to pass table name using global variable in sql transform and extract that table data into simple txt file. The challenge i am seeing is how do you update the schema of sql transform every time table is changed.Because if schema is not updated it wont match with the defined table and the job will fail. Is it possible?

Accepted Solutions (0)

Answers (1)

Answers (1)

Active Contributor
0 Kudos

Is there any specific reason why you lean towards this approach?

I assume you would pass a different table name as value to the global variable every time you execute the extraction.It is not possible. I would not suggest the idea of extracting the tables using SQL transform. By doing that you will be missing the impact/lineage analysis and potentially it will lead to poor performance as well.

0 Kudos

Hi mageshwaran.subramanian ,

Can you look into my question here? It is the same type of work I am trying to get done.