demo-products.csv

CSV

100 rows15.9 KBready

SQL query

Query limits and engine behavior

Only SELECT and WITH are allowed. Queries use a 30-second DuckDB timeout, a 1,000-row preview and an 8 MiB result limit. Automatic mode selects DuckDB for joins, filters, sorts or aggregates over collections with 250,000+ records; simple queries stay native. First use builds a disk-backed cache. DuckDB spills within the configured memory and temporary storage limits. Use _json for original normalized values. Exports require a complete result.

Table names and columns

Use the table identifiers below. For nested objects, use json_extract(account, '$.region'). Quote identifiers that contain spaces or dots.

demo-products.csv

c_73d9998f1d7a3ef70a529f22

_record_id · _ordinal · _json · active · amount · category · country · currency · duration_ms · email · event_type · id · name · note · product_id · profile · quantity · role · session_id · sku · status · stock · timestamp · user_id ·

Saved queries

Save a query to reuse it or expose it through the API.

Recent queries

Queries you run here appear in this history.

Show original data 100 rows · demo-products.csv

Column summaries & cleanup suggestions

id Text	name Text	email Text	sku Text	status Text	event_type Text	timestamp Text	active Text	amount Text	category Text	country Text	currency Text	duration_ms Text	note Text	product_id Text	profile Text	quantity Text	role Text	session_id Text	stock Text	user_id Text
51	Wireless keyboard	[email protected]	SKU-000051	Empty text	Empty text	2024-01-01T00:00:50Z	false	4556.56	electronics	Empty text	EUR	Empty text	products record 51 · synthetic test data	Empty text	products	Empty text	Empty text	Empty text	56	Empty text
52	Laptop stand	[email protected]	SKU-000052	Empty text	Empty text	2024-01-01T00:00:51Z	true	2475.75	home	Empty text	EUR	Empty text	products record 52 · synthetic test data	Empty text	products	Empty text	Empty text	Empty text	475	Empty text
53	Water bottle	[email protected]	SKU-000053	Empty text	Empty text	2024-01-01T00:00:52Z	true	394.94	office	Empty text	EUR	Empty text	products record 53 · synthetic test data	Empty text	products	Empty text	Empty text	Empty text	394	Empty text
54	Notebook	[email protected]	SKU-000054	Empty text	Empty text	2024-01-01T00:00:53Z	false	8313.13	electronics	Empty text	EUR	Empty text	products record 54 · synthetic test data	Empty text	products	Empty text	Empty text	Empty text	313	Empty text
55	Desk lamp	[email protected]	SKU-000055	Empty text	Empty text	2024-01-01T00:00:54Z	true	6232.32	home	Empty text	EUR	Empty text	products record 55 · synthetic test data	Empty text	products	Empty text	Empty text	Empty text	232	Empty text
56	USB-C hub	[email protected]	SKU-000056	Empty text	Empty text	2024-01-01T00:00:55Z	true	4151.51	office	Empty text	EUR	Empty text	products record 56 · synthetic test data	Empty text	products	Empty text	Empty text	Empty text	151	Empty text
57	Wireless keyboard	[email protected]	SKU-000057	Empty text	Empty text	2024-01-01T00:00:56Z	false	2070.70	electronics	Empty text	EUR	Empty text	products record 57 · synthetic test data	Empty text	products	Empty text	Empty text	Empty text	70	Empty text
58	Laptop stand	[email protected]	SKU-000058	Empty text	Empty text	2024-01-01T00:00:57Z	true	9989.89	home	Empty text	EUR	Empty text	products record 58 · synthetic test data	Empty text	products	Empty text	Empty text	Empty text	489	Empty text
59	Water bottle	[email protected]	SKU-000059	Empty text	Empty text	2024-01-01T00:00:58Z	true	7908.08	office	Empty text	EUR	Empty text	products record 59 · synthetic test data	Empty text	products	Empty text	Empty text	Empty text	408	Empty text
60	Notebook	[email protected]	SKU-000060	Empty text	Empty text	2024-01-01T00:00:59Z	false	5827.27	electronics	Empty text	EUR	Empty text	products record 60 · synthetic test data	Empty text	products	Empty text	Empty text	Empty text	327	Empty text
61	Desk lamp	[email protected]	SKU-000061	Empty text	Empty text	2024-01-01T00:01:00Z	true	3746.46	home	Empty text	EUR	Empty text	products record 61 · synthetic test data	Empty text	products	Empty text	Empty text	Empty text	246	Empty text
62	USB-C hub	[email protected]	SKU-000062	Empty text	Empty text	2024-01-01T00:01:01Z	true	1665.65	office	Empty text	EUR	Empty text	products record 62 · synthetic test data	Empty text	products	Empty text	Empty text	Empty text	165	Empty text
63	Wireless keyboard	[email protected]	SKU-000063	Empty text	Empty text	2024-01-01T00:01:02Z	false	9584.84	electronics	Empty text	EUR	Empty text	products record 63 · synthetic test data	Empty text	products	Empty text	Empty text	Empty text	84	Empty text
64	Laptop stand	[email protected]	SKU-000064	Empty text	Empty text	2024-01-01T00:01:03Z	true	7503.03	home	Empty text	EUR	Empty text	products record 64 · synthetic test data	Empty text	products	Empty text	Empty text	Empty text	3	Empty text
65	Water bottle	[email protected]	SKU-000065	Empty text	Empty text	2024-01-01T00:01:04Z	true	5422.22	office	Empty text	EUR	Empty text	products record 65 · synthetic test data	Empty text	products	Empty text	Empty text	Empty text	422	Empty text
66	Notebook	[email protected]	SKU-000066	Empty text	Empty text	2024-01-01T00:01:05Z	false	3341.41	electronics	Empty text	EUR	Empty text	products record 66 · synthetic test data	Empty text	products	Empty text	Empty text	Empty text	341	Empty text
67	Desk lamp	[email protected]	SKU-000067	Empty text	Empty text	2024-01-01T00:01:06Z	true	1260.60	home	Empty text	EUR	Empty text	products record 67 · synthetic test data	Empty text	products	Empty text	Empty text	Empty text	260	Empty text
68	USB-C hub	[email protected]	SKU-000068	Empty text	Empty text	2024-01-01T00:01:07Z	true	9179.79	office	Empty text	EUR	Empty text	products record 68 · synthetic test data	Empty text	products	Empty text	Empty text	Empty text	179	Empty text
69	Wireless keyboard	[email protected]	SKU-000069	Empty text	Empty text	2024-01-01T00:01:08Z	false	7098.98	electronics	Empty text	EUR	Empty text	products record 69 · synthetic test data	Empty text	products	Empty text	Empty text	Empty text	98	Empty text
70	Laptop stand	[email protected]	SKU-000070	Empty text	Empty text	2024-01-01T00:01:09Z	true	5017.17	home	Empty text	EUR	Empty text	products record 70 · synthetic test data	Empty text	products	Empty text	Empty text	Empty text	17	Empty text
71	Water bottle	[email protected]	SKU-000071	Empty text	Empty text	2024-01-01T00:01:10Z	true	2936.36	office	Empty text	EUR	Empty text	products record 71 · synthetic test data	Empty text	products	Empty text	Empty text	Empty text	436	Empty text
72	Notebook	[email protected]	SKU-000072	Empty text	Empty text	2024-01-01T00:01:11Z	false	855.55	electronics	Empty text	EUR	Empty text	products record 72 · synthetic test data	Empty text	products	Empty text	Empty text	Empty text	355	Empty text
73	Desk lamp	[email protected]	SKU-000073	Empty text	Empty text	2024-01-01T00:01:12Z	true	8774.74	home	Empty text	EUR	Empty text	products record 73 · synthetic test data	Empty text	products	Empty text	Empty text	Empty text	274	Empty text
74	USB-C hub	[email protected]	SKU-000074	Empty text	Empty text	2024-01-01T00:01:13Z	true	6693.93	office	Empty text	EUR	Empty text	products record 74 · synthetic test data	Empty text	products	Empty text	Empty text	Empty text	193	Empty text
75	Wireless keyboard	[email protected]	SKU-000075	Empty text	Empty text	2024-01-01T00:01:14Z	false	4612.12	electronics	Empty text	EUR	Empty text	products record 75 · synthetic test data	Empty text	products	Empty text	Empty text	Empty text	112	Empty text
76	Laptop stand	[email protected]	SKU-000076	Empty text	Empty text	2024-01-01T00:01:15Z	true	2531.31	home	Empty text	EUR	Empty text	products record 76 · synthetic test data	Empty text	products	Empty text	Empty text	Empty text	31	Empty text
77	Notebook	[email protected]	SKU-000077	Empty text	Empty text	2024-01-01T00:01:16Z	false	447.47	electronics	Empty text	EUR	Empty text	products record 77 · synthetic test data	Empty text	products	Empty text	Empty text	Empty text	447	Empty text
78	Desk lamp	[email protected]	SKU-000078	Empty text	Empty text	2024-01-01T00:01:17Z	true	8366.66	home	Empty text	EUR	Empty text	products record 78 · synthetic test data	Empty text	products	Empty text	Empty text	Empty text	366	Empty text
79	USB-C hub	[email protected]	SKU-000079	Empty text	Empty text	2024-01-01T00:01:18Z	true	6285.85	office	Empty text	EUR	Empty text	products record 79 · synthetic test data	Empty text	products	Empty text	Empty text	Empty text	285	Empty text
80	Wireless keyboard	[email protected]	SKU-000080	Empty text	Empty text	2024-01-01T00:01:19Z	false	4204.04	electronics	Empty text	EUR	Empty text	products record 80 · synthetic test data	Empty text	products	Empty text	Empty text	Empty text	204	Empty text
81	Laptop stand	[email protected]	SKU-000081	Empty text	Empty text	2024-01-01T00:01:20Z	true	2123.23	home	Empty text	EUR	Empty text	products record 81 · synthetic test data	Empty text	products	Empty text	Empty text	Empty text	123	Empty text
82	Water bottle	[email protected]	SKU-000082	Empty text	Empty text	2024-01-01T00:01:21Z	true	42.42	office	Empty text	EUR	Empty text	products record 82 · synthetic test data	Empty text	products	Empty text	Empty text	Empty text	42	Empty text
83	Notebook	[email protected]	SKU-000083	Empty text	Empty text	2024-01-01T00:01:22Z	false	7961.61	electronics	Empty text	EUR	Empty text	products record 83 · synthetic test data	Empty text	products	Empty text	Empty text	Empty text	461	Empty text
84	Desk lamp	[email protected]	SKU-000084	Empty text	Empty text	2024-01-01T00:01:23Z	true	5880.80	home	Empty text	EUR	Empty text	products record 84 · synthetic test data	Empty text	products	Empty text	Empty text	Empty text	380	Empty text
85	USB-C hub	[email protected]	SKU-000085	Empty text	Empty text	2024-01-01T00:01:24Z	true	3799.99	office	Empty text	EUR	Empty text	products record 85 · synthetic test data	Empty text	products	Empty text	Empty text	Empty text	299	Empty text
86	Wireless keyboard	[email protected]	SKU-000086	Empty text	Empty text	2024-01-01T00:01:25Z	false	1718.18	electronics	Empty text	EUR	Empty text	products record 86 · synthetic test data	Empty text	products	Empty text	Empty text	Empty text	218	Empty text
87	Laptop stand	[email protected]	SKU-000087	Empty text	Empty text	2024-01-01T00:01:26Z	true	9637.37	home	Empty text	EUR	Empty text	products record 87 · synthetic test data	Empty text	products	Empty text	Empty text	Empty text	137	Empty text
88	Water bottle	[email protected]	SKU-000088	Empty text	Empty text	2024-01-01T00:01:27Z	true	7556.56	office	Empty text	EUR	Empty text	products record 88 · synthetic test data	Empty text	products	Empty text	Empty text	Empty text	56	Empty text
89	Notebook	[email protected]	SKU-000089	Empty text	Empty text	2024-01-01T00:01:28Z	false	5475.75	electronics	Empty text	EUR	Empty text	products record 89 · synthetic test data	Empty text	products	Empty text	Empty text	Empty text	475	Empty text
90	Desk lamp	[email protected]	SKU-000090	Empty text	Empty text	2024-01-01T00:01:29Z	true	3394.94	home	Empty text	EUR	Empty text	products record 90 · synthetic test data	Empty text	products	Empty text	Empty text	Empty text	394	Empty text
91	USB-C hub	[email protected]	SKU-000091	Empty text	Empty text	2024-01-01T00:01:30Z	true	1313.13	office	Empty text	EUR	Empty text	products record 91 · synthetic test data	Empty text	products	Empty text	Empty text	Empty text	313	Empty text
92	Wireless keyboard	[email protected]	SKU-000092	Empty text	Empty text	2024-01-01T00:01:31Z	false	9232.32	electronics	Empty text	EUR	Empty text	products record 92 · synthetic test data	Empty text	products	Empty text	Empty text	Empty text	232	Empty text
93	Laptop stand	[email protected]	SKU-000093	Empty text	Empty text	2024-01-01T00:01:32Z	true	7151.51	home	Empty text	EUR	Empty text	products record 93 · synthetic test data	Empty text	products	Empty text	Empty text	Empty text	151	Empty text
94	Water bottle	[email protected]	SKU-000094	Empty text	Empty text	2024-01-01T00:01:33Z	true	5070.70	office	Empty text	EUR	Empty text	products record 94 · synthetic test data	Empty text	products	Empty text	Empty text	Empty text	70	Empty text
95	Notebook	[email protected]	SKU-000095	Empty text	Empty text	2024-01-01T00:01:34Z	false	2989.89	electronics	Empty text	EUR	Empty text	products record 95 · synthetic test data	Empty text	products	Empty text	Empty text	Empty text	489	Empty text
96	Desk lamp	[email protected]	SKU-000096	Empty text	Empty text	2024-01-01T00:01:35Z	true	908.08	home	Empty text	EUR	Empty text	products record 96 · synthetic test data	Empty text	products	Empty text	Empty text	Empty text	408	Empty text
97	USB-C hub	[email protected]	SKU-000097	Empty text	Empty text	2024-01-01T00:01:36Z	true	8827.27	office	Empty text	EUR	Empty text	products record 97 · synthetic test data	Empty text	products	Empty text	Empty text	Empty text	327	Empty text
98	Wireless keyboard	[email protected]	SKU-000098	Empty text	Empty text	2024-01-01T00:01:37Z	false	6746.46	electronics	Empty text	EUR	Empty text	products record 98 · synthetic test data	Empty text	products	Empty text	Empty text	Empty text	246	Empty text
99	Laptop stand	[email protected]	SKU-000099	Empty text	Empty text	2024-01-01T00:01:38Z	true	4665.65	home	Empty text	EUR	Empty text	products record 99 · synthetic test data	Empty text	products	Empty text	Empty text	Empty text	165	Empty text
100	Water bottle	[email protected]	SKU-000100	Empty text	Empty text	2024-01-01T00:01:39Z	true	2584.84	office	Empty text	EUR	Empty text	products record 100 · synthetic test data	Empty text	products	Empty text	Empty text	Empty text	84	Empty text

Use Changes to clean this dataset.

Edit the source file

Inline edits write to your original file. Changes prepares a separate result.

Saved views

File settings

Source details

Filename: c80b4dc33578ec3c77f92189-demo-products.csv

Updated: 2026-10-11T13:06:06Z

Processing history