Oracle Autonomous Data Warehouse and data lakes
summary
Oracle positions Autonomous Data Warehouse as a data lakehouse that reads object-storage files (Parquet, ORC, Avro, JSON, CSV) via external tables, infers partitions from directory layouts, and applies Parquet optimizations plus partition pruning with autoscaling CPU for parallel queries. It joins lake files with warehouse tables using standard SQL (building on 30 years of SQL extensions), applies row‑level security and data masking, and supports archiving via hybrid partitioning. Integration with OCI Data Catalog and access to S3/Azure/GCP object stores enables mixed-tool use (Spark/Hadoop) against the same data.
AI-written summary · about
chapters (7)
- 0:00Introduction to data lakes
- 0:17What is a data lakehouse?
- 8:10Analyzing data lake data
- 8:30Power of SQL analysis
- 10:10Performance and multi-cloud
- 12:29Use cases and features
- 22:32Conclusion and resources
related talks
28mAutonomous Data Warehouse and the Data Lake
32mIntroducing Oracle Autonomous AI Lakehouse Open Multicloud Data Platform
21mDeep dive: Data loading
30mSelf-service data warehousing
26mModernize your Enterprise Data Warehouse & generate value from data
02h 05mBig Data and the Data Lake from the Analyst Perspective
31mData Warehouses Meet Data Lakes
24mOracle's vision for simplifying data-driven apps and analytics