SVV_EXTERNAL_PARTITIONS
Use SVV_EXTERNAL_PARTITIONS to view details for partitions in external tables.
SVV_EXTERNAL_PARTITIONS is visible to all users. Superusers can see all rows; regular users can see only metadata to which they have access. For more information, see CREATE EXTERNAL SCHEMA.
Table columns
| Column name | Data type | Description |
|---|---|---|
| schemaname | text | The name of the Amazon Redshift external schema for the external table with the specified partitions. |
| tablename | text | The name of the external table. |
| values | text | Values for the partition. |
| location | text | The location of the partition. The column size is limited to 128 characters. Longer values are truncated. |
| 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 partition is
compressed; 1 indicates compressed,
0 indicates not compressed. |
| parameters | text | Partition properties. |
