# Dremio
#### Connectivity Summary
An out of the box connector is available for Dremio databases. It provides support for crawling database objects, profiling of sample data and lineage building.
The drivers used by the connector are given below:
> **Driver / API:** Dremio JDBC Driver
>
> **Version:** 4.3.1
>
> **Details:** Driver can be downloaded from the official website of Dremio given below:\
>
#### **Connector Capabilities**
The connector capabilities are shown below:
**Crawling**
Supported objects and data types for Crawling are:
* Tables
* Table Columns
* Views
Note: Unsupported Data Types: Binary Varying
**Profiling**
| **Feature** | **Support** | **Remarks** |
| ---------------- | --------------------------------------------- | ------------------------------------------------- |
| Table Profiling | Row count, Columns count, View sample data | |
| View Profiling | Row count, Columns count, View sample data | View is treated as a table for profiling purposes |
| Column Profiling | Min, Max, Null count, distinct, top 50 values | |
| Full Profiling | Supported | |
| Sample Profiling | Supported | |
**Lineage Building**
| **Lineage** | **Details** |
| --------------- | ------------------------------- |
| Table Lineage | Supported |
| Column Lineage | Supported |
| Lineage Sources | Data Sources, Views, Query Logs |
**Querying**
| **Operation** | **Details** |
| ---------------------- | -------------------------- |
| Select | Supported |
| Insert | Not supported, by default. |
| Update | Not supported, by default. |
| Delete | Not supported, by default. |
| Joins within database | Supported |
| Joins outside database | Not supported |
| Aggregations | Supported |
| Group By | Supported |
| Order By | Supported |
> By default the service account provided for the connector will be used for any query operations. If the service account has write privileges, then Insert / Update / Delete queries can be executed.
#### **Pre-requisites**
To use the connector, the following need to be available:
* Connection details as specified in the following section should be available.
* A service account with read privileges.
* Add Dremio client drivers into the OvalEdge Jar path to communicate with the Dremio database.
Check the [Configuration section](https://support.ovaledge.com/configuration) for further details on how to add the drivers to the jar path.
#### **Connection Details**
The following connection settings should be added for connecting to a Dremio database:
* **Database Type:** Dremio
* **License Type:** Standard, Auto Lineage
* **Connection Name:** Select a Connection name for the Dremio database. The name that you specify is a reference name to easily identify your Dremio database connection in OvalEdge. Example: Dremio Connection1
* **Server:** Database instance URL (on-premises/cloud-based)\
Example: 34.54.56.78
* **Port Number:** 31010
* **Driver Name:** JDBC driver name for Dremio. It will be auto-populated.\
Example: com.dremio.jdbc.Driver
* **Username:** User account login credential (only for Dremio Authentication
* **Password:** Password (only for Dremio Authentication)
* **Connection String:** Dremio connection string. Set the Connection string toggle button to automatic, to get the details automatically from the credentials provided. Alternatively, you can manually enter the string.\
**Format:** jdbc:dremio:direct={server}:31010\
Example: jdbc:dremio:direct=34.54.56.78:31010
> Once connectivity is established, additional configurations for [Crawling](https://support.ovaledge.com/understanding-crawler-settings) and [Profiling](https://support.ovaledge.com/understanding-profiling-settings) can be specified.
| **Property** | **Details** |
| ----------------------------------------- | ---------------------------------------------------------------------------------- |
| **Crawler configurations** | |
| Tables, Views, Columns | By default it is selected true |
| Relationships | Need to select for crawl relationships |
| Procedures, Functions, View, Source codes | Need to select for crawl Procedures, functions view source codes |
| Crawler rules | Default include tables regex has regex = (.\*) , which can crawl all the tables |
| **Profile Settings** | |
| Tables and columns | By default it is selected true |
| Views and columns | By default it is selected true |
| Profile Rules | Default include tables regex has regex = (.\*) , which can profile all the tables |
| Query Log Setting | |
***
Copyright © 2025, OvalEdge LLC, Peachtree Corners GA USA
---
# Agent Instructions: Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter:
```
GET https://docs.ovaledge.com/release8.1/connectors/connector-repositories/rdbms/dremio.md?ask=
```
The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.