This content, written by Bruce Sandell, was initially posted in Looker Blog on Apr 2, 2018. The content is subject to limited support.
Last week, Oracle announced the General Availability of Autonomous Data Warehouse Cloud (ADWC), which was introduced during the .
Looker has spent the past year working closely with Oracle to ensure that we’re able support ADWC at launch, and we are happy to report that Looker provides full support for ADWC as of our 5.10 release.
About autonomous data warehouse cloud
ADWC has all of the key features that you’d expect in a modern data warehouse: it’s simple to provision, it’s fast, and it’s fully elastic for both compute and storage: you can scale your storage and compute up or down instantly, with no down time.
ADWC also provides some advanced features that set it apart. The database is fully autonomous, meaning that is self-managing. DBA’s don’t need to worry about performance optimization techniques like indexes, partitions and materialized views. ADWC uses sophisticated machine learning algorithms to optimize data storage and retrieval based on data volume and usage patterns. An administrator need only specify the required service level for the database and ADWC takes it from there, guaranteeing up to 99.995% reliability.
In addition, ADWC is built on the Exadata platform, Oracle’s highest performance engineered systems, and the performance benefits are obvious when tearing through multi-billion row data sets. It also takes advantage of the new , which includes several significant performance improvements, particularly when it comes to analytical workloads, and there are a number of new Advanced Analytic functions as well.
Benefits for Looker users
ADWC is fully managed, so Data Analysts can spend more time bringing value to the business and less time worrying about how queries are written, how data is organized, or if their infrastructure is properly sized for their workload.
Looker users will also be able to incorporate all of the new analytic into their analysis and can take advantage of Oracle’s Advanced Analytical functions to provide new insights.
And of course, everyone wants to analyze more data and get their results faster, which is where ADWC really shines, providing a great experience for Looker users. Because Looker connects directly to ADWC, users can take full advantage of its impressive performance. Would you like a dashboard that includes the number of unique visitors to your website over the last week from millions of web events? Oracle’s approx_count_distinct function can provide that information so quickly that it will not impact dashboard rendering times.
We’re very excited to be partnering with Oracle on this release and preliminary feedback has been fantastic! We can’t wait to see the amazing things that our customers can do by combining Looker with the speed, performance, reliability and simplicity of Oracle’s new Autonomous Data Warehouse Cloud.
Learn more about how to get started with Oracle’s ADWC .