Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.

Creating a remote function from Dataform

Hello Community,

We need in our project, from a Dataform Workflow  to trigger a Cloud Run Workflow via an end point.
For this we decided to use a BigQuery Remote Function and call it from our Dataform Workflow.
The BQ remote function looks like this:

CREATE FUNCTION PROJECT_ID.DATASET_ID.remote_add(x INT64, y INT64) RETURNS INT64
REMOTE WITH CONNECTION PROJECT_ID.LOCATION.CONNECTION_NAME
OPTIONS (
endpoint = 'ENDPOINT_URL'
)

DATASET_ID: the ID of your BigQuery dataset.
ENDPOINT_URL: the URL of your Cloud Function or Cloud Run remote function endpoint.

 

The question would be, can we create the BQ remote function directly from Dataform and not doing it manually from BQ user interface?


Thank you and Best regards,
Valentin

0 3 532
3 REPLIES 3