Welcome to the Microsoft Q&A platform.
Happy to answer your questions.
Please have a look at this doc on U-SQL :
https://learn.microsoft.com/en-us/u-sql/objects-and-extensions/catalog-views/objects
Hope this helps.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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]
Welcome to the Microsoft Q&A platform.
Happy to answer your questions.
Please have a look at this doc on U-SQL :
https://learn.microsoft.com/en-us/u-sql/objects-and-extensions/catalog-views/objects
Hope this helps.