Skip to main content

Datometry Documentation

Install Hyper-Q User Defined Functions for Google BigQuery

Hyper-Q utilizes user defined functions (UDFs) to implement standard functionality. These are referred to as Standard UDFs. The UDFs must be installed in the Azure Synapse instance and updated with each new Hyper-Q release.

  1. Locate the UDF source files in the directory /opt/datometry/dtm/udf/standard.

  2. (Optional) If using an MD store setup deviating from the default outlined in this guide, you must adjust the schema in the UDF source files to match it by replacing __DTM_MDSTORE with the appropriate schema name.

  3. Execute the SQL contained in all UDF source files directly on the Google BigQuery instance using a database client to connect directly to the instance.

Note

Some database clients require explicit batch handling to split multiple requests in the same file. To learn how to process batch files with BigQuery, see Running interactive and batch query jobs in the Google BigQuery documentation.