CODEWITHSUNDEEP
google-bigquery
Yang L
Yang L

Reputation: 469

Access control in BigQuery

In the documentation of BigQuery, it has only three types of sources: organization, project and dataset. Roles and permissions are on these resources.My question is is there any way to define an access control to a particular table in a dataset?

Upvotes: 1

Views: 514

Answers (2)

Mikhail Berlyant
Mikhail Berlyant

Reputation: 172994

No, you cannot define access control on table. Only down to dataset! At the same time there is a way to define row-level access

Yet, another option for you (depends on specific use case) would potentially be Protecting Data with Cloud KMS Keys - this will not control access but rather ability to see actual data vs. encrypted

Upvotes: 3

Felipe Hoffa
Felipe Hoffa

Reputation: 59175

With BigQuery you can define read access up to a per-row level:

With that said, going to a per-row or per-table level access will take a lot more work (involving authorized views) than working the native project/dataset access controls.

Upvotes: 2

Related Questions