Amazon Redshift
Database Developer Guide


Use SVV_EXTERNAL_TABLES to view details for external tables. For more information, see CREATE EXTERNAL SCHEMA.

SVV_EXTERNAL_TABLES is visible to all users. Superusers can see all rows; regular users can see only metadata to which they have access.

Table Columns

Column Name Data Type Description
schemaname text The name of the Amazon Redshift external schema for the external table.
tablename text The name of the external table.
location text The location of the table.
input_format text The input format
output_format text The output format.
serialization_lib text The serialization library.
serde_parameters text SerDe parameters.
compressed integer A value that indicates whether the table is compressed; 1 indicates compressed, 0 indicates not compressed.
parameters text Table properties.

On this page: