Execute SQL files in tBigQuery Components

rajesh90 — Sat, 16 Nov 2024 00:05:51 GMT

Hello Team,

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.

Thank you.

Re: Execute SQL files in tBigQuery Components

kakooo16 — Tue, 01 Jun 2021 14:43:37 GMT

To achieve this you will have probebly to use this job design

in tFileInputraw : you will pass your .sql file

topic Re: Execute SQL files in tBigQuery Components in Talend Studio

Execute SQL files in tBigQuery Components

Re: Execute SQL files in tBigQuery Components