Spotfire Server: How to see materialized views from Google BigQuery in Information designer

When setting up Google BigQuery as a data source in the Information designer tool using the data source template from the below community article, you will not see materialized views.

https://community.spotfire.com/articles/spotfire/spotfire-jdbc-data-access-connectivity-details/#wiki-header-31

To see materialized views, you need to add the following:

<table-types>TABLE,VIEW,MATERIALIZED_VIEW</table-types>

The data source template should look similar to the below (for the Simba driver):

<jdbc-type-settings>
  <type-name>BigQuery</type-name>
  <driver>com.simba.googlebigquery.jdbc41.Driver</driver>
  <connection-url-pattern>jdbc:bigquery://https://www.googleapis.com/bigquery/v2:443;ProjectId=&lt;project&gt;;OAuthType=0;OAuthServiceAcctEmail=xxxxxx@developer.gserviceaccount.com;OAuthPvtKeyPath=D:\\path\file</connection-url-pattern>
  <table-types>TABLE,VIEW,MATERIALIZED_VIEW</table-types>
  <supports-catalogs>true</supports-catalogs> 
  <supports-schemas>true</supports-schemas>
  <supports-procedures>false</supports-procedures>
  <column-name-pattern>$$name$$</column-name-pattern>
  <table-name-pattern>$$name$$</table-name-pattern>
  <schema-name-pattern>$$name$$</schema-name-pattern>
  <catalog-name-pattern>$$name$$</catalog-name-pattern>
  <procedure-name-pattern>$$name$$</procedure-name-pattern>
  <column-alias-pattern>$$name$$</column-alias-pattern>
</jdbc-type-settings>

Note that this is different from some other data sources like PostgreSQL where the materialized view is not using the underscore '_'

 <table-types>TABLE,VIEW,MATERIALIZED VIEW</table-types>

https://support.revvitysignals.com/hc/en-us/articles/23600312350100-How-to-make-materialized-query-tables-or-views-visible-in-TIBCO-Spotfire-Information-Designer