File Set Connectors
Index a File System and Query It with SQL
Last Updated: August 27, 2026FILE SYSTEM CONNECTOR Index a File System and Query It with SQL Point Query Streams at a share and you get a live inventory of every file — names, sizes, dates, owners and folder structure — as four SQL tables. The files themselves are never opened. Metadata only Duplicate detection Daily growth history Free-space tracking...
Query Multi-Record CSV Files with SQL
Last Updated: August 27, 2026MULTI-RECORD CSV CONNECTOR Query Multi-Record CSV Files with SQL Some exports put a record-type tag at the start of every line, and each tag carries a different set of columns. Query Streams gives every tag its own SQL table, and a sequence column that joins the related records back together. One table per tag Groups...
Query a Folder of Parquet Files with SQL
Last Updated: August 27, 2026PARQUET FOLDER CONNECTOR Query a Folder of Parquet Files with SQL Parquet carries its own schema, so there is nothing to guess. Point Query Streams at the folder and every file becomes one SQL table with the exact column names and types the files already declare — no Spark, no Python, no uploads. Types from...
Combine Multiple SQLite Database Files Into One Table
Last Updated: August 27, 2026SQLITE FOLDER CONNECTOR Combine Multiple SQLite Database Files Into One Table Two hundred .db files, one query. Query Streams unions every file in the folder table by table, opens each database read-only so nothing can be disturbed, and keeps the file each row came from. One table per table name Opened read-only Declared types enforced...
Turn a Folder of JSON Files Into SQL Tables
Last Updated: August 27, 2026JSONL FOLDER CONNECTOR Turn a Folder of JSON Files Into SQL Tables JSON is nested and SQL is flat, so the real question is not whether your logs can be read but what shape you get. Query Streams flattens nested objects into ordinary columns with a policy you can see and change — then you...
Merge Multiple Excel Files Into One Table
Last Updated: August 27, 2026EXCEL FOLDER CONNECTOR Merge Multiple Excel Files Into One Table Point Query Streams at the folder of workbooks and every worksheet becomes a SQL table — the same tab from every file, unioned, typed and read-only. No consolidation macro, no master workbook to rebuild each month. One table per worksheet Next month’s file auto-joins All-in...
Combine Multiple CSV Files Into One Table
Last Updated: August 27, 2026CSV FOLDER CONNECTOR Combine Multiple CSV Files Into One Table Stop stitching exports together by hand. Point Query Streams at the folder and every CSV in it becomes one queryable SQL table — new files join automatically, and you can still tell which file every row came from. Thousands of files New files auto-join Money...
How to Query a Folder of Files with SQL
Last Updated: August 27, 2026FILE SET CONNECTORS Your Folder Is Now a Database Point Query Streams at a folder of CSV, Excel, Parquet, JSON or SQLite files and every file becomes a queryable SQL table — read-only, refreshed on demand, and never uploaded anywhere. 7 folder types Read-only, enforced Cached on your machine Joins to any connector Start Free...
English 
Spanish 
German 
French 
Portuguese 
Japanese 
Korean 
Chinese 
Italian 
Dutch 
Indonesian 
Polish