Modeling with Uploaded Files
Glean can directly use CSVs and other common data files for small or adhoc analysis, without needing to set up a traditional database.
From the model builder page, select "Uploads" as the data connection. You can then either click the "Upload" button or drag a file from your computer into the tables list. This will upload the file to Glean and make it available as if it were a table in a databse.
You can update the contents of an existing file by uploading or dragging in a new version with the same name.
Glean currently supports the following formats:
- Comma seperated or tab separated values files (
- JSON files containing a single array of objects. Object keys will
be used as column names. (
- Apache Parquet
Glean enforces a max size of 50 MB for uploaded files.
Writing SQL for Uploaded Files
Glean uses DuckDB as the SQL-engine for uploaded files.
Glean loads your files into the DuckDB instance as a table with a name matching the file. Since filenames contain special characters, you will need to quote the table name.
SELECT * FROM "my_file.csv";
Glean is compatible with the
DuckDB SQL dialect.
However, side-effects from statements such as
will be discarded. The DuckDB instance is re-created and discarded between