jdbc-connection-setup.sql

#Get the credentials from the Keyvault that a scope was defined for using the
#Databricks CLI. See: https://docs.azuredatabricks.net/security/secrets/secret-scopes.html
#alternatively, hard-code the credentials here:
jdbcUrl = dbutils.secrets.get(scope="JDBC", key="url")
jdbcUsername = dbutils.secrets.get(scope="JDBC", key="username")
jdbcPassword = dbutils.secrets.get(scope="JDBC", key="password")

#create an object with the credentials that we can pass on to the spark dataframe reader
connectionProperties = {
  "user" : jdbcUsername,
  "password" : jdbcPassword,
}