Archivos CSV / Parquet / JSON with DBine
How to connect DBine to Archivos CSV / Parquet / JSON and what you can do once it's connected. This page is written from what the Archivos CSV / Parquet / JSON driver says about itself, so it matches the version of DBine you download.
Connect
- In DBine, open New connection.
- Pick Archivos CSV / Parquet / JSON in the list of engines.
- Fill in the fields below, press Test connection and then Save.
General
| Field | Description |
|---|---|
| Folder required | The folder with the files (you can pick any file inside it). Each .csv, .tsv, .parquet, .json, .jsonl or .ndjson (also compressed with .gz) becomes a view. A file on this computer. Example: /path/to/files |
| Read-only | On or off. |
Advanced
| Field | Description |
|---|---|
| Include subfolders | Views from subfolders are named folder/file. On or off. |
| Only this file | Opens only the chosen file (an .xlsx too), not the whole folder. On or off. |
What the explorer shows
The objects appear right under the connection:
- Files
- Tables
- Macros
Query editor
The editor uses SQL, with completion for the connection's objects. Statements and commands run against the database selected in the tab.
Ready-made templates for new objects:
- New view
- New macro
- New table macro
- New sequence
Tools for Archivos CSV / Parquet / JSON
Available
- Graphical execution plans
- Server monitor
- Manual transactions (commit and rollback)
- Create databases
- Drop databases
- Database properties
- Relations in the ER diagram
- Visual designer for new objects
- Compare and sync schemas
- Native bulk load when migrating data
Not available for Archivos CSV / Parquet / JSON
- Live query profiler
- Sessions and running queries
- End a session
- Locks: who blocks whom
- Cancel another session's query from the sessions list
- Index usage
- Rename objects
- Clone tables
- Users and permissions
- Backups
Why a tool doesn't apply to an engine, and the details of each one, are in the engine support reference.
Generated from the Archivos CSV / Parquet / JSON driver 0.1.12, which DBine downloads the first time you connect to Archivos CSV / Parquet / JSON.