Data Studio has always been a powerhouse for handling data, offering a suite of tools for data transformation, machine learning, data sharing, and more. In this post, I’m thrilled to dive into the enhancements made to the Data Loading interface and what it means for Autonomous database users, thanks to the latest release.
New Features Unveiled
Data Load has been a part of Data Studio since its inception, playing a crucial role. The latest updates have introduced several exciting improvements, and I can’t wait to share my top picks.
Starting your Data Loading journey is as simple as clicking on the “Data Load” tile within Data Studio. Here’s what you’ll find:
Load Data: Standard data loading option.
Link Data: Create an external table while keeping the datasets in their original source.
Feed Data: Set up continuous data loading for new files arriving at the original data source, like an Object Store.
Noteworthy Enhancements
The first major shift is the move to a Credentials-centric model. Users now input their credentials once and gain access to all tenancy buckets permitted by these credentials. This eliminates the need for creating separate entities for each bucket, significantly enhancing the user experience:
Another upgrade is the revamped UI, which now allows for the automatic addition of expressions to a table. Users can effortlessly add to the table metadata information like the sysdate and the name of the origin file, streamlining the data tracking process:
A crucial new feature is the automatic detection of Personally Identifiable Information (PII). This enables users to identify PII in their data sources and take appropriate actions, such as implementing masking functions:
Lastly, the integration of AI features marks a significant advancement. Users can now generate datasets using AI, providing valuable business support. However, it’s always advisable to verify the AI-generated results for accuracy:
Conclusion
These enhancements to Data Studio’s Data Loading capabilities mark a significant leap forward in data management, offering users a more intuitive, efficient, and secure experience. To learn more about Oracle Autonomous Database capabilities check out this Live Lab.
More is coming, stay tuned!
Alexey Filanovskiy
Product Manager
My role involves overseeing the product management of Data Lake features for the Oracle Autonomous Database.