Search code examples
azure-sql-databaseazure-blob-storageazure-data-factoryetl

Is there a UI based way to load csv data to Azure SQL Database?

I'm trying to figure out the easiest way to load data into an Azure SQL Database. I'm aware of all the methods referenced here , here and here as well as various ETL tools. By far, it looks like bcp using SSMS is the easiest way. My question is, is there an easier UI based way to load data from a file into a table, either via a bucket(blob storage) or directly uploaded like we can in Google BigQuery or AWS RedShift or Athena or Glue?

Solution

  • Please try the Azure Data Factory Copy Data tool as explained here.

    1.On the Let's get started page, select the Copy Data tile to launch the Copy Data tool.

    enter image description here

    2.On the Properties page, under Task name, enter CopyFromBlobToSqlPipeline. Then select Next. The Data Factory UI creates a pipeline with the specified task name.

    enter image description here

    3.On the Source data store page, complete the following steps:

    3a. Click + Create new connection to add a connection

    enter image description here

    3b. Select Azure Blob Storage from the gallery, and then select Next.

    enter image description here

    3c. On the New Linked Service page, select your storage account from the Storage account name list, and then select Finish.

    enter image description here

    3d. Select the newly created linked service as source, then click Next.

    enter image description here

    4.On the Choose the input file or folder page, complete the following steps:

    4a. Click Browse to navigate file, then click Choose.

    enter image description here

    4b. Click Next to move to next step.

    5.On the File format settings page, notice that the tool automatically detects the column and row delimiters. Select Next. You also can preview data and view the schema of the input data on this page.

    enter image description here

    6.On the Destination data store page, completes the following steps:

    6a. Click + Create new connection to add a connection

    enter image description here

    6b. Select Azure SQL Database from the gallery, and then select Next.

    enter image description here

    6c. On the New Linked Service page, select your server name and DB name from the dropdown list, and specify the username and password, then select Finish.

    enter image description here

    6d. Select the newly created linked service as sink, then click Next.

    enter image description here

    7.On the Table mapping page, select the table, and then select Next.

    9.On the Settings page, select Next.

    10.On the Summary page, review the settings, and then select Next.