I'll try to summarize and go directly to the key points as I see this:
- Client to S3 ๐ SAS Token or OAUTH 2.0 with Service to Service authentication (preferred)
- Databricks to S3 ๐ Use Service Principal or Managed Identities (preferred)
- Bronze/Silver/Gold ๐ Create different catalogs per layer or different schemas/databases per catalog to place bronze, silver and gold layers. All of them under Unity Catalog governance. Then, you can set proper permissions for users, groups or service principals depending on layer they should be allowed to interact with.
- Serverless cluster ๐ You can set in "permissions" who can access and how. Establish as needed.