Databases

You can run queries directly against relational databases, NoSQL databases, and data warehouses, referred to in Dremio Sonar as databases. Using these databases, you can perform “external queries.” External queries use native syntax for a source and can be used for SQL statements that are not supported directly in Dremio or are too complex to convert.

The following databases are supported:

• Amazon OpenSearch Service

• Amazon Redshift

• Apache Druid

• Dremio Cluster

• Elasticsearch

• IBM Db2

• Microsoft Azure Data Explorer

• Microsoft Azure Synapse Analytics

• Microsoft SQL Server

• MongoDB

• MySQL

• Oracle

• PostgreSQL

• Snowflake

• Teradata