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.
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=<project>;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>
Comments
0 comments
Please sign in to leave a comment.