0
I tried several ways to call a Procedure through this interesting Big Query feature for scheduling queries. If it is possible to call Procedures through this feature, it will be a great opportunity to work in various ways with the data in Big Query.
I have tried to call these procedures in several ways, in short:
CALL project.schema.procedure()
CALL schema.procedure()
CALL procedure()
I ask for help!!!! Thank you!
0
This feature is available in Bigquery and works well, just create a new query tab, place your call and click the programming button
Behold:
However, it is important to note that the function or precedent name must be with the full path and not only the name as you put it:
CALL `data-analytics-sandbox-dev.data_analytics_utils.SPC_GENERATE_REVENUE_DEF`();
Once you do this just add the execution data and be happy. :)
Then just follow the execution:
Browser other questions tagged bigquery
You are not signed in. Login or sign up in order to post.