kimo
Open demo
Warehouses

Amazon Redshift + Kimo

AWS data warehouse. Query your warehouse live. Kimo pushes the SQL down, so nothing gets copied and nothing goes stale.

Auth
Read-only credentials
Sync
Live query
Setup
≈ 10 min
Request access

Live demo workspace with fictional data · no signup, no credentials needed

kimo / connectors / redshiftSyncing
Sync loglive query
  • Succeeded:fct_orders+1,659 rowsnow
  • Succeeded:fct_sessions+40 rows2m ago
  • Succeeded:dim_customers+97 rows4m ago
  • Succeeded:fct_orders+878 rows6m ago
Rows synced · 30 days
77.5M
Workspaces
23%
Simulated demo data
What you can do

What teams build with Amazon Redshift

Amazon Redshift on its own answers half the question. Joined with the rest of your stack in Kimo, it answers the other half.

01

Reuse your dbt models

Kimo reads your marts as-is. Certify metrics on top of them instead of rebuilding logic.

fct_ · dim_ tables
02

Live queries, cached smartly

Push-down SQL with result caching keeps dashboards fast and warehouse spend predictable.

Cache hit 92%
03

Self-serve for business teams

Anyone can explore certified measures without writing SQL or waiting on the data team.

Certified metrics
Objects & tables

Exactly what gets synced

Kimo maps Amazon Redshift into clean, typed tables with primary keys and incremental cursors, so syncs stay fast and joins just work.

3 tables · 12 fields

fct_orders

Live query≈ 82,900,000 rows
FieldTypeNotes
order_ididPrimary key
customer_ididReferences customer
revenuedecimalMeasure
ordered_attimestampIncremental cursor
Custom fields and extra objects are discovered automatically on each sync. Row counts are illustrative.
Sample model

From raw Amazon Redshift tables to a certified metric

A starter model Kimo suggests the moment Amazon Redshift is connected. Every join is editable.

Amazon Redshift · Revenue by segment

Orders fact table joined with the customer dimension and CRM accounts.

Template
  • Amazon Redshift
    fct_orders
  • HubSpot
    companies
  • Google Sheets
    targets
Model
customer_id
Measuresrevenueorders
Revenue · last 30 days
$61.1K-0.2% wk/wk

Fictional data · hover the chart for daily values

Setup

Connect Amazon Redshift in 10 min

No engineers, no pipelines to maintain. Kimo asks for the minimum access it needs and tells you exactly what it will read.

  1. 1

    Create a dedicated role

    Grant SELECT on the schemas Kimo should see, and a small warehouse for its queries.

  2. 2

    Open network access

    Allow Kimo’s static egress IPs, use an SSH tunnel, or run the on-prem agent inside your network.

  3. 3

    Enter connection details

    Credentials are encrypted at rest with a per-workspace key and tested before saving.

  4. 4

    Pick schemas

    Kimo reads the information schema and suggests models from your marts.

Create a read-only user
CREATE USER kimo_reader PASSWORD '<generated>';
GRANT USAGE ON SCHEMA analytics TO kimo_reader;
GRANT SELECT ON ALL TABLES IN SCHEMA analytics TO kimo_reader;

Read-only, encrypted, revocable. Credentials are encrypted with a per-workspace key, never logged, and can be rotated without breaking your models.

Connect Amazon Redshift
Step 2 of 3 · Kimo demo workspace
  • Reaching host
  • Authenticating
  • Reading schema
Read-only access
Illustration only · placeholder values, never real secrets
FAQ

Amazon Redshift questions, answered

Amazon Redshift is queried live: Kimo compiles each chart to SQL and runs it on your warehouse, with a short result cache you control per dashboard.

Amazon Redshift · Read-only credentials · Live query

See your Amazon Redshift data in Kimo in 10 min.

Try it on the live demo workspace first, then connect your own account when you are ready.

Request access