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?