Skip to main content

Architecture

Smart Data Lake Builder (SDLB) is basically a Java application which is started on the command line. It can run in many environments and platforms like a Databricks cluster, Azure Synapse, Google Dataproc, and also on your local machine, see Getting Started.

Find below an overview of requirements, versions and supported configurations.

Basic Requirements​

  • Needs Java 17+ to run (SDLB 2.x: Java 8+)
  • Uses Hadoop Java library to read local and remote files (S3, ADLS, HDFS, ...)
  • Is programmed in Scala 2.13
  • Uses Maven 3+ as build system
  • Python 3 is needed only for Python transformations, the MLflow Actions and the SQL engine

Modules​

Since SDLB 3.x, the core of SDLB does not depend on Spark anymore. It defines the configuration, the DAG execution and an engine independent DataFrame API, and each execution engine is a separate module. Declare the modules you need in your Maven project:

ModuleContentDepends on
sdl-coreconfiguration, DAG execution, run state, generic Actions (Copy, Historize, Upsert, Custom), file Actions, engine independent DataObjects (JdbcTableDataObject, JdbcViewDataObject, DeltaLakeTableDataObject, IcebergTableDataObject) and the plain-Scala engine-
sdl-sparkSpark engine (SparkClassicConnection, SparkSubFeed), file formats, Spark transformers, Python transformations, MLflow Actionssdl-core
sdl-sparkconnectSpark Connect engine (SparkConnectConnection, SparkConnectTableDataObject)sdl-core
sdl-sqlSQL engine executing transformations in the database (SQLGlot, needs Python)sdl-core
sdl-deltalake, sdl-icebergSpark implementations of the Delta Lake and Iceberg DataObjectssdl-spark
sdl-snowflakeSnowflakeTableDataObject and the Snowpark enginesdl-spark
sdl-kafka, sdl-debezium, sdl-azure, sdl-gcpconnectors for Kafka, Debezium CDC, Azure and Google Cloudsdl-spark
sdl-langmeta tools: configuration and schema exporters, CatalogSchemaUpdater, schema viewer JSON schemaall of the above

An engine independent DataObject, e.g. DeltaLakeTableDataObject, is implemented per engine by the corresponding module, e.g. sdl-deltalake for Spark and sdl-sparkconnect for Spark Connect. Which engine an Action uses is selected by its engine connection, see Execution Engines.

caution

sdl-spark and sdl-sparkconnect cannot be used in the same JVM, as the Spark classic and the Spark Connect client libraries conflict.

Versions and supported configuration​

SDLB is published as Maven artifacts on Maven Central. The SDLB versions are build with specific versions of Apache Spark and other libraries. This page gives an overview of the respective versions.

The following tables give an overview of dependency versions that are delivered with each major branch of SDLB. It is possible to customize dependencies and make Smart Data Lake Builder work with other version combinations, but this needs manual tuning of dependencies in your own maven project. In general, Java library versions are held as close as possible to the ones used in the corresponding Spark version.

SDLB Version 3.X​

SDLB version 3.X uses Apache Spark 4.X and requires Java 17+. Scala 2.12 is no longer supported; 3.X is built for Scala 2.13 only. See Upgrading to SDLB 3.x for the changes needed when upgrading from 2.X.

SDL VersionJava/Scala VersionHadoop VersionSpark EngineLog4jSnowflake/Snowpark EngineDelta LakeIceberg
3.0.XJava 17+, Scala 2.133.4.24.1.32.24.33.1.8 / 1.18.04.4.01.11.0

SDLB Version 2.X​

SDL VersionJava/Scala VersionHadoop VersionSpark EngineLog4jSnowflake/Snowpark EngineDelta LakeIceberg
2.8.XJava 8+, Scala 2.12/2.133.3.63.5.32.20.03.1.1 / 1.15.0 (*)3.2.01.6.1
2.7.XJava 8+, Scala 2.12/2.133.3.63.5.22.20.03.0.0 / 1.13.2 (*)3.2.01.6.1
2.6.XJava 8+, Scala 2.12/2.133.3.63.4.32.20.02.12.0 / 1.9.0 (*)2.4.01.3.1
2.5.XJava 8+, Scala 2.123.3.23.3.22.17.22.11.0 / 1.6.22.2.01.1.0
2.4.XJava 8+, Scala 2.123.3.13.2.21.2.172.10.0 / 1.2.02.0.0-
2.3.XJava 8+, Scala 2.123.3.13.2.21.2.172.10.0 / 1.2.02.0.0-
2.2.XJava 8+, Scala 2.123.3.13.2.11.2.172.9.2 / 0.11.01.1.0-
2.1.XJava 8+, Scala 2.122.7.43.1.11.2.172.8.41.0.0-

(*) Snowpark is not supported for Scala 2.13 in SDLB 2.X, see also this note.

SDLB Version 1.X​

SDLB version 1.X used Apache Spark 2.X. This branch of SDLB is no longer maintained. To profit from the latest development, please upgrade to a more recent version of SDLB.

Release Notes​

See SDLB Release Notes including breaking changes on Github

Context​

containers Legend:

Components of an SDLB Job​

components Legend:

Cross cutting concerns​

Logging​

By default, SDLB uses the logging libraries included in the corresponding Spark version, see the Log4j column above. This is Log4j 2.x for all SDLB 3.X versions (Spark 3.3.x and later, see SPARK-6305), and Log4j 1.2.x for SDLB versions with Spark 2.4.x up to Spark 3.2.x.

You can customize logging dependencies manually by creating your own maven project.