Importing com.microsoft.spark.sqlanalytics

Eric Ste-Marie 6 Reputation points
2022-06-29T20:17:07.237+00:00

Hello all,

I'm trying to write to an SQL Pool from a pyspark dataframe in a Synapse notebook.

The documentation found at synapse-spark-sql-pool-import-export suggests that I should "import com.microsoft.spark.sqlanalytics" in my pyspark cell. (python code tab)

and use df.write.synapsesql("SQL_POOL_NAME.SCHEMA_NAME.TABLE_NAME")

I get ModuleNotFoundError at the import:

ModuleNotFoundError: No module named 'com.microsoft.spark.sqlanalytics'

Any idea?

Thanks!

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,171 questions
{count} vote

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.