Databases
Dremio connects to a wide range of relational databases, data warehouses, and NoSQL databases, letting you query them directly. Several of these connections also support external queries for advanced use cases.
For the Dremio trial, database sources are not supported.
Relational Databases
These relational databases store data in tables with predefined schemas and use SQL for queries:
Data Warehouses
These data warehouses are optimized for large-scale analytical queries rather than transactional workloads:
NoSQL Databases
These NoSQL databases use flexible schemas and are designed for unstructured or semi-structured data:
Private Networking
By default, database connections use public networking. If Dremio has enabled private source connectivity for your organization, you can use AWS PrivateLink for supported sources.
| Source | Private Networking |
|---|---|
| Apache Druid | Not currently supported |
| Amazon Redshift | Supported |
| IBM Db2 | Not currently supported |
| MongoDB | Not currently supported |
| Microsoft SQL Server | Not currently supported |
| Oracle | Not currently supported |
| PostgreSQL | Not currently supported |
| SAP HANA | Not currently supported |
| Snowflake | Supported |
| Vertica | Not currently supported |
External Queries
External queries use the native syntax of the database and can be used for SQL statements that are not supported directly in Dremio. To run external queries, use the SELECT SQL command with the EXTERNAL_QUERY parameter.
You can run external queries against the following databases: Amazon Redshift, Microsoft SQL Server, MySQL, and PostgreSQL. To run these queries, you need the EXTERNAL QUERY privilege. When you update the metadata for a database connection, Dremio clears permissions, formats, and data Reflections for all datasets created from external queries.
When external querying is not enabled, all queries must use standard SQL syntax. Likewise, all user or role read and write access to tables or views are governed by privileges.