static mockups · no backend required

Product UI mockups

Every view from the app, rendered statically with dummy data — the same scenario as the blog post (1M customers × 10M orders, the region join). These are fixed mockups: nothing here is clickable, but everything you see is what the real UI shows against a live warehouse.

01 · Worksheet

run SQL → grid results, with the query lifecycle visible (submitted → running → done)
localhost:5173/#/worksheets
⌘Worksheets
⚡Warehouses
◷Query History
▦Data Explorer
◈Cost Center
Worksheetsconnected · demo
-- 10M orders × 1M customers, grouped by region SELECT c.region, count(*) AS cnt FROM orders o JOIN customers c ON o.customer_id = c.customer_id GROUP BY c.region ORDER BY cnt DESC
submitted→ running · 2.9s→ profile→ done
query 59ccd824ad04e34f2.9 s21 nodes · 17 with column treatments5 rows
regioncnt
central2,000,000
west2,000,000
north2,000,000
south2,000,000
east2,000,000

02 · Query profile

result-at-top DAG — the join fans out side-by-side, codegen clusters are slim chips
localhost:5173/#/history/59ccd824ad04e34f
⌘Worksheets
⚡Warehouses
◷Query History
▦Data Explorer
◈Cost Center
Query Profile · 59ccd824ad04e34fconnected
AdaptiveSparkPlan
WholeStageCodegen (4) 20 ms
Sort 0.2% · 20 ms
5 rows
Exchange 1.2% · 156 ms
×7 tasks
WholeStageCodegen (2) 5.40 s ×8
HashAggregate 37.8% · 4.80 s
40 rows · ×8 · ~589 ms/task
Project
Output [2] · Input [3]
BroadcastHashJoin INNER
customers.customer_id = orders.customer_id
10M rows
Filter WHERE
isnotnull(customer_id)
Scan parquet 2.8% · 361 ms
customers /tmp/spark-data/customers
1M rows · ×9
BroadcastExchange 1.4% · 178 ms
1M rows
WholeStageCodegen (1) 1.40 s ×8
Filter WHERE
isnotnull(customer_id)
Scan parquet 2.9% · 368 ms
orders /tmp/spark-data/orders
10M rows · ×8
join fans its two inputs out side-by-side — data flows up
HashAggregate#2 / 21
Output [2]
[region, cnt]
Keys
[region]
Functions
[partial_count(1), count(1)]
~589 ms per task ×8 tasks
duration 4.80 s · 37.8% of query
ranked #2 of 21 nodes

03 · Warehouse manager

t-shirt sizing → ECS Fargate; lifecycle: created → starting → running → idle → suspended → resuming
localhost:5173/#/warehouses
⌘Worksheets
⚡Warehouses
◷Query History
▦Data Explorer
◈Cost Center
Warehouses2 running · 1 suspended
create→ starting→ running→ idle · 5m→ suspended→ resuming
namesizedriverexecutorsstatusactions
analyticsL4 vCPU / 8 GB4 · spot ● running suspendresizedelete
demoS2 vCPU / 4 GB2 · spot ● running suspendresizedelete
etl-nightlyXS2 vCPU / 4 GB1 · spot ○ suspended resumeresizedelete
ad-hocM4 vCPU / 8 GB4 · spot ◌ starting resizedelete

04 · Data explorer

catalog browser — schemas, tables, columns, sample rows
localhost:5173/#/explorer
⌘Worksheets
⚡Warehouses
◷Query History
▦Data Explorer
Data Explorerconnected
Catalog
▾ spark_catalog
Schema · default
▾ customers
customer_id int
name string
region string
tier int
▾ orders
id long
customer_id int
product_id int
amount decimal(10,2)
order_date string
ordersparquet · 10,000,000 rows · /tmp/spark-data/orders
idcustomer_idproduct_idamountorder_date
0000.002024-01-01
1111.002024-01-02
2222.002024-01-03
3333.002024-01-04
……………
9,999,999999,9994,9999,999,999.002024-12-31

05 · Query history

every run has a reload-safe URL — click a row to open its profile
localhost:5173/#/history
⌘Worksheets
⚡Warehouses
◷Query History
▦Data Explorer
◈Cost Center
Query Historyring buffer · 500 entries
timequery idsqlwarehousedurationrowsstatus
22:41:0259ccd824ad04e34fSELECT c.region, count(*) AS cnt FROM orders o JOIN…demo2.9 s5success · profile
22:38:47faae3bb101fa8e1eSELECT c.region, count(*) AS cnt FROM orders o JOIN…demo1.5 s5success · profile
22:35:108c1e4f3ab92d7710SELECT region, count(*) FROM customers GROUP BY regionanalytics1.1 s5success · profile
22:31:550f4d77c2aa19b6e4SELECT * FROM orders WHERE amount > 5000 LIMIT 100demo0.8 s100success · profile
22:28:33b34d8f1ac07e5539DROP TABLE IF EXISTS staging_rawetl-nightly0.2 s0failed · no table

06 · Cost Center

every resource with state + monthly estimate, daily spend from Cost Explorer with budget projection, console deep-links
localhost:5173/#/costs
⌘Worksheets
⚡Warehouses
◷Query History
▦Data Explorer
◈Cost Center
Cost Centerconnected · demo
Today
$0.42
Last 7 days
$2.18
Last 30 days
$8.92
Projected month
$12.60
budget $20.00
Active resources
8
16 tracked
Daily spendCost Explorer
Fargate · 8 tasks
ResourceStateSpecUptimeEst. monthlyWarehouse
arn:…task/flashpoint/etl-driver↗running2 vCPU / 8GB2.1din rateetl
arn:…task/flashpoint/ana-driver↗running4 vCPU / 16GB5.8hin rateanalytics
arn:…task/flashpoint/etl-exec-0↗running2 vCPU / 8GB2.1din rateetl
arn:…task/flashpoint/ana-exec-0↗running2 vCPU / 8GB5.8hin rateanalytics
Gateway · infra
i-0a1b2c3d4e5f67890↗runningt4g.small41d$12.26/moinfra
vol-0ff21ec9aab7e↗in-usegp3 20GB—$1.60/moinfra
flashpoint-dev-warehouses↗activedynamodb——infra
flashpoint-dev-query-results↗actives3——infra
Warehouse spend
WarehouseSizeStatusToday7d30d
etlSrunning$0.42$2.18$8.92
analyticsMrunning$0.00$0.94$3.10
old-nightlyXSsuspended$0.00$0.12$0.38