CODEWITHSUNDEEP
sqlgoogle-bigquerygcloud
Viriato
Viriato

Reputation: 683

Scheduled query returning "Procedure not found"

We have created a scheduled query on Google's BigQuery API that should call a routine main_routine that is present in a dataset analytics:

call analytics.main_routine()

The region of the dataset and the scheduled query is the same (us).

Every job execution of this scheduled query is returning the following error:

Procedure is not found: analytics.main_routine at [1:6];

Any help is appreciated, thank you!

Upvotes: 1

Views: 658

Answers (2)

kiran mathew
kiran mathew

Reputation: 2343

When you schedule the query, it fails with Procedure not found: analytics.main_routine at [1:6] because it runs on a multi region (US).

Please try to schedule the query on a specific region (single region - us-central1) and let me know if it worked or not.

Multi-region :

enter image description here

Single region:

enter image description here

Upvotes: 1

Mohammad
Mohammad

Reputation: 678

Could you please make sure, Project name is included when calling the procedure as below:

call <Project_name>.<Dataset_Name>.<Procedure_Name>();

Upvotes: 0

Related Questions