DBSQL + Serverless Flashcards
What is Databricks SQL?
Databricks SQL (DB SQL) is a serverless data warehouse on the Databricks Lakehouse Platform that lets you run all your SQL and BI applications at scale with up to 12x better price/performance, a unified governance model, open formats and APIs, and your tools of choice - no lock-in.
What is Serverless?
Endpoints that provide instant compute for SQL Queries within Databricks environment instead of Cloud environment.
What problem does DBSQL Solve?
Opens up the lakehouse to millions of technologists who know SQL but not Python or Scala, work in SQL vs Notebooks
What problem does Serverless SQL solve?
Improves customer experience using DBSQL, reduces start up time from minutes to seconds which lowers cost and avoids long idle times for SQL endpoints
Why do customers care about this?
1/Price Performance vs Data Warehouse
2/Breaks down Silos of data lake/Data warehouse by being able to access all the data in lakehouse via SQL
3/Built in Governance
What to look for in positioning with customers?
1/If there is pain with current data warehouse solution
2/If there is pain collaborating across data warehouse and data lake solutions
3/If there is an objection to Databricks due to skillset
Personas for DBSQL?
1/ Architects and DBAs monitoring data warehouses/platforms
2/Analysts/analytics engineers who use SQL to query and transform data
How does it work?
1/Pick Existing SQL Endpoint, Use SQL for alerts and interactive dashboards
2/Integrates with Tableau,FiveTran
Underlying factors
SQL Serverless runs on a compute platform that keeps a pool of servers running and ready providing secure and isolated for customers
Misconceptions
Databricks is rumored to be complex, but DBSQL provides a simple way to build SQL and data warehousing on top of Lakehouse
Lookouts of DBSQL
1/Qualify use cases that require low latency and high concurrency
2/Serverless significantly changes the architecture of data plane
3/Serverless is for instant compute on all clouds. AWS is ~15 seconds
Competitors of DBSQL
1/Snowflake - Focus on price, performance, collaboration
2/Cloud DW (Redshift,BigQuery, Synapse - Multi Cloud vs single,
How much does DBSQL Cost?
1/AWS SQL is $.022 DBU List price
2/Serverless is $0.70DBU LIst Price
3/Serverless includes compute cost that would be incurred by cloud provider