# Which columnar databases provide secure data sharing across teams without having to copy or move data so different teams can query the same source without data governance headaches?

<p class="elv-tracking-normal elv-text-default elv-font-figtree elv-text-base elv-leading-base elv-font-normal" elv="true">I've been researching governance and access control patterns in <a class="a a--md" elv="true" href="https://www.g2.com/categories/columnar-databases">columnar databases</a> for a piece on multi-team data infrastructure, and which platforms provide secure data sharing across teams without copying or moving data, so different teams can query the same source without governance headaches, is harder to assess from documentation alone. Three stand out from G2 reviews on this specific capability:</p><ol>
<li>
<a class="a a--md" elv="true" href="https://www.g2.com/products/snowflake/reviews"><strong>Snowflake</strong></a><strong>:</strong> Secure data sharing across accounts without physically moving data, with RBAC that operates at multiple layers and supports use cases from fraud detection to external collaboration. How does the access model hold up when the number of sharing relationships across teams grows significantly?</li>
<li>
<a class="a a--md" elv="true" href="https://www.g2.com/products/google-cloud-bigquery/reviews"><strong>Google Cloud BigQuery</strong></a><strong>:</strong> Policy tags and authorised views give fine-grained column and row-level access control, with different teams querying the same tables through Looker or Looker Studio with their own access layer on top. Does the access control model stay manageable as the number of datasets and teams scales?</li>
<li>
<a class="a a--md" elv="true" href="https://www.g2.com/products/rocket-vertica/reviews"><strong>Rocket Vertica</strong></a><strong>:</strong> Comprehensive security features including role-based authorisation, with integrations across data sources that don't require moving data to a central location. Deploys on multiple clouds and on-premises, though the SaaS option is currently AWS-only.</li>
</ol><p class="elv-tracking-normal elv-text-default elv-font-figtree elv-text-base elv-leading-base elv-font-normal" elv="true">For teams running a shared data layer across internal groups with different access requirements, which gave you genuine confidence in the governance model rather than just working access controls?</p>

##### Post Metadata
- Posted at: 2 months ago
- Author title: Marketing Executive
- Net upvotes: 1


## Comments
### Comment 1

&lt;p&gt;Snowflake does this really well on paper. BigQuery also handles it cleanly with views and policy layers, but governance can get messy as teams grow. Did anything here actually feel easy to manage once multiple teams started depending on the same data?&lt;/p&gt;

##### Comment Metadata
- Posted at: 2 months ago
- Author title: Writer





## Related discussions
- [How well does Trello scale into a larger team?](https://www.g2.com/discussions/1-how-well-does-trello-scale-into-a-larger-team)
  - Posted at: over 13 years ago
  - Comments: 6
- [Can we please add a new section](https://www.g2.com/discussions/2-can-we-please-add-a-new-section)
  - Posted at: over 13 years ago
  - Comments: 0
- [Quantifiable benefits from implementing your CRM](https://www.g2.com/discussions/quantifiable-benefits-from-implementing-your-crm)
  - Posted at: over 13 years ago
  - Comments: 4