namespaces

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

Overview

Name	namespaces
Type	Resource
Id	aws.redshift.namespaces

Fields

The following fields are returned by SELECT queries:

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

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
register_namespace	insert	NamespaceIdentifier, ConsumerIdentifiers, region		Registers a cluster or serverless namespace to the Amazon Web Services Glue Data Catalog.
deregister_namespace	delete	NamespaceIdentifier, ConsumerIdentifiers, region		Deregisters a cluster or serverless namespace from the Amazon Web Services Glue Data Catalog.

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.

Name	Datatype	Description
ConsumerIdentifiers	array	An array containing the ID of the consumer account that you want to deregister the cluster or serverless namespace from.
NamespaceIdentifier	object	The unique identifier of the cluster or serverless namespace that you want to deregister.
region	string	AWS region (default: us-east-1)

INSERT examples

register_namespace

Registers a cluster or serverless namespace to the Amazon Web Services Glue Data Catalog.

INSERT INTO aws.redshift.namespaces (
NamespaceIdentifier,
ConsumerIdentifiers,
region
)
SELECT 
'{{ NamespaceIdentifier }}',
'{{ ConsumerIdentifiers }}',
'{{ region }}'
RETURNING
status
;

Manifest

# Description fields are for documentation purposes
- name: namespaces
props:
  - name: NamespaceIdentifier
    value: "{{ NamespaceIdentifier }}"
    description: Required parameter for the namespaces resource.
  - name: ConsumerIdentifiers
    value: "{{ ConsumerIdentifiers }}"
    description: Required parameter for the namespaces resource.
  - name: region
    value: "{{ region }}"
    description: Required parameter for the namespaces resource.

DELETE examples

deregister_namespace

Deregisters a cluster or serverless namespace from the Amazon Web Services Glue Data Catalog.

DELETE FROM aws.redshift.namespaces
WHERE NamespaceIdentifier = '{{ NamespaceIdentifier }}' --required
AND ConsumerIdentifiers = '{{ ConsumerIdentifiers }}' --required
AND region = '{{ region }}' --required
;