Summary
Suggest introducing database level default connection options, something like this:
CREATE/ALTER DATABASE my_db
OPTIONS (
DEFAULT_STORAGE_CONNECTION = 'my_s3_connection',
DEFAULT_STORAGE_PATH = 's3://mybucket/users/'
);
Newly created tables of database my_db, without implicit connection options, should use the DEFAULT_STORAGE_CONNECTION/PATH specified at database level.