Skip to main content

Why to use Azure Databricks to run your Apache Spark Notebooks

A few months ago (almost one year) a new flavor of Apache Spark appeared on Microsoft Azure. Azure Databricks it is just a platform optimized for Azure, where Apache Spark can run.
The consumer does not need anymore to configure the Apache Spark cluster (VM creation, configuration, network, security, storage and many more). Azure Databricks already has a cluster that is configured and ready to be used. We can focus on our application and business requirements and less on the infrastructure part.

Capabilities and Features
All the features that we have inside Apache Spark can also be found inside Azure Databricks. The same version of Spark that you have on-premises runs on top of Azure Databricks, the only difference is at the infrastructure level, where you already have the system preconfigured. As a user, you are free to scale up or down your cluster in a 'drag and drop' manner, without having to pay attention or do anything else.
All the 5 main components of Spark can be found on top of Azure Databricks:

  • Streaming Capability
  • GraphX for data exploration and cognitive analytics
  • MLib for machine learning support
  • Core API for integration with R, Python, Scala, Java, and SQL
  • DataFrames with Spark SQL for working with structured data
A nice feature of Azure Databricks is the capability to remove/terminate a Spark cluster in the moment when the cluster it is not used anymore. When you create a new cluster, you have the option to specify after how many minutes of inactivity the cluster should be terminated. This option is useful especially during the developing phase where you can save a lot of resources in this way without complicated procedures. 

Integration points
At this moment in time, there are integration points with Hadoop Storage, Apache Kafka, Azure SQL Data Warehouse, Azure Data Lake Store and Azure Blob Storage. This in combination with Spark capability to combine data stream with static data makes Apache Spark a super exciting option when you need fast deployment and reliable services. 
As a side note, Azure Databricks it is using Azure Container Services behind the scene.

Even if Spark has an excellent support for ML, Data Analysis and Fog Computing in IoT scenarios, in the most of the cases, Spark it is used for the streaming capabilities, where it is enabling us to ETL on top of data streams, trigger events based on stream content or data enrichment with static content when needed. 
It is a clear trend to do a lot of AI and ML inside Azure Spark that enables us to process and analyze data streams in real-time. 

The pricing model of Azure Databricks contains two components:
  1. Azure VM price
  2. DBU (Databricks Unit)
Depending on the cluster size, you will pay for the no. of Azure VM's that you are using inside the cluster. You can specify the type and the number of the VM's that you want to use. The price of the VMs it's the same as for Azure VM with Linux.
DBU represents the processing capability. Based on the type of the VM you will notice that each VM has a different DBU capability. D12 has 1 DBU vs D15 that had 5 DBUs for each node. For each DBU you will an additional amount of money. We can imagine that inside DBU are all other costs of cluster management from configuration and networking to storage and environment optimization. 
For DBU there are two pricing tiers (Standard and Premium). The most significant difference between this two is the Role Base Access control that can be found on the Premium tier. 

What you shall take a look on Azure Databricks?
  1. Autoscaling capability
  2. Auto-termination capability
  3. Optimized by design
  4. Connectors with Azure Services (e.g. Azure Data Lake and Blob Storage)
  5. PowerBI integration
  6. Support for automation
  7. Simple price model
  8. Multiple types of Azure VM supported
  9. Enterprise-ready with Azure AD support
  10. Security and privacy out of the box


Popular posts from this blog

ADO.NET provider with invariant name 'System.Data.SqlClient' could not be loaded

Today blog post will be started with the following error when running DB tests on the CI machine:
threw exception: System.InvalidOperationException: The Entity Framework provider type 'System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer' registered in the application config file for the ADO.NET provider with invariant name 'System.Data.SqlClient' could not be loaded. Make sure that the assembly-qualified name is used and that the assembly is available to the running application. See for more information. at System.Data.Entity.Infrastructure.DependencyResolution.ProviderServicesFactory.GetInstance(String providerTypeName, String providerInvariantName) This error happened only on the Continuous Integration machine. On the devs machines, everything has fine. The classic problem – on my machine it’s working. The CI has the following configuration:

TeamCity.NET 4.51EF 6.0.2VS2013
It seems that there …

GET call of REST API that contains '/'-slash character in the value of a parameter

Let’s assume that we have the following scenario: I have a public HTTP endpoint and I need to post some content using GET command. One of the parameters contains special characters like “\” and “/”. If the endpoint is an ApiController than you may have problems if you encode the parameter using the http encoder.
using (var httpClient = new HttpClient()) { httpClient.BaseAddress = baseUrl; Task<HttpResponseMessage> response = httpClient.GetAsync(string.Format("api/foo/{0}", "qwert/qwerqwer"))); response.Wait(); response.Result.EnsureSuccessStatusCode(); } One possible solution would be to encode the query parameter using UrlTokenEncode method of HttpServerUtility class and GetBytes method ofUTF8. In this way you would get the array of bytes of the parameter and encode them as a url token.
The following code show to you how you could write the encode and decode methods.

Entity Framework (EF) TransactionScope vs Database.BeginTransaction

In today blog post we will talk a little about a new feature that is available on EF6+ related to Transactions.
Until now, when we had to use transaction we used ‘TransactionScope’. It works great and I would say that is something that is now in our blood.
using (var scope = new TransactionScope(TransactionScopeOption.Required)) { using (SqlConnection conn = new SqlConnection("...")) { conn.Open(); SqlCommand sqlCommand = new SqlCommand(); sqlCommand.Connection = conn; sqlCommand.CommandText = ... sqlCommand.ExecuteNonQuery(); ... } scope.Complete(); } Starting with EF6.0 we have a new way to work with transactions. The new approach is based on Database.BeginTransaction(), Database.Rollback(), Database.Commit(). Yes, no more TransactionScope.
In the followi…