ADF Pipeline & SQL Fix
Budget: ₹1,500 – ₹12,500 INR
I have a production-support ticket that I need to close quickly. The Azure Data Factory pipeline is taking too much time to run when it reaches the step that calls a SQL script, and the underlying issue appears to be performance-related within that script. Your task is to jump into my Azure environment, pinpoint the root cause, and get the pipeline running cleanly end-to-end.
What you’ll tackle
• Debug the pipeline activity that integrates with the SQL script.
• Tune or rewrite the script so it runs efficiently without timing out or over-consuming resources.
• Validate by triggering the pipeline in Production and showing a successful, performant run.
I’ll provide access to the ADF workspace, the pipeline, monitoring logs, and the current SQL code. Once the job is done, I simply need confirmation that the ticket can be closed, along with a brief summary of the fix so I can document it internally.
What you’ll tackle
• Debug the pipeline activity that integrates with the SQL script.
• Tune or rewrite the script so it runs efficiently without timing out or over-consuming resources.
• Validate by triggering the pipeline in Production and showing a successful, performant run.
I’ll provide access to the ADF workspace, the pipeline, monitoring logs, and the current SQL code. Once the job is done, I simply need confirmation that the ticket can be closed, along with a brief summary of the fix so I can document it internally.
Related categories:
Data Processing
SQL
Cloud Computing
Education
Azure
Debugging
Data Integration
ETL
Data Management
Performance Tuning