Skip to main content

List BigQuery Datasets

Lists all datasets in the specified project to which you have been granted the READER dataset role.

External Documentation

To learn more, visit the GCP documentation.

Basic Parameters

ParameterDescription
FilterAn expression for filtering the results of the request by label. Thesyntax is "labels.name:value". Multiple filters can be ANDed together byconnecting with a space. Example: "labels.department:receiving labels.active".See Filtering datasets using labels for details.
Project IDProject ID of the datasets to be listed.
Return All PagesAutomatically fetch all resources, page by page.

Advanced Parameters

ParameterDescription
AllWhether to list all datasets, including hidden ones.
FieldsSelector specifying which fields to include in a partial response.
Max ResultsThe maximum number of results to return.

Example Output

{
"kind": "bigquery#datasetList",
"etag": "JTA2N6OOwOWmTwxyLqQXgA==",
"datasets": [
{
"kind": "bigquery#dataset",
"id": "project:database",
"datasetReference": {
"datasetId": "Test",
"projectId": "project"
},
"location": "us-central1"
}
]
}

Workflow Library Example

List Bigquery Datasets with Gcp and Send Results Via Email

Workflow LibraryPreview this Workflow on desktop