Upload UDF in BigQuery using Python API Client

Question

I would like to create a UDF inside a specific dataset in BigQuery. I've tried using the create_table and other API methods from the Python Client but none seem to work.

Is there any method or way to upload a UDF (stored in a file and read it as a string) into BigQuery?

Suds · Accepted Answer · 2020-10-02 15:27:14Z

2

This is my UDF:

$ cat test.udf
CREATE OR REPLACE FUNCTION dataset_name.addFourAndDivideAny(x ANY TYPE, y ANY TYPE) AS ((x + 4) / y);

This is my upload command ran on Cloud Shell (it will ask to authorise):

bq query --nouse_legacy_sql  < test.udf

In python:

from google.cloud import bigquery

client = bigquery.Client()

with open('test.udf', 'r') as file:
     QUERY = file.read().replace('\n', '')

query_job = client.query(QUERY)

I have got the UDF in single line in the file, but you can use multi-lines file as well. Just make sure the QUERY string is properly constructed.

edited Oct 2, 2020 at 15:27

answered Oct 1, 2020 at 18:22

Suds

1566 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Julian Over a year ago

This works perfectly using the bq in bash. But I was wondering if this could also be achieved in Python?

Suds Over a year ago

@Julian - I have added python way as well.

Julian Over a year ago

Ye, i did the same way, I was creating a job_config and calling methods: create_table and some others instead of just querying what I was needing. Thanks so much :)

Collectives™ on Stack Overflow

Upload UDF in BigQuery using Python API Client

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related