Join Manfred, David, and the rest of the Trino Community for Part 3 of the Trino Training Series.
More information including slide decks and scripts at https://trino.io/blog/2023/11/15/sql-training-3
- 0:00 Introduction
- 3:46 Start of Data management with SQL and Trino
- 5:35 Write operations overview
- 6:31 Necessary access and capabilities
- 14:45 Dynamic catalog management
- 21:25 Differences of data sources
- 22:08 Object storage data sources including metadata storage
- 26:25 Traditional RDBMS and other data sources
- 27:53 Impact from data source differences
- 28:24 Schema management
- 31:42 Table management
- 33:28 Determine connector use in catalog with SQL
- 38:05 Hive and Iceberg metadata
- 47:00 Adding data with create table and insert
- 49:54 Insert into and create table as select CTAS
- 53:15 Changing data with updated, delete, and merge
- 1:00:35 Catalog and table procedures
- 1:04:45 Questions and answers
- 1:06:30 Resources and more
