Deep dive: Data loading

on YouTube ↗21m

" summary

Oracle Autonomous Database’s Data Load GUI performs real-world loading without scripting: it creates tables, infers columns and types from Excel and JSON, stores complex JSON objects for later SQL parsing, and runs batch merges using DBMS_CLOUD.COPY_DATA. A demo loads two years of monthly sales from an Object Store and applies 45 files of adjustments merged on OrderNumber, dropping the summed sales (about $160M) as expected. The tool links Parquet as an external table, offers no scripting point‑and‑click runs plus generated SQL for reuse.

AI-written summary · about

" chapters (7)

1. 0:00Start
2. 0:17Data Loading Tools
3. 6:25Load Data from Local File
4. 8:51Set Up a Cloud Location
5. 9:44Load Data from Cloud Storage
6. 11:48Insights
7. 12:04Data Analysis

" related talks

• 30mSelf-service data warehousingPatrick Wheeler · Oracle DatabaseWorld 2021
• 28mAutonomous Data Warehouse and the Data LakeMarty Gubar · Oracle DatabaseWorld 2021
• 23mOracle Autonomous Data Warehouse and data lakesAlexey Filanovskiy · Oracle CloudWorld 2022
• 28mReliable data integration from applications to analyticsJayant Mahto · Oracle CloudWorld 2022
• 27mAutonomous Database Data StudioMike Matthews · Oracle DatabaseWorld: AI Edition 2024
• 34mOracle Autonomous Database: simplify your database managementYasin Baskan · Oracle CloudWorld 2022
• 14mMulticloud Analytics Made SimpleMarty Gubar · Oracle DatabaseWorld: Multicloud AI Edition 2025
• 32mAccess external data sources and web services from your autonomous databaseCan Tuzla · Oracle CloudWorld 2022