How to build a cloud data mart in 20 minutes
summary
A cloud data mart is built in 20 minutes on Autonomous Database by provisioning an ADB (8 OCPUs with auto‑scale to 24), loading four CSV dimension files and linking 24 parquet sales files as an external table, the CSV load taking ~14 seconds. A data flow aggregates SALES_EXT into SALES_AGG_EXT; an analytic view with measures (including a Discount calc and prior‑period change) is published as SALES_AGG_EXT_AV and used successfully for pivot and chart analysis.
AI-written summary · about
chapters (7)
- 0:00Intro
- 1:48Five step process
- 2:17Demo
- 4:22Load or link data
- 7:42Transform data
- 11:48Analyze data
- 15:54Review
related talks
30mSelf-service data warehousing
27mAutonomous Database Data Studio
28mAutonomous Data Warehouse and the Data Lake
27mHow To Develop & Operate An Agile Cloud Datawarehouse In A Rapidly Changing Multi-ERP Environment
14mMulticloud Analytics Made Simple
23mOracle Autonomous Data Warehouse and data lakes
32mIntroducing Oracle Autonomous AI Lakehouse Open Multicloud Data Platform
43mData warehousing reinvented for today's needs