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:
https://github.com/mkleehammer/pyodbc...

https://docs.microsoft.com/en-us/sql/...

sample code used:
import pyodbc
server = 'yourDbServerName'
database = 'yourDBName'
username = 'UserName'
password = 'Password'
   
cnxn = pyodbc.connect('DRIVER={ODBC Driver 17 for SQL Server};SERVER=' + server + ';DATABASE='+ database +';UID=' + username + ';PWD='+ password)

Link for Azure Synapse Analytics Playlist:
1. Introduction to Azure Synapse Anal...

Link for Azure Data bricks Play list:
1.  Introduction to Azure Databricks

Link for Azure Functions Play list:
1. Introduction to Azure Functions

Link for Azure Basics Play list:
1. What is Azure and Cloud

Link for Azure Data factory Play list:
1. Introduction to Azure Data Factory

Link for Azure Data Factory Real time Scenarios
1. Handle Error Rows in Data Factory ...

Link for Azure Logic Apps playlist
1. Introduction to Azure Logic Apps

#Azure #AzureSynapse #AzureSynapseAnalytics #wafastudies

• #science_technology
• #azure_synapse_analytics
• #intro_to_azure_synapse
• #overview_of_azure_synapse_analytics
• #about_azure_synapse_analytics
• #azure_basics
• #synapse_service
• #azure_synapse_basics
• #azure_synapse_analytics_playlist
• #azure_synapse_tutorials
• #azure_synapse_analytics_real_time_scenarios
• #real_time_examples_of_synapse
• #run_sql_from_synapse_spark_notebook
• #query_sql_db_from_spark_notebook
• #pyodbc_to_query_with_sql_in_python
• #python_pyodbc_library
• #pyodbc_to_query_sql_from_spark_notebook