Master Databricks and Apache Spark Step by Step: Lesson 12 - Using SQL Views

In this video, you learn how to query save SQL queries as views so they can be re-used in your data analysis and pipelines.

Get Master Azure Databricks Step by Step at

Example Notebook for lesson 11 and 12 at:

You need to unzip the file and import the notebook into Databricks to run the code.

Video on Creating and Loading the tables used in this video

Video on Dimensional Modeling - with an explanation of Snowflake Schema
.​

[guillermojastrzebski]

Best explanation I found in my whole life on how to use SQL. The CTE explanation alone is worth its weight in gold.
People, don't get confused by the series title: this is much more than Databricks and Spark. This is a guy who really know his stuff and enjoys teaching... a true Jedi Master! Between Luke and Yoda

[iandaniel]

Thanks For this Series on Databricks and Spark, not even half way in and I'm understanding a lot of stuff. From padawan to Jedi Knight 💯

[anthonygonsalvis]

Love the exercises! Learned Databricks' plotting capabilities while completing the exercise. Please retain and expand the exercise element of your tutorials/notebooks. Btw, you don't need to join any original tables for the 3rd exercise; all the data columns you need are already in the t_salesinfo table that you created along the way.

[surendersaini]

Great video. Could you also include the information about location of newly created table in terms of physical storage and impact on persistence due to cluster start/stop operations

[Raaj_ML]

When you create table out of view, will the table get updated when the corresponding view is updated ?

[utsavchanda]

Are the accesses to these SQL tables and views limited only to the Databricks user account which creates these or are these globally available across all Databricks user accounts in a project environment?

[opeyemikofoworola]

Thanks for the video. Is there a way to export the graph or map ?

[tiagohenriqueribeiroferrei]

How can I import the database Adventureworks to Databricks?

[claudiocordova]

GitHub link doesn't seem to work.