The avatar for @adityawarmanfw
Fidocia Wima Adityawarman
Product, analytics, viz. Product analyst @ShowwcaseHQ.
Public
Edited
Jun 24, 2023
Insert cell
Insert cell
Plot.plot({
axis: null,
margin: 20,
marginRight: 120,
height: 16000,
marks: [
Plot.tree(sql, {path: "name", delimiter: "."})
]
})
Insert cell
db
SELECT DISTINCT concat(database_name, '.', schema_name) AS name
FROM duckdb_functions()
WHERE database_name = 'system'

UNION ALL

SELECT DISTINCT concat(database_name, '.', schema_name, '.', function_type) AS name
FROM duckdb_functions()
WHERE database_name = 'system'

UNION ALL

SELECT DISTINCT concat(database_name, '.', schema_name, '.', function_type, '.', function_name) AS name
FROM duckdb_functions()
WHERE database_name = 'system'

UNION ALL

SELECT DISTINCT concat(database_name, '.', schema_name, '.', function_type, '.', function_name, '.', return_type) AS name
FROM duckdb_functions()
WHERE database_name = 'system'

-- DESCRIBE SELECT * FROM duckdb_functions()
Insert cell
db
SE
Insert cell
Insert cell
d3.hierarchy(sql2)
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