Guide
Documentation
Versions
Release Information
Production
Beta
Development
Allocation Assignments
Getting Started
Allocations Quick Start
Rule Based Tagging
Why are Allocations Useful
Configure Allocations
Configure an Allocation
Recursive Allocations
Results and Troubleshooting
Allocation Results
Troubleshooting Allocations
Custom App Sandbox
Getting Started with the Custom App Sandbox
Dashboards
Learning About Dashboards
Using Dashboards
Formatting Numbers and Other Data Types
Example Calculated Columns
Example Metrics
Data and Service Connectors
Cloud Service Connections
Quandl Connector
Database and Data Lake Connections
Amazon Athena
Amazon Redshift
Apache Doris
Apache Hive
Apache Spark
Azure Databricks
Databend
Exasol
Greenplum
IBM DB2
IBM Informix
Microsoft Fabric
Microsoft SQL Server
MySQL
ODBC
Oracle
PlaidCloud Lakehouse
PostgreSQL
Presto
SAP HANA
Snowflake
StarRocks
Trino
ERP System Connections
Infor Connector
JD Edwards (Legacy) Connector
Oracle EBS Connector
Oracle Fusion Connector
SAP Analytics Cloud Connector
SAP ECC Connector
SAP Profitability and Cost Management (PCM) Connector
SAP Profitability and Performance Management (PaPM) Connector
SAP S/4HANA Connector
Git Repository Connections
AWS CodeCommit Repository Connector
Azure Repos Repository Connector
BitBucket Repository Connector
GitHub Repository Connector
GitLab Repository Connector
Google Service Connections
Google BigQuery Connector
Google Sheets
Open Table Format Connections
Apache Hive Open Table Format
Apache Hudi Open Table Format
Apache Iceberg Open Table Format
Delta Lake Open Table Format (Databricks Catalog)
REST Connections
Gusto REST Connector
Microsoft Dynamics 365 REST Connector
Mulesoft REST Connector
Netsuite REST Connector
Paycor REST Connector
Quickbooks REST Connector
Ramp REST Connector
Sage Intacct REST Connector
Salesforce REST Connector
Stripe REST Connector
Workday REST Connector
Team Collaboration Connections
Microsoft Teams Connector
Slack Connector
Data Lakehouse Service
Getting Started
Pricing
Data Management - Dimensions
Dimension Functions for Expressions and Aggregations
Loading and Unloading Dimensions
Using Dimensions (Hierarchies)
Using Dimensions (Hierarchies)
Data Management - Tabular
Using Tables and Views
Table Explorer
Publishing Tables
Expressions
Lakehouse v1
Aggregate Functions
ANY
APPROX_COUNT_DISTINCT
ARG_MAX
ARG_MIN
ARRAY_AGG
AVG
AVG_IF
COUNT
COUNT_DISTINCT
COUNT_IF
COVAR_POP
COVAR_SAMP
GROUP_ARRAY_MOVING_AVG
GROUP_ARRAY_MOVING_SUM
HISTOGRAM
JSON_ARRAY_AGG
JSON_OBJECT_AGG
KURTOSIS
MAX
MAX_IF
MEDIAN
MEDIAN_TDIGEST
MIN
MIN_IF
QUANTILE_CONT
QUANTILE_DISC
QUANTILE_TDIGEST
QUANTILE_TDIGEST_WEIGHTED
RETENTION
SKEWNESS
STDDEV_POP
STDDEV_SAMP
STRING_AGG
SUM
SUM_IF
WINDOW_FUNNEL
AI Functions
AI_EMBEDDING_VECTOR
AI_TEXT_COMPLETION
AI_TO_SQL
COSINE_DISTANCE
Array Functions
ARRAY_AGGREGATE
ARRAY_APPEND
ARRAY_APPLY
ARRAY_CONCAT
ARRAY_CONTAINS
ARRAY_DISTINCT
ARRAY_FILTER
ARRAY_FLATTEN
ARRAY_GET
ARRAY_INDEXOF
ARRAY_LENGTH
ARRAY_PREPEND
ARRAY_REDUCE
ARRAY_REMOVE_FIRST
ARRAY_REMOVE_LAST
ARRAY_SIZE
ARRAY_SLICE
ARRAY_SORT
ARRAY_TO_STRING
ARRAY_TRANSFORM
ARRAY_UNIQUE
ARRAYS_ZIP
CONTAINS
GET
RANGE
SLICE
UNNEST
Bitmap Functions
BITMAP_AND
BITMAP_AND_COUNT
BITMAP_AND_NOT
BITMAP_CARDINALITY
BITMAP_CONTAINS
BITMAP_COUNT
BITMAP_HAS_ALL
BITMAP_HAS_ANY
BITMAP_INTERSECT
BITMAP_MAX
BITMAP_MIN
BITMAP_NOT
BITMAP_NOT_COUNT
BITMAP_OR
BITMAP_OR_COUNT
BITMAP_SUBSET_IN_RANGE
BITMAP_SUBSET_LIMIT
BITMAP_UNION
BITMAP_XOR
BITMAP_XOR_COUNT
INTERSECT_COUNT
SUB_BITMAP
Conditional Functions
[ NOT ] BETWEEN
[ NOT ] IN
AND
CASE
COALESCE
Comparison Methods
ERROR_OR
GREATEST
IF
IFNULL
IS [ NOT ] DISTINCT FROM
IS_ERROR
IS_NOT_ERROR
IS_NOT_NULL
IS_NULL
LEAST
NULLIF
NVL
NVL2
OR
Context Functions
CONNECTION_ID
CURRENT_CATALOG
CURRENT_USER
DATABASE
LAST_QUERY_ID
VERSION
Conversion Functions
BUILD_BITMAP
CAST, ::
TO_BINARY
TO_BITMAP
TO_BOOLEAN
TO_FLOAT32
TO_FLOAT64
TO_HEX
TO_INT16
TO_INT32
TO_INT64
TO_INT8
TO_STRING
TO_TEXT
TO_UINT16
TO_UINT32
TO_UINT64
TO_UINT8
TO_VARCHAR
TO_VARIANT
TRY_CAST
TRY_TO_BINARY
Date & Time Functions
ADD TIME INTERVAL
CURRENT_TIMESTAMP
DATE
DATE DIFF
DATE_ADD
DATE_FORMAT
DATE_PART
DATE_SUB
DATE_TRUNC
DAY
EXTRACT
LAST_DAY
MONTH
MONTHS_BETWEEN
NEXT_DAY
NOW
PREVIOUS_DAY
QUARTER
STR_TO_DATE
STR_TO_TIMESTAMP
SUBTRACT TIME INTERVAL
TIME_SLOT
TIMESTAMP_DIFF
TIMEZONE
TO_DATE
TO_DATETIME
TO_DAY_OF_MONTH
TO_DAY_OF_WEEK
TO_DAY_OF_YEAR
TO_HOUR
TO_MINUTE
TO_MONDAY
TO_MONTH
TO_QUARTER
TO_SECOND
TO_START_OF_DAY
TO_START_OF_FIFTEEN_MINUTES
TO_START_OF_FIVE_MINUTES
TO_START_OF_HOUR
TO_START_OF_ISO_YEAR
TO_START_OF_MINUTE
TO_START_OF_MONTH
TO_START_OF_QUARTER
TO_START_OF_SECOND
TO_START_OF_TEN_MINUTES
TO_START_OF_WEEK
TO_START_OF_YEAR
TO_TIMESTAMP
TO_UNIX_TIMESTAMP
TO_WEEK_OF_YEAR
Dictionary Functions
DICT_GET
Geography Functions
GEO_TO_H3
GEOHASH_DECODE
GEOHASH_ENCODE
H3_CELL_AREA_M2
H3_CELL_AREA_RADS2
H3_DISTANCE
H3_EDGE_ANGLE
H3_EDGE_LENGTH_KM
H3_EDGE_LENGTH_M
H3_EXACT_EDGE_LENGTH_KM
H3_EXACT_EDGE_LENGTH_M
H3_EXACT_EDGE_LENGTH_RADS
H3_GET_BASE_CELL
H3_GET_DESTINATION_INDEX_FROM_UNIDIRECTIONAL_EDGE
H3_GET_FACES
H3_GET_INDEXES_FROM_UNIDIRECTIONAL_EDGE
H3_GET_ORIGIN_INDEX_FROM_UNIDIRECTIONAL_EDGE
H3_GET_RESOLUTION
H3_GET_UNIDIRECTIONAL_EDGE
H3_GET_UNIDIRECTIONAL_EDGE_BOUNDARY
H3_GET_UNIDIRECTIONAL_EDGES_FROM_HEXAGON
H3_HEX_AREA_KM2
H3_HEX_AREA_M2
H3_HEX_RING
H3_INDEXES_ARE_NEIGHBORS
H3_IS_PENTAGON
H3_IS_RES_CLASS_III
H3_IS_VALID
H3_K_RING
H3_LINE
H3_NUM_HEXAGONS
H3_TO_CENTER_CHILD
H3_TO_CHILDREN
H3_TO_GEO
H3_TO_GEO_BOUNDARY
H3_TO_PARENT
H3_TO_STRING
H3_UNIDIRECTIONAL_EDGE_IS_VALID
POINT_IN_POLYGON
STRING_TO_H3
Geometry Functions
HAVERSINE
ST_ASBINARY
ST_ASEWKB
ST_ASEWKT
ST_ASGEOJSON
ST_ASTEXT
ST_ASWKB
ST_ASWKT
ST_CONTAINS
ST_DIMENSION
ST_DISTANCE
ST_ENDPOINT
ST_GEOHASH
ST_GEOM_POINT
ST_GEOMETRYFROMEWKB
ST_GEOMETRYFROMEWKT
ST_GEOMETRYFROMTEXT
ST_GEOMETRYFROMWKB
ST_GEOMETRYFROMWKT
ST_GEOMFROMEWKB
ST_GEOMFROMEWKT
ST_GEOMFROMGEOHASH
ST_GEOMFROMTEXT
ST_GEOMFROMWKB
ST_GEOMFROMWKT
ST_GEOMPOINTFROMGEOHASH
ST_LENGTH
ST_MAKE_LINE
ST_MAKEGEOMPOINT
ST_MAKELINE
ST_MAKEPOLYGON
ST_NPOINTS
ST_NUMPOINTS
ST_POINTN
ST_POLYGON
ST_SETSRID
ST_SRID
ST_STARTPOINT
ST_TRANSFORM
ST_X
ST_XMAX
ST_XMIN
ST_Y
ST_YMAX
ST_YMIN
TO_GEOMETRY
TO_STRING
Hash Functions
BLAKE3
CITY64WITHSEED
MD5
SHA
SHA1
SHA2
SIPHASH
SIPHASH64
XXHASH32
XXHASH64
Interval Functions
EPOCH
TO_CENTURIES
TO_DAYS
TO_DECADES
TO_HOURS
TO_MICROSECONDS
TO_MILLENNIA
TO_MILLISECONDS
TO_MINUTES
TO_MONTHS
TO_SECONDS
TO_WEEKS
TO_YEARS
IP Address Functions
INET_ATON
INET_NTOA
IPV4_NUM_TO_STRING
IPV4_STRING_TO_NUM
TRY_INET_ATON
TRY_INET_NTOA
TRY_IPV4_NUM_TO_STRING
TRY_IPV4_STRING_TO_NUM
Map Functions
MAP_CAT
MAP_CONTAINS_KEY
MAP_DELETE
MAP_FILTER
MAP_INSERT
MAP_KEYS
MAP_PICK
MAP_SIZE
MAP_TRANSFORM_KEYS
MAP_TRANSFORM_VALUES
MAP_VALUES
Numeric Functions
ABS
ACOS
ADD
ASIN
ATAN
ATAN2
CBRT
CEIL
CEILING
COS
COT
CRC32
DEGREES
DIV
DIV0
DIVNULL
EXP
FACTORIAL
FLOOR
INTDIV
LN
LOG(b, x)
LOG(x)
LOG10
LOG2
MINUS
MOD
MODULO
NEG
NEGATE
PI
PLUS
POW
POWER
RADIANS
RAND()
RAND(n)
ROUND
SIGN
SIN
SQRT
SUBTRACT
TAN
TRUNCATE
Other Functions
ASSUME_NOT_NULL
EXISTS
GROUPING
HUMANIZE_NUMBER
HUMANIZE_SIZE
IGNORE
REMOVE_NULLABLE
TO_NULLABLE
TYPEOF
Search Functions
MATCH
QUERY
SCORE
Semi-Structured Functions
AS_<type>
CHECK_JSON
FLATTEN
GET
GET_IGNORE_CASE
GET_PATH
IS_ARRAY
IS_BOOLEAN
IS_FLOAT
IS_INTEGER
IS_NULL_VALUE
IS_OBJECT
IS_STRING
JQ
JSON_ARRAY
JSON_ARRAY_APPLY
JSON_ARRAY_DISTINCT
JSON_ARRAY_ELEMENTS
JSON_ARRAY_EXCEPT
JSON_ARRAY_FILTER
JSON_ARRAY_INSERT
JSON_ARRAY_INTERSECTION
JSON_ARRAY_MAP
JSON_ARRAY_OVERLAP
JSON_ARRAY_REDUCE
JSON_ARRAY_TRANSFORM
JSON_EACH
JSON_EXTRACT_PATH_TEXT
JSON_MAP_FILTER
JSON_MAP_TRANSFORM_KEYS
JSON_MAP_TRANSFORM_VALUES
JSON_OBJECT_DELETE
JSON_OBJECT_INSERT
JSON_OBJECT_KEEP_NULL
JSON_OBJECT_KEYS
JSON_OBJECT_PICK
JSON_PATH_EXISTS
JSON_PATH_MATCH
JSON_PATH_QUERY
JSON_PATH_QUERY_ARRAY
JSON_PATH_QUERY_FIRST
JSON_PRETTY
JSON_STRIP_NULLS
JSON_TO_STRING
JSON_TYPEOF
OBJECT_KEYS
PARSE_JSON
Sequence Functions
NEXTVAL
String Functions
ASCII
BIN
BIT_LENGTH
CHAR
CHAR_LENGTH
CHARACTER_LENGTH
CONCAT
CONCAT_WS
FROM_BASE64
FROM_HEX
HEX
INSERT
INSTR
JARO_WINKLER
LCASE
LEFT
LENGTH
LENGTH_UTF8
LIKE
LOCATE
LOWER
LPAD
LTRIM
MID
NOT LIKE
NOT REGEXP
NOT RLIKE
OCT
OCTET_LENGTH
ORD
POSITION
QUOTE
REGEXP
REGEXP_INSTR
REGEXP_LIKE
REGEXP_REPLACE
REGEXP_SUBSTR
REPEAT
REPLACE
REVERSE
RIGHT
RLIKE
RPAD
RTRIM
SOUNDEX
SOUNDS LIKE
SPACE
SPLIT
SPLIT_PART
STRCMP
System Functions
CLUSTERING_INFORMATION
FUSE_BLOCK
FUSE_COLUMN
FUSE_ENCODING
FUSE_SEGMENT
FUSE_SNAPSHOT
FUSE_STATISTIC
FUSE_TIME_TRAVEL_SIZE
Table Functions
GENERATE_SERIES
INFER_SCHEMA
INSPECT_PARQUET
LIST_STAGE
RESULT_SCAN
SHOW_GRANTS
STREAM_STATUS
TASK_HISTORY
Test Functions
SLEEP
UUID Functions
GEN_RANDOM_UUID
UUID
Window Functions
CUME_DIST
DENSE_RANK
FIRST
FIRST_VALUE
LAG
LAST
LAST_VALUE
LEAD
NTH_VALUE
NTILE
PERCENT_RANK
RANK
ROW_NUMBER
Lakehouse v2
Aggregate Functions
ANY_VALUE
APPROX_COUNT_DISTINCT
APPROX_TOP_K
AVG
BITMAP
BOOL_OR
CORR
COUNT
COUNT_IF
COVAR_POP
COVAR_SAMP
DS_HLL_ACCUMULATE
DS_HLL_COMBINE
DS_HLL_COUNT_DISTINCT
DS_HLL_ESTIMATE
DS_THETA_COUNT_DISTINCT
GROUP_CONCAT
GROUPING
GROUPING_ID
HLL_RAW_AGG
HLL_UNION
HLL_UNION_AGG
MANN_WHITNEY_U_TEST
MAX
MAX_BY
MIN
MIN_BY
MULTI_DISTINCT_COUNT
MULTI_DISTINCT_SUM
PERCENTILE_APPROX
PERCENTILE_APPROX_WEIGHT
PERCENTILE_CONT
PERCENTILE_DISC
PERCENTILE_DISC_LC
RETENTION
STD
STDDEV
STDDEV_POP
STDDEV_SAMP
SUM
SUM_MAP
VAR_POP
VAR_SAMP
VARIANCE
VARIANCE_POP
VARIANCE_SAMP
WINDOW_FUNNEL
Array Functions
ALL_MATCH
ANY_MATCH
ARRAY_AGG
ARRAY_APPEND
ARRAY_AVG
ARRAY_CONCAT
ARRAY_CONTAINS
ARRAY_CONTAINS_ALL
ARRAY_CONTAINS_SEQ
ARRAY_CUM_SUM
ARRAY_DIFFERENCE
ARRAY_DISTINCT
ARRAY_FILTER
ARRAY_FLATTEN
ARRAY_GENERATE
ARRAY_INTERSECT
ARRAY_JOIN
ARRAY_LENGTH
ARRAY_MAP
ARRAY_MAX
ARRAY_MIN
ARRAY_POSITION
ARRAY_REMOVE
ARRAY_REPEAT
ARRAY_SLICE
ARRAY_SORT
ARRAY_SORTBY
ARRAY_SUM
ARRAY_TO_BITMAP
ARRAY_TOP_N
ARRAY_UNIQUE_AGG
ARRAYS_OVERLAP
ARRAYS_ZIP
CARDINALITY
ELEMENT_AT
REVERSE
UNNEST
Binary Functions
FROM_BINARY
TO_BINARY
Bit Functions
BIT_SHIFT_LEFT
BIT_SHIFT_RIGHT
BIT_SHIFT_RIGHT_LOGICAL
BITAND
BITNOT
BITOR
BITXOR
Bitmap Functions
BASE64_TO_BITMAP
BITMAP_AGG
BITMAP_AND
BITMAP_ANDNOT
BITMAP_CONTAINS
BITMAP_COUNT
BITMAP_EMPTY
BITMAP_FROM_BINARY
BITMAP_FROM_STRING
BITMAP_HAS_ANY
BITMAP_HASH
BITMAP_HASH64
BITMAP_INTERSECT
BITMAP_MAX
BITMAP_MIN
BITMAP_OR
BITMAP_REMOVE
BITMAP_SUBSET_IN_RANGE
BITMAP_SUBSET_LIMIT
BITMAP_TO_ARRAY
BITMAP_TO_BASE64
BITMAP_TO_BINARY
BITMAP_TO_STRING
BITMAP_UNION
BITMAP_UNION_COUNT
BITMAP_UNION_INT
BITMAP_XOR
INTERSECT_COUNT
SUB_BITMAP
SUBDIVIDE_BITMAP
TO_BITMAP
UNNEST_BITMAP
Condition Functions
CASE
COALESCE
IF
IFNULL
NULLIF
Cryptographic Functions
AES_DECRYPT
AES_ENCRYPT
BASE64_DECODE_BINARY
BASE64_DECODE_STRING
FROM_BASE64
MD5
MD5SUM
MD5SUM_NUMERIC
SHA2
SM3
TO_BASE64
Date and Time Functions
ADD_MONTHS
ADDDATE
CONVERT_TZ
CURDATE
CURRENT_DATE
CURRENT_TIME
CURRENT_TIMESTAMP
CURRENT_TIMEZONE
CURTIME
DATE
DATE_ADD
DATE_DIFF
DATE_FORMAT
DATE_SLICE
DATE_SUB
DATE_TRUNC
DATEDIFF
DAY
DAYNAME
DAYOFMONTH
DAYOFWEEK
DAYOFWEEK_ISO
DAYOFYEAR
DAYS_ADD
DAYS_DIFF
DAYS_SUB
FROM_DAYS
FROM_UNIXTIME
HOUR
HOURS_ADD
HOURS_DIFF
HOURS_SUB
JODATIME_FORMAT
LAST_DAY
LOCALTIME
LOCALTIMESTAMP
MAKEDATE
MICROSECONDS_ADD
MICROSECONDS_SUB
MILLISECONDS_DIFF
MINUTE
MINUTES_ADD
MINUTES_DIFF
MINUTES_SUB
MONTH
MONTHNAME
MONTHS_ADD
MONTHS_DIFF
MONTHS_SUB
NEXT_DAY
Dictionary Functions
DICT_MAPPING
DICTIONARY_GET
Hash Functions
MURMUR_HASH3_32
XX_HASH3_128
XX_HASH3_64
JSON Functions
GET_JSON_BOOL
GET_JSON_DOUBLE
GET_JSON_INT
GET_JSON_OBJECT
GET_JSON_STRING
JSON_ARRAY
JSON_CONTAINS
JSON_EACH
JSON_EXISTS
JSON_KEYS
JSON_LENGTH
JSON_OBJECT
JSON_PRETTY
JSON_QUERY
JSON_REMOVE
JSON_SET
JSON_STRING
PARSE_JSON
TO_JSON
Map Functions
CARDINALITY
DISTINCT_MAP_KEYS
ELEMENT_AT
MAP_APPLY
MAP_CONCAT
MAP_FILTER
MAP_FROM_ARRAYS
MAP_KEYS
MAP_SIZE
MAP_VALUES
TRANSFORM_KEYS
TRANSFORM_VALUES
Math Functions
ABS
ACOS
ASIN
ATAN
ATAN2
BIN
CBRT
CEIL
CEILING
CONV
COS
COSH
COSINE_SIMILARITY
COSINE_SIMILARITY
COSINE_SIMILARITY_NORM
COT
DCEIL
DEGREES
DEXP
DFLOOR
DIVIDE
DLOG1
DLOG10
DPOW
DROUND
DSQRT
E
EXP
FLOOR
FMOD
FPOW
GREATEST
LEAST
LN
LOG
LOG10
LOG2
MOD
MULTIPLY
NEGATIVE
PI
PMOD
POSITIVE
POW
POWER
RADIANS
RAND
RANDOM
ROUND
SIGN
Meta Functions
GET_QUERY_DUMP
INSPECT_ALL_PIPES
INSPECT_HIVE_PART_INFO
INSPECT_MEMORY
INSPECT_MEMORY_DETAIL
INSPECT_MV_META
INSPECT_MV_PLAN
INSPECT_MV_REFRESH_INFO
INSPECT_MV_RELATIONSHIPS
INSPECT_RELATED_MV
INSPECT_TABLE_PARTITION_INFO
INSPECT_TASK_RUNS
LOOKUP_STRING
Pattern Matching Functions
LIKE
REGEXP
REGEXP_COUNT
REGEXP_EXTRACT
REGEXP_EXTRACT_ALL
REGEXP_REPLACE
Percentile Functions
PERCENTILE_APPROX_RAW
PERCENTILE_CONT
PERCENTILE_DISC
PERCENTILE_EMPTY
PERCENTILE_HASH
PERCENTILE_UNION
Scalar Functions
HLL_CARDINALITY
HLL_EMPTY
HLL_HASH
Spatial Functions
ST_ASTEXT
ST_CIRCLE
ST_CONTAINS
ST_DISTANCE_SPHERE
ST_GEOMETRYFROMTEXT
ST_LINEFROMTEXT
ST_POINT
ST_POLYGON
ST_X
ST_Y
String Functions
APPEND_TRAILING_CHAR_IF_ABSENT
ASCII
CHAR
CHAR_LENGTH
CHARACTER_LENGTH
CONCAT
CONCAT_WS
CRC32
ENDS_WITH
FIELD
FIND_IN_SET
FORMAT_BYTES
GROUP_CONCAT
HEX
HEX_DECODE_BINARY
HEX_DECODE_STRING
INET_ATON
INITCAP
INSTR
LCASE
LEFT
LENGTH
LOCATE
LOWER
LPAD
LTRIM
MONEY_FORMAT
NGRAM_SEARCH
NULL_OR_EMPTY
PARSE_URL
REGEXP_SPLIT
REPEAT
REPLACE
REVERSE
RIGHT
RPAD
RTRIM
SPACE
SPLIT
SPLIT_PART
STARTS_WITH
STR_TO_MAP
STRCMP
STRLEFT
STRPOS
STRRIGHT
SUBSTR
SUBSTRING
SUBSTRING_INDEX
TOKENIZE
Struct Functions
NAMED_STRUCT
ROW
Table Functions
FILES
GENERATE_SERIES
Utility Functions
BAR
CATALOG
COLUMN_COMPRESSED_SIZE
COLUMN_SIZE
CURRENT_ROLE
CURRENT_VERSION
CURRENT_WAREHOUSE
DATABASE
ENCODE_SORT_KEY
EQUIWIDTH_BUCKET
GET_QUERY_PROFILE
HOST_NAME
IS_ROLE_IN_SESSION
ISNOTNULL
ISNULL
LAST_QUERY_ID
SLEEP
UUID
UUID_NUMERIC
UUID_V7
UUID_V7_NUMERIC
VERSION
Variant Functions
VARIANT_GET
VARIANT_QUERY
VARIANT_TYPEOF
File Management
Adding New Document Accounts
Add AWS S3 Account
Add Google Cloud Storage Account
Add Wasabi Hot Storage Account
Add OneDrive Account
Add Azure Blob Storage Account
Add Azure Data Lake Gen2 Account
Add MinIO Account
Add Backblaze B2 Account
Add Cloudflare R2 Account
Add DigitalOcean Spaces Account
Add Linode Object Storage Account
Add Google Drive Account
Add SFTP Account
Add WebDAV Account
Add FTP Account
Account and Access Management
Control Document Account Access
Document Temporary Storage
Managing Document Account Backups
Managing Document Account Owners
Using Start Paths in Document Accounts
Using Document Accounts
How To
Selecting the Latest Record in a Large Version History Table
Identity and Access Management (IAM)
Overview
Organizations and Workspaces Explained
Viewing and Managing Workspaces
Managing Workspace Members
Managing Security Groups and Assignments
Member (User) Identity
Member Management
Member Authentication
Advanced Operations
Setting Up Auth0 SAML for Single Sign-On
Setting Up AWS IAM Identity Center SAML for Single Sign-On
Setting Up Google Workspace SAML for Single Sign-On
Setting Up Microsoft Entra ID SAML for Single Sign-On
Setting Up Okta SAML for Single Sign-On
Manage Organization Administrators
Managing Single Sign-On for Organization
Setting Member Expiration Period
Jupyter Notebooks and Command Line Interfaces
Jupyter Notebooks
Command Line
OAuth Tokens
Markdown Example Page
Panel Apps
Creating and Registering Panel Apps in Plaidcloud
Using Panel Apps in Plaidcloud
PlaidLink
PlaidLink Agents
Installation
Configure
Upgrade
PlaidXL
Installation
Connecting
Working with Data
Projects
Viewing Projects
Managing Projects
Managing Tables and Views
Managing Hierarchies
Managing Data Editors
Archive a Project
Viewing the Project Log
PySpark and Spark Compute Clusters
Getting Started with PySpark
Scheduled Workflows
Event Scheduler
Workflow Steps
Workflow Control Steps
Create Workflow
Run Workflow
Stop Workflow
Copy Workflow
Rename Workflow
Delete Workflow
Set Project Variable
Set Workflow Variable
Worklow Loop
Raise Workflow Error
Clear Workflow Log
Import Steps
Import Archive
Import CSV
Import Excel
Import External Database Tables
Import Fixed Width
Import Google BigQuery
Import Google Spreadsheet
Import HDF
Import HTML
Import JSON
Import Project Table
Import Quandl
Import SAS7BDAT
Import SPSS
Import SQL
Import Stata
Import XML
Import Alteryx YXDB
Import Parquet
Import Avro
Export Steps
Export to CSV
Export to Excel
Export to External Project Table
Export to Google Spreadsheet
Export to HDF
Export to HTML
Export to JSON
Export to Quandl
Export to SQL
Export to Table Archive
Export to XML
Table Steps
Table Anti Join
Table Append
Table Clear
Table Copy
Table Cross Join
Table Drop
Table Extract
Table Faker
Table In-Place Delete
Table In-Place Update
Table Inner Join
Table Lookup
Table Melt
Table Outer Join
Table Pivot
Table Union All
Table Union Distinct
Table Upsert
Dimension Steps
Dimension Clear
Dimension Create
Dimension Delete
Dimension Export
Dimension Load
Dimension Sort
Document Steps
Compress PDF
Concatenate Files
Convert Document Encoding
Convert Document Encoding to ASCII
Convert Document Encoding to UTF-8
Convert Document Encoding to UTF-16
Convert Image to PDF
Convert PDF or Image to JPEG
Copy Document Directory
Copy Document File
Create Document Directory
Crop Image to Headshot
Delete Document Directory
Delete Document File
Document Text Substitution
Fix File Extension
Merge Multiple PDFs
Rename Document Directory
Rename Document File
Notification Steps
Notify Distribution Group
Notify Agent
Notify Via Email
Notify Via Log
Notify via Microsoft Teams
Notify via Slack
Notify Via SMS
Notify Via Twitter
Notify Via Web Hook
Agent Steps
Agent Remote Execution of SQL
Agent Remote Export of SQL Result
Agent Remote Import Table into SQL Database
Document - Remote Delete File
Document - Remote Export File
Document - Remote Import File
Document - Remote Rename File
General Steps
Pass
Run Remote Python
User Defined Transform
Wait
PDF Reporting Steps
Report Single
Reports Batch
Common Step Operations
Advanced Data Mapper Usage
Allocation By Assignment Dimension
Allocation Split
Rule-Based Tagging
SAP ECC and S/4HANA Steps
Call SAP Financial Document Attachment
Call SAP General Ledger Posting
Call SAP Master Data Table RFC
Call SAP RFC
SAP PCM Steps
Create SAP PCM Model
Delete SAP PCM Model
Calculate PCM Model
Copy SAP PCM Model
Copy SAP PCM Period
Copy SAP PCM Version
Rename SAP PCM Model
Run SAP PCM Console Job
Run SAP PCM Hyper Loader
Stop PCM Model Calculation
Workflows
Where are the Workflows
Workflow Explorer
Create Workflow
Duplicate a Workflow
Copy & Paste steps
Change the order of steps in a workflow
Run a workflow
Running one step in a workflow
Running a range of steps in a workflow
Managing Step Errors
Continue on Error
Skip steps in a workflow
Conditional Step Execution
Controlling Parallel Execution
Manage Workflow Variables
Viewing Workflow Log
View Workflow Report
View a dependency audit
PlaidCloud Documentation
Expressions
Lakehouse v1
String Functions
SUBSTRING
SUBSTRING
Learn how to use SUBSTRING in PlaidCloud Lakehouse. Alias for the SUBSTR string function. Includes detailed syntax, examples, and usage reference.
Alias for
SUBSTR
.