move-coop / parsons

A python library of connectors for the progressive community.
https://www.parsonsproject.org/
Other
259 stars 131 forks source link

[Bug] Drop dependencies for cols needs a CASCADE #818

Closed elyse-weiss closed 1 year ago

elyse-weiss commented 1 year ago

We are using alter_table_cascade=True in a rs.upsert(). It is failing because some of the dependent views have their own dependent views. We need to add CASCADE to this line in the code: https://github.com/move-coop/parsons/blob/main/parsons/databases/redshift/redshift.py#L1090

Detailed Description

To Reproduce

Your Environment

Additional Context

Priority