Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

There is a public version of this guide here, How to Cancel Running Load Jobs, especially when blocking deploy model changes. Should this one be deleted?


When trying to deploy a model you might encounter this warning : "Integration load(s) still running for data location. Putting this data location in "Maintenance" mode will prevent them from being submitted as integration batches".

...

The obvious workaround would be to use the maintenance mode, but if you don't want to waste time you might want to canncel cancel these loads.

The clean way of doing it would be to use the CANCEL_LOAD function from the SQL API, but you may also use direct SQL update.

...