Azure Bits and Bytes

Пікірлер

@namangarg7023 2 ай бұрын

Tough to achieve in different real time scenarios but still a masterpiece activity explained for new users..tks

@sraoarjun 3 ай бұрын

Awesome

@adityakvs3529 5 ай бұрын

In sink why you upsert and insert

@Ramana6783 9 ай бұрын

Hi..I'm not getting invoice table is not executed for me in pipeline...where I went wrong...can you please help me to fix it

@Ramana6783 9 ай бұрын

Actually why we nee to create the same table in target DB (demobits DB)

@Ramana6783 9 ай бұрын

Please attach the codes for the vedio that you have been used

@swagatpadhi7078 Жыл бұрын

Nua rasan card pain kn kn darkar ? Elegibility ?

@nagarajupinnu3621 Жыл бұрын

why can't we update watermarkDate in a table directly with query instead of Stored procedure which is extra object

@azurebitsandbytes5804 Жыл бұрын

The script activity was not present at the time of making this video. You can use this definitely.

@sirigiriharikrishna1772 Жыл бұрын

How Capture data change works in case of timestamp

@dhrumilgajjar3515 Жыл бұрын

Great explanation and useful video

@shaileshsondawale2811 Жыл бұрын

Wonderful Delivery...!!!! :)

@gsuri-m2k Жыл бұрын

how munch does the basic parameter alerts costs in Azure ?

@shaileshsondawale8765 Жыл бұрын

Awesome...!!! Simplicity in Teaching...!!! Great..!!!

@rohitsethi5696 Жыл бұрын

no this is not useful.The table should be manually enter. This is 200% end developer can end wrong table or misspell or space in table name end or before. The best way to store all the table name in the Table then for each loop process

@shankar1556 Жыл бұрын

Does orders and invoice tables has same schema? How mapping works if table name and column names are different

@shaileshsondawale8765 Жыл бұрын

Awesome Content.. Great work done Sir....

@Tsoy78 Жыл бұрын

I can't see stored procedure to select when in the Sink settings !!

@shinojpkoduvally5205 Жыл бұрын

I assume this works only when Source in in Table format. How do we use REST API as source which return a JSON object and pass that to Stored Procedure in Sink? Appreciated if you have Video for such scenario.

@lilian9921 10 ай бұрын

Hi, did you get the chance to test by using REST API as a source? If so, how did it go?

@kirankumarjena1781 Жыл бұрын

Do you know how to customise the alerts. Suppose in the alert mail you are getting the subscription ID as well. As it is confidential so I don't want to expose that in my metric alter rule

@Andydady-fp2zm Жыл бұрын

Thanks I learned lot in this tutorial. good one

@harrydadson7467 Жыл бұрын

Please can someone please assist me on how I'm not able to do a Copy Activity to Stored Procedure on MySQL table in sink setting. Please help. Thanks

@暁明徐 2 жыл бұрын

greate demo!

@alexcarter-jones3251 2 жыл бұрын

Great video! Have you ever set up an incremental load between an Oracle source table and an SQL sink table before? I am currently trying to do this but can only get my delta load to work when copying from SQL to SQL as you did in this video, any guidance would be greatly appreciated :)

@rathikavenkatesh2510 2 жыл бұрын

Want to call a sp after copy data actually. Is it possible?

@sriramch3128 2 жыл бұрын

Please let me know how did u get that @source when u created stored procedure

@harrydadson7467 Жыл бұрын

I believe this is not an option anymore in the new ADF, video was made couple of years ago

@sriramch3128 2 жыл бұрын

I need that data set of net flix can u provide

@shivprasads.jadhav6450 2 жыл бұрын

Perfect

@RameshPatel-fg9qk 2 жыл бұрын

Thanks, Nice Video Please Share Multiple csv file move in to Archiver Folder on Daily Bases

@CraigBoland 2 жыл бұрын

Recipient or Distribution Group appears to be not currently supported. We tried sending alerts to our team's distribution group. None were received though we verified the distribution group does indeed work for us. When switching back to individual email addresses, we began receiving the alerts again.

@juzerpatanwala5133 2 жыл бұрын

where can we find this dataset of customer orders

@juzerpatanwala5133 2 жыл бұрын

Please create a playlist for Azure DevOps

@chandrasekharnallam2578 2 жыл бұрын

nice explanation with easily understanding the concept. thank you

@loki9267 3 жыл бұрын

Thanks for detailed explanation

@vijaychandar100 3 жыл бұрын

Great info thanks

@ambicagudda4143 3 жыл бұрын

Thank you for the good video. One question here, what if we want to get modified records as well along with the new records.

@azurebitsandbytes5804 3 жыл бұрын

Then we have to consider modified date from the source and at the same time you would need use sp as sink with merge logic. I have posted a video with sink as the SP. Plz refer

@ambicagudda4143 3 жыл бұрын

@@azurebitsandbytes5804 If possible please add one video on the mentioned requirement. Thank you

@Ramana6783 9 ай бұрын

Hi..please post the link for the above requirement

@AMagicViewer 3 жыл бұрын

To the point.. nice one 😊👍

@AMagicViewer 3 жыл бұрын

Good one👍

@grabmylook4500 3 жыл бұрын

Thanks for this amazing video, I hope someday you do a bulk copy from an Azure SQL database to another Azure SQL database 😎

@jyothikulkarni2961 3 жыл бұрын

can we add more than 1 email id to be sent

@azurebitsandbytes5804 3 жыл бұрын

Yes, you can add multiple email ids

@krishnakumar-vi3tf 3 жыл бұрын

It was nice,but one question how can i handle multiple tables passing dynamically to pipe line,right now you are entering table names at pipe line level manually but my requirement is i have to pass table list for both lookups dynamically

@krishnakumar-vi3tf 3 жыл бұрын

i got to know there is another video where we can pass tables dynamically with master pipe line..excellent..its an urgent requirement for me..thanks a lot

@muraliyadav7601 3 жыл бұрын

Thanks Sangram for the video, I have a requirement which I need to send the password as a header in the web activity body, the password is available in the key vault as a secret, how can we do that

@muraliyadav7601 3 жыл бұрын

I am able to get it by using web activity 😀,

@vagdevigovardhanam120 3 жыл бұрын

Good video, thanks for that But one question how about the invoice mapping in copy activity(in child pipeline). Master pipeline failing(ForEach activity) due to not being able to load invoice data. Can you please tell me how this can be fixed Thanks

@azurebitsandbytes5804 3 жыл бұрын

Clear off the schema of the sql dataset. It will work

@SangLeWeb 2 жыл бұрын

@@azurebitsandbytes5804 can you elaborate on this? mine only work on the first table but always get "Column name 'xxxx' cannot be found in either source data or column" but if I map the data then it works but then the 1st table would failed with similar message.

@azurebitsandbytes5804 2 жыл бұрын

@@SangLeWeb Look Up First Row Only Property needs to be unchecked to allow reading all the records from the config table

@SangLeWeb 2 жыл бұрын

@@azurebitsandbytes5804 That's not I was referring to, mine is already unchecked and I can see it loops through 2 records but as I said, it works only the 1st loop, the 2nd threw an error about the ID not avail since my 2nd table does not call ID but it says userID. So it seems like the source still using the previous schema instead of new one which I already put a "Select *..". Just try to run the child by changing the table name wouldn't work neither unless I create a mapping then I can run with different table name. The only diff between your sample and mine is my sourct table name is diff from my sink so I created 3 variable (SourceName, TargetName, WatermarkValue) but I don't think this should be an issue.

@SangLeWeb 2 жыл бұрын

I figured it out, it was my SP that I ran causing the issue. BTW, thanks for taking the time to put up the videos, very insightful.

@wheretastesdivedeep 3 жыл бұрын

How to handle if the table don't have data?

@azurebitsandbytes5804 3 жыл бұрын

Which table?

@shivprasads.jadhav6450 3 жыл бұрын

Detailed video. Keep it up and ongoing with such a informative videos.

@azurebitsandbytes5804 3 жыл бұрын

Thanks shiv

@ambershergill1982 3 жыл бұрын

when your 3000 threshold reach would you receive two emails or just one email you setup at action group ? Please update

@shivprasads.jadhav6450 3 жыл бұрын

Informative video

@divyaravichandran7633 3 жыл бұрын

Awesome and clear explanation!!

@ajithreddy6805 3 жыл бұрын

Great Video!!!! Can we add more variables?? like Pipeline Name, File Name and Error message. Like Azure logics app variables

@ashwinds6293 3 жыл бұрын

Am getting an error in pulling the data through ADF for Oracle as a Source . Could you please help me in this

@Lihka080 3 жыл бұрын

@ Azure Bits and Bytes Hi Sir very useful and excellent, could you please add update logic, so if there is any change in source table records it should update the records in sink table then need to take latest from source to sink table. Thanks in advance

Ең жақсы KZbin

Пікірлер