Trino
This page describes how to use Trino or Starburst as a source in Activations.
Getting Started
Activations can use Trino (and any supported Trino catalog) as a source. Activations has been tested with the open-source Trino as well as Starburst Galaxy and Starburst Enterprise.
- Open Activations and navigate to the Sources page.
- Click New Source and select Trino from the list.
- Configure your Trino connection:
- Enter your Trino host name
- Enter your Trino user name
- Enter your Trino password
- (Optional) If your Trino instance does not run on port 443, enter the port here. Activations requires a TLS connection to Trino.
- You’re all set! Head over to the Syncs page to activate your data.
How to find your Hostname in Starburst:
Activations utilizes JDBC in order to connect to Trino/Starburst. In order to get the correct hostname to input into your Activations connection you will want to follow the instructions linked here in Starburst's documentation to get your JDBC url for your desired cluster.
Once you have the JDBC url you'll only need to input the subdomain into the Activations hostname field.
Example JDBC url: jdbc:trino://census-example-cluster.trino.galaxy.starburst.io:443?user=mytestuser@getcensus.com/accountadmin
Hostname value to input into Activationscensus-example-cluster.trino.galaxy.starburst.io
Using the Advanced Sync Engine
Trino supports both of Activations' Sync Engines: Basic and Advanced. In order to use the Advanced Sync Engine with Trino, all of the following must be true:
- Your Trino cluster must have a catalog named
CENSUScontaining a schema namedCENSUS - The connector you use for the
CENSUScatalog must support:CREATE TABLEandDROP TABLE- Table writes, including row-level
INSERT,DELETE, andUPDATEoperations. Tables that support these operations are sometimes called "transactional" tables in Trino connector documentation, although Activations does not require true ACID transactions for the Advanced Sync Engine. - The
CREATE OR REPLACE TABLEstatement, which was added to Trino in October 2023 and is available in some Starburst releases (check the release notes for your Starburst Enterprise version or for Starburst Galaxy).
- The account (service account or user) that Activations uses to connect to your Trino cluster must have full permissions for the
CENSUS.CENSUSschema.
We have successfully tested Activations' Advanced Sync Engine with the following configurations - it's possible that other configurations are supported, and we encourage you to use the Activations connection tester to obtain diagnostics if needed:
CENSUScatalog using the MySQL, Postgres, and Snowflake connectors in read-write modeCENSUScatalog using the Iceberg connector with S3 object storage and the AWS Glue catalogCENSUScatalog using the Starburst Delta Lake connector, on both the AWS Glue catalog and the Starburst Galaxy catalog
Activations is unable to provide any additional Trino table options (such as location) to the WITH clause when creating or managing tables in the CENSUS catalog, so please ensure your catalog and schema are configured with any needed default table options.
Notes
As of December 2023, Warehouse Writeback is not yet supported but is coming soon - please reach out to your Activations account executive for details.