Platform
Resources
Pricing
Sign in
Contact us
Templates /
SQL + Chart
Sign up to use template
Observable
The end-to-end solution for building and hosting better data apps, dashboards, and reports.
Workspace
Published
3 collections
Edited
Dec 14, 2021
434 forks
6 stars
1
SQL
Working with SQL
Database Clients
(8)
SQL Mystery Game
(5)
Curated datasets
SQL + Chart
Arrays as SQL
Convert CSV to Parquet
Also listed in…
Basic Templates
Templates
Insert cell
Insert cell
database
=
FileAttachment
(
"chinook.db"
)
.
sqlite
(
)
Insert cell
database
SELECT * FROM tracks
Insert cell
Plot
.
plot
(
{
caption
:
"What are the common lengths of songs?"
,
x
:
{
transform
:
d
=>
d
/
1000
/
60
,
label
:
"Minutes (s) →"
}
,
marks
:
[
Plot
.
ruleY
(
[
0
]
)
,
Plot
.
rectY
(
query
,
Plot
.
binX
(
{
y
:
"sum"
}
,
{
x
:
"Milliseconds"
}
)
)
]
}
)
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.
Try it for free
Learn more
Fork
View
Export
Listed in...
SQL
Observable
Basic Templates
Observable
Templates
Observable
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
database
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
query
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
Cells
database
File attachments
chinook.db
SQLite
Databases
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML