Blog

In this video Terry takes you though the key components of Spark ML. We then build a very basic model demonstrating the key parts, using Kaggle’s Black Friday data to produce a regression model to predict spend on Black Friday.

In this video Terry takes you though DataFrame caching, persist and unpersist. This is vital information you need to know to get the best performance from Spark.

In this video Simon takes you though how write data from a Spark DataFrame to Azure SQL Data Warehouse. While this may sound simple, to get the most from Azure SQL Data Warehouse, you need to be using Polybase to read in data.

In this video Simon takes you though how to begin working with partitioned data in Azure Databricks.

In this video Simon takes you though how to read and write data in various formats. We also look at a deep dive on Parquet.

In this video Simon takes you though how to use the SQL API in Azure Databricks. If you come from a more traditional data analytics background then you will be no stranger to SQL. In this video we explore how to register a temporary table and start querying it with SQL.

In this video Simon takes you though how to join DataFrames in Azure Databricks

In this video Terry takes a look at transformations and Actions in Spark. We discuss how the Catalyst engine works and demo a Spark DAG..

In this video Terry takes you through how to ,make a connection from Azure Databricks to Data Lake Gen 2. We also look at secrets and discuss best practices on how to securely store keys in Azure Databricks.

In this video Terry takes you through how to use Notebook widgets. Widgets allow you to create a parameter driven notebooks which integrates with scheduled jobs and Azure Data Factory. Widgets allow you to create a generic notebook which can solve multiple problems.

In this video Simon takes you though the basics of how to Version Control Notebooks in Git with Azure DevOps. We look at how link a notebook with Azure DevOps, how to see the notebook history and how to commit your changes to Git.

In this video Terry takes you through how to get started with Azure Databricks Notebooks. We look at the notebook service, Databricks optimisations, Magic and how to import a notebook from the Databricks documentation.

In this video Simon takes you through how to size a cluster. We look at what happens when you take 3GB of data and cache it on a 2 node cluster. How do you see the distribution of data? How many partitions are there on each node?. How do we achieve workload isolation? All these questions are answered.

In this video Simon takes you through the creation of a cluster in Azure Databricks, explore the difference between the various cluster types and Databricks run-times and options to get you started with your first cluster.

In this video Terry takes you through a tour of the Databricks workspace.