Databases

You can run queries directly against relational databases, 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 Redshift
• Elasticsearch
• Microsoft Azure Data Explorer
• Microsoft Azure Synapse Analytics
• Microsoft SQL Server
• MongoDB
• MySQL
• Oracle
• Postgres
• Snowflake
• Teradata