Skip to main content

Datometry Documentation

Install Hyper-Q User Defined Functions

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 folder /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 Azure Synapse instance using a database client to connect directly to the instance. Suitable clients include sqlcmd, SSMS, and SQL Workbench/J.

    Note

    Some database clients require explicit batch handling to split multiple requests in the same file. To learn how to process batch files with sqlcmd, see KB article How to Process SQL Batches for Azure Synapse Analyics with sqlcmd.