question

RamyaHarinarthini-7767 avatar image
RamyaHarinarthini-7767 asked ·

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

 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
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

PRADEEPCHEEKATLA-MSFT avatar image
PRADEEPCHEEKATLA-MSFT answered ·

Welcome to the Microsoft Q&A platform.

Happy to answer your questions.

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

https://docs.microsoft.com/en-us/u-sql/objects-and-extensions/catalog-views/objects

Hope this helps.

Sourced from MSDN – Azure Data Lake Analytics


Share
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.