Adding External Users to CTA Viewers Group

In addition to your organization's PAD users, you may have some folks who only need access to view certain tables and do not need the ability to edit them. Luckily, PAD offers Admin users the ability to add external users to a Viewers group. One important thing to note is that the external user must have a Google account.

Instructions:

1. While logged into your PAD account, navigate to groups.google.com. You automatically will be taken to “My groups”. If not, click “My groups” on the left side menu
2. The two groups: “ Administrators” and “ Viewers” should be available to you. Click the name of the “Viewers” group.
3. On the left side, under the “People” section, click the “Members” button.
4. At the top menu bar below the search bar, click the “Add members” button. Add the external user’s email address to “Group members” and make sure “Directly add members” is toggled on. Click “Add members”.
5. The user should now have access to the “viewers_dataset” in your BigQuery project! 

Note that viewers added only have access to data in the “viewers_dataset” that you explicitly insert into that dataset. Best practice for this is to create views from your other datasets into the viewers_dataset as needed. Example query to do so below:

CREATE VIEW IF NOT EXISTS prod-partner-a-176bffe6.viewers_dataset.example_view(zip_code, population, households) AS
SELECT
  geo_id,
  total_pop,
  households
FROM `prod-partner-a-176bffe6.sample_dataset_us.zip_codes_2018_5yr`
WHERE
  total_pop > 100
ORDER BY
  total_pop DESC;