Hi @Dhruv Dalsania​ Thank you for posting your question in our community! We are happy to assist you.To help us provide you with the most accurate information, could you please take a moment to review the responses and select the one that best answer...
Hello experts. We need to transfer couple of tables from our old system to Databricks through JDBC connection. So, the first step was to create the corresponding table as below:CREATE TABLE IF NOT EXISTS jdbc_tableUSING JDBCOPTIONS (DRIVER = "DriverX...
Hello. I am trying to establish a connection from Databricks to our DB2 AS400 server. Below is my code: CREATE TABLE IF NOT EXISTS table_nameUSING JDBCOPTIONS (DRIVER = "com.ibm.as400.access.AS400JDBCDriver", URL = "jdbc:as400://<IP>:446;prompt=false...
Hi all,I'm trying to connect to ServiceNow as a data source to ingest some data to a lake.ServiceNow is a MySQL database underneath, however, I cannot figure out how to connect to it with "regular" MySQL JDBC - has anyone ever tried this?
Hello @Frank Wagner​ Thank you for posting to Databricks Community ForumIt seems like there is not enough documentation around JDBC connectivitySeems like there are a few commercial connectorshttps://www.cdata.com/drivers/servicenow/jdbc/https://www....
Hi, is there any way/workaround to query JDBC tables the same way one can do with other type of clusters?Doing so right now causes an error saying that only text based files are supported (json, parquet, delta etc) even though the tables are recogniz...
I've been waiting patiently for this option since public preview early 2021. The vast majority of our data is in SQL Server databases, and because we are unable to query these data sources is the primary reason the data team hasn't adopted SQL Worksp...
SQL Workbench is not able to connect to Cluster using JDBC/ODBC connection. Getting the following error. I used the configuration provided by the cluster (jdbc:spark://<host>.cloud.databricks.com:443/default;transportMode=http;ssl=1;httpPath=sql/prot...
As we are getting 401 error that means an authentication issue. We should use Personal access token for password.The username should be "token" and the password should be PAT token.