give drop secret a cascade option

[lmatz]

Is your feature request related to a problem? Please describe.

To drop all of its dependent objects and finally the secret itself.

Easy way to drop all the tables/sources associated with a certain upstream

Describe the solution you'd like

No response

Describe alternatives you've considered

No response

Additional context

No response

[lmatz]

It would be better if we provide a way to check which tables/sources are using the secret at the moment before the user can drop cascade it.

BTW, this reasoning also applies to MV and tables/sources.