Skip to main content

listings_subscriptions

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

Overview

Namelistings_subscriptions
TypeResource
Idgoogle.analyticshub.listings_subscriptions

Fields

The following fields are returned by SELECT queries:

Successful response

NameDatatypeDescription
namestringOutput only. The resource name of the subscription. e.g. projects/myproject/locations/us/subscriptions/123.
commercialInfoobjectOutput only. This is set if this is a commercial subscription i.e. if this subscription was created from subscribing to a commercial listing. (id: GoogleCloudBigqueryAnalyticshubV1SubscriptionCommercialInfo)
creationTimestring (google-datetime)Output only. Timestamp when the subscription was created.
dataExchangestringOutput only. Resource name of the source Data Exchange. e.g. projects/123/locations/us/dataExchanges/456
destinationDatasetobjectOptional. BigQuery destination dataset to create for the subscriber. (id: DestinationDataset)
lastModifyTimestring (google-datetime)Output only. Timestamp when the subscription was last modified.
linkedDatasetMapobjectOutput only. Map of listing resource names to associated linked resource, e.g. projects/123/locations/us/dataExchanges/456/listings/789 -> projects/123/datasets/my_dataset For listing-level subscriptions, this is a map of size 1. Only contains values if state == STATE_ACTIVE.
linkedResourcesarrayOutput only. Linked resources created in the subscription. Only contains values if state = STATE_ACTIVE.
listingstringOutput only. Resource name of the source Listing. e.g. projects/123/locations/us/dataExchanges/456/listings/789
logLinkedDatasetQueryUserEmailbooleanOutput only. By default, false. If true, the Subscriber agreed to the email sharing mandate that is enabled for DataExchange/Listing.
organizationDisplayNamestringOutput only. Display name of the project of this subscription.
organizationIdstringOutput only. Organization of the project this subscription belongs to.
resourceTypestringOutput only. Listing shared asset type.
statestringOutput only. Current state of the subscription.
subscriberContactstringOutput only. Email of the subscriber.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
projects_locations_data_exchanges_listings_list_subscriptionsselectprojectsId, locationsId, dataExchangesId, listingsIdincludeDeletedSubscriptions, pageSize, pageTokenLists all subscriptions on a given Data Exchange or Listing.

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
dataExchangesIdstring
listingsIdstring
locationsIdstring
projectsIdstring
includeDeletedSubscriptionsboolean
pageSizeinteger (int32)
pageTokenstring

SELECT examples

Lists all subscriptions on a given Data Exchange or Listing.

SELECT
name,
commercialInfo,
creationTime,
dataExchange,
destinationDataset,
lastModifyTime,
linkedDatasetMap,
linkedResources,
listing,
logLinkedDatasetQueryUserEmail,
organizationDisplayName,
organizationId,
resourceType,
state,
subscriberContact
FROM google.analyticshub.listings_subscriptions
WHERE projectsId = '{{ projectsId }}' -- required
AND locationsId = '{{ locationsId }}' -- required
AND dataExchangesId = '{{ dataExchangesId }}' -- required
AND listingsId = '{{ listingsId }}' -- required
AND includeDeletedSubscriptions = '{{ includeDeletedSubscriptions }}'
AND pageSize = '{{ pageSize }}'
AND pageToken = '{{ pageToken }}';