I’m trying to run DbDiagnostics::executeDbProfile using a Databricks CDM.
I’m not sure how to configure the connectionDetails.
The following gives the error shown below
Code
connectionDetails <- DatabaseConnector::createConnectionDetails (
dbms = "spark",
server = "nachc-databricks.cloud.databricks.com:443/default",
user = "token",
password = "my-token",
pathToDriver="D:\\_YES_2023-05-28\\workspace\\SosExamples\\_COVID\\02-data-diagnostics\\drivers\\databricks\\",
extraSettings="transportMode=http;ssl=1;httpPath=sql/protocolv1/o/3956472157536757/0123-223459-leafy532;AuthMech=3"
)
Error
Connecting using Spark ODBC driver
Error: nanodbc/nanodbc.cpp:1118: IM002: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
How do I successfully connect to the Databricks instance?
I’m new(ish) to R, how can I see the code that’s being executed by executeDbProfile?
I’m assuming it is something similar to this:
odbc_con <- dbConnect(odbc::odbc(),
Driver = "SQLServer",
Server = server,
Database = test,
Uid = 'username',
Pwd = 'password',
Port = 1433)
Thanks,
John