Allow setting storage on schema level

### Is there an existing issue for this?

- [x] I have searched the existing issues

### Problem statement

During the migration process it is not possible to specify to apply storage locations on the schema level.

### Proposed Solution

introduce a flag that allows to specify the storage location either on catalog or schema level.

### Additional Context

_No response_