Try ktx against a real data stack

Postgres + dbt + Metabase + Notion, pre-loaded with the Orbit demo corpus. Read-only credentials are shared after verification so you can connect ktx in seconds.

4 sourcesread-onlypublic~5 MB · 38k rows

postgres database

host

start.kaelio.com

port

5432

database

demo

username

kaelio_demo

password

not-a-real-postgres-password

sslmode

prefer(no TLS termination)

url

postgresql://kaelio_demo:not-a-real-postgres-password@start.kaelio.com:5432/demo?sslmode=disable

jdbc

jdbc:postgresql://start.kaelio.com:5432/demo?user=kaelio_demo&password=not-a-real-postgres-password

Two schemas with 21 raw tables and 35 analytics views, ~38k rows of demo data. Connect directly or register as a ktx source.

shell

# connect with psql
$ psql 'postgresql://kaelio_demo:not-a-real-postgres-password@start.kaelio.com:5432/demo?sslmode=disable'

shell

# or register as a ktx source
$ ktx source add postgres demo \
  --url 'postgresql://kaelio_demo:not-a-real-postgres-password@start.kaelio.com:5432/demo?sslmode=disable'

what's inside · Postgres

orbit_rawschema

21 tables

~5 MB · 38,338 rows

Notable tables

accounts
users
sessions
contracts
subscriptions
purchase_requests
purchase_orders
invoices
invoice_line_items
approval_events

orbit_analyticsschema

35 views

Notable views

int_customer_health_signals
int_active_contract_arr
int_parent_account_arr_movements
int_procurement_qualifying_actions
int_activation_policy_windows