What happens if we update a function/procedure definition in the middle of a job that makes use of it?


  • Let's say that we have an Azure Data Lake job that performs some data transformations.  This job makes use of functions A, B and C. While the job is running, we are updating the definition of the function C.  Will the job pick up the updated function C code or the code that was there when the job got started?

    Sanjeewa J

    Monday, April 30, 2018 3:01 AM

All replies

  • That's a great question. From my understanding, it is treated as a function in c#. Like C#, before the program runs, it takes and binds the assemblies and functions together and executes the program. The SQL query execution functionality is similar to that.

    Thursday, May 10, 2018 10:58 PM