Cloud Data Warehousing on Data Lakes: Databricks Launches SQL Analytics


Databrick is a data analytics and Artificial Intelligence company that reports the launch of an SQL analytics service that makes it easier for data analysts to run their standard SQL queries directly on data lakes.

A data lake is a system or storehouse where data stored in its natural/raw format that expands the scope of Data Lake from Machine Learning and data science to all data workloads including BI or Business Intelligence and SQL. SQL Analytics will be available for public preview on November 18. Now, the organization can allow data teams to work on a single source for data science, data analytics, and data engineering.

Lakehouse architecture eases data and Artificial Intelligence for the organization. Previously, the data groups had to maintain a proprietary data warehouse for BI workloads as no other data platform could meet the performance needed for BI and the flexibility needed for data science. Maintenance is expensive and complicated, this conjunction of legacy architecture has created data silos slow down team productivity and innovation. A Lakehouse directs this by running all workloads by a single architecture.

Dan Jeavons, GM Data Science, commented that Shell chose Databricks as one of the foundational components of its platform. Shell has undergone a digital transformation to deliver more and cleaner energy solutions for which they are investing heavily in data lake architecture as wee as they wish to enable data teams to rapidly query massive datasets in the simplest possible way. Executing rapid queries on petabyte-scale datasets using standard BI tools is a game-changer. SQL Analytics is built on Data Lake, an open organization data motor that includes quality, dependability, and security, to a client’s present data lake. Customers can avoid multiple storing of data or duplicates of data as well as locking data up in proprietary format.

To convey BI-execution on a data lake, SQL Analytics uses two unique innovation, first is easy to use auto-scaling endpoints. That keeps question idleness reliably low under high client load. Second is the Delta Engine, Databricks unique question execution engine. It used to complete questions quickly against both small and large data sets. With local connectors for all BI tools such as Tableau and Microsoft Power BI, Clients can easily integrate SQL Analytics into existing BI workflow to perform analytics. SQL Analytics allows a SQL local question and visualization interface to let analysts, data scientists, and developers without access to previous BI tools to build dashboards and reports that can effectively share inside their association.

The lakehouse architecture held by Databricks partners includes BI Partners such as Tableau, Power BI, Qlik, Looker, Thoughtspot, Ingest Partners such as Fivetran, Fishtown Analytics, Matillion, Talend, Catalog Partners such as Collibra, Alation, and Consulting Partners such as Slalom, Thorogood, Advancing Analytics.


Please enter your comment!
Please enter your name here