Have you worked on Redshift? For example, an audit table with certain fields.

Amazon Redshift is a columnar, petabyte‑scale data warehouse service. It stores data in compressed, column‑oriented format, which speeds up analytical queries. Key features include distribution styles (KEY, EVEN, ALL) to control how rows are spread across nodes, sort keys to order data for efficient range scans, and vacuum to reclaim space after many deletes or updates. An audit table in Redshift typically contains columns like audit_id (primary key), action_type, user_id, timestamp, and details. Because Redshift is read‑heavy, you should design the table with a suitable distribution key (often the foreign key to the main table) and a sort key on the timestamp for fast time‑range queries. Use COPY for bulk loads, and schedule VACUUM and ANALYZE to keep statistics up to date.