- 2445 Views
- 4 replies
- 1 kudos
i am trying to read data from azure sql database from databricks. azure sql database is created with private link endpoint.Using DBR 10.4 LTS Cluster and expectation is the connector is pre installed as per documentation.using the below code to fetch...
- 2445 Views
- 4 replies
- 1 kudos
Latest Reply
It seems that .option("databaseName", "test") is redundant here as you need to include the db name in the url.Please verify that you use a connector compatible to your cluster's Spark version : Apache Spark connector: SQL Server & Azure SQL
3 More Replies
by
leon
• New Contributor II
- 2043 Views
- 2 replies
- 1 kudos
Hello,I am using querying my Delta Lake with SQL Connect and later want to explore the result in pandas.with connection.cursor() as cursor:
cur = cursor.execute("""
SELECT DISTINCT sample_timestamp, value, name
FROM de...
- 2043 Views
- 2 replies
- 1 kudos
Latest Reply
Hi @Leon Bam​, Please check this article and let us know if that helps.
1 More Replies
- 2463 Views
- 11 replies
- 2 kudos
I started to explore Databricks SQL Connector. And I'm wondering can I execute query from Databricks SQL Connector from notebook or job?sample code:'test_query' lives in Databricks SQL. It is ready to use query!from databricks import sql
hostname =...
- 2463 Views
- 11 replies
- 2 kudos
Latest Reply
@Borislav Blagoev​ - There is a "Select as Best" link underneath each reply. All you need to do, if you choose, is to click on that link for whichever reply best answered your question. The purpose is to help other members find helpful solutions more...
10 More Replies