23. Copy Data Activity in Azure Data Factory
ฝัง
- เผยแพร่เมื่อ 27 มี.ค. 2020
- In this Video, I discussed about Copy Data Activity in Azure Data Factory
Link for Azure Functions Play list:
• 1. Introduction to Azu...
Link for Azure Basics Play list:
• 1. What is Azure and C...
Link for Azure Data factory Play list:
• 1. Introduction to Azu...
#azure #adf #azuredatafactory - วิทยาศาสตร์และเทคโนโลยี
hi bro glad to see your classes but if you give the links of the documentation in description which you mentioned in the video that would be helpful
Please do some more practical sessions on ADF which are related to real-time projects. So it will helpful to all
Yesss exactly
thanks for your effort...better to complete Lab on each topic..instead showing them in ADF window.
for multiple files from a nested folder what we have to do ? In the source dataset keep the filename as empty and put here recursive in pipeline
Hii have seen all your videos i am working along with microsoft for an upcoming project with providence healthcare in US. Videos were really helpfull. Can you comment if copy data activity will work if we want to copy files in different subscriptions?
Awesome videos bro.Do you have the C# code to create copy activity programmatically? Im trying to add additional columns to the source dataset but couldn’t find a way.It would be great if you can help me in doing that. Thank you
Awesome, could you also Configure SSIS IR with Vnet
Hello I want to compare values of four fields weather they are same or not .. like if a=b=c=d
Can we do that using derived column activity ?thanks in advance
Bro, can you please make a video on using UPSERT option in copy data activity loading into multiple tables at a time?
You are awesome bro.
Thank you 🙂
Hey do you have a video for Copy activity where we load csv to Azure datalake ?
Thanks !
How can I copy tables from hive usable and sink into .CSV?
Thank you.
Welcome 🤗
Can u plz share the video on on premises sql server database to azure blob storage using copy data tool
I dream of a world where not 99% of it tutorials are indian
Hehe 😅
Actually i have created a Ftp server in my win 10 machine using IISM and while creating linked service to connect with it i get error "connection failed".
Can you please do one thing like instead of storing these files in blob storage cloud directly,
create a local FTP server in you local machine and then use data factory to connect with the Local FTP server and then copy data to blob storage.
can we connect i have an issue with HTTp Connector
Thank a lot
Welcome 😊
diffrence between file and table
I am getting Error: Invalid configuration value detected for fs.azure.account.key when i use delta lake connector , when i preview data in DBFS (Hive) i am able to view but when i am trying to copy data i am getting error can you please help me
How to copy data to a computed column in sink? It is giving error.
Possible to transfer pdf and jpg files
How to load top 10 records from CSV file to Azure sql database in ADF
You can use suggograte transformation and filter condition to achieve this task
Hey, can u help me with unzipping password protected zip file using azure data factory
okay
you have chosen csv file why ,But you started ur discussion with table.. by 11:38 Please share
Is that possible to view column pattern expression in windows transformation ?
Hi Wafa,
Could you please help me store the below data into a table of one row in SQL?
Table Schema
MPR,ReadDate,Block1,ReadType1,Block2,ReadType2,Block3,ReadType3,Block4,ReadType4,Block5,ReadType5,Block6,ReadType6
Explanation :
Block1 ==> 00:30 and kWh value goes into this column
Block2 ==> 01:00 and kWh value goes into this column
Block3 ==> 01:30 and kWh value goes into this column
Block4 ==> 02:00 and kWh value goes into this column
Block5 ==> 02:30 and kWh value goes into this column
Block6 ==> 03:00 and kWh value goes into this column
Here is Data :
MPR,ReadDatetime,kWh,ReadType
111,04/11/2020 00:30,100,Actual
111,04/11/2020 01:00,100,Actual
111,04/11/2020 01:30,100,Actual
111,04/11/2020 02:00,100,Actual
111,04/11/2020 02:30,100,Actual
111,04/11/2020 03:00,100,Actual
please suggest to me how can I achieved this.
Please share your presentation
Link should be placed on description not on video🤷🏻
Too many repeats. If you eliminate repetitions, then amount of information will be 20%-30% out of the all time. Try to avoid it as it makes lestener feel boring.