Це відео не доступне.
Перепрошуємо.

Getting Started with Databricks SQL

Поділитися
Вставка
  • Опубліковано 15 сер 2024
  • 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.
    Get Why the Data Lakehouse Is Your Next Data Warehouse to discover the inner workings of the Databricks Lakehouse Platform. Download the ebook: dbricks.co/3ZE...
    Connect with us:
    Website: databricks.com
    Facebook: / databricksinc
    Twitter: / databricks
    LinkedIn: / databricks
    Instagram: / databricksinc Databricks is proud to announce that Gartner has named us a Leader in both the 2021 Magic Quadrant for Cloud Database Management Systems and the 2021 Magic Quadrant for Data Science and Machine Learning Platforms. Download the reports here. databricks.com...

КОМЕНТАРІ • 29

  • @asheetsinvhal2195
    @asheetsinvhal2195 3 роки тому +19

    Really like this guy's way of presentation...technical+marketing gem

  • @benwagner742
    @benwagner742 Рік тому +1

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

  • @enqithegod2254
    @enqithegod2254 5 місяців тому

    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.

  • @EuanM20X
    @EuanM20X 10 місяців тому

    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

  • @nsulikow
    @nsulikow 5 місяців тому

    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

  • @CalvinPuah
    @CalvinPuah 2 роки тому +1

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

  • @lauramartins673
    @lauramartins673 4 місяці тому

    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.

  • @drummerboi4eva
    @drummerboi4eva 2 роки тому

    Super presentation Simon thanks for sharing

  • @michaeldemarco82
    @michaeldemarco82 2 роки тому +2

    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

  • @Jim132518
    @Jim132518 2 роки тому

    Great Job, the intro I was looking for.

  • @MrReachashish
    @MrReachashish 7 місяців тому

    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 ?

  • @danhorus
    @danhorus 3 роки тому +5

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

  • @jasonkhaihoang781
    @jasonkhaihoang781 Рік тому

    Thank you. This is helpful for me :)

  • @PujaSingh-no1wy
    @PujaSingh-no1wy 2 роки тому +1

    Very nice

  • @abdulamz38
    @abdulamz38 2 роки тому

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

  • @priyankamahato2063
    @priyankamahato2063 2 роки тому

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

  • @majorck
    @majorck 2 роки тому

    Great information!

  • @Luis-sr5nt
    @Luis-sr5nt Рік тому

    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

  • @tadastadux
    @tadastadux 2 роки тому +1

    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?

    • @dennyglee
      @dennyglee 2 роки тому

      In this particular scenario, the data is sitting in Delta Lake and then Databricks SQL queries the data directly. In the process it does catch it so that Tableau (or any other BI tool) will be able to leverage it. HTH!

  • @anthonyphan4036
    @anthonyphan4036 2 роки тому

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

  • @palashs1
    @palashs1 2 роки тому

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

    • @dennyglee
      @dennyglee 2 роки тому

      Sorry for the delay, it should be up and running now, eh?!

  • @kfirgollan
    @kfirgollan Рік тому

    Really good video, well made :+1:

  • @hakobavjyan7498
    @hakobavjyan7498 2 роки тому

    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.

    • @lukasu-ski4325
      @lukasu-ski4325 2 роки тому +1

      Documentation: "Databricks SQL is now in Public Preview and enabled for all users in new workspaces." For old workspaces it needs to be enabled by admin.

  • @gardnmi
    @gardnmi 2 роки тому

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

    • @PrebenOlsen90
      @PrebenOlsen90 2 роки тому

      Yes, and not with SQL Analytics.

    • @dennyglee
      @dennyglee 2 роки тому

      It's less about being limited to SQL but it's designed for the SQL Analyst in mind. Saying this, please perhaps add a community request on adding Python and Scala support, eh?!