Lakehouse runtime
SQL over Apache Iceberg tables: warehouses, sessions, queries, maintenance, governance, limits and a gallery of worked examples.
Chapters
- IntroductionThe Groundzero Lakehouse is a SQL engine over Apache Iceberg tables. You open a warehouse, start a SQL session on the compute size you choose, and write Spark SQL in the…
- OverviewThe Lakehouse combines the low cost and openness of files in object storage with the tables, transactions and SQL of a database.
- QuickstartThis section takes you from an empty warehouse to a query result you export. You need access to a warehouse (the list in Lakehouse shows the warehouses you can see) and…
- How-to guidesExpand Databases in the tree to see each database (the system database audit is listed first), then Tables, a table and its Columns. A column is shown as name (type).…
- SQL referenceA permission named All at a level covers every action at that level. An explicit table-level deny always wins.
- Limits and behaviourWhen a session stops, whatever lived only in memory is gone: temporary views, SET values and unread results. Tables and data are never affected.
- Troubleshooting
- Examples galleryThe examples use fictional data for Acme Retail, held in these tables of the acme-retail-lake warehouse. Run each statement on its own.