# Class ViewDefinition (2.65.0)

2.65.0 (latest) 2.62.0 2.61.0 2.60.0 2.59.0 2.58.0 2.57.2 2.56.0 2.55.3 2.54.2 2.53.0 2.52.0 2.51.0 2.50.1 2.49.0 2.48.1 2.47.0 2.46.0 2.45.0 2.44.0 2.43.3 2.42.3 2.41.0 2.40.3 2.39.1 2.38.2 2.37.2 2.36.0 2.35.0 2.34.2 2.33.2

    public abstract class ViewDefinition extends TableDefinition

Google 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](https://cloud.google.com/bigquery/querying-data#views)

## Inheritance

[java.lang.Object](https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html) \> [TableDefinition](https://docs.cloud.google.com/java/docs/reference/google-cloud-bigquery/latest/com.google.cloud.bigquery.TableDefinition) \> ViewDefinition

## Inherited Members

[TableDefinition.getSchema()](https://docs.cloud.google.com/java/docs/reference/google-cloud-bigquery/latest/com.google.cloud.bigquery.TableDefinition#com_google_cloud_bigquery_TableDefinition_getSchema__) [TableDefinition.getType()](https://docs.cloud.google.com/java/docs/reference/google-cloud-bigquery/latest/com.google.cloud.bigquery.TableDefinition#com_google_cloud_bigquery_TableDefinition_getType__) [TableDefinition.toBuilder()](https://docs.cloud.google.com/java/docs/reference/google-cloud-bigquery/latest/com.google.cloud.bigquery.TableDefinition#com_google_cloud_bigquery_TableDefinition_toBuilder__) [Object.clone()](https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html#clone--) [Object.equals(Object)](https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html#equals-java.lang.Object-) [Object.finalize()](https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html#finalize--) [Object.getClass()](https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html#getClass--) [Object.hashCode()](https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html#hashCode--) [Object.notify()](https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html#notify--) [Object.notifyAll()](https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html#notifyAll--) [Object.toString()](https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html#toString--) [Object.wait()](https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html#wait--) [Object.wait(long)](https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html#wait-long-) [Object.wait(long,int)](https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html#wait-long-int-)

## Static Methods

### newBuilder(String query)

    public static ViewDefinition.Builder newBuilder(String query)

Returns a builder for a BigQuery view definition.

| **Parameter** ||
|---|---|
| **Name** | **Description** |
| `query` | `https://docs.oracle.com/javase/8/docs/api/java/lang/String.html` the query used to generate the view |

| **Returns** ||
|---|---|
| **Type** | **Description** |
| `https://docs.cloud.google.com/java/docs/reference/google-cloud-bigquery/latest/com.google.cloud.bigquery.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` | `https://docs.oracle.com/javase/8/docs/api/java/lang/String.html` the query used to generate the table |
| `functions` | `https://docs.cloud.google.com/java/docs/reference/google-cloud-bigquery/latest/com.google.cloud.bigquery.UserDefinedFunction[]` user-defined functions that can be used by the query |

| **Returns** ||
|---|---|
| **Type** | **Description** |
| `https://docs.cloud.google.com/java/docs/reference/google-cloud-bigquery/latest/com.google.cloud.bigquery.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` | `https://docs.oracle.com/javase/8/docs/api/java/lang/String.html` the query used to generate the table |
| `functions` | `https://docs.oracle.com/javase/8/docs/api/java/util/List.html<https://docs.cloud.google.com/java/docs/reference/google-cloud-bigquery/latest/com.google.cloud.bigquery.UserDefinedFunction>` user-defined functions that can be used by the query |

| **Returns** ||
|---|---|
| **Type** | **Description** |
| `https://docs.cloud.google.com/java/docs/reference/google-cloud-bigquery/latest/com.google.cloud.bigquery.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` | `https://docs.oracle.com/javase/8/docs/api/java/lang/String.html` the query used to generate the table |

| **Returns** ||
|---|---|
| **Type** | **Description** |
| `https://docs.cloud.google.com/java/docs/reference/google-cloud-bigquery/latest/com.google.cloud.bigquery.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` | `https://docs.oracle.com/javase/8/docs/api/java/lang/String.html` the query used to generate the table |
| `functions` | `https://docs.cloud.google.com/java/docs/reference/google-cloud-bigquery/latest/com.google.cloud.bigquery.UserDefinedFunction[]` user-defined functions that can be used by the query |

| **Returns** ||
|---|---|
| **Type** | **Description** |
| `https://docs.cloud.google.com/java/docs/reference/google-cloud-bigquery/latest/com.google.cloud.bigquery.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` | `https://docs.oracle.com/javase/8/docs/api/java/lang/String.html` the query used to generate the table |
| `functions` | `https://docs.oracle.com/javase/8/docs/api/java/util/List.html<https://docs.cloud.google.com/java/docs/reference/google-cloud-bigquery/latest/com.google.cloud.bigquery.UserDefinedFunction>` user-defined functions that can be used by the query |

| **Returns** ||
|---|---|
| **Type** | **Description** |
| `https://docs.cloud.google.com/java/docs/reference/google-cloud-bigquery/latest/com.google.cloud.bigquery.ViewDefinition` |   |

## Constructors

### ViewDefinition()

    public ViewDefinition()

## Methods

### getQuery()

    public abstract String getQuery()

Returns the query used to create the view.

| **Returns** ||
|---|---|
| **Type** | **Description** |
| `https://docs.oracle.com/javase/8/docs/api/java/lang/String.html` |   |

### getUserDefinedFunctions()

    public List<UserDefinedFunction> getUserDefinedFunctions()

Returns user defined functions that can be used by [#getQuery()](https://docs.cloud.google.com/java/docs/reference/google-cloud-bigquery/latest/com.google.cloud.bigquery.ViewDefinition#com_google_cloud_bigquery_ViewDefinition_getQuery__). Returns `null` if
not set.
See Also: [User-Defined Functions](https://cloud.google.com/bigquery/user-defined-functions)

| **Returns** ||
|---|---|
| **Type** | **Description** |
| `https://docs.oracle.com/javase/8/docs/api/java/util/List.html<https://docs.cloud.google.com/java/docs/reference/google-cloud-bigquery/latest/com.google.cloud.bigquery.UserDefinedFunction>` |   |

### toBuilder()

    public abstract ViewDefinition.Builder toBuilder()

Returns a builder for the `ViewInfo` object.

| **Returns** ||
|---|---|
| **Type** | **Description** |
| `https://docs.cloud.google.com/java/docs/reference/google-cloud-bigquery/latest/com.google.cloud.bigquery.ViewDefinition.Builder` |   |

**Overrides** [TableDefinition.toBuilder()](https://docs.cloud.google.com/java/docs/reference/google-cloud-bigquery/latest/com.google.cloud.bigquery.TableDefinition#com_google_cloud_bigquery_TableDefinition_toBuilder__)

### 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](https://cloud.google.com/bigquery/sql-reference/). If set to `
null` or `true`, legacy SQL dialect is used. This property is experimental and might be
subject to change.

| **Returns** ||
|---|---|
| **Type** | **Description** |
| `https://docs.oracle.com/javase/8/docs/api/java/lang/Boolean.html` |   |