The avatar for @kelly-xie
Kelly Xie
Unlisted
Edited
Aug 4, 2024
Fork of DuckDB Data Tables
8
Insert cell
Insert cell
Insert cell
db = DuckDBClient.of([FileAttachment('Commodity.parquet'), FileAttachment('CommodityXX.parquet'), FileAttachment('Flow.parquet'),
FileAttachment('ImportCommodityXX.parquet'), FileAttachment('ImportContributionsXX.parquet'), FileAttachment('ImportMultiplierXX.parquet'),
FileAttachment('ImportSectorXX.parquet'), FileAttachment('SectorXX.parquet')
])
Insert cell
db
Type Table, then Shift-Enter. Ctrl-space for more options.

Insert cell
Insert cell
db
SELECT * FROM Flow
Insert cell
Insert cell
mermaidTablesDiagram = mermaidDiagram(db)
Insert cell
Insert cell
Insert cell
Insert cell
schemas = (await db.query('select * from information_schema.schemata')).toArray().map(Object.fromEntries)
Insert cell
Insert cell
Insert cell
dataTables = (await db.query('select * from information_schema.tables')).toArray().map(Object.fromEntries)
Insert cell
databaseConfig = (await db.query('SELECT * FROM duckdb_settings()')).toArray().map(Object.fromEntries)
Insert cell
Insert cell
libraryVersion
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