DESC DATASHARE - Amazon Redshift

DESC DATASHARE

Displays a list of the database objects within a datashare that are added to it using ALTER DATASHARE. Amazon Redshift displays the names, databases, schemas, and types of tables, views, and functions.

Syntax

DESC DATASHARE datashare_name [ OF NAMESPACE namespace_guid ]

Parameters

datashare_name

The name of the datashare .

NAMESPACE namespace_guid

A value that specifies the namespace that the datashare uses. When you run DESC DATAHSARE as a consumer cluster administrator, specify the NAMESPACE parameter to view inbound datashares.

Examples

The following example displays the information for outbound datashares on a producer cluster.

DESC DATASHARE SalesShare; producer_account | producer_namespace | share_type | share_name | object_type | object_name -----------------+---------------------------------------+-------------+--------------+-------------+--------------------------------------------------- 123456789012 | 13b8833d-17c6-4f16-8fe4-1a018f5ed00d | OUTBOUND | SalesShare | TABLE | public.tickit_sales_redshift 123456789012 | 13b8833d-17c6-4f16-8fe4-1a018f5ed00d | OUTBOUND | SalesShare | SCHEMA | public

The following example displays the information for inbound datashares on a consumer cluster.

DESC DATASHARE SalesShare of namespace '13b8833d-17c6-4f16-8fe4-1a018f5ed00d'; producer_account | producer_namespace | share_type | share_name | object_type | object_name ------------------+--------------------------------------+------------+------------+-------------+------------------------------ 123456789012 | 13b8833d-17c6-4f16-8fe4-1a018f5ed00d | INBOUND | salesshare | table | public.tickit_sales_redshift 123456789012 | 13b8833d-17c6-4f16-8fe4-1a018f5ed00d | INBOUND | salesshare | schema | public (2 rows)