public abstract class ViewDefinition extends TableDefinitionGoogle BigQuery view table definition. BigQuery's views are logical views, not materialized views, which means that the query that defines the view is re-executed every time the view is queried. See Also: Views
Static Methods
newBuilder(String query)
public static ViewDefinition.Builder newBuilder(String query)Returns a builder for a BigQuery view definition.
| Parameter | |
|---|---|
| Name | Description |
query |
Stringthe query used to generate the view |
| Returns | |
|---|---|
| Type | Description |
ViewDefinition.Builder |
|
newBuilder(String query, UserDefinedFunction[] functions)
public static ViewDefinition.Builder newBuilder(String query, UserDefinedFunction[] functions)Returns a builder for a BigQuery view definition.
| Parameters | |
|---|---|
| Name | Description |
query |
Stringthe query used to generate the table |
functions |
UserDefinedFunction[]user-defined functions that can be used by the query |
| Returns | |
|---|---|
| Type | Description |
ViewDefinition.Builder |
|
newBuilder(String query, List<UserDefinedFunction> functions)
public static ViewDefinition.Builder newBuilder(String query, List<UserDefinedFunction> functions)Returns a builder for a BigQuery view definition.
| Parameters | |
|---|---|
| Name | Description |
query |
Stringthe query used to generate the table |
functions |
List<UserDefinedFunction>user-defined functions that can be used by the query |
| Returns | |
|---|---|
| Type | Description |
ViewDefinition.Builder |
|
of(String query)
public static ViewDefinition of(String query)Creates a BigQuery view definition given the query used to generate the table.
| Parameter | |
|---|---|
| Name | Description |
query |
Stringthe query used to generate the table |
| Returns | |
|---|---|
| Type | Description |
ViewDefinition |
|
of(String query, UserDefinedFunction[] functions)
public static ViewDefinition of(String query, UserDefinedFunction[] functions)Creates a BigQuery view definition given a query and some user-defined functions.
| Parameters | |
|---|---|
| Name | Description |
query |
Stringthe query used to generate the table |
functions |
UserDefinedFunction[]user-defined functions that can be used by the query |
| Returns | |
|---|---|
| Type | Description |
ViewDefinition |
|
of(String query, List<UserDefinedFunction> functions)
public static ViewDefinition of(String query, List<UserDefinedFunction> functions)Creates a BigQuery view definition given a query and some user-defined functions.
| Parameters | |
|---|---|
| Name | Description |
query |
Stringthe query used to generate the table |
functions |
List<UserDefinedFunction>user-defined functions that can be used by the query |
| Returns | |
|---|---|
| Type | Description |
ViewDefinition |
|
Constructors
ViewDefinition()
public ViewDefinition()Methods
getQuery()
public abstract String getQuery()Returns the query used to create the view.
| Returns | |
|---|---|
| Type | Description |
String |
|
getUserDefinedFunctions()
public List<UserDefinedFunction> getUserDefinedFunctions()Returns user defined functions that can be used by #getQuery(). Returns null if
not set.
See Also: User-Defined Functions
| Returns | |
|---|---|
| Type | Description |
List<UserDefinedFunction> |
|
toBuilder()
public abstract ViewDefinition.Builder toBuilder()Returns a builder for the ViewInfo object.
| Returns | |
|---|---|
| Type | Description |
ViewDefinition.Builder |
|
useLegacySql()
public Boolean useLegacySql()Returns whether to use BigQuery's legacy SQL dialect for this query. By default this property
is set to false. If set to false, the query will use BigQuery's Standard SQL. If set to
null or true, legacy SQL dialect is used. This property is experimental and might be
subject to change.
| Returns | |
|---|---|
| Type | Description |
Boolean |
|