New Data Loading experience in Autonomous Database Data Studio

January 19, 2024 | 3 minute read
Alexey Filanovskiy
Product Manager
Text Size 100%:

Exciting New Updates in Data Studio

Data Studio has always been a powerhouse for handling data, offering a suite of tools for data transformationmachine learningdata 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:

  1. Load Data: Standard data loading option.
  2. Link Data: Create an external table while keeping the datasets in their original source.
  3. 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.


Previous Post

Sharing Data from On-Premise Oracle Databases

Alexey Filanovskiy | 4 min read

Next Post


Autonomous JSON Database adopts ECPUs and per-gigabyte Storage, lowering the entry level price point for developers

Hermann Baer | 3 min read
Everything you need to know about data warehousing with the world's leading cloud solution provider