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.

note

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:

• IBM Db2
• Microsoft SQL Server
• MySQL
• Oracle
• PostgreSQL
• SAP HANA

Data Warehouses

These data warehouses are optimized for large-scale analytical queries rather than transactional workloads:

• Amazon Redshift
• Google BigQuery
• Microsoft Azure Synapse Analytics
• Snowflake
• Vertica

NoSQL Databases

These NoSQL databases use flexible schemas and are designed for unstructured or semi-structured data:

• Apache Druid
• MongoDB

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.