1. Query SQL Server DB from Spark notebook in Azure Synapse Analytics | pyodbc to query SQL server

In this video, I discussed about querying SQL DB from Synapse spark notebook in Azure Synapse Analytics. We used pyodbc library to do the same.

pyodbc documentation links:

sample code used:
import pyodbc
server = 'yourDbServerName'
database = 'yourDBName'
username = 'UserName'
password = 'Password'


Link for Azure Synapse Analytics Playlist:

Link for Azure Data bricks Play list:

Link for Azure Functions Play list:

Link for Azure Basics Play list:

Link for Azure Data factory Play list:

Link for Azure Data Factory Real time Scenarios

Link for Azure Logic Apps playlist

#Azure #AzureSynapse #AzureSynapseAnalytics #wafastudies

[universal]

Hey, it's a Great explanation.
But is there any other way, rather than using username and password, can we use SPN or using a linked service authentication

[akhilpmadhu]

Can you please explain how to save a dataframe from synapse notebook to Sql server table

[avicool]

Thanks for sharing this concept, please share more of this kind videos.

[pavangumma]

Is your sql database is connected to the synapse workspace through dedicated or server less sql pool? Or even without sql pool can we do this?

[NeumsFor]

It's not common but you should do one on bulk loading to sql server from spark NB.

[ranjansrivastava]

Hi Maheer, Well Explained as usual, Could you please share one demo to insert bulk records, size may be petabyes from spark to SQL server or vice-versa.

[adityasomwanshi]

Is there any way we can connect via linked service?

[tarunpothala]

Sir, does cur.display() or cur.show() functions exists ?

[NehalKumarJaiswal-vq]

Can you please explain how to connect on-premise Sql server, I am getting lots of interview question about connecting on-premise database with Azure cloud, please

[followmanish]

Hi Miheer, i am trying to access the external table from a serverless SQL pool, but i am getting error "External table 'Employee_table' is not accessible because location does not exist or it is used by another process. (16562) (SQLExecDirectW)")", can you please guide how to resolve this issue, or anyone can help?

[aapal]

Sir,
Could you share code for below queries ?
how to execute stored procedure in synapse note book, stored procedure has been create in dedicated sql pool ?

[muapatrick]

Can this work with on prem SQL server ?

[Aryanarijit]

How to hide the credentials using keyvault?

[AKHILESHKUMAR-szil]

will this work on on-premise sql server?

[sureshkumar-gpmw]

i am preparing for dp-203. will this video help on this. can anyone please suggest on dp-203.