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
Dremio Arctic (Preview)
Managing Security
Managing Your Subscription
- Viewing Usage
- Managing Billing Accounts
API Reference
- Billing
- 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
- 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
  - 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
  - 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
  - Regular Expressions
  - Semistructured Data
  - 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
  - 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
Changelog

On this page

Managing Engines & Workloads

Managing Engines
Engine Routing

Was this page helpful?

Glad to hear it! Thank you for your feedback. Sorry to hear that. Thank you for your feedback.