Skip to main content

customers

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

Overview

Namecustomers
TypeResource
Idgoogle.prod_tt_sasportal.customers

Fields

The following fields are returned by SELECT queries:

Successful response

NameDatatypeDescription
namestringOutput only. Resource name of the customer.
displayNamestringRequired. Name of the organization that the customer entity represents.
sasUserIdsarrayUser IDs used by the devices belonging to this customer.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
customers_getselectcustomersIdReturns a requested customer.
customers_listselectpageSize, pageTokenReturns a list of requested customers.
customers_patchupdatecustomersIdupdateMaskUpdates an existing customer.
customers_provision_deploymentexecCreates a new SAS deployment through the GCP workflow. Creates a SAS organization if an organization match is not found.
customers_migrate_organizationexecMigrates a SAS organization to the cloud. This will create GCP projects for each deployment and associate them. The SAS Organization is linked to the gcp project that called the command. go/sas-legacy-customer-migration
customers_setup_sas_analyticsexecSetups the a GCP Project to receive SAS Analytics messages via GCP Pub/Sub with a subscription to BigQuery. All the Pub/Sub topics and BigQuery tables are created automatically as part of this service.

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
customersIdstring
pageSizeinteger (int32)
pageTokenstring
updateMaskstring (google-fieldmask)

SELECT examples

Returns a requested customer.

SELECT
name,
displayName,
sasUserIds
FROM google.prod_tt_sasportal.customers
WHERE customersId = '{{ customersId }}' -- required;

UPDATE examples

Updates an existing customer.

UPDATE google.prod_tt_sasportal.customers
SET
data__name = '{{ name }}',
data__displayName = '{{ displayName }}',
data__sasUserIds = '{{ sasUserIds }}'
WHERE
customersId = '{{ customersId }}' --required
AND updateMask = '{{ updateMask}}'
RETURNING
name,
displayName,
sasUserIds;

Lifecycle Methods

Creates a new SAS deployment through the GCP workflow. Creates a SAS organization if an organization match is not found.

EXEC google.prod_tt_sasportal.customers.customers_provision_deployment 
@@json=
'{
"newOrganizationDisplayName": "{{ newOrganizationDisplayName }}",
"newDeploymentDisplayName": "{{ newDeploymentDisplayName }}",
"organizationId": "{{ organizationId }}"
}';