Comment on page
UP20040 Could not DROP entity used by a job or materialized view
- 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.
- 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.