The Dataiku Frontrunner Awards have just launched to recognize your achievements! SUBMIT YOUR ENTRY

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

Solved!
aurelien_b
Level 1
Run a complexe SQL "script" to create tables in Bigquery (GCP)

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

0 Kudos
1 Solution
SarinaS
Dataiker
Dataiker

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

View solution in original post

3 Replies
CoreyS
Community Manager
Community Manager

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.

Looking for more resources to help you use DSS effectively and upskill your knowledge? Check out these great resources: Dataiku Academy | Documentation | Knowledge Base

A reply answered your question? Mark as ‘Accepted Solution’ to help others like you!
0 Kudos
SarinaS
Dataiker
Dataiker

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

View solution in original post

aurelien_b
Level 1
Author

Hello Sarina,

Thanks for your answer, it's very clear.

Aurélien

0 Kudos
Labels (3)
A banner prompting to get Dataiku DSS
Public