Getting Started with Databricks SQL

preview_player
Показать описание
It has long been said that business intelligence needs a relational warehouse, but that view is changing. With the Lakehouse architecture being shouted from the rooftops, Databricks have released SQL Analytics, an alternative workspace for SQL-savvy users to interact with an analytics-tuned cluster. But how does it work? Where do you start? What does a typical Data Analyst’s user journey look like with the tool?

This session will introduce the new workspace and walk through the various key features – how you set up a SQL Endpoint, the query workspace, creating rich dashboards and connecting up BI tools such as Microsoft Power BI.

If you’re truly trying to create a Lakehouse experience that satisfies your SQL-loving Data Analysts, this is a tool you’ll need to be familiar with and include in your design patterns, and this session will set you on the right path.

Connect with us:
Рекомендации по теме
Комментарии
Автор

Really like this guy's way of gem

asheetsinvhal
Автор

I know I'm late but just wow, this guy's presentation skills are top notch. Honestly that's even an understatement.

benwagner
Автор

Very late to this, transitioning to a new role with Databricks, this guy is top notch, I would watch full on playlists on him going through Databricks

EuanMX
Автор

I was terrified that Databricks was only for Data Engineering/Scientist, however, this presentation helped me understand the other possibilities, which are crucial to a data analytics position I'm seeking. Thank you.

enqithegod
Автор

Hey Simon. Great video. It might be great to update it to 2024, including Unity Catalog, Federated Catalog, improvements in SQL, etc! Thanks for all your great videos

nsulikow
Автор

Thank you for the overview. That was very helpful. :)

CalvinPuah
Автор

Super presentation Simon thanks for sharing

drummerboieva
Автор

Great Job, the intro I was looking for.

Jim
Автор

I am looking and looking but I can't seem to find an example of how to use Widgets on Databricks SQL Dashboards. I'd love to create dropdowns where the user could choose the kind of data they are seeing instead of creating one view for each set of data although it is the same metric.

lauramartins
Автор

your presentation is good but I think you need to show how you can attach to different types of data in the lake. What if we have structured storage or unstructured storage how do I engage those different storage silos and make queries

michaeldemarco
Автор

Hello Databricks, I can see the SQL end point unable to start . Is there any issue?

abdulamz
Автор

Really interested in seeing how it compares to Synapse Serverless in terms of performance and cost

danhorus
Автор

hello, I am doing the Data analyst course in Databricks but I do not have the option SQL environment, just Data Engineer and Machine learning. How can I get the SQL option on the databrick cloud? thank you

Luis-srnt
Автор

How do we get the primary key of a table in data bricks in SQL

priyankamahato
Автор

How does this works when your complete data is not residing in Databricks. Can it access data residing in other places which are connected to Databricks and then join with some data on Databricks and then presents these dashboards ?

MrReachashish
Автор

Great clip. A question about the data warehouse where data sits on the data lake parquet files. Can Databricks SQL cache the data model before Tableau consumes it or data needs loading to Synapse first?

tadastadux
Автор

What kind of SQL language does it use? e.g. TSQL?

anthonyphan
Автор

How do I access or add SQL Analytics to my Databricks workspace in Azure ? Is it a separate subscription ? seems like its missing from my workspace.

hakobavjyan
Автор

Is this really only limited to SQL? Can you build dashboards with other API's like python or scala?

gardnmi
Автор

When is the new Databricks UI planned for a launch? Mainly for SQL Analytics.

palashs