Is it possible to call a Procedure in Scheduled Queries (Schedule Queries) in the Big Query?

Asked

Viewed 19 times

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!

1 answer

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: inserir a descrição da imagem aqui

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. :) inserir a descrição da imagem aqui

Then just follow the execution: inserir a descrição da imagem aqui

Browser other questions tagged

You are not signed in. Login or sign up in order to post.