MicroStrategy ONE

Connect to Trino

Starting in MicroStrategy 2021 Update 8, you can connect to Trino. Trino is a distributed SQL query engine that stands out for many reasons:

  • Built around replacing the Hive runtime engine to allow for faster querying of Big Data warehouses and data lakes.

  • Designed to query large data sets distributed over one or more heterogeneous data sources.

  • It’s super fast at ad-hoc queries over various data sources, including data lakes such as Iceberg/Databricks or data warehouses such as Hive/Snowflake.

Connect in MicroStrategy

  • Web
  • Workstation
  • Workstation Local Mode

  1. In MicroStrategy Web, click Create > Add External Data.

  2. Find and select the Trino connector from the data source list.

  3. Select an import option and click Next.

  4. Next to Data Sources, click New Data Source to add a new connection.

  5. In the Connections dialog, complete the required fields.

  6. Copy the generated truststore file to your local machine. You must provide an absolute path to the truststore file.

  7. Click Save.

  8. Connect to the saved Trino data source and select the tables you want to import.

  9. Prepare the data or click Finish. You can now use the saved cube to build dashboards.

Connect a Data Source

  1. In the Navigation pane, click , next to Datasets

  2. Choose an Environment, Project, and Data Import Cube.

  3. Find and select the Trino connector from the data source list.

  4. Select an import option and click Next.

  5. Next to Data Sources, click New Data Source to add a new connection.

  6. In the Connections dialog, complete the required fields and copy the generated truststore file on to your local machine and ensure to provide the absolute path to the truststore file.

  7. Click Save.

  8. Connect to the saved Trino data source and select the tables you want to import.

  9. Prepare the data or click Finish. You can now use the saved cube to build dashboards.

Create a Data Source

  1. Connect to an environment.

  2. In the Navigation pane, click , next to Data Sources.

  3. Find and select the Trino connector from the data source list.

  4. Create a new Trino connection.

  5. Complete the required fields.

  6. Upload the truststore certification and enable TLS encryption, if necessary.

  7. Save the data source. Use this data source in MicroStrategy Web or Workstation to create datasets and dashboards.

  1. In the Navigation pane, click , next to Dashboards.

  2. In the Datasets panel, click New Data.

  3. Find and select the Trino connector from the data source list.

  4. Select an import option and click Next.

  5. Next to Data Sources, click New Data Source to add a new connection.

  6. Complete the required fields.

  7. Copy the generated truststore file to your local machine. You must provide an absolute path to the truststore file.

  8. Click Save.

  9. Connect to the saved Trino data source and select the tables you want to import.

  10. Prepare the data or click Finish. You can now use the saved cube to build dashboards.