Trino Engineering Notes

README.md

Trino Engineering Notes

1. Trino
   1. sql query engine
   2. for Data Analytics
   3. query large data sets from one or more disparate data sources
   4. open source
2. Starburst Galaxy - A managed Trino Environment.
3. Catalog - some sort of the Database which user queries into
   1. Connector - Configured in each catalog. Read/Write access to a data source.
      1. Connectors behave differently depending on the underlying data source.
      2. Object storage (hive, iceberg) vs SQL DB (mysql)
   2. Catalog contains one or more schema. - similar to postgres
   3. Schema contains one or more tables.
   4. Table contains one or more columns.
   5. Each column has a specific data type.
   6. Each row in a table represents a dataset or record.
4. Querying
   1. Basic

      select *
      from "catalog.schema.table"
      where "column" like "%example%"

5. Datagrip Client
   1. https://docs.starburst.io/clients/datagrip.html
6. https://www.youtube.com/watch?v=SnvSBYhRZLg