Create a Starburst (Trino) Data Source

The trino endpoint allows you to connect and manage Trino data sources in Immuta.

Trino workflow

Create a data source

POST /trino/handler

Save the provided connection information as a data source.

Required Immuta permission: CREATE_DATA_SOURCE

Payload parameters

Response parameters

Request example

This request creates a Trino data source.

Payload example

Response example

Get information about a data source

GET /trino/handler/{handlerId}

Get the handler metadata associated with the provided handler ID.

Query parameters

Response parameters

Request example

This request returns metadata for the handler with the ID 1.

Response example

Manage data sources

Update a specific data source

PUT /trino/handler/{handlerId}

Update the data source metadata associated with the provided handler ID. This endpoint does not perform partial updates, but will allow the dictionary to be omitted. In this case, it uses the current dictionary.

Required: The global GOVERNANCE permission or be the data source owner

Query parameters

Payload parameters

Response parameters

Request example

This request updates the data source name to Marketing Data for the data source with the handler ID 1.

Payload example

Response example

Update multiple data sources

PUT /trino/bulk

Update the data source metadata associated with the provided connection string.

Required: The global GOVERNANCE permission or be the data source owner

Payload parameters

Response parameters

Request example

This request updates the metadata for all data sources with the connection string specified in example-payload.json.

Payload example

The payload below adds a certificate (certificate.json) to the data sources with the provided connection.

Response example

Recalculate the high cardinality column for a data source

PUT /trino/handler/{handlerId}/triggerHighCardinalityJob

Recalculate the high cardinality column for the specified data source.

Required: The global GOVERNANCE permission or be the data source owner

Query parameters

Response parameters

The response returns a string of characters that identify the high cardinality job run.

Request example

This request re-runs the job that calculates the high cardinality column for the data source with the handler ID 30.

Response example

Refresh a view

PUT /trino/handler/{handlerId}/refreshNativeViewJob

Refresh the view of a data source.

Required: The global GOVERNANCE permission or be the data source owner

Query parameters

Response parameters

The response returns a string of characters that identifies the refresh view job run.

Request example

This request refreshes the view for the data source with the handler ID 7.

Response example