H2
Supported
Relational databases
Catalog H2 databases (embedded, file or server mode).
Capabilities
| Capability | Support | Notes |
|---|---|---|
| Tables, views & columns | Supported | |
| Keys, constraints & indexes | Supported | |
| Procedures & functions | Not available | |
| Data lineage | Partial | |
| Lineage from query history | Not available | |
| Business glossary links | Supported | |
| Data quality probes | Supported | |
| Data profiling | Supported | |
| Data classification | Supported | |
| Chat with your data | Supported |
Connection settings
Create the connection on the Blindata Agent from Settings > Agents > Connections with the connection wizard, choosing H2 in the technology step.
| Driver class | org.h2.Driver |
|---|---|
| JDBC URL | jdbc:h2:mem:testdb |
| Authentication |
Service principal (shared technical user) User principal (personal credentials, BYOC) Ephemeral credentials (asked at each run)
|
| Crawling strategy | JDBC or SQL |
The driver is included in the Blindata Agent: no installation is needed. Driver properties can be added under Advanced settings in the connection wizard.
Prerequisites & permissions
- A Blindata Agent installed with network access to H2.
- A read-only user able to read the database catalog (JDBC metadata,
INFORMATION_SCHEMAor the vendor system views). SELECTon the tables to analyze for data quality, profiling, classification and Chat with your data.
Set up metadata crawling
- Create the connection to H2 on the agent (see Connection settings) and use Test to verify it.
- Create or open the system that represents H2 in the catalog and link it to the connection.
- In the CRAWLING tab add a crawling job with strategy JDBC or SQL.
- Run a TEST to check the number of extracted objects, then RUN or schedule the job.
The job options and the column aliases of every extraction query are described in the Generic JDBC reference.