Warning: this walkthrough is not to be considered as official guidance or recommendation from Microsoft. It is presented for educational purposes only, and comes “as-is” and confers no rights, no warranties or guarantees. Since this article was originally posted in 2019, the implementation of Spline might undergo changes which may break the steps described herein.
Tracking lineage of data as it is manipulated within Apache Spark is a common ask from customers. As of date, there are two options, the first of which is the Hortonworks Spark Atlas Connector, which persists lineage information to Apache Atlas. However, some customers who use Azure Databricks do not necessarily need or use the “full” functionality of Atlas, and instead want a more purpose-built solution. This is where the second option, Spline, comes in. Spline can persist lineage information to Apache Atlas or to a MongoDB database. Now, given that Azure Cosmos DB exposes a MongoDB API, it presents an attractive PaaS option to serve as the persistence layer for Spline.
This blog post is the result of my attempts to use Spline from within Azure Databricks, persisting the lineage information to Azure Cosmos DB using the MongoDB API. Some open “to-do” items are at the end of this blog post.
Installing Spline within Azure Databricks
First and foremost, you need to install a number of JAR libraries to allow Spark to start talking to Spline and thereon to Azure Cosmos DB MongoDB API. There is an open item wherein the Spline team is actively considering providing an “uber JAR” which will include all these dependencies. Until then, you will need to use the Maven coordinates as shown below and install these into Azure Databricks as Maven libraries. The list (assuming you are using Spark 2.4) is below. If you are using other versions of Spark within Azure Databricks, you will need to change the Maven coordinates for org.apache.spark:spark-sql-kafka and
za.co.absa.spline:spline-core-spark-adapter to match the Spark version.
[Updated on 26 March 2019] The original version of this post had every single dependency (including “child” / transitive dependencies) listed. Based on expert advice from my colleague Alexandre Gattiker, there is a cleaner way of just installing the 3 libraries:
za.co.absa.spline:spline-core:0.3.6 za.co.absa.spline:spline-core-spark-adapter-2.4:0.3.6 za.co.absa.spline:spline-persistence-mongo:0.3.6
To add just these libraries, you need to specify “exclusions” when adding these libraries in the Databricks UI, such as what is shown in the screenshot below:
The exclusions that we have to add are:
If you still do need the full list with transitive dependencies included, it is now included as an Appendix at the very end of this post.
Preparing Azure Cosmos DB for Spline
This was pretty easy, all I needed to do was create a new Azure Cosmos DB account with the MongoDB API enabled. I did need to enable the “pipeline aggregation” preview feature without which the Spline UI does not work. For good measure I also enabled the 3.4 wire protocol but in hindsight it is not required, as Spline only uses the legacy MongoDB driver which is a much older version of the wire protocol.
Spark code changes
Setup the Spark session configuration items in order to connect to Azure Cosmos DB’s MongoDB endpoint:
System.setProperty("spline.mode", "REQUIRED") System.setProperty("spline.persistence.factory", "za.co.absa.spline.persistence.mongo.MongoPersistenceFactory") System.setProperty("spline.mongodb.url", "<<the primary connection string from the Azure Cosmos DB account>>") System.setProperty("spline.mongodb.name", "<<Cosmos DB database name>>")
Enable lineage tracking for that Spark session:
import za.co.absa.spline.core.SparkLineageInitializer._ spark.enableLineageTracking()
Then we run a sample aggregation query (we do this as a Python cell just to show that the lineage tracking and persistence works even in PySpark):
%python rawData = spark.read.option("inferSchema", "true").json("/databricks-datasets/structured-streaming/events/") rawData.createOrReplaceTempView("rawData") sql("select r1.action, count(*) as actionCount from rawData as r1 join rawData as r2 on r1.action = r2.action group by r1.action").write.mode('overwrite').csv("/tmp/pyaggaction.csv")
Running the Spline UI
To run the UI, I simply followed the instructions from the Spline documentation page. Since this process just needs Java to run, I can envision a PaaS-only option wherein this UI runs inside a container or an Azure App Service (doing that is left as an exercise to the reader – or maybe for a later blog post)! For now, here’s the syntax I used:
java -D"spline.mongodb.url=<<connection string from Cosmos DB page in Azure Portal>>" -D"spline.mongodb.name=<<Azure Cosmos DB name>>" -jar <<full path to spline-web-0.3.6-exec-war.jar>>
Then by browsing to the port 8080 on the machine running the UI, you can see the Spline UI. Firstly, a lineage view on the above join + aggregate query that we executed:
and then, a more detailed view:
This is of course a simple example; you can try more real-world examples on your own. Spline is under active development and is open-source; the authors are very active and responsive to queries and suggestions. I encourage you to try this out and judge for yourselves.
As of this moment, I must call out some open items that I am aware of:
- [Update 1 Apr 2019] The issue with Search has been understood and there is a reasonable way out. Again, my colleague Alexandre has been instrumental in finding the mitigation.
Unfortunately, the Search textbox does not seem to work correctly for me. I have opened an issue with the Spline team and hopefully we can track down why this is breaking.
- I have not tested this with any major Spark jobs. If you plan to use this for any kind of serious usage, you should thoroughly test it. Please remember that this is an third-party open-source project, provided on an “as-is” basis.
- [Update 26 March 2019]: I have verified that the above setup works correctly with VNET Service Endpoints to Azure Cosmos DB, and with corresponding firewall rules set on the Cosmos DB side to only allow traffic from the said VNET where the Databricks workspace is deployed.
My Azure Databricks workspace is deployed into an existing VNET. I still need to test service endpoints and firewall rules on the Cosmos DB side to ensure that traffic to the Azure Cosmos DB is restricted to only that from the VNET.
- Last but not the least, as I already mentioned, if the Spline team releases an uber JAR that would reduce the overhead of managing and installing all the dependencies, that would make life a bit easier on the Azure Databricks front.
I hope this was useful; do try it out and leave me any questions / feedback / suggestions you have!
Here is the full list of dependencies including all children / transitive dependencies. It may be useful if your Databricks workspace is deployed in a “locked-down” VNET with very restrictive NSG rules in place for outbound traffic:
org.json4s:json4s-native_2.11:3.5.3 org.json4s:json4s-ast_2.11:3.5.3 org.json4s:json4s-scalap_2.11:3.5.3 org.json4s:json4s-core_2.11:3.5.3 org.json4s:json4s-ext_2.11:3.5.3 org.scala-lang:scalap:2.11.12 org.scalaz:scalaz-core_2.11:7.2.27 org.slf4s:slf4s-api_2.11:1.7.25 com.github.salat:salat-core_2.11:1.11.2 com.github.salat:salat-util_2.11:1.11.2 org.mongodb:bson:3.10.1 org.apache.atlas:atlas-common:1.0.0 org.apache.atlas:atlas-intg:1.0.0 org.apache.atlas:atlas-notification:1.0.0 org.mongodb:casbah-core_2.11:3.1.1 org.mongodb:casbah-commons_2.11:3.1.1 org.mongodb:casbah-query_2.11:3.1.1 org.apache.kafka:kafka-clients:2.1.1 org.mongodb:mongo-java-driver:3.10.1 org.mongodb:mongodb-driver-legacy:3.10.1 org.apache.spark:spark-sql-kafka-0-10_2.11:2.4.0 za.co.absa.spline:spline-core:0.3.6 za.co.absa.spline:spline-commons:0.3.6 za.co.absa.spline:spline-core-spark-adapter-2.4:0.3.6 za.co.absa.spline:spline-core-spark-adapter-api:0.3.6 za.co.absa.spline:spline-model:0.3.6 za.co.absa.spline:spline-persistence-api:0.3.6 za.co.absa.spline:spline-persistence-atlas:0.3.6 za.co.absa.spline:spline-persistence-hdfs:0.3.6 za.co.absa.spline:spline-persistence-mongo:0.3.6