UP20040 Could not DROP entity used by a job or materialized view
Possible Causes
You tried to DROP one of the following entities: CONNECTION, TABLE, or MATERIALIZED VIEW, and that entity is used by a job or a materialized view. For example, you tried to drop a connection and that connection is being used in a COPY FROM job. SQLake does not allow dropping that connection because it will result in errors in the running job.
Possible Solutions
First, drop the jobs or materialized views using the entity and then retry to drop the entity. You can get the list of jobs a/o materialized views using the entity from the error message.
Last updated