CODEWITHSUNDEEP
azure-data-factoryazure-data-lakeu-sql
Amit Tiwari
Amit Tiwari

Reputation: 31

USQL Execution and refer another script

Could you guys help with following:

  1. How can we execute script usql script stored in ADL store using ADF. What is standard practice of storing script?
  2. Currently I don't see a way to refer script from another script. It will make script execution simple because then I can make a deep chain where ScriptA will refer to ScriptB and so on and Only submitting ScriptB would be sufficient since it will automatically invoke dependent script.
    1. Please point me to documentation for recommendation for better partition/indexing schema and performance improvement tips/tricks

Upvotes: 1

Views: 200

Answers (1)

Michael Rys
Michael Rys

Reputation: 6684

  1. This was just asked and answered here: Execute U-SQL script in ADL storage from Data Factory in Azure

  2. U-SQL offers you a meta-data service with Procedures and Functions. So instead of doing file chaining, you can register your reusable script components as procedures and functions instead.

  3. take a look at the performance tuning slides on http://www.slideshare.net/MichaelRys. If you have access to SQLPASS or TechReady presentation recordings, there are videos of that presentation available as well.

Upvotes: 1

Related Questions