Dremio Cloud
Dremio Cloud
Dremio Software
What is Dremio Cloud?
Quick Tour of the Dremio Console
Getting Started with Dremio Test Drive
Signing Up
Dremio Sonar
Getting Started with Sonar
Prerequisites for Configuring Cloud Resources
Configuring Cloud Resources Manually
Managing Your Data
Spaces
Datasets
Apache Iceberg
Copying Data Into Tables
Expiring Snapshots
Optimizing Tables
Rolling Back Tables
Connecting to Your Data
Arctic Catalog
AWS Glue Catalog
Amazon S3
Azure Storage
Dremio
Formatting Data
Databases
Amazon Redshift
Microsoft SQL Server
MySQL
Oracle
PostgreSQL
Snowflake
Querying Your Data
Viewing Jobs and Job Details
Accelerating Queries with Reflections
Types and Benefits
Best Practices
Creating and Editing Reflections
Testing Reflections
Viewing Whether Queries Used Reflections
Refreshing Reflections
Viewing Information about Reflections
Disabling Reflections
Deleting Reflections
Setting Expiration Policy
Managing Projects and Clouds
Managing Projects
Managing Clouds
Managing Engines & Workloads
Managing Engines
Engine Routing
Connecting from Client Applications
Alteryx Designer
Astrato
DBeaver
dbt
DbVisualizer
Deepnote
Domo
Hex
Looker
Microsoft Power BI
Working from Datasets
Connecting to Dremio Cloud from Power BI Desktop
Publishing Reports
Enabling Single Sign-On
Administering Connectivity
Troubleshooting Connectivity
Working from Dataflows
Python
Qlik Sense Desktop
SAP Business Objects
Superset and Preset
Tableau
ThoughtSpot
Drivers
JDBC Driver for Arrow Flight SQL
JDBC Driver for Arrow Flight SQL Release Notes
JDBC Driver for Arrow Flight SQL 10.0.0
Legacy JDBC Driver
Legacy 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
ODBC Driver for Arrow Flight SQL Release Notes
ODBC Driver for Arrow Flight SQL 0.9.1
Developing Client Applications with Arrow Flight
Arrow Flight
Arrow Flight SQL
Dremio Arctic (Preview)
Setting Up
Getting Started with Dremio Sonar and Arctic
Getting Started with Apache Spark and Arctic
Quick Tour
Managing Catalogs
Automatic Table Optimization
Configuring Your Engine
Dremio Sonar
Apache Flink
Apache Hive
Apache Spark
Managing Security
Authentication
BI Applications
External Token Providers
Identity Providers
Microsoft Azure Active Directory
Okta
Social Identity Providers
OAuth Applications
Personal Access Tokens
Access Management
Privileges
Best Practices
Roles
Row-Access & Column-Masking
SCIM
Users
Audit Logging
AWS PrivateLink
Compliance
Managing Your Subscription
Viewing Usage
Managing Billing Accounts
API Reference
Billing
Billing Accounts
Billing Transactions
Credit Balances
Catalog
Source
Configuration Attributes
Spaces
Home Space
Folders
Table
View
Tag
Wiki
Clouds
Engines
Engine Rules
Identity Providers
Microsoft Azure Active Directory
Okta
Job
Job Results
Personal Access Tokens
Projects
Reflection
Reflection Summary
SQL
Usage
Arctic
Catalogs
Engine
Jobs
Schedules
SQL Reference
Data Types
Mappings for External Sources
Amazon Redshift
Microsoft SQL Server
MySQL
Oracle
PostgreSQL
Time Zone Support
Coercions Support
SQL Commands
ALTER BRANCH
ALTER TABLE
ALTER TAG
ALTER USER
ALTER VIEW
ANALYZE TABLE
COPY INTO <table>
CREATE BRANCH
CREATE FUNCTION
CREATE ROLE
CREATE TABLE
CREATE TAG
CREATE USER
CREATE VIEW
DELETE
DESCRIBE FUNCTION
DESCRIBE TABLE
DROP BRANCH
DROP FUNCTION
DROP ROLE
DROP TABLE
DROP TAG
DROP USER
DROP VIEW
GRANT ROLE
GRANT TO ROLE
GRANT TO USER
INSERT
MERGE
MERGE BRANCH
OPTIMIZE TABLE
REVOKE FROM ROLE
REVOKE FROM USER
REVOKE ROLE
ROLLBACK TABLE
SELECT
SHOW BRANCHES
SHOW FUNCTIONS
SHOW LOGS
SHOW TABLES
SHOW TAGS
SHOW VIEWS
TRUNCATE
UPDATE
USE
VACUUM TABLE
WITH
SQL Functions
All Functions
ABS
ACOS
AES_ENCRYPT
APPROX_COUNT_DISTINCT
ARRAY_CONTAINS
ASCII
ASIN
ATAN
AVG
BASE64
BIN
BINARY_STRING
BIT_AND
BIT_LENGTH
BIT_OR
BOOL_AND
BOOL_OR
BROUND
BTRIM
CASE
CAST
CBRT
CEILING
CHARACTER_LENGTH
CHAR_LENGTH
CHR
COALESCE
COL_LIKE
CONCAT
CONCAT_WS
CONVERT_FROM
CONVERT_REPLACEUTF8
CONVERT_TIMEZONE
CONVERT_TO
CORR
COS
COSH
COT
COUNT
COVAR_POP
COVAR_SAMP
CRC32
CUME_DIST
CURRENT_DATE
CURRENT_DATE_UTC
CURRENT_SCHEMA
CURRENT_TIME
CURRENT_TIMESTAMP
DATEDIFF
DATE_ADD
DATE_DIFF
DATE_PART
DATE_SUB
DATE_TRUNC
DAY
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
DEGREES
DENSE_RANK
E
ENCODE
ENDS_WITH
EXP
EXTRACT
FACTORIAL
FIRST_VALUE
FLATTEN
FLOOR
FROM_HEX
GEO_BEYOND
GEO_DISTANCE
GEO_NEARBY
GREATEST
HASH
HEX
HLL
HOUR
ILIKE
IMAXDIR
IMINDIR
INITCAP
INSTR
IS [NOT] DISTINCT FROM
ISDATE
IS [NOT] FALSE
IS [NOT] NULL
ISNUMERIC
IS [NOT] TRUE
IS_BIGINT
IS_INT
IS_MEMBER
IS_SUBSTR
IS_UTF8
IS_VARCHAR
LAG
LAST_DAY
LAST_QUERY_ID
LCASE
LEAD
LEAST
LEFT
LENGTH
LEVENSHTEIN
LIKE
LISTAGG
LN
LOCALTIME
LOCALTIMESTAMP
LOCATE
LOG
LOG10
LOWER
LPAD
LSHIFT
LTRIM
MAP_KEYS
MAP_VALUES
MASK
MASK_FIRST_N
MASK_HASH
MASK_LAST_N
MASK_SHOW_FIRST_N
MASK_SHOW_LAST_N
MAX
MAXDIR
MD5
MEDIAN
MIN
MINDIR
MINUTE
MOD
MONTH
MONTHS_BETWEEN
NDV
NEXT_DAY
NOW
NTILE
NULLIF
NVL
OCTET_LENGTH
PERCENTILE_CONT
PERCENTILE_DISC
PERCENT_RANK
PI
POSITION
POW, POWER
QUARTER
QUERY_USER
QUOTE
RADIANS
RANDOM
RANK
REGEXP_EXTRACT
REGEXP_LIKE
REGEXP_MATCHES
REGEXP_REPLACE
REGEXP_SPLIT
REPEAT
REPEATSTR
REPLACE
REVERSE
RIGHT
ROUND
ROW_NUMBER
RPAD
RSHIFT
RTRIM
SECOND
SESSION_USER
SHA, SHA1
SHA256
SHA512
SIGN
SIMILAR_TO
SIN
SINH
SIZE
SOUNDEX
SPLIT_PART
SQRT
STARTS_WITH
STDDEV
STDDEV_POP
STDDEV_SAMP
STRPOS
ST_FROMGEOHASH
ST_GEOHASH
SUBSTR
SUBSTRING
SUBSTRING_INDEX
SUM
SYSTEM_USER
TAN
TANH
TIMESTAMPADD
TIMESTAMPDIFF
TOASCII
TO_CHAR
TO_DATE
TO_HEX
TO_NUMBER
TO_TIME
TO_TIMESTAMP
TRANSACTION_TIMESTAMP
TRANSLATE
TRIM
TRUNCATE
TYPEOF
UCASE
UNBASE64
UNHEX
UNIX_TIMESTAMP
UPPER
USER
VAR_POP
VAR_SAMP
WEEK
WEEKOFYEAR
XOR
YEAR
Aggregate
APPROX_COUNT_DISTINCT
AVG
BIT_AND
BIT_OR
CORR
COUNT
COVAR_POP
COVAR_SAMP
HLL
LISTAGG
MAX
MIN
NDV
STDDEV
STDDEV_POP
STDDEV_SAMP
SUM
VAR_POP
VAR_SAMP
Binary
BASE64
BIN
BIT_LENGTH
CRC32
ENCODE
FROM_HEX
HEX
TO_HEX
UNBASE64
UNHEX
Bitwise
BIT_AND
BIT_OR
LSHIFT
RSHIFT
XOR
Boolean
IS [NOT] DISTINCT FROM
ISDATE
IS [NOT] FALSE
IS [NOT] NULL
ISNUMERIC
IS [NOT] TRUE
IS_MEMBER
IS_SUBSTR
Conditional
BOOL_AND
BOOL_OR
CASE
COALESCE
GREATEST
LEAST
NULLIF
NVL
Conversion
BINARY_STRING
CAST
CONVERT_FROM
CONVERT_REPLACEUTF8
CONVERT_TIMEZONE
CONVERT_TO
ENCODE
FLATTEN
FROM_HEX
HASH
HEX
ST_FROMGEOHASH
ST_GEOHASH
TOASCII
TO_CHAR
TO_DATE
TO_HEX
TO_NUMBER
TO_TIME
TO_TIMESTAMP
UNHEX
Cryptography
AES_ENCRYPT
MD5
SHA, SHA1
SHA256
SHA512
Data Generation
RANDOM
Datatype
IS [NOT] DISTINCT FROM
ISDATE
IS [NOT] FALSE
IS [NOT] NULL
IS [NOT] TRUE
IS_BIGINT
IS_INT
IS_SUBSTR
IS_VARCHAR
SIZE
TYPEOF
Date/Time
CONVERT_TIMEZONE
CURRENT_DATE
CURRENT_DATE_UTC
CURRENT_TIME
CURRENT_TIMESTAMP
DATEDIFF
DATE_ADD
DATE_DIFF
DATE_PART
DATE_SUB
DATE_TRUNC
DAY
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
EXTRACT
HOUR
LAST_DAY
MINUTE
MONTH
MONTHS_BETWEEN
NEXT_DAY
QUARTER
SECOND
TIMESTAMPADD
TIMESTAMPDIFF
TO_DATE
TO_TIME
TO_TIMESTAMP
UNIX_TIMESTAMP
WEEK
WEEKOFYEAR
YEAR
Directory
IMAXDIR
IMINDIR
MAXDIR
MINDIR
Geospatial
GEO_BEYOND
GEO_DISTANCE
GEO_NEARBY
ST_FROMGEOHASH
ST_GEOHASH
Math
ABS
ACOS
ASIN
ATAN
BROUND
CBRT
CEILING
COS
COSH
COT
DEGREES
E
EXP
FACTORIAL
FLOOR
LN
LOG
LOG10
MOD
PI
POW, POWER
RADIANS
ROUND
SIGN
SIN
SINH
SQRT
STDDEV
STDDEV_POP
STDDEV_SAMP
TAN
TANH
TRUNCATE
Percentile
MEDIAN
PERCENTILE_CONT
PERCENTILE_DISC
Regular Expressions
REGEXP_EXTRACT
REGEXP_LIKE
REGEXP_MATCHES
REGEXP_REPLACE
REGEXP_SPLIT
Semistructured Data
ARRAY_CONTAINS
MAP_KEYS
MAP_VALUES
String
ASCII
BASE64
BTRIM
CHARACTER_LENGTH
CHAR_LENGTH
CHR
COL_LIKE
CONCAT
CONCAT_WS
CRC32
ENDS_WITH
FROM_HEX
HEX
ILIKE
INITCAP
INSTR
IS_UTF8
LCASE
LEFT
LENGTH
LEVENSHTEIN
LIKE
LOCATE
LOWER
LPAD
LTRIM
MASK
MASK_FIRST_N
MASK_HASH
MASK_LAST_N
MASK_SHOW_FIRST_N
MASK_SHOW_LAST_N
OCTET_LENGTH
POSITION
QUOTE
REGEXP_EXTRACT
REGEXP_LIKE
REGEXP_MATCHES
REGEXP_REPLACE
REGEXP_SPLIT
REPEAT
REPEATSTR
REPLACE
REVERSE
RIGHT
RPAD
RTRIM
SIMILAR_TO
SOUNDEX
SPLIT_PART
STARTS_WITH
STRPOS
ST_FROMGEOHASH
ST_GEOHASH
SUBSTR
SUBSTRING
SUBSTRING_INDEX
TOASCII
TO_HEX
TRANSLATE
TRIM
UCASE
UNBASE64
UNHEX
UPPER
System
CURRENT_DATE
CURRENT_DATE_UTC
CURRENT_SCHEMA
CURRENT_TIME
CURRENT_TIMESTAMP
LAST_QUERY_ID
LOCALTIME
LOCALTIMESTAMP
NOW
QUERY_USER
SESSION_USER
SYSTEM_USER
TRANSACTION_TIMESTAMP
UNIX_TIMESTAMP
USER
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
Reserved Keywords
System Tables
Clouds
Engines
Events
Jobs (Runtime)
Jobs (Historical)
Privileges (Organization)
Privileges (Project)
Projects
Reflections
Roles
Tables
Usage
Users
Views
Information Schema
Catalogs
Columns
Schemata
Tables
Views
Appendix
AWS: Resources
Creating an IAM Role for Granting Access to a Project Store
Creating an IAM Role for Granting Access to Compute Resources
Creating an IAM User to Enable Access to Your Data
Creating an Internet Gateway
Creating a NAT Gateway
Creating a Route Table
Creating a Security Group
Create a VPC and Subnets
Creating a VPC Endpoint
Setting Up IAM Permissions
CloudFormation Template
Keyboard Shortcuts
Supported Regions
Troubleshooting Cloud Resource Configuration
Changelog
On this page
Welcome to Dremio Cloud Documentation - Dremio
>
>
>
>
>
>
Files
File upload is not currently supported.
Was this page helpful?
Yes
No
Glad to hear it! Thank you for your feedback.
Sorry to hear that. Thank you for your feedback.