To see Materialized Views, you need to add the following XML setting in the data source template of Google BigQuery.

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

1.  Launch the Spotfire Server configuration tool.
2. Click the Configuration tab and Click Data Source Templates on the left pane.
3. In the existing Google BigQuery data source template, add the above XML setting.
4. The data source template should look similar to the below (considering you are using the Simba JDBC 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>

5. Save the Configuration Tool and restart the Spotfire server services for changes to take effect.
6. Launch the installed Spotfire client session and check the data source metadata for Materialized Views.

Doc: XML settings for data source templates

• https://docs.tibco.com/pub/spotfire_server/latest/doc/html/TIB_sfire_server_tsas_admin_help/server/topics/xml_settings_for_data_source_templates.html

Community article:

• https://community.spotfire.com/articles/spotfire/spotfire-jdbc-data-access-connectivity-details/