question

Anshal-7634 avatar image
0 Votes"
Anshal-7634 asked AnnuKumari-MSFT commented

Blob api estimation

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

azure-data-factoryazure-blob-storage
· 5
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@Anshal-7634 : Can you describe the use-case in detail like what you are trying to achieve, what is your source and target etc. Currently this is unclear

0 Votes 0 ·

@Anshal-7634 May I know what exactly are you trying to perform (Can you bit elaborate more on the issue)?

Azure Blob Storage pricing: https://azure.microsoft.com/en-in/pricing/details/storage/blobs/

Calculate your estimated hourly or monthly costs for using Azure. : https://azure.microsoft.com/en-in/pricing/calculator/

Azure Blob Storage Cost calculation

Refer to this article how to use Get Blob rest


0 Votes 0 ·
AnnuKumari-MSFT avatar image AnnuKumari-MSFT SumanthMarigowda-MSFT ·

Hi @Anshal-7634 ,
Just checking in to see if you got a chance to see previous response. Please revert back with more details if the above response did not answer your query.

0 Votes 0 ·

Hi @Anshal-7634 ,
just checking back to see if you got the resolution for the query. If not, please revert back so that we will respond back with the more details and we will try to help

0 Votes 0 ·

Thank you I want to blob api and copy the data to SQL please guide me all steps

0 Votes 0 ·

1 Answer

AnnuKumari-MSFT avatar image
1 Vote"
AnnuKumari-MSFT answered AnnuKumari-MSFT commented

Hi @Anshal-7634 ,
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.


image.png (26.0 KiB)
image.png (29.6 KiB)
image.png (29.3 KiB)
image.png (33.5 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @Anshal-7634 ,
Just checking in to see if you got a chance to see previous response. If the suggested response helped you, please click Accept Answer and kindly upvote the same.

0 Votes 0 ·