Run a complexe SQL "script" to create tables in Bigquery (GCP)

aurelien_b

Hello everyone,

I have a serious trouble when i want to process my data from one table in bigquery to another via the execution of a sql script. See the error below. (This step writen in sql is a processing step which should run in bigquery compute instance)

Do you have any idea?

Thanks in advandfor your answer

Sarina

Hi @aurelien_b
,

For the validation error you see, I would suggest walking through the BigQuery JDBC steps outlined here, in case something was skipped.

Regarding the second message, note that SQL script recipes are not supported for BigQuery. As an alternative, you might try creating a Python recipe with SQLExecutor2. Your query is more complex, but here's a brief example of executing SQL statements with SQLExecutor2 for BigQuery.

Hope that helps,

Sarina

CoreyS

Hi, @aurelien_b
! Can you provide any further details on the thread to assist users in helping you find a solution (insert examples like DSS version etc.) Also, can you let us know if you’ve tried any fixes already?This should lead to a quicker response from the community.

aurelien_b

Hello Sarina,

Thanks for your answer, it's very clear.

Aurélien