How to configure Trino as a destination in Mage to write pipeline data to Trino-compatible catalogs using supported connectors such as PostgreSQL, Iceberg, Delta Lake, and more.
Key | Description | Example Value | Required |
---|---|---|---|
catalog | Trino catalog used to access the target data source (e.g., PostgreSQL, Iceberg, Delta Lake). | my_prod_pg | ✅ |
connector | Trino connector name. Determines how Trino interacts with the catalog’s backend. | postgresql | ✅ |
host | Hostname or IP address of the Trino coordinator. | 127.0.0.1 | ✅ |
port | Port where the Trino coordinator is running. Default is 8080 . | 8080 | ✅ |
username | Username for authenticating with the Trino coordinator. | admin | ✅ |
password | (Optional) Password for Trino authentication. | abc123... | ❌ |
schema | Schema name where the target table will be created or written to. | public | ✅ |
table | Name of the destination table to write data into. | dim_users_v1 | ✅ |
query_max_length | Maximum character length allowed for Trino SQL query payloads. | 1000000 | ❌ |
ssl | Whether to disable SSL certificate verification. Set false to disable. | false | ❌ |
location | (Delta Lake only) URI location of the target table or storage bucket. | s3://my-delta-bucket/ | ❌ |
ignore_location_for_temp_tables | Prevents Trino from setting WITH LOCATION for temp tables. Recommended when using Delta Lake with Glue metastore. | false (default) | ❌ |
WITH LOCATION
property will not delete underlying data when dropped.
To avoid residual files when Mage creates temp tables, set: