We use Google Cloud Platform - Bigquery as our primary database.
We would like to run a sql file stored in the GCP bucket or local drive and load the output results into respective tables, precisely Insert into table sql statements.
The main purpose to do this is to avoid code changes to the Talend job, instead update the sql that is stored at a particular location.
Please let us know how can we implement the above in Talend job.
