Introduction
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 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
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
Customizing Executors
Administering Projects
Create and Open a Project
Open an Existing Project
Close an Open Project
Delete a Project
Managing Engines
Creating Custom Dremio Projects
Azure ARM
Deploying Dremio on Azure
Administering Dremio on Azure
Enabling TLS for Dremio UI on Azure
Amazon EKS
Deploying Dremio on EKS
Customizing EKS Deployment
Administering Dremio on EKS
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
Data Sources
Uploading Files
Querying Files and Directories
Querying External Data Sources
Runtime Filtering
Promoting Entities
Amazon Redshift
Amazon S3
Amazon Elasticsearch Service
Amazon Glue
Azure Data Lake Storage Gen1
Azure Storage
Microsoft Azure Synapse Analytics
Elasticsearch
Google Cloud Storage
HBase
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
Roles SQL Commands
Users
Migration
SCIM Integration with Okta
Best Practices
Privileges SQL Commands
Privileges APIs
Roles APIs
Users SQL Commands
Users APIs
Lake Formation
Row-Level Filtering & Column Masking
Personal Access Tokens
Users, Groups, and Roles
Sharing and Permissions
Inbound Impersonation
Client Connectivity
Drivers
Arrow Flight
ODBC
Windows ODBC
Linux ODBC
Mac ODBC
JDBC
Clients
Alteryx Designer
DBeaver
DbVisualizer
IBM Cognos Analytics
Looker
Microsoft Excel
Microsoft Excel PowerPivot
Microsoft Excel
Microsoft Power BI Desktop
Microsoft Power BI Gateway
Microstrategy Desktop
Qlik Sense Desktop
Python
R
SAP Business Objects
Tableau
SQL Reference
Date/Time Formatting
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_LENGTH
BOOL_AND
BOOL_OR
BTRIM
CASE
CAST
CBRT
CEILING
CHARACTER_LENGTH
CHAR_LENGTH
CHR
COALESCE
CONCAT
CONCAT_WS
CONTAINS
CONVERT_TIMEZONE
CORR
COS
COSH
COT
COUNT
CURRENT_DATE
CURRENT_DATE_UTC
CURRENT_SCHEMA
CURRENT_TIME
CURRENT_TIMESTAMP
DATE_ADD
DATE_PART
DATE_SUB
DATE_TRUNC
DEGREES
E
EXP
EXTRACT
FLOOR
FROM_HEX
HLL
ILIKE
INITCAP
ISFALSE
ISNULL
ISTRUE
IS_BIGINT
IS_DATE
IS_INT
IS_UTF8
IS_VARCHAR
LAST_QUERY_ID
LEFT
LENGTH
LOCALTIME
LOCALTIMESTAMP
LOCATE
LOG
LOG10
LOWER
LPAD
LSHIFT
LTRIM
MAX
MEDIAN
MIN
MOD
NDV
NOW
NULLIF
OCTET_LENGTH
PERCENTILE_CONT
PERCENTILE_DISC
PI
PIVOT
POSITION
POWER
QUERY_USER
RADIANS
RANDOM
REGEXP_SPLIT
REPEAT
REPEATSTR
REPLACE
REVERSE
RIGHT
ROUND
RPAD
RSHIFT
RTRIM
SESSION_USER
SIGN
SIN
SINH
SPLIT_PART
SQRT
STRPOS
SUBSTRING
SUM
TAN
TANH
TIMESTAMPADD
TIMESTAMPDIFF
TO_CHAR
TO_HEX
TO_NUMBER
TO_TIMESTAMP
TRANSACTION_TIMESTAMP
TRANSLATE
TRIM
TRUNCATE
TYPEOF
UNIX_TIMESTAMP
UNPIVOT
UPPER
USER
VAR_POP
VAR_SAMP
XOR
Aggregate
APPROX_COUNT_DISTINCT
AVG
CORR
COUNT
HLL
MAX
MIN
NDV
PIVOT
SUM
UNPIVOT
VAR_POP
VAR_SAMP
Binary
ASCII
BIT_LENGTH
FROM_HEX
ILIKE
INITCAP
LOWER
LPAD
OCTET_LENGTH
REPEAT
REVERSE
RPAD
STRPOS
TO_HEX
UPPER
Bitwise
LSHIFT
RSHIFT
XOR
Boolean
ISFALSE
ISNULL
ISTRUE
Conditional
BOOL_AND
BOOL_OR
CASE
COALESCE
ISNULL
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_TIMEZONE
FROM_HEX
TO_CHAR
TO_HEX
TO_NUMBER
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_PART
DATE_SUB
DATE_TRUNC
EXTRACT
TIMESTAMPADD
TIMESTAMPDIFF
TO_TIMESTAMP
UNIX_TIMESTAMP
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
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
LOCATE
LOWER
LPAD
LTRIM
OCTET_LENGTH
POSITION
REGEXP_SPLIT
REPEAT
REPEATSTR
REPLACE
REVERSE
RIGHT
RPAD
RTRIM
SPLIT_PART
STRPOS
SUBSTRING
TO_HEX
TRANSLATE
TRIM
UPPER
Window
COUNT
HLL
MAX
MIN
NDV
SUM
VAR_POP
VAR_SAMP
SQL Commands
Analyze Table
Datasets
Privileges
Reflections
Roles
Sources
Tables
Users
Reserved Words
Window Functions
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
Server Status API
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
List Users
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
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
4.9 Release Notes
4.8 Release Notes
4.7 Release Notes
4.6 Release Notes
4.5 Release Notes
4.3 Release Notes
4.2 Release Notes
4.1 Release Notes
4.0 Release Notes
3.3 Release Notes
3.2 Release Notes
3.1 Release Notes
3.0 Release Notes
2.1 Release Notes
2.0 Release Notes
1.4 Release Notes
1.3 Release Notes
1.2 Release Notes
1.1 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
Dremio ODBC Driver Release Notes
1.5.4 Release Notes
1.5.3 Release Notes
1.5.1 Release Notes
1.5.0 Release Notes
Glossary
Contributing to Dremio
Dremio Community
>
>
Column Masking
Previous:
Next: