datastores

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

Overview

Name	datastores
Type	Resource
Id	google.apigee.datastores

Fields

Name	Datatype	Description
createTime	string	Output only. Datastore create time, in milliseconds since the epoch of 1970-01-01T00:00:00Z
datastoreConfig	object	Configuration detail for datastore
displayName	string	Required. Display name in UI
lastUpdateTime	string	Output only. Datastore last update time, in milliseconds since the epoch of 1970-01-01T00:00:00Z
org	string	Output only. Organization that the datastore belongs to
self	string	Output only. Resource link of Datastore. Example: /organizations/{org}/analytics/datastores/{uuid}
targetType	string	Destination storage type. Supported types gcs or bigquery.

Methods

Name	Accessible by	Required Params	Description
organizations_analytics_datastores_get	SELECT	datastoresId, organizationsId	Get a Datastore
organizations_analytics_datastores_list	SELECT	organizationsId	List Datastores
organizations_analytics_datastores_create	INSERT	organizationsId	Create a Datastore for an org
organizations_analytics_datastores_delete	DELETE	datastoresId, organizationsId	Delete a Datastore from an org.
organizations_analytics_datastores_update	REPLACE	datastoresId, organizationsId	Update a Datastore
organizations_analytics_datastores_test	EXEC	organizationsId	Test if Datastore configuration is correct. This includes checking if credentials provided by customer have required permissions in target destination storage

SELECT examples

List Datastores

SELECT
createTime,
datastoreConfig,
displayName,
lastUpdateTime,
org,
self,
targetType
FROM google.apigee.datastores
WHERE organizationsId = '{{ organizationsId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO google.apigee.datastores (
organizationsId,
datastoreConfig,
displayName,
targetType
)
SELECT 
'{{ organizationsId }}',
'{{ datastoreConfig }}',
'{{ displayName }}',
'{{ targetType }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: datastoreConfig
      value:
        - name: path
          value: string
        - name: projectId
          value: string
        - name: bucketName
          value: string
        - name: datasetName
          value: string
        - name: tablePrefix
          value: string
    - name: displayName
      value: string
    - name: org
      value: string
    - name: lastUpdateTime
      value: string
    - name: self
      value: string
    - name: createTime
      value: string
    - name: targetType
      value: string

REPLACE example

Replaces all fields in the specified datastores resource.

/*+ update */
REPLACE google.apigee.datastores
SET 
datastoreConfig = '{{ datastoreConfig }}',
displayName = '{{ displayName }}',
targetType = '{{ targetType }}'
WHERE 
datastoresId = '{{ datastoresId }}'
AND organizationsId = '{{ organizationsId }}';

DELETE example

Deletes the specified datastores resource.

/*+ delete */
DELETE FROM google.apigee.datastores
WHERE datastoresId = '{{ datastoresId }}'
AND organizationsId = '{{ organizationsId }}';