Skip to main content

locations

Creates, updates, deletes, gets or lists a locations resource.

Overview​

Namelocations
TypeResource
Idgoogle.bigquerydatatransfer.locations

Fields​

The following fields are returned by SELECT queries:

NameDatatypeDescription
namestringResource name for the location, which may vary between implementations. For example: "projects/example-project/locations/us-east1"
displayNamestringThe friendly name for this location, typically a nearby city name. For example, "Tokyo".
labelsobjectCross-service attributes for the location. For example {"cloud.googleapis.com/region": "us-east1"}
locationIdstringThe canonical id for this location. For example: "us-east1".
metadataobjectService-specific metadata. For example the available capacity at the given location.

Methods​

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
projects_locations_getselectprojectsId, locationsIdGets information about a location.
projects_locations_listselectprojectsIdextraLocationTypes, filter, pageSize, pageTokenLists information about the supported locations for this service. This method lists locations based on the resource scope provided in the ListLocationsRequest.name field: * Global locations: If name is empty, the method lists the public locations available to all projects. * Project-specific locations: If name follows the format projects/{project}, the method lists locations visible to that specific project. This includes public, private, or other project-specific locations enabled for the project. For gRPC and client library implementations, the resource name is passed as the name field. For direct service calls, the resource name is incorporated into the request path based on the specific service implementation and version.
projects_locations_enroll_data_sourcesexecprojectsId, locationsIdEnroll data sources in a user project. This allows users to create transfer configurations for these data sources. They will also appear in the ListDataSources RPC and as such, will appear in the BigQuery UI, and the documents can be found in the public guide for BigQuery Web UI and Data Transfer Service.
projects_locations_unenroll_data_sourcesexecprojectsId, locationsIdUnenroll data sources in a user project. This allows users to remove transfer configurations for these data sources. They will no longer appear in the ListDataSources RPC and will also no longer appear in the BigQuery UI. Data transfers configurations of unenrolled data sources will not be scheduled.

Parameters​

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
locationsIdstring
projectsIdstring
extraLocationTypesstring
filterstring
pageSizeinteger (int32)
pageTokenstring

SELECT examples​

Gets information about a location.

SELECT
name,
displayName,
labels,
locationId,
metadata
FROM google.bigquerydatatransfer.locations
WHERE projectsId = '{{ projectsId }}' -- required
AND locationsId = '{{ locationsId }}' -- required
;

Lifecycle Methods​

Enroll data sources in a user project. This allows users to create transfer configurations for these data sources. They will also appear in the ListDataSources RPC and as such, will appear in the BigQuery UI, and the documents can be found in the public guide for BigQuery Web UI and Data Transfer Service.

EXEC google.bigquerydatatransfer.locations.projects_locations_enroll_data_sources
@projectsId='{{ projectsId }}' --required,
@locationsId='{{ locationsId }}' --required
@@json=
'{
"dataSourceIds": "{{ dataSourceIds }}"
}'
;