Browse Amazon Redshift data
Browse schemas, tables and column layout in Redshift, read a 500-row preview, and see why the table tab does not edit cells.
The sidebar lists schemas and tables from the Redshift catalog. You can filter the loaded tables and load more when a schema is large. If your user cannot read some catalog details, the sidebar says that physical details are unavailable instead of hiding the gap.
Structure
The Structure view lists each column with its type, its ENCODE setting, whether it is part of the distribution key, and its sort key. A button shows the DDL that Redshift returns for the table. That DDL is shown for reading and copying. Tablyne does not edit table structure on Redshift.
Preview
The Preview view does not read anything when you open the table. You press the button, Tablyne reminds you that the read uses Redshift resources, and then it reads up to 500 rows. The read has a 60-second deadline, and you can cancel it. After a read, a line shows the queue time, execution time, cache use and WLM class for that query when the server provides them.
Why the grid is read-only
The tab is marked read-only, and the reason is shown. Redshift treats primary keys, foreign keys and uniqueness as information only. It does not enforce them, so a safe row-by-row edit has nothing solid to check against. To change data, use the console, where every write is reviewed first.
More objects
A separate list shows external schemas, datashares, materialized views, procedures and functions, cut at 500 items. An ER diagram draws the relationships of a schema, limited to 50 tables, and notes that they are informational.