Reference documentation and code samples for the BigQuery Client class Dataset.
Datasets allow you to organize and control access to your tables.
Namespace
Google \ Cloud \ BigQueryMethods
__construct
| Parameters | |
|---|---|
| Name | Description | 
| connection | Google\Cloud\BigQuery\Connection\ConnectionInterfaceRepresents a connection to BigQuery. | 
| id | stringThe dataset's ID. | 
| projectId | stringThe project's ID. | 
| mapper | Google\Cloud\BigQuery\ValueMapper | 
| info | array[optional] The dataset's metadata. | 
| location | string|null[optional] A default geographic location, used when no dataset metadata exists. | 
exists
Check whether or not the dataset exists.
Example:
echo $dataset->exists(); | Returns | |
|---|---|
| Type | Description | 
| bool | |
delete
Delete the dataset.
Please note that by default the library will not attempt to retry this call on your behalf.
Example:
$dataset->delete(); | Parameters | |
|---|---|
| Name | Description | 
| options | arrayConfiguration options. | 
| ↳ deleteContents | boolIf true, delete all the tables in the dataset. If false and the dataset contains tables, the request will fail. Defaults to  | 
update
Update the dataset.
Providing an etag key as part of $metadata will enable simultaneous update protection. This is useful in preventing override of modifications made by another user. The resource's current etag can be obtained via a GET request on the resource.
Please note that by default this call will not automatically retry on your behalf unless an etag is set.
Example:
$dataset->update([ 'friendlyName' => 'A fanciful dataset.' ]); | Parameters | |
|---|---|
| Name | Description | 
| metadata | arrayThe available options for metadata are outlined at the Dataset Resource API docs | 
| options | array[optional] Configuration options. | 
table
Lazily instantiates a table. There are no network requests made at this point. To see the operations that can be performed on a dataset please see Table.
Example:
$table = $dataset->table('myTableId'); | Parameter | |
|---|---|
| Name | Description | 
| id | stringThe id of the table to request. | 
| Returns | |
|---|---|
| Type | Description | 
| Google\Cloud\BigQuery\Table | |
tables
Fetches tables in the dataset.
Example:
$tables = $dataset->tables(); foreach ($tables as $table) { echo $table->id() . PHP_EOL; } | Parameters | |
|---|---|
| Name | Description | 
| options | arrayConfiguration options. | 
| ↳ maxResults | intMaximum number of results to return per page. | 
| ↳ resultLimit | intLimit the number of results returned in total. Defaults to  | 
| ↳ pageToken | stringA previously-returned page token used to resume the loading of results from a specific point. | 
| Returns | |
|---|---|
| Type | Description | 
| Google\Cloud\Core\Iterator\ItemIterator<\google\cloud\bigquery\table> | |
createTable
Creates a table.
Please note that by default the library will not attempt to retry this call on your behalf.
Example:
$table = $dataset->createTable('aTable'); | Parameters | |
|---|---|
| Name | Description | 
| id | mixed | 
| options | arrayConfiguration options. | 
| ↳ metadata | arrayThe available options for metadata are outlined at the Table Resource API docs | 
| Returns | |
|---|---|
| Type | Description | 
| Google\Cloud\BigQuery\Table | |
model
Lazily instantiates a machine learning model in the dataset. There are no network requests made at this point. To see the operations that can be performed on a model, please see Model.
Example:
$model = $dataset->model('my_model'); echo $model->id(); | Parameters | |
|---|---|
| Name | Description | 
| id | stringThe model's ID. | 
| info | array[optional] The model resource data. | 
| Returns | |
|---|---|
| Type | Description | 
| Google\Cloud\BigQuery\Model | |
models
Fetches all of the models in the dataset.
Please note that Model instances obtained from this method contain only a subset of the resource representation. Fields returned include modelReference, modelType, creationTime, lastModifiedTime and labels. To obtain a full representation, call Google\Cloud\BigQuery\Model::reload().
Example:
$models = $dataset->models(); foreach ($models as $model) { echo $model->id() . PHP_EOL; } | Parameters | |
|---|---|
| Name | Description | 
| options | arrayConfiguration options. | 
| ↳ maxResults | intMaximum number of results to return per page. | 
| ↳ resultLimit | intLimit the number of results returned in total. Defaults to  | 
| ↳ pageToken | stringA previously-returned page token used to resume the loading of results from a specific point. | 
| Returns | |
|---|---|
| Type | Description | 
| Google\Cloud\Core\Iterator\ItemIterator<\google\cloud\bigquery\model> | |
routine
Lazily instantiates a routine.
There are no network requests made at this point. To see the operations that can be performed on a routine, please see Google\Cloud\BigQuery\Routine.
Example:
$routine = $dataset->routine('my_routine'); echo $routine->identity()['routineId']; | Parameters | |
|---|---|
| Name | Description | 
| id | stringThe routine's ID. | 
| info | array[optional] The routine resource data. | 
| Returns | |
|---|---|
| Type | Description | 
| Google\Cloud\BigQuery\Routine | |
routines
Fetches all of the routines in the dataset.
Please note that Routine instances obtained from this method contain only a subset of the resource representation. Fields returned include etag, projectId, datasetId, routineId, routineType, creationTime, lastModifiedTime and language. To obtain a full representation, call Google\Cloud\BigQuery\Routine::reload().
Example:
$routines = $dataset->routines(); foreach ($routines as $routine) { echo $routine->identity()['routineId'] . PHP_EOL; } | Parameters | |
|---|---|
| Name | Description | 
| options | arrayConfiguration options. | 
| ↳ maxResults | intMaximum number of results to return per page. | 
| ↳ resultLimit | intLimit the number of results returned in total. Defaults to  | 
| ↳ pageToken | stringA previously-returned page token used to resume the loading of results from a specific point. | 
| Returns | |
|---|---|
| Type | Description | 
| Google\Cloud\Core\Iterator\ItemIterator<\google\cloud\bigquery\model> | |
createRoutine
Creates a routine.
Please note that by default the library will not attempt to retry this call on your behalf.
Example:
$routine = $dataset->createRoutine('my_routine', [ 'routineType' => 'SCALAR_FUNCTION', 'definitionBody' => 'concat(x, "\n", y)', 'arguments' => [ [ 'name' => 'x', 'dataType' => [ 'typeKind' => 'STRING' ] ], [ 'name' => 'y', 'dataType' => [ 'typeKind' => 'STRING' ] ] ] ]); | Parameters | |
|---|---|
| Name | Description | 
| id | stringThe routine ID. | 
| metadata | arrayThe available options for metadata are outlined at the Routine Resource API docs. Omit  | 
| options | array[optional] Configuration options. | 
| Returns | |
|---|---|
| Type | Description | 
| Google\Cloud\BigQuery\Routine | |
info
Retrieves the dataset's details. If no dataset data is cached a network request will be made to retrieve it.
Example:
$info = $dataset->info(); echo $info['selfLink']; | Parameter | |
|---|---|
| Name | Description | 
| options | array[optional] Configuration options. | 
| Returns | |
|---|---|
| Type | Description | 
| array | |
reload
Triggers a network request to reload the dataset's details.
Example:
$dataset->reload(); $info = $dataset->info(); echo $info['selfLink']; | Parameter | |
|---|---|
| Name | Description | 
| options | array[optional] Configuration options. | 
| Returns | |
|---|---|
| Type | Description | 
| array | |
id
Retrieves the dataset's ID.
Example:
echo $dataset->id(); | Returns | |
|---|---|
| Type | Description | 
| string | |
identity
Retrieves the dataset's identity.
An identity provides a description of a resource that is nested in nature.
Example:
echo $dataset->identity()['projectId']; | Returns | |
|---|---|
| Type | Description | 
| array | |