"Cannot Drop Table" Error (Log entry)

DS ERROR : 10136.10005 – Cannot DROP TABLE <table-name> because it is being referenced by object <view-name>.
Problem may be due to a SQL view created using schema binding.

For some operations ETL+ drops and re-creates tables and views in the data warehouse. As of ETL+ version 2024.10.1905.35, ETL+ cannot drop tables created using the WITH SCHEMABINDING clause.

What is Schema Binding

Schema binding is established when a view is created using the WITH SCHEMABINDING clause.

SQL

CREATE VIEW <view-name>
WITH SCHEMABINDING
AS
SELECT...

Resolution

Recreate the SQL view in the target data warehouse with a view that does not use the WITH SCHEMABINDING clause.