知識庫

BigQuery Public Datasets Not Listed on Tableau Data Source Page


發佈時間 : 18 Dec 2019
上次修改日期 : 19 Jul 2023

解決方法

Option 1 - Manually enter the project name
  1. Enter the name of the project in the drop-down menu of the Connections dialog and click the plus icon.
User-added image
 
Option 2 - Use custom SQL
  1. From the Project drop-down list, select publicdata
  2. From the Dataset drop-down list, select samples
  3. Under Table, double-click 'New Custom SQL'. 
  4. In the Edit Custom SQL dialog, enter a query using the syntax below and then click OK: 
    SELECT * FROM `project-id.dataset_name.table_name`

原因

This is the current default behavior with BigQuery public datasets.
這篇文章是否解決了問題?