Autonomous Database Data Studio

on YouTube ↗27m

" summary

Data Studio links to an AWS Glue catalog and auto-creates external tables over about 20 datasets, loads 24 CSV files from OCI into a single CUSTSALES table, and configures a live feed (object filter custsales*.csv) scheduled daily so new files arrive automatically. It builds SQL-based transforms (OCI/Oracle Data Integrator engine) that produce a reusable CUSTSALES_FACT fact table*, schedules the flow at 7:00 AM, and shares the result with other Autonomous Databases in-region.

AI-written summary · about

" chapters (13)

1. 0:00Autonomous Database Data Studio intro
2. 1:10Finding and understanding data sources
3. 3:13Integrating multiple data sources
4. 7:32Analyzing data with built-in tools
5. 10:24AI-driven data insights
6. 11:09Secure data sharing with stakeholders
7. 12:11Unified metadata with Data Studio Catalog
8. 14:41Demo: AWS Glue data catalog link
9. 17:31Demo loading data from OCI storage
10. 19:17Demo: Continuous data feeds setup
11. 21:07Demo: Reusable data transformations
12. 22:31Demo: Secure cross-database sharing
13. 24:18Summary of Data Studio capabilities

" related talks

• 30mSelf-service data warehousingPatrick Wheeler · Oracle DatabaseWorld 2021
• 28mAutonomous Data Warehouse and the Data LakeMarty Gubar · Oracle DatabaseWorld 2021
• 21mDeep dive: Data loadingBud Endress · Oracle DatabaseWorld 2022
• 20mTips and tricks: Data warehousing for Oracle E-Business Suite and SaaS dataJayant Mahto · Oracle DatabaseWorld 2022
• 19mHow to build a cloud data mart in 20 minutesPatrick Wheeler · Oracle DatabaseWorld 2022
• 32mAccess external data sources and web services from your autonomous databaseCan Tuzla · Oracle CloudWorld 2022
• 23mOracle Autonomous Data Warehouse and data lakesAlexey Filanovskiy · Oracle CloudWorld 2022
• 31mAutonomous Database: Simplify your database managementYasin Baskan · Oracle DatabaseWorld 2021