TomoS tsoumdoa

tsoumdoa / 0-load-bim-open-schema-parquet.sql

Last active July 28, 2025 14:22

Simple DuckDB query demo to work with Bim Open Schema by Ara 3D

	-- create table from parquet files:
	CREATE TABLE Descriptors AS
	SELECT * FROM read_parquet('./Descriptors.parquet');

	CREATE TABLE Documents AS
	SELECT * FROM read_parquet('./Documents.parquet');

	CREATE TABLE DoubleParameters AS
	SELECT * FROM read_parquet('./DoubleParameters.parquet');