11. Copy Data from Blob Storage to Azure SQL | Azure data engineer

[@akkirajusudhakar450]

All doubts are cleared with this video, Subscribed from end....

[@Amrit-Manash]

very Nicely explained thanks Brother

[@DiwakarMulampaka]

sir , in real time like organizations most of the times we will use linux commands or GUI to transfer data from blob to SQL or local system to blob or anywhere?, please let me know

[@learnbydoingit]

Gui adf

[@gudiatoka]

nice brother

[@deepanshuaggarwal7042]

What will happen if we have mismatch in source csv file and table schema ?

[@manu77564]

Thank you

[@khushii7470]

I keep getting this error message👉 "Schema import failed: Please select a table". 5:49
even though I've already selected a table

[@learnbydoingit]

Will create video for that

[@123featbydeepak]

I’m also getting same error. Plz help😢

[@123featbydeepak]

Hey, Just got the solution. try once.
during selecting table it will be like
dbo tablename
try this
dbo dbotablename ------> this will again throw error.
now again try -------> dbo tablename
In my case it worked, try and please respond if it work or not. I'll get motivated.

[@onjup5627]

Storage account--->container --->input file path place (Could you please explain how your date came to this place?)

[@learnbydoingit]

Date?

[@onjup5627]

@@learnbydoingit sorry data

[@learnbydoingit]

@@onjup5627 as of now I kept manually created container and clicked on upload to upload file from local machine

[@divyan_show]

Operation on target Copy data1 failed: Failure happened on 'Sink' side. ErrorCode=UserErrorInvalidColumnName,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=The column Prop_0 is not found in target side,Source=Microsoft.DataTransfer.ClientLibrary,' - I am getting this error

[@learnbydoingit]

Bro error from sink side... Column name check prop_0

[@sanyaaltaf]

What is the path to reach the azure SQL table page?

[@learnbydoingit]

Search sql and then go

[@abidshaik6327]

which data you are using bro? sample data or any other data. can you please share the data with us?

[@learnbydoingit]

Any data

[@chinmayiyedhli7549]

I did as you taught, but it failed. error: Operation on target Copy data2 failed: Failure happened on 'Sink' side. ErrorCode=UserErrorInvalidColumnName,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=The column Salary is not found in target side,Source=Microsoft.DataTransfer.ClientLibrary,'. Please help me out.

[@learnbydoingit]

Bro error is saying it's failed bcz of sink side.... In your sql do you have salary column pls check

I am getting error while creating sql database under free trial for creating sql table.

[@learnbydoingit]

What is the error

@@learnbydoingit i had retried with free trial, it got deployed successfully.

[@taniyasharma1522]

Operation on target Copy data1 failed: Failure happened on 'Sink' side. ErrorCode=SqlColumnNameNotExist,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Column 'Age' does not exist in the target table '[dbo].[employee]'.,Source=Microsoft.DataTransfer.Connectors.MSSQL,'
I am getting this error.

[@learnbydoingit]

It's saying in sink side age column is not available

[@Bangarrajukosuri]

How to create table for azure data factory

[@learnbydoingit]

In sql table just create table schems by using create table statements

[@manikumar-ix7sr]

@@learnbydoingit in this right
CREATE TABLE [dbo].[employee]
(
[emp_id] [NVARCHAR](128),
[name] [NVARCHAR](128),
[salary] [NVARCHAR](128),
[address] [NVARCHAR](128),
)
GO
select * from employee

[@123featbydeepak]

Same as in sql.

[@123featbydeepak]

error :- "Schema import failed: Please select a table".
Solution :-
Hey, Just got the solution. try once.
during selecting table it will be like
dbo tablename
try this
dbo dbotablename ------> this will again throw error.
now again try -------> dbo tablename
In my case it worked, try and please respond if it work or not. I'll get motivated.

[@learnbydoingit]

I have uploaded video for this error

[@learnbydoingit]

ruclips.net/video/2N9VIyRsTd8/видео.htmlsi=2y5HxmBM15rsFVHc

[@123featbydeepak]

Some how it is working

[@123featbydeepak]

@@learnbydoingit Dataset is using 'AzureSqlDatabase' linked service with SQLVersion v2 type, which is not supported in data flow. now facing this error

[@KISHOREKUMAR-mu3xo]

it seems your skipping table creation bro .....please do complete videos

[@learnbydoingit]

Bro pls complete sql before this ,sql is more important than this

[@123featbydeepak]

create table testtable
( ID NVARCHAR(128),
Age NVARCHAR(128),
CustomerSince NVARCHAR(128),
HighestSpend NVARCHAR(128),
ZipCode NVARCHAR(128),
HiddenScore NVARCHAR(128),
MonthlyAverageSpend NVARCHAR(128),
Level NVARCHAR(128),
)