Select your cookie preferences

We use essential cookies and similar tools that are necessary to provide our site and services. We use performance cookies to collect anonymous statistics, so we can understand how customers use our site and make improvements. Essential cookies cannot be deactivated, but you can choose “Customize” or “Decline” to decline performance cookies.

If you agree, AWS and approved third parties will also use cookies to provide useful site features, remember your preferences, and display relevant content, including relevant advertising. To accept or decline all non-essential cookies, choose “Accept” or “Decline.” To make more detailed choices, choose “Customize.”

Viewing a datashare in Amazon Redshift

Focus mode
Viewing a datashare in Amazon Redshift - Amazon Redshift

You can view datashares from the console or with SQL.

Console

You can view datashares from the Datashares or Clusters tab.

  • Use the Datashares tab to list datashares in your account or from other accounts.

    • To view datashares created in your account, choose In my account, then choose the datashare you want to view.

    • To view datashares that are shared from other accounts, choose From other accounts, then choose the datashare you want to view.

  • Use the Clusters tab to list datashares in your cluster or from other clusters.

    First, connect to a database. Then, choose a datashare either from the Datashares from other clusters or Datashares created in my cluster section to view its details.

SQL

You can list datashares created in the cluster and look into the contents of the datashare.

The following example displays the information of a datashare named salesshare.

DESC DATASHARE salesshare; producer_account | producer_namespace | share_type | share_name | object_type | object_name | include_new -------------------+--------------------------------------+------------+------------+-------------+--------------------------------+------------------- 123456789012 | 13b8833d-17c6-4f16-8fe4-1a018f5ed00d | OUTBOUND | salesshare | table | public.tickit_users_redshift | 123456789012 | 13b8833d-17c6-4f16-8fe4-1a018f5ed00d | OUTBOUND | salesshare | table | public.tickit_venue_redshift | 123456789012 | 13b8833d-17c6-4f16-8fe4-1a018f5ed00d | OUTBOUND | salesshare | table | public.tickit_category_redshift| 123456789012 | 13b8833d-17c6-4f16-8fe4-1a018f5ed00d | OUTBOUND | salesshare | table | public.tickit_date_redshift | 123456789012 | 13b8833d-17c6-4f16-8fe4-1a018f5ed00d | OUTBOUND | salesshare | table | public.tickit_event_redshift | 123456789012 | 13b8833d-17c6-4f16-8fe4-1a018f5ed00d | OUTBOUND | salesshare | table | public.tickit_listing_redshift | 123456789012 | 13b8833d-17c6-4f16-8fe4-1a018f5ed00d | OUTBOUND | salesshare | table | public.tickit_sales_redshift | 123456789012 | 13b8833d-17c6-4f16-8fe4-1a018f5ed00d | OUTBOUND | salesshare | schema | public | t 123456789012 | 13b8833d-17c6-4f16-8fe4-1a018f5ed00d | OUTBOUND | salesshare | view | public.sales_data_summary_view |

The following example displays the outbound datashares in a producer cluster.

SHOW DATASHARES LIKE 'sales%';

The output looks similar to the following.

share_name | share_owner | source_database | consumer_database | share_type | createdate | is_publicaccessible | share_acl | producer_account | producer_namespace -----------+--------------+-----------------+-------------------+------------+---------------------+----------------------+-----------+------------------+--------------------------------------- salesshare | 100 | dev | | OUTBOUND | 2020-12-09 02:27:08 | True | | 123456789012 | 13b8833d-17c6-4f16-8fe4-1a018f5ed00d

For more information, see DESC DATASHARE and SHOW DATASHARES.

You can also use SVV_DATASHARES, SVV_DATASHARE_CONSUMERS, and SVV_DATASHARE_OBJECTS to view the datashares, the objects within the datashare, and the datashare consumers.

You can view datashares from the Datashares or Clusters tab.

  • Use the Datashares tab to list datashares in your account or from other accounts.

    • To view datashares created in your account, choose In my account, then choose the datashare you want to view.

    • To view datashares that are shared from other accounts, choose From other accounts, then choose the datashare you want to view.

  • Use the Clusters tab to list datashares in your cluster or from other clusters.

    First, connect to a database. Then, choose a datashare either from the Datashares from other clusters or Datashares created in my cluster section to view its details.

PrivacySite termsCookie preferences
© 2025, Amazon Web Services, Inc. or its affiliates. All rights reserved.