Create
To create a new data source, just click on the Add + button in the explorer view and add a file of type Datasource.
The form to create and manage datasources has two tabs: "General" and "Tables".
General
The "General" tab allows you to create or edit the details of a data source connection.
The available fields are:
| Field | Description |
|---|---|
| Name | A descriptive name for the data source connection |
| Description | A short description of the data source connection |
| Type | The database type, such as MySQL, PostgreSQL, etc. |
| Enabled | A flag indicating whether the data source is enabled or not |
Depending on the type of datasource you have chosen you will need to fill additional fields.
For server-based databases (PostgreSQL, ClickHouse, Oracle, MSSQL, MySQL):
| Field | Description |
|---|---|
| Host | The server address or host name of the database |
| Port | The port number used to access the database |
| User | The user name used to log in to the database |
| Password | The password used to log in to the database |
| Database | The name of the database to connect to |
For file-based datasources (CSV, SQLite, DuckDB):
| Field | Description |
|---|---|
| File path | The project file to query. Pick a .csv file for CSV sources, a .sqlite, .sqlite3 or .db file for SQLite sources, or a .duckdb or .ddb file for DuckDB sources |
SQLite and DuckDB datasources are read-only and expose all the tables contained in the database file. After selecting the file, use the Tables tab to scan and enable the tables you want to query.
The whole database file is read from project storage on every query, so its size is capped. Larger files are rejected. Administrators can change the limit with the DATASOURCES_SQLITE_MAX_FILE_SIZE_MB and DATASOURCES_DUCKDB_MAX_FILE_SIZE_MB settings.
Tables
The Tables tab displays a table of the tables in the database that have been scanned by MINEO.
The columns in the table are:
| Field | Description |
|---|---|
| Table name | The name of the table |
| Visible | A flag indicating whether the table is visible or not. This allows you to control which tables are available for use in MINEO |
Clicking on a table will take you to its detailed view.
Table detailed view
The Table Details pane displays information about a database table.
It is composed by three tabs:
| Field | Description |
|---|---|
| General | Contains information about the table, including its name, enabled flag, UUID, table name, and description |
| Columns | Displays information about the columns in the table, including the column name, an editable description, the data type, and two flags indicating whether the column is a primary key and whether it's active or not |
| Preview | Displays a preview of the first few rows of data in the table, showing a sample of the actual data stored in the table |
Overall, the Table Details pane provides a comprehensive view of the metadata and data in a table, making it easier to understand and manage the table's structure and contents.