TIBCO Data Virtualization® Adapter Online Help > TDV Google BigQuery Adapter > Data Model > Views
 
Views
Views are similar to tables in the way that data is represented; however, views do not support updates. Data sources that are represented as views are typically read-only data sources. Often, a stored procedure is available to update the data if such functionality is applicable to the data source.
Queries can be executed against a view as if it were a normal table, and the data that comes back is similar in that regard. To find out more about tables and stored procedures, please navigate to their corresponding entries in this help document.
Views are composed of columns and pseudo columns.
Google BigQuery Adapter Views
Name
Description
Datasets
Lists all the accessible datasets for a given project.
PartitionsList
Lists the partitioning definitions for tables
PartitionsValues
Lists the partitioning ranges for tables
Projects
Lists all the projects for the authorized user.
Datasets
Lists all the accessible datasets for a given project.
Columns
Name
Type
Description
Id [KEY]
String
The fully qualified, unique, opaque Id of the dataset.
Kind
String
The resource type.
FriendlyName
String
A descriptive name for the dataset
DatasetReference_ProjectId
String
A unique reference to the container project.
DatasetReference_DatasetId
String
A unique reference to the dataset, without the project name.
PartitionsList
Lists the partitioning definitions for tables
Columns
Name
Type
Description
Id [KEY]
String
A unique identifier for the partition.
ProjectId
String
The project that the table belongs to.
DatasetId
String
The dataset that the table belongs to.
TableName
String
The name of the table.
ColumnName
String
The name of the column used for partitioning.
ColumnType
String
The type of the partitioning column.
Kind
String
The type of partitioning used by the table. One of DATE, RANGE or INGESTION.
RequireFilter
Boolean
Whether a filter on the partition column is required to query the table.
PartitionsValues
Lists the partitioning ranges for tables
Columns
Name
Type
Description
Id
String
A unique identifier for the partition.
RangeLow
String
The lowest value of the partition column. Either an integer when Kind is RANGE, or a date otherwise.
RangeHigh
String
The highest value of the partition column. Either an integer when Kind is RANGE, or a date otherwise.
RangeInterval
String
The range of values which are included in each partition. Only valid when Kind is RANGE
Projects
Lists all the projects for the authorized user.
Columns
Name
Type
Description
Id [KEY]
String
The unique identifier of the Project
Kind
String
The resource type.
FriendlyName
String
A descriptive name for the project.
NumericId
String
The numeric Id of the project.
ProjectReference_ProjectId
String
A unique reference to the project.