val sqlContext = SparkSession.builder().appName("GenerateEventsSql").getOrCreate()

val jdbcSqlConnStr = "jdbc:sqlserver://someserver.database.windows.net:1433;databaseName=myDW;user=admin;password=XXXX;"

val tableName = "dbo.SomeTable"

val allTableData = sqlContext.read.format("jdbc")
                    .options(Map(
                      "driver" -> "com.microsoft.sqlserver.jdbc.SQLServerDriver",
                      "url" -> jdbcSqlConnStr, "dbtable" -> tableName)
                    )
  .load()