subscriptions

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

Overview

Name	subscriptions
Type	Resource
Id	google.analyticshub.subscriptions

Fields

Name	Datatype	Description
name	string	Output only. The resource name of the subscription. e.g. projects/myproject/locations/US/subscriptions/123.
creationTime	string	Output only. Timestamp when the subscription was created.
dataExchange	string	Output only. Resource name of the source Data Exchange. e.g. projects/123/locations/US/dataExchanges/456
lastModifyTime	string	Output only. Timestamp when the subscription was last modified.
linkedDatasetMap	object	Output 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.
linkedResources	array	Output only. Linked resources created in the subscription. Only contains values if state = STATE_ACTIVE.
listing	string	Output only. Resource name of the source Listing. e.g. projects/123/locations/US/dataExchanges/456/listings/789
organizationDisplayName	string	Output only. Display name of the project of this subscription.
organizationId	string	Output only. Organization of the project this subscription belongs to.
resourceType	string	Output only. Listing shared asset type.
state	string	Output only. Current state of the subscription.
subscriberContact	string	Output only. Email of the subscriber.

Methods

Name	Accessible by	Required Params	Description
projects_locations_subscriptions_get	SELECT	locationsId, projectsId, subscriptionsId	Gets the details of a Subscription.
projects_locations_subscriptions_list	SELECT	locationsId, projectsId	Lists all subscriptions in a given project and location.
projects_locations_subscriptions_delete	DELETE	locationsId, projectsId, subscriptionsId	Deletes a subscription.
projects_locations_subscriptions_refresh	EXEC	locationsId, projectsId, subscriptionsId	Refreshes a Subscription to a Data Exchange. A Data Exchange can become stale when a publisher adds or removes data. This is a long-running operation as it may create many linked datasets.
projects_locations_subscriptions_revoke	EXEC	locationsId, projectsId, subscriptionsId	Revokes a given subscription.

SELECT examples

Lists all subscriptions in a given project and location.

SELECT
name,
creationTime,
dataExchange,
lastModifyTime,
linkedDatasetMap,
linkedResources,
listing,
organizationDisplayName,
organizationId,
resourceType,
state,
subscriberContact
FROM google.analyticshub.subscriptions
WHERE locationsId = '{{ locationsId }}'
AND projectsId = '{{ projectsId }}';

DELETE example

Deletes the specified subscriptions resource.

/*+ delete */
DELETE FROM google.analyticshub.subscriptions
WHERE locationsId = '{{ locationsId }}'
AND projectsId = '{{ projectsId }}'
AND subscriptionsId = '{{ subscriptionsId }}';