Databricks SQL
Who are the key audiences and side audiences for Databricks SQL? - answerSQL
analysts, and Business stakeholders.
How can users view and run Databricks SQL dashboards as stakeholders? - answer-
Dashboards can be put on a schduele to run or manually ran.
- Links are emailed to stakeholders when giving permission or can give them the link
externally.
What are the beneifts of using databricks sql for in-lakehouse platform data processing?
- answer- Full ACID Transaction
- Focus on your data flow, instead of worrying about failures.
- Open Standards, open source.
- Store petabytes of data without worries of lock-in. Growing community including
Presto, Spark and more.
- Unifies streaming/batch. Convert existing jobs with minimal modifications.
How do you complete a basic Databricks SQL query? - answer1. Select SQL Editor in
sidebar.
2. Click '+ NEW' in the sidebar and select Query.
3. In the sidebar, click Queries and then click + Create Query
4. In the sidebar, click Workspace and then click + Create Query
5. Select a SQL warehouse (catalog, schema, table)
6. Run query.
Where do you create a databricks SQL query to run/write code? - answero Workspace -
>Add (dropdown)- > Select query
o SQL Editor -> '+' -> Create New Query
What does the schema browser show/contain? - answero Break the catalogs down.
Lists:
Catalogs -> Schemas -> Tables -> Columns
How do you add multiple queries to a dashboard? - answer- Able to do
- Click on elpises and select 'Edit' and can add/delete dashboards.
How do you complete a basic Databricks SQL dashboard? - answero Click '+ NEW' in
the sidebar and select Dashboard
o Click Dashboards in the sidebar and click '+Create Dashboard'
o Click Workspace in the sidebar and click '+Create Dashboard'
o If you don't want to start from an empty dashboard, you can create a quick dashboard
, § Click 'Catalog' in the sidebar
§ Browse to the table, then in the 'Actions' menu, click 'Create a quick dashboard'
How can dashboards be configured to automatically refresh? - answero Dashboard
owner and users with the Can Edit permission can configure a dashboard to
automatically refresh on a schedule. To automatically refresh a dashboard:
1. Click 'Schedule at the top right of the dashboard. The scheduling dialog appears.
2. In the 'Refresh every' drop down, select a period
3. In the SQL warehouse drop-down, optionally select a SQL warehouse to use for all
the queries. If you don't select a warehouse, the queries execute on the last used SQL
warehouse.
4. Next to 'Subscribers', optionally enter a list of emails to notify when the dashboard is
automatically updated.
5. Click 'Save'. The schedule label changes to 'Scheduled'
What is the purpose of databricks endpoints/warehouses? - answero Fully managed
SQL-optimized compute clusters that auto scale based on user load to support a better
experience for user concurrency and performance.
-- Faster launch times
-- Simplify the SQL endpoint management
What can serverless Databricks SQL endpoints/warehouses do for quick starting? -
answero With serverless compute, the compute layer exists in your databricks account
rather than your AWS account. This gives users in your account instant access to fully
managed and elastic compute resources.
-- Serverless Quotas: are a safety measure for serverless compute. Serverless Quotas
restrict how many serverless compute resources a customer can have at any given
time.
What are the trade offs between cluster size and cost for Databricks SQL
endpoints/warehouses? - answero Classic/Pro.
--Nonserverless, essentially create the size of your clusters. Slower than serverless.
-- Environments have to load up, taking a bit longer.
o Serverless
--Environments are ready, take 2-3 seconds to load.
--Less customizable, but much easier.
--Save a lot more money.
What does Partner Connect do for intergrating data products? - answero Dedicated
ecosystem of integrations that allows users to easily connect with popular data
ingestion, transformation and Bi partner products.
o Helps data analysts get useful data into their lake house faster without the need to
manually configure each product so they can get data-driven insights.
Who are the key audiences and side audiences for Databricks SQL? - answerSQL
analysts, and Business stakeholders.
How can users view and run Databricks SQL dashboards as stakeholders? - answer-
Dashboards can be put on a schduele to run or manually ran.
- Links are emailed to stakeholders when giving permission or can give them the link
externally.
What are the beneifts of using databricks sql for in-lakehouse platform data processing?
- answer- Full ACID Transaction
- Focus on your data flow, instead of worrying about failures.
- Open Standards, open source.
- Store petabytes of data without worries of lock-in. Growing community including
Presto, Spark and more.
- Unifies streaming/batch. Convert existing jobs with minimal modifications.
How do you complete a basic Databricks SQL query? - answer1. Select SQL Editor in
sidebar.
2. Click '+ NEW' in the sidebar and select Query.
3. In the sidebar, click Queries and then click + Create Query
4. In the sidebar, click Workspace and then click + Create Query
5. Select a SQL warehouse (catalog, schema, table)
6. Run query.
Where do you create a databricks SQL query to run/write code? - answero Workspace -
>Add (dropdown)- > Select query
o SQL Editor -> '+' -> Create New Query
What does the schema browser show/contain? - answero Break the catalogs down.
Lists:
Catalogs -> Schemas -> Tables -> Columns
How do you add multiple queries to a dashboard? - answer- Able to do
- Click on elpises and select 'Edit' and can add/delete dashboards.
How do you complete a basic Databricks SQL dashboard? - answero Click '+ NEW' in
the sidebar and select Dashboard
o Click Dashboards in the sidebar and click '+Create Dashboard'
o Click Workspace in the sidebar and click '+Create Dashboard'
o If you don't want to start from an empty dashboard, you can create a quick dashboard
, § Click 'Catalog' in the sidebar
§ Browse to the table, then in the 'Actions' menu, click 'Create a quick dashboard'
How can dashboards be configured to automatically refresh? - answero Dashboard
owner and users with the Can Edit permission can configure a dashboard to
automatically refresh on a schedule. To automatically refresh a dashboard:
1. Click 'Schedule at the top right of the dashboard. The scheduling dialog appears.
2. In the 'Refresh every' drop down, select a period
3. In the SQL warehouse drop-down, optionally select a SQL warehouse to use for all
the queries. If you don't select a warehouse, the queries execute on the last used SQL
warehouse.
4. Next to 'Subscribers', optionally enter a list of emails to notify when the dashboard is
automatically updated.
5. Click 'Save'. The schedule label changes to 'Scheduled'
What is the purpose of databricks endpoints/warehouses? - answero Fully managed
SQL-optimized compute clusters that auto scale based on user load to support a better
experience for user concurrency and performance.
-- Faster launch times
-- Simplify the SQL endpoint management
What can serverless Databricks SQL endpoints/warehouses do for quick starting? -
answero With serverless compute, the compute layer exists in your databricks account
rather than your AWS account. This gives users in your account instant access to fully
managed and elastic compute resources.
-- Serverless Quotas: are a safety measure for serverless compute. Serverless Quotas
restrict how many serverless compute resources a customer can have at any given
time.
What are the trade offs between cluster size and cost for Databricks SQL
endpoints/warehouses? - answero Classic/Pro.
--Nonserverless, essentially create the size of your clusters. Slower than serverless.
-- Environments have to load up, taking a bit longer.
o Serverless
--Environments are ready, take 2-3 seconds to load.
--Less customizable, but much easier.
--Save a lot more money.
What does Partner Connect do for intergrating data products? - answero Dedicated
ecosystem of integrations that allows users to easily connect with popular data
ingestion, transformation and Bi partner products.
o Helps data analysts get useful data into their lake house faster without the need to
manually configure each product so they can get data-driven insights.
