Introduction
Quickstart
Cluster Deployments
Data Sources
Data Formats
- Delta Lake
- Parquet Best Practices
Datasets
Jobs
Data Reflections
Data Security
Client Connectivity
- Drivers
  - Arrow Flight
  - ODBC
  - JDBC
- Clients
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
    - CAST
    - CBRT
    - CEILING
    - CHARACTER_LENGTH
    - CHAR_LENGTH
    - CHR
    - CONCAT
    - 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
    - NOW
    - OCTET_LENGTH
    - PERCENTILE_CONT
    - PERCENTILE_DISC
    - PI
    - POSITION
    - POWER
    - QUERY_USER
    - RADIANS
    - RANDOM
    - 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
    - UPPER
    - USER
    - VAR_POP
    - VAR_SAMP
    - XOR
  - Aggregate
    - APPROX_COUNT_DISTINCT
    - AVG
    - CORR
    - COUNT
    - HLL
    - MAX
    - MIN
    - SUM
    - 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
    - ISNULL
  - Context
  - 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
  - Math
    - ABS
    - ACOS
    - ASIN
    - ATAN
    - CBRT
    - CEILING
    - COS
    - COSH
    - COT
    - DATE_TRUNC
    - DEGREES
    - E
    - EXP
    - FLOOR
    - LOG
    - LOG10
    - MOD
    - PI
    - POWER
    - RADIANS
    - ROUND
    - SIGN
    - SIN
    - SINH
    - SQRT
    - TAN
    - TANH
    - TRUNCATE
  - Percentile
  - String
    - ASCII
    - BTRIM
    - CHARACTER_LENGTH
    - CHAR_LENGTH
    - CHR
    - CONCAT
    - CONTAINS
    - FROM_HEX
    - ILIKE
    - INITCAP
    - IS_UTF8
    - LEFT
    - LENGTH
    - LOCATE
    - LOWER
    - LPAD
    - LTRIM
    - OCTET_LENGTH
    - POSITION
    - REPEAT
    - REPEATSTR
    - REPLACE
    - REVERSE
    - RIGHT
    - RPAD
    - RTRIM
    - SPLIT_PART
    - STRPOS
    - SUBSTRING
    - TO_HEX
    - TRANSLATE
    - TRIM
    - UPPER
  - Window
    - COUNT
    - HLL
    - MAX
    - MIN
    - SUM
    - VAR_POP
    - VAR_SAMP
- SQL Commands
  - Analyze Table
  - Datasets
  - Privileges
  - Reflections
  - Sources
  - Tables
  - Users
- Reserved Words
Rest API Reference
Knowledge Base
Release Notes
Dremio JDBC Driver Release Notes
Dremio ODBC Driver Release Notes
Glossary
Contributing to Dremio

Dremio Community

> >

Reflection API

Reflection API provides a way for you to easily manage your Dremio reflections:

Reflection
List Reflections
View a Reflection
View Reflections Summary
Create a Reflection
Edit a Reflection
Delete a Reflection

Previous:

Next: