title: BigQuery Data Connectors: How to limit the accessible data by field value
body: <p>I have one large BigQuery table with multiple different clients analytics data stored within it. Clients wish to connect the table to one of the <a href="https://cloud.google.com/bigquery/partners/" rel="nofollow noreferrer">data visualization tools</a> partnered with Google. My worry is regarding the potential for client data to be mixed. Is there a sure-fire way of ensuring that the data provided to each client is filtered to only contain their own?</p>
  
  <p>The Clients data all have an associated account_id. Can I use this field to filter by? If the answer is no to filtering, then is the best approach filtering the large BigQuery table into smaller ones for each client?</p>