Share via

moving data from databricks to azure sql

Samuel Zetabobo 1 Reputation point
2022-03-01T01:11:42.853+00:00

I am looking to insert data to an azure sql table from an azure databricks notebook, however it could not perform this action

Azure Databricks
Azure Databricks

An Apache Spark-based analytics platform optimized for Azure.


1 answer

Sort by: Most helpful
  1. ShaikMaheer-MSFT 38,631 Reputation points Microsoft Employee Moderator
    2022-03-03T12:30:45.827+00:00

    Hi @Samuel Zetabobo ,

    Thank you for posting your query in Microsoft Q&A Platform.

    As per my understanding, you are trying to load data from source to Azure SQL using Azure data bricks notebook. As you have not mentioned what type of source it is. I am assuming your intension is know more about how to load data to Azure SQL tables using azure data bricks notebooks. Please correct me if my understanding is incorrect here.

    There is detailed documentation with steps and screenshots available to explain taking data from ADLS gen2 file and loading it to Azure synapse SQL table using Azure data bricks note book. Click here for same. Requesting to follow steps here and see if that helps.

    Please let us know how it goes or if any further queries.

    ----------

    Please consider hitting Accept Answer. Accepted answers helps community as well.

    Was this answer helpful?


Your answer

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