Forum Discussion
Write data into synapse dedicated sql pool from fabric notebook
How to write data into synapse dedicated sql pool from fabric notebook. I want to save the spark dataframe from Fabric Notebook into Azure Synapse dedicated sql pool. Is it doable, if yes, can a...
Hi SriThiru,
Yes, ye bilkul possible hai. Fabric Notebook se Synapse Dedicated SQL Pool me data likhne ke 2 tareeke hain:
**Option 1: Using spark.write with JDBC**
```python
df.write \
.format("com.microsoft.sqlserver.jdbc.spark") \
.mode("overwrite") \
.option("url", "jdbc:sqlserver://your-server.sql.azuresynapse.net:1433;database=yourDB") \
.option("dbtable", "schema.tableName") \
.option("user", "username") \
.option("password", "password") \
.save()