How to determine datetime when U-SQL Database object was compiled?

Ramya Harinarthini_MSFT 5,351 Reputation points Microsoft Employee
2020-05-14T07:14:34.193+00:00

 I have a few U-SQL databases that I've created in ADLA, and in each database I have compiled objects (stored procedures, table functions, views, etc.).
I want to see WHEN each item was last compiled similar to how I might query sys.objects in SQL Server.  I've looked for a way to see this on the Portal, as well as Visual Studio Data Lake Analytics Explorer, but I cannot determine that.

Also, if I could query a "system" catalog to see this I could then compare two different databases (like QA vs Production, etc.).
Thanks!

[Note: As we migrate from MSDN, this question has been posted by an Azure Cloud Engineer as a frequently asked question]

 Sourced from MSDN – Azure Data Lake Analytics 

Azure Data Lake Analytics
0 comments
Accepted answer
  1. PRADEEPCHEEKATLA-MSFT 89,466 Reputation points Microsoft Employee
    2020-05-14T07:18:00.777+00:00

    Welcome to the Microsoft Q&A platform.

    Happy to answer your questions.

    Please have a look at this doc on U-SQL :

    https://video2.skills-academy.com/en-us/u-sql/objects-and-extensions/catalog-views/objects

    Hope this helps.

     Sourced from MSDN – Azure Data Lake Analytics 

    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.