The avatar for @observablehq
Observable
The end-to-end solution for building and hosting better data apps, dashboards, and reports.
Public
Observable Tips and Tricks
Edited
Mar 3
Paused
1 fork
Importers
16 stars
Observable Tips and Tricks
Don’t do this!Find and replaceVersion locking for notebook imports
Mixing Queries and Arrays into SQL
Insert cell
Insert cell
Insert cell
Insert cell
// Table name "data" with penguins as source
db = extendDB(await DuckDBClient.of({
data: penguins
}))
Insert cell
Insert cell
Insert cell
Insert cell
islands
Insert cell
db
SELECT *
FROM data
WHERE island IN (${ islands })
Insert cell
Insert cell
Insert cell
Insert cell
db
SELECT *
FROM data
WHERE ${
islands2.length
? sql`island IN (${ islands2 })`
: sql`FALSE`
}
Insert cell
Insert cell
Insert cell
queryDreamyPenguins = (condition = true) => sql`
SELECT * FROM data
WHERE island = 'Dream' AND (${ condition })
`
Insert cell
Insert cell
db
SELECT *
FROM (${
queryDreamyPenguins( sql`flipper_length_mm > ${ flipperLength }` )
})
Insert cell
Insert cell
Insert cell
import { pizzeriaDB as originalPizzeriaDB } from "@observablehq/pizza-paradise-data"
Insert cell
pizzeriaDB = extendDB(originalPizzeriaDB)
Insert cell
Insert cell
Insert cell
Insert cell
pizzeriaDB
SELECT ${
sql(
pizzaColumns.length
? pizzaColumns.map(pizzeriaDB.escape).join(",")
: "*"
)
}
FROM ${ sql( pizzeriaDB.escape(pizzaTable) ) }
Insert cell
Insert cell
Insert cell
pizzeriaDB[extended]
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
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