The avatar for @observablehq
Observable
The end-to-end solution for building and hosting better data apps, dashboards, and reports.
Published
SQL
Edited
Jul 21, 2022
2 forks
Importers
46 stars
SQL
Working with SQL
Database Clients
(8)
SQL Mystery Game
(5)
Curated datasetsSQL + Chart
Arrays as SQL
Convert CSV to Parquet
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
alphabet
Insert cell
diamonds
Insert cell
Insert cell
// Create a database with the tables alphabet and diamonds
db = DuckDBClient.of({ alphabet, diamonds })
Insert cell
Insert cell
db
Type Table, then Shift-Enter. Ctrl-space for more options.

Insert cell
Insert cell
db
select * from alphabet
join diamonds on alphabet.letter = diamonds.color
Insert cell
Insert cell
// a very simple example
simple = DuckDBClient.of({ example: [{a: 1, b: 10}, {a: 2, b: 20}] })
Insert cell
simple
Type Table, then Shift-Enter. Ctrl-space for more options.

Insert cell

Purpose-built for displays of data

Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.
Learn more