File formats and stages: Enforce dependency checks (Preview)¶
Attention
This behavior change is in the 2025_05 bundle.
For the current status of the bundle, refer to Bundle History.
File formats and stages behave in the following ways:
- Before the change:
You can drop or recreate a file format or stage even when external tables depend on it. You can also alter a stage location. These actions invalidate the dependent external tables.
- After the change:
You can’t drop or recreate a file format or stage that has dependent external tables. You also can’t alter the location of a stage with dependent external tables. To perform these operations, first drop the dependent external tables.
Ref: 1989