Column Profile

Preview in your theme

ready — 11 columns, all 11 rendered. Expand revenue_usd for the histogram and percentiles, country for its top values, signed_up_at for the time span. legacy_referrer is 100% missing, schema_version and experiment_arm are constant, event_id is a key candidate.

analytics.events

11 columns · 248,190 rows · scanned 2 hours ago

Rows scanned: 248,190
Non-missing: 237,771
Missing: 10,419
Distinct: 18,442

Min: 0
p25: 3.5
Median: 8.99
Mean: 23.87
p75: 24.99
Max: 1,899.5
Std dev: 61.42

01,899.5

Histogram bins of revenue_usd
Range	Rows
0 to 118.72	188,658
118.72 to 237.44	27,140
237.44 to 356.16	9,874
356.16 to 474.88	5,218
474.88 to 593.59	2,907
593.59 to 712.31	1,684
712.31 to 831.03	962
831.03 to 949.75	548
949.75 to 1,068.47	311
1,068.47 to 1,187.19	186
1,187.19 to 1,305.91	118
1,305.91 to 1,424.63	74
1,424.63 to 1,543.34	44
1,543.34 to 1,662.06	26
1,662.06 to 1,780.78	14
1,780.78 to 1,899.5	7

ready · degenerate input — a schema whose table has zero scanned rows. Every share is 0/0, which reads as an em dash instead of NaN, and each panel says why there is nothing to profile.

warehouse.orders_staging

4 columns · 0 rows · created 4 minutes ago

Rows scanned
0
Non-missing
0
Missing
0
Distinct
0
This dataset has no rows yet, so nothing could be profiled for this column.

loading — skeleton rows in the same five-track layout as the real list, so nothing jumps when the profile lands.

empty — the profiler ran but found no columns.

No columns profiled

Point the profiler at a dataset and every column shows up here with its type, missing rate and distribution.

error — the profiling job failed; Try again is only rendered because onRetry was passed, and it really recovers to the ready state.

Couldn't profile this dataset

The profiling job didn't return a result.

Loading preview…

This component is part of Pro

The install command, prompt and concept map are included with a Pro license — one purchase unlocks every Pro component, forever.

Unlock with Pro

event_iduuiduniqueTypeTypecategoricalMissingMissing0%(0)DistinctDistinct248,190DistributionDistributiontop: 0f2c1a8e-7d44-4d2b-9c31-6a5f0b7e1d92

user_idvarchar(36)TypeTypecategoricalMissingMissing12%(29,782)DistinctDistinct41,204DistributionDistributiontop: usr_9f31c0

revenue_usdfloat64TypeTypenumericMissingMissing4.2%(10,419)DistinctDistinct18,442DistributionDistribution0 – 1,899.5

session_secondsint32TypeTypenumericMissingMissing0%(0)DistinctDistinct8,902DistributionDistribution1 – 3,600

countrychar(2)TypeTypecategoricalMissingMissing<0.1%(2)DistinctDistinct148DistributionDistributiontop: US

plan_tiervarchar(16)TypeTypecategoricalMissingMissing0%(0)DistinctDistinct4DistributionDistributiontop: free

is_returningbooleanTypeTypebooleanMissingMissing0%(0)DistinctDistinct2DistributionDistributiontop: true

signed_up_attimestamptzhigh nullsTypeTypetemporalMissingMissing38.6%(95,740)DistinctDistinct149,112DistributionDistribution18 months

schema_versionint32constantTypeTypenumericMissingMissing0%(0)DistinctDistinct1DistributionDistribution3 – 3

experiment_armvarchar(16)constantTypeTypecategoricalMissingMissing0%(0)DistinctDistinct1DistributionDistributiontop: control

legacy_referrertextall nullTypeTypecategoricalMissingMissing100%(248,190)DistinctDistinct0DistributionDistributionnothing to profile

order_idbigintno rowsTypeTypenumericMissingMissing—(0)DistinctDistinct0DistributionDistributionnothing to profile

total_amountnumeric(12,2)no rowsTypeTypenumericMissingMissing—(0)DistinctDistinct0DistributionDistributionnothing to profile

fulfilment_statusvarchar(32)no rowsTypeTypecategoricalMissingMissing—(0)DistinctDistinct0DistributionDistributionnothing to profile

placed_attimestamptzno rowsTypeTypetemporalMissingMissing—(0)DistinctDistinct0DistributionDistributionnothing to profile