29. Lookup activity in azure data factory | Azure data factory

#adf #datafactory #azuredatafactory #adf
Lookup activity in azure data factory
Azure Data Factory: Lookup Activity Tutorial 🔍
Welcome to our latest KZbin tutorial where we explore the Lookup activity in Azure Data Factory (ADF)!
Join us in this comprehensive tutorial as we dive into the Lookup activity, an essential tool in Azure Data Factory, Microsoft's cloud-based data integration service. The Lookup activity allows you to query and retrieve data from external data sources, empowering you to enrich your data pipelines with additional information or reference data.
Key Topics Covered:
Understanding the purpose and use cases of the Lookup activity
Configuring the Lookup activity in Azure Data Factory pipelines
Connecting to various data sources, such as databases, files, and APIs
Defining query expressions and parameters for data retrieval
Handling lookup results and mapping them to pipeline data structures
Error handling and retry mechanisms for robust lookup operations
Best practices and tips for efficient usage and optimization
Want more similar videos- hit like, comment, share and subscribe
❤️Do Like, Share and Comment ❤️
❤️ Like Aim 5000 likes! ❤️
➖➖➖➖➖➖➖➖➖➖➖➖➖
Please like & share the video.
➖➖➖➖➖➖➖➖➖➖➖➖➖
➖➖➖➖➖➖➖➖➖➖➖➖➖
script
create table employee (
id int,
name varchar(128),
country varchar(128)
)
insert into employee values(1,'manish','india')
insert into employee values(2,'manish','USA')
insert into employee values(3,'manish','india')
insert into employee values(4,'manish','india')
insert into employee values(5,'manish','india')
insert into employee values(6,'manish','india')
insert into employee values(7,'manish','india')
create table employee_resign (
id int
)
insert into employee_resign values(1)
insert into employee_resign values(2)
insert into employee_resign values(3)
create procedure emp_delete @id int as
delete from employee where id=@id
exec emp_delete @id=1
select * from employee
select * from employee_resign
➖➖➖➖➖➖➖➖➖➖➖➖➖
AWS DATA ENGINEER : • AWS DATA ENGINEER
Azure data factory :
• Azure Data Factory
Azure data engineer playlist : • Azure Data Engineer
SQL PLAYLIST : • SQL playlist
PYSPARK PLAYLIST -
• Pyspark Tutorial
➖➖➖➖➖➖➖➖➖➖➖➖➖
📣Want to connect with me? Check out these links:📣
Join telegram to discuss t.me/+Cb98j1_f...
➖➖➖➖➖➖➖➖➖➖➖➖➖
what we have covered in this video:
➖➖➖➖➖➖➖➖➖➖➖➖➖
Hope you liked this video and learned something new :)
See you in next video, until then Bye-Bye!
➖➖➖➖➖➖➖➖➖➖➖➖➖
get metadata vs lookup in adf
How to use lookup in adf
adf lookup activity sql query
Lookup in adf azure data factory
lookup activity in azure data factory example
azure data factory lookup activity output value array
adf lookup query
limitations of lookup activity in adf
#AzureDataFactory
#DataIntegration
#ETL
#CloudData
#DataEngineering
#LookupActivity
#DataLookup
#DataRetrieval
#AzureServices
#DataPipeline
#AzureDataFactoryLookup
#DataQuery
#DataEnrichment
#DataTransformation
#DataWorkflow
#DataProcessing
#DataAnalytics
#BigData
#CloudComputing
#MicrosoftAzure

[@SandeepKabdwal]

Your adf content is perfect for quick learning

[@Surendra-tf1hz]

super content bro. osm explanation.

[@kalakritibysanskriti]

Keep uploading

[@krishnaudata-jb7nt]

you work is really good bro

[@pulastyadas3351]

The expression 'length(activity('Lookup1').output.value)' cannot be evaluated because property 'value' doesn't exist, available properties are 'firstRow, effectiveIntegrationRuntime, billingReference, durationInQueue'. Getting this error. Could you please check and rectify.

[@vijaybhaskarreddy-i2v]

Suppose if we have 1000 employees in resign table do we need run 1000 time SP Activity?

[@kalakritibysanskriti]

Thanks