Using DROP CASCADE function in Airbyte


Exploring the possibility of using DROP CASCADE function in Airbyte to resolve dependency issues when dropping tables


Is there a way to make Airbyte use DROP CASCADE function? I’m getting the following error:

ERROR: cannot drop table ? because other objects depend on it Detail: view dev_staging.stg_files__countries_by_? depends on table ? Hint: Use DROP … CASCADE to drop the dependent objects too.

Everything worked fine before updating from 0.4x to 0.51 version.

This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want to access the original thread.

Join the conversation on Slack

["drop-cascade", "dependency-error", "airbyte-platform"]