Spotfire Ideas Portal
Spotfire native connector (using OAuth credentials) need a new selection prompt for "Project" in addition to the existing "Billing Project" selection prompt, so that the connector returns only the list of tables the user is granted access to in BigQuery.
Without the project filter, the connector is returning ALL the tables in the Bigquery data catalog resulting in a long wait time for the user to select the tables for querying.
Partly solved in 11.4 by the preference: Connectors > Google BigQuery > List All Projects. Setting this to False, the connector only load data from the selected billing project and any specifically defined projects (as entered in the "include data from additional projects" field). Default is True.
Thanks for contributing. Just to clarify how it works currently: the connector lists all tables from all projects available to the user, regardless of the selected billing project (not necessary all tables in the database). Long waiting times can be avoided by limit which tables the users can access or to save the data connection to the library to avoid re-loading all the tables.
As I understand the request (please correct me if I'm wrong), you want the ability to select a project in the connector UI to have the connector only list the tables from that project.