Query AZURE SQL Server Database using Databricks & Pyspark

In this video I will show you how to Query Data from Azure SQL Database.

=====⏱️Timestamps⏱️=====
00:00 Introduction.
03:51 Create AZURE SQL Server service.
05:16 Create JDBC Connection.
08:38 Execute the select Query against the database using Databricks.
11:20 Execute the select Query with condition against the database using Databricks.

=====THINGS YOU NEED TO KNOW!!!=====
🎥How to create free account in Databricks Community Edition:-
🎥Ingest Data from Azure SQL Database : Databricks & Pyspark:-
🎥Read & Write Parquet file using Databrick and PySpark:-

=====SOCIAL=====

#databricks #machinelearning #datascience
#DatabricksIngestDatafromAzureSQL, #AzureSQLDatabaseDatabricks, #DatabricksAzureSQL, #DataricksAzureDatabase,#Databricksreaddbtable,#DatabricksReadDatabaseTable, #SparkReadSQLTable,#SparkIngestDBTable,#SparkIngestDataBaseTable,#PysparkIngestDataBaseTable,#SparkLoadfromDBTable,#SparkReadfromDatabase,#DatabricksReadfromDatabase, #DatabricksJDBC,#SparkJdbc, #PysparkJDBC, #DatabricksAzureSQL, #SparkAzureSQLDB,#SparkAzureSQLDatabase #PySparkAzureSQLDatabase #DatabricksTutorial, #DatabricksMergeStatement, #AzureDatabricks,#Databricks,#Pyspark
#Spark#AzureDatabricks,#AzureADF,#Databricks #LearnPyspark #LearnDataBRicks #DataBricksTutorial,#Databricks,#Pyspark,#Spark,#AzureDatabricks,#AzureADF
#Databricks #LearnPyspark #LearnDataBRicks #DataBricksTutorial,#databrickssparktutorial
#databrickstutorial,#databricksazure,#databricksnotebooktutorial,#databricksdeltalake,
#databricksazuretutorial,#databrickstutorialforbeginners, #azuredatabrickstutorial,#databrickstutorial,#databrickscommunityedition,#databrickscommunityeditionclustercreation,#databrickscommunityeditiontutorial,#databrickscommunityeditionpyspark,#databrickscommunityeditioncluster,#databrickspysparktutorial,#databrickscommunityeditiontutorial,#databrickssparkcertification,#databrickscli,#databrickstutorialforbeginners,
#databricksinterviewquestions,#databricksazure

[manjunathbn]

How to read multiple tables from sql server?

[Manojkumar-irxw]

Select is working for me
But when i write delete query it is not working. Is this a supported operation?

[pluralvistamaar]

Thanks for the video... Unfortunately it did not work for me... Did you configure something else?

I get this error : Cannot open server
or error: Invalid object name 'Customer'.