customers

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

Overview

Name	customers
Type	Resource
Id	google.sasportal.customers

Fields

Name	Datatype	Description
name	string	Output only. Resource name of the customer.
displayName	string	Required. Name of the organization that the customer entity represents.
sasUserIds	array	User IDs used by the devices belonging to this customer.

Methods

Name	Accessible by	Required Params	Description
customers_get	SELECT	customersId	Returns a requested customer.
customers_list	SELECT		Returns a list of requested customers.
customers_patch	UPDATE	customersId	Updates an existing customer.
customers_migrate_organization	EXEC		Migrates 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_provision_deployment	EXEC		Creates a new SAS deployment through the GCP workflow. Creates a SAS organization if an organization match is not found.
customers_setup_sas_analytics	EXEC		Setups 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.

SELECT examples

Returns a list of requested customers.

SELECT
name,
displayName,
sasUserIds
FROM google.sasportal.customers
;

UPDATE example

Updates a customers resource.

/*+ update */
UPDATE google.sasportal.customers
SET 
sasUserIds = '{{ sasUserIds }}',
name = '{{ name }}',
displayName = '{{ displayName }}'
WHERE 
customersId = '{{ customersId }}';