Why Tablyne for Amazon Redshift

An Amazon Redshift client for provisioned clusters and Serverless, with reviewed writes and a read-only table preview.

Tablyne lets you browse a Redshift warehouse, run SQL, and know what a query will do before it runs. It covers provisioned clusters and Redshift Serverless, on macOS, Windows and Linux.

Two ways to connect

You can connect over a direct TLS connection with the PostgreSQL protocol, or through the Redshift Data API. The direct connection can go through an SSH tunnel. The Data API signs its requests with your AWS credentials and does not need a network path to the cluster. Tablyne also asks the server which kind of deployment it is, and tells you if the saved type is wrong.

Reads are cheap to keep safe

Reads in the console run inside a read-only transaction. Writes and DDL always open a review of the exact SQL first. In the strictest safe mode, statements such as DELETE without WHERE, TRUNCATE, DROP, COPY, UNLOAD and CALL are refused outright.

What Tablyne does not do

Table data opens as a read-only preview of up to 500 rows. There is no cell-by-cell editing of Redshift tables, because Redshift does not enforce keys and uniqueness. Changes go through the console and its review. Redshift also gives no per-query price, so Tablyne says that instead of showing a guess.

Where to go next

  1. Connect to Amazon Redshift with a profile, a secret or a password.
  2. Read safe mode and review for the rules on writes.
  3. Open the Amazon Redshift client page for the short version.