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.).


    Bill Blakey

    Wednesday, January 9, 2019 8:56 PM


  • Hi Bill,

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

    Let us know if this helps, else we can gladly continue the dialogue.


    Thursday, January 10, 2019 8:53 AM