Creating Metadata for the Google BigQuery Adapter

How to:

Reference:

Create Synonym for the Google BigQuery Adapter creates the metadata used for WebFOCUS reporting.

Procedure: How to Create Metadata

  1. From the WebFOCUS Reporting Server Web Console, click Connect to Data.
  2. Right-click the configured connection for the Google BigQuery Adapter (for example, GoogleBigQuery) and click Show DBMS objects from the context menu, as shown in the following image.


    The Available Objects for Google BigQuery (GoogleBigQuery) pane opens, as shown in the following image.

  3. Enter or select parameter values and clickCreate Base Synonyms, Create Cluster Synonym With BV, or Update Base Synonyms on the ribbon.

Reference: Synonym Creation Parameters for Google BigQuery

The following liast described the synonym creation parameters for which you can supply values.
Object Type

Restrict candidates for synonym creation based on the selected object type(s): Tables, Views, External SQL Scripts, and any other supported objects.

Choosing External SQL Scripts from the drop-down list enables you to represent an SQL Query as a synonym for read-only reporting. A Synonym candidate can be any file that contains one (and only one) valid SQL Query and does not contain end-of-statement delimiters (";" or "/") and comments.

Depending on the adapter, you can further restrict your search by choosing check boxes for listed objects.

Owner/Schema

Select an owner/schema from the drop-down list, or click Search to search.

Project

Indicates the project associated with the Google BigQuery data.

Application

Select an application directory. The default value is baseapp.

Customize data type mappings

If checked, opens additional fields for decomposing date fields, adding geographic roles, and selecting the data type for numeric fields and for alphanumeric fields.

Action

Select Create Base Synonyms, Create Cluster Synonym With BV, or Update Base Synonyms.

Prefix

Assign a prefix to the synonym names.

Suffix

Assign a suffix to the synonym names.

Database

Select objects for which to create synonyms. If you selected Create Cluster Synonym With BV as the action, the list will have facts and dimensions. If you select a fact or dimension, you can right-click it to show or add related dimensions to the list of checked items for the cluster.

Click Create Base Synonyms, Create Cluster Synonym With BV, or Update Base Synonyms on the ribbon.

WebFOCUS

Feedback