Dremio Software
Dremio Cloud
Dremio Software
Quickstart
Azure Quickstart
AWS Quickstart
Standalone Quickstart
Cluster Deployments
Deployment Architecture
Dremio Services
Metadata Storage
Distributed Storage
Coordinator Nodes System-level Caching
ZooKeeper
High Availability
Wire Encryption
Authentication
Multiple AWS Clusters
Limits
Customizing Configuration
Configuring via dremio.conf
Configuring Dremio Services
Configuring Metadata Storage
Configuring Distributed Storage
Configuring ZooKeeper
Configuring High Availability
Configuring Cloud Cache
Configuring Wire Encryption
Configuring Authorization for Power BI
Configuring Single Sign-On
Configuring via dremio-env
Configuring Memory
Configuring Logs and PID Location
Configuring Dremio for Queries with non-ISO-8859-1 Literals
Setting Up LDAP
Deployment Models
Amazon Deployments
AWS Edition
Deploying Dremio on AWS
Deploying Dremio on AWS
Upgrade to Dremio Enterprise
Configuring AWS Edition
Configuring IAM Roles
Configuring Security Groups
Configuring LDAP
Configuring SSO in AWS Edition
Configuring Executor Nodes
Administering Projects
Create and Open a Project
Open an Existing Project
Close an Open Project
Delete a Project
Managing Engines
Creating Custom Dremio Projects
Amazon EKS
Deploying Dremio on EKS
Customizing EKS Deployment
Administering Dremio on EKS
Azure Deployments
Azure ARM
Deploying Dremio on Azure
Administering Dremio on Azure
Enabling TLS for Dremio UI on Azure
Azure AKS
Deploying Dremio on AKS
Customizing AKS Deployment
Administering Dremio on AKS
Google Cloud GKE
Hadoop Using YARN
HPE Ezmeral
MapR using YARN
Standalone Cluster
System Requirements
Installing and Upgrading
RPM Install and Upgrade
Tarball Install and Upgrade
Configuring Standalone Clusters
Deprecated Deployment Models
AWS Cloudformation
Admin Tasks
Logs
Start, Stop, and Status
Admin CLI
Backup
Restore
Reset Password
Clean Metadata
Repair ACLs
Export Profiles
Upgrade KV Store
Cleaning Up Job Results
Cleaning Up Spill Directories
Monitoring Nodes
Monitoring System Telemetry
Monitoring Cluster Usage
Managing Metadata
Querying Metadata
Caching Metadata
Managing Job Workloads
Job History & Details
Queue Control
Workload Management
Gandiva-based Execution
Hash Aggregate Spilling
Support Settings
Querying Your Data
Data Sources
Uploading Files
Querying Files and Directories
Querying External Data Sources
Runtime Filtering
Promoting Entities
Amazon Redshift
Amazon S3
Amazon OpenSearch Service
Amazon Glue
Azure Data Explorer
Azure Data Lake Storage Gen1
Azure Storage
Microsoft Azure Synapse Analytics
Elasticsearch
Google Cloud Storage
HDFS
Hive
Ranger-Based Authorization
Connecting to a Ranger Host using SSL
S3 on Amazon EMR Configuration
IBM DB2
MapR-FS
Microsoft SQL Server
MongoDB
MySQL
NAS
Oracle
Postgres
Teradata
Data Formats
Apache Iceberg
Delta Lake
Parquet Best Practices
Datasets
Concepts
Virtual Datasets
Data Curation
Jobs
Job Overview
Job Details
Job Acceleration
Job Profile
Job Metrics
Downloading Profiles
Uploading Profile Data
Querying Profile Datasets
Analyzing Profiles
Example: Number of Rows
Example: Amount of Consumed Memory
Example: Operator Type Mapping
Example: profile_attempt_0
Data Reflections
Reflections Overview
Creating Data Reflections
Refreshing Data Reflections
Offloading Operational Databases
Optimizing Data Reflections
Data Security
Access Control
Access Control Structure
Privileges
Roles
Users
Migration
SCIM Integration with Okta
Best Practices
Lake Formation
Row-Level Filtering & Column Masking
Personal Access Tokens
Users, Groups, and Roles
Sharing and Permissions
Inbound Impersonation
Client Connectivity
Drivers
ODBC Driver for Arrow Flight SQL
JDBC
Clients
Alteryx Designer
DBeaver
DbVisualizer
IBM Cognos Analytics
Looker
Microsoft Excel
Microsoft Excel PowerPivot
Microsoft Power BI
Microstrategy Desktop
Qlik Sense Desktop
Python
SAP Business Objects
Tableau
ThoughtSpot
Developing Client Applications
Arrow Flight
Arrow Flight SQL
SQL Reference
Data Types
IBM DB2
Elasticsearch
Hive
MongoDB
MySQL
Oracle
PostgreSQL
Redshift
Microsoft SQL Server
Teradata
SQL Functions
All Functions
ABS
ACOS
APPROX_COUNT_DISTINCT
ASCII
ASIN
ATAN
AVG
BINARY_STRING
BIT_AND
BIT_LENGTH
BIT_OR
BOOL_AND
BOOL_OR
BTRIM
CASE
CAST
CBRT
CEILING
CHARACTER_LENGTH
CHAR_LENGTH
CHR
COALESCE
CONCAT
CONCAT_WS
CONTAINS
CONVERT_FROM
CONVERT_REPLACEUTF8
CONVERT_TIMEZONE
CONVERT_TO
CORR
COS
COSH
COT
COUNT
COVAR_POP
COVAR_SAMP
CUME_DIST
CURRENT_DATE
CURRENT_DATE_UTC
CURRENT_SCHEMA
CURRENT_TIME
CURRENT_TIMESTAMP
DATE_ADD
DATE_DIFF
DATE_PART
DATE_SUB
DATE_TRUNC
DEGREES
DENSE_RANK
E
EXP
EXTRACT
FIRST_VALUE
FLATTEN
FLOOR
FROM_HEX
GEO_BEYOND
GEO_DISTANCE
GEO_NEARBY
GREATEST
HASH
HLL
ILIKE
IMAXDIR
IMINDIR
INITCAP
IS [NOT] DISTINCT FROM
ISFALSE
IS [NOT] NULL
ISNUMERIC
ISTRUE
IS_BIGINT
IS_DATE
IS_INT
IS_MEMBER
IS_UTF8
IS_VARCHAR
LAG
LAST_QUERY_ID
LEAD
LEAST
LEFT
LENGTH
LIKE
LOCALTIME
LOCALTIMESTAMP
LOCATE
LOG
LOG10
LOWER
LPAD
LSHIFT
LTRIM
MAX
MAXDIR
MEDIAN
MIN
MINDIR
MOD
NDV
NOW
NTILE
NULLIF
OCTET_LENGTH
PERCENTILE_CONT
PERCENTILE_DISC
PERCENT_RANK
PI
PIVOT
POSITION
POWER
QUERY_USER
RADIANS
RANDOM
RANK
REGEXP_LIKE
REGEXP_MATCHES
REGEXP_REPLACE
REGEXP_SPLIT
REPEAT
REPEATSTR
REPLACE
REVERSE
RIGHT
ROUND
ROW_NUMBER
RPAD
RSHIFT
RTRIM
SESSION_USER
SIGN
SIMILAR_TO
SIN
SINH
SPLIT_PART
SQRT
STDDEV
STDDEV_POP
STDDEV_SAMP
STRPOS
SUBSTRING
SUM
TAN
TANH
TIMESTAMPADD
TIMESTAMPDIFF
TOASCII
TO_CHAR
TO_DATE
TO_HEX
TO_NUMBER
TO_TIME
TO_TIMESTAMP
TRANSACTION_TIMESTAMP
TRANSLATE
TRIM
TRUNCATE
TYPEOF
UNIX_TIMESTAMP
UNPIVOT
UPPER
USER
VAR_POP
VAR_SAMP
XOR
Aggregate
APPROX_COUNT_DISTINCT
AVG
BIT_AND
BIT_OR
CORR
COUNT
COVAR_POP
COVAR_SAMP
HLL
MAX
MIN
NDV
PIVOT
STDDEV
STDDEV_POP
STDDEV_SAMP
SUM
UNPIVOT
VAR_POP
VAR_SAMP
Binary
ASCII
BIT_LENGTH
FROM_HEX
INITCAP
LOWER
LPAD
OCTET_LENGTH
REPEAT
REVERSE
RPAD
STRPOS
TO_HEX
UPPER
Bitwise
BIT_AND
BIT_OR
LSHIFT
RSHIFT
XOR
Boolean
IS [NOT] DISTINCT FROM
ISFALSE
IS [NOT] NULL
ISNUMERIC
ISTRUE
IS_MEMBER
Conditional
BOOL_AND
BOOL_OR
CASE
COALESCE
GREATEST
LEAST
NULLIF
Context
CURRENT_DATE
CURRENT_DATE_UTC
CURRENT_SCHEMA
CURRENT_TIME
CURRENT_TIMESTAMP
LAST_QUERY_ID
LOCALTIME
LOCALTIMESTAMP
NOW
QUERY_USER
SESSION_USER
TRANSACTION_TIMESTAMP
UNIX_TIMESTAMP
USER
Conversion
BINARY_STRING
CAST
CONVERT_FROM
CONVERT_REPLACEUTF8
CONVERT_TIMEZONE
CONVERT_TO
FLATTEN
FROM_HEX
HASH
TOASCII
TO_CHAR
TO_DATE
TO_HEX
TO_NUMBER
TO_TIME
TO_TIMESTAMP
Data Generation
RANDOM
Datatype
IS_BIGINT
IS_DATE
IS_INT
IS_VARCHAR
TYPEOF
Date/Time
CONVERT_TIMEZONE
CURRENT_DATE
CURRENT_DATE_UTC
CURRENT_TIME
CURRENT_TIMESTAMP
DATE_ADD
DATE_DIFF
DATE_PART
DATE_SUB
DATE_TRUNC
EXTRACT
TIMESTAMPADD
TIMESTAMPDIFF
TO_DATE
TO_TIME
TO_TIMESTAMP
UNIX_TIMESTAMP
Directory
IMAXDIR
IMINDIR
MAXDIR
MINDIR
Geospatial
GEO_BEYOND
GEO_DISTANCE
GEO_NEARBY
Math
ABS
ACOS
ASIN
ATAN
CBRT
CEILING
COS
COSH
COT
DEGREES
E
EXP
FLOOR
LOG
LOG10
MOD
PI
POWER
RADIANS
ROUND
SIGN
SIN
SINH
SQRT
STDDEV
STDDEV_POP
STDDEV_SAMP
TAN
TANH
TRUNCATE
Percentile
MEDIAN
PERCENTILE_CONT
PERCENTILE_DISC
String
ASCII
BTRIM
CHARACTER_LENGTH
CHAR_LENGTH
CHR
CONCAT
CONCAT_WS
CONTAINS
FROM_HEX
ILIKE
INITCAP
IS_UTF8
LEFT
LENGTH
LIKE
LOCATE
LOWER
LPAD
LTRIM
OCTET_LENGTH
POSITION
REGEXP_LIKE
REGEXP_MATCHES
REGEXP_REPLACE
REGEXP_SPLIT
REPEAT
REPEATSTR
REPLACE
REVERSE
RIGHT
RPAD
RTRIM
SIMILAR_TO
SPLIT_PART
STRPOS
SUBSTRING
TOASCII
TO_HEX
TRANSLATE
TRIM
UPPER
Window
COUNT
COVAR_POP
COVAR_SAMP
CUME_DIST
DENSE_RANK
FIRST_VALUE
HLL
LAG
LEAD
MAX
MIN
NDV
NTILE
PERCENT_RANK
RANK
ROW_NUMBER
SUM
VAR_POP
VAR_SAMP
SQL Commands
Apache Iceberg Tables
CREATE
SELECT
INSERT
UPDATE
DELETE
ALTER
MERGE
TRUNCATE
DROP
Analyze Table
Datasets
Privileges
Queue Routing
Reflections
Roles
Sources
Tables
Users
Reserved Words
Rest API Reference
Overview
Account API
View a User
View a Group
Catalog API
Home
Space
Source
Source Types
Source Type Configuration
Source Metadata Policy
Folder
Dataset
File
Access Control
Wikis and Tags
List Catalogs
View a Catalog
View the Graph Information of a Catalog
View a Catalog using its Path
View a Catalog Wikis and Tags
Create a Catalog
Promote a File/Folder to a Physical Dataset
Refresh a Catalog
Create and Update Tags and Wiki for a Catalog
Edit a Catalog
Delete a Catalog
Job API
View a Job
Cancel a Running Job
KVStore Report API
Privileges API (16.0+)
GET /grant
GET {grantType}
PUT /grants
Invalidate LDAP User Cache API
Reflection API
Reflection and Reflection-Summary Objects
List Reflections
View a Reflection
View Reflections Summary
Create a Reflection
Edit a Reflection
Delete a Reflection
Role API (18.0+)
Add/Remove Members
Create Role
Delete Role
Get Role Info
Get Member List
Get Privileges List
Update Role
Source API
Source
Source Types
List Sources
Create a Source
Edit a Source
Delete a Source
SQL API
Submit an SQL Query
Token API
Delete Tokens
Delete a Token
User API
View a User
List Tokens of a User
Create a Token for a User
Delete Tokens of a User
Delete a Specific Token of a User
Create User
Delete User
Get User Privileges
Get User
Update User
Vote API
List Votes
Workload Management API
View Queue Information
Create a Queue
Update Attributes of a Queue
Delete a Specific Queue
List Rules
Create and Manage Rules
Knowledge Base
Apache Log4j Vulnerability
G1 Garbage Collection Setup
Kerberos Setup and Troubleshooting
Kubernetes Troubleshooting
Log Monitoring for AKS
Adding HBase via REST
Release Notes
22.0.0 Release Notes
21.0.0+ Release Notes
20.0.0+ Release Notes
19.0.0+ Release Notes
18.0.0+ Release Notes
17.0.0+ Release Notes
16.0.0+ Release Notes
15.0.0+ Release Notes
14.0.0 Release Notes
13.0.0 Release Notes
12.0.0 Release Notes
11.0.0 Release Notes
Dependencies & Licenses
Dremio JDBC Driver Release Notes
17.0.0 (Dremio June 2021) Release Notes
15.0.0 (Dremio February 2021) Release Notes
14.0.0 (Dremio February 2021) Release Notes
11.0.0 (Dremio November 2020) Release Notes
ODBC Driver for Arrow Flight SQL Release Notes
ODBC Driver for Arrow Flight SQL 0.9.0
Glossary
On this page
Release Notes
Summary of changes for each release.
22.0.0 Release Notes
21.0.0+ Release Notes
20.0.0+ Release Notes
19.0.0+ Release Notes
18.0.0+ Release Notes
17.0.0+ Release Notes
16.0.0+ Release Notes
15.0.0+ Release Notes
14.0.0 Release Notes
13.0.0 Release Notes
12.0.0 Release Notes
11.0.0 Release Notes
Was this page helpful?
Yes
No
Glad to hear it! Thank you for your feedback.
Sorry to hear that. Thank you for your feedback.