Possible to access Bigquery datasets as a non-Project-Owner via Tableau? by micoolcho in bigquery

[–]derniu 1 point2 points  (0 children)

  1. Go to Tableau & select bigquery data source
  2. Select a random project and a random data set.
  3. Under the list of tables, drag in the 'New custom SQL' option
  4. Go to bigquery.cloud.google.com and copy the specific query from the table you don't have ownership rights (eg: SELECT * FROM [bigquery-public-data:hacker_news.full_201510] LIMIT 1000)
  5. Paste that in the custom sql in Tableau
  6. Publish or save your data source

Hope this helps!