Blob api estimation

Anshal 1,866 Reputation points
2022-04-20T07:30:09.497+00:00

Hi friends what are the steps to use Ali for example get blob
Give me step by step help

Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
2,425 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,514 questions
Accepted answer
  1. AnnuKumari-MSFT 30,601 Reputation points Microsoft Employee
    2022-04-27T05:56:03.08+00:00

    Hi @Anshal ,
    Thankyou for your query. As per my understanding , you want to fetch data from BLOB API that is probably REST API which connects to Azure BLOB storage and copy the data into SQL server. Please let me know if my understanding about your query is incorrect.

    Here are the steps that can lead you to copy data from BLOB API to Az SQL Server.

    1. Create a dataset of type REST pointing to the BLOB API
      196821-image.png
    2. Use Copy data activity in ADF pipeline and use the above dataset in source .
      196699-image.png
    3. Create another dataset of type Az SQL server and use it in sink settings.
      196822-image.png
    4. You can use pre-copy script section to truncate the table everytime before load.
      196750-image.png

    It would be great if you can confirm whether the data resides in your blob storage then you can use Az blob storage connector directly instead of REST

    Please let us know if it helps.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest