Snowflake is a Data Warehouse that is hosted in the cloud. The permission policies that you can define can become very complex - actually I find it's too complicated, I prefer BigQuery from GCP because of this reason.

Thanks!