Skip to main content

tenancy_units_project

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

Overview

Nametenancy_units_project
TypeResource
Idgoogle.serviceconsumermanagement.tenancy_units_project

Fields

SELECT not supported for this resource, use SHOW METHODS to view available operations for the resource.

Methods

NameAccessible byRequired ParamsDescription
add_projectINSERTservicesId, servicesId1, servicesId2, tenancyUnitsIdAdd a new tenant project to the tenancy unit. There can be a maximum of 1024 tenant projects in a tenancy unit. If there are previously failed AddTenantProject calls, you might need to call RemoveTenantProject first to resolve them before you can make another call to AddTenantProject with the same tag. Operation.
delete_projectDELETEservicesId, servicesId1, servicesId2, tenancyUnitsIdDeletes the specified project resource identified by a tenant resource tag. The mothod removes a project lien with a 'TenantManager' origin if that was added. It will then attempt to delete the project. If that operation fails, this method also fails. After the project has been deleted, the tenant resource state is set to DELETED. To permanently remove resource metadata, call the RemoveTenantProject method. New resources with the same tag can't be added if there are existing resources in a DELETED state. Operation.
remove_projectDELETEservicesId, servicesId1, servicesId2, tenancyUnitsIdRemoves the specified project resource identified by a tenant resource tag. The method removes the project lien with 'TenantManager' origin if that was added. It then attempts to delete the project. If that operation fails, this method also fails. Calls to remove already removed or non-existent tenant project succeed. After the project has been deleted, or if was already in a DELETED state, resource metadata is permanently removed from the tenancy unit. Operation.

INSERT example

Use the following StackQL query and manifest file to create a new tenancy_units_project resource.

/*+ create */
INSERT INTO google.serviceconsumermanagement.tenancy_units_project (
servicesId,
servicesId1,
servicesId2,
tenancyUnitsId,
projectConfig,
tag
)
SELECT
'{{ servicesId }}',
'{{ servicesId1 }}',
'{{ servicesId2 }}',
'{{ tenancyUnitsId }}',
'{{ projectConfig }}',
'{{ tag }}'
;

DELETE example

Deletes the specified tenancy_units_project resource.

/*+ delete */
DELETE FROM google.serviceconsumermanagement.tenancy_units_project
WHERE servicesId = '{{ servicesId }}'
AND servicesId1 = '{{ servicesId1 }}'
AND servicesId2 = '{{ servicesId2 }}'
AND tenancyUnitsId = '{{ tenancyUnitsId }}';