Release Notes
Get Started
Clusters
Cloud Settings
- AWS
- Azure
Table Type
Query Data Lakes
- Catalog
- File external table
Integration
- Authenticate to AWS resources
- Authenticate to Azure cloud storage
- BI tools
- IDE tools
  - DataGrip
  - DBeaver
- Monitor with DataDog
Query Acceleration
- CBO
- Synchronous materialized view
- Asynchronous materialized view
- Colocate join
- Indexing
  - Bitmap indexing
  - Bloomfilter indexing
- Data Deduplication
  - Use Bitmap for exact count distinct
  - Use HLL for approximate count distinct
- Lateral join
Data Loading
- Concepts
  - Strict mode
- Batch load data from Amazon S3
- Batch load data from Azure cloud storage
- Load data from a local file system
- Load data from Confluent Cloud
  - Load data from Confluent Cloud through Routine Load
  - Load data from Confluent Cloud through Kafka connector
- Load data from Amazon MSK
- Load data from Amazon Kinesis
Data Unloading
- Unload data into AWS S3
Data Backup
- Back up and restore data with AWS S3
Security
- Console Access Control
- Data Access Control
- Application keys
- Service accounts
- Use SSL connection
Alarm
Usage and Billing
- Understand your usage
- Understand your billing
Organizations and Accounts
Reference
- Amazon Web Services (AWS)
- Microsoft Azure
- SQL Reference
- SQL Functions
  - Function list
  - Java UDFs
  - Window functions
  - Lambda expression
  - Date Functions
    - add_months
    - adddate
    - convert_tz
    - current_date
    - current_time
    - current_timestamp
    - date
    - date_add
    - date_diff
    - date_format
    - date_slice
    - date_sub, subdate
    - date_trunc
    - datediff
    - day
    - dayofweek_iso
    - dayname
    - dayofmonth
    - dayofweek
    - dayofyear
    - days_add
    - days_diff
    - days_sub
    - from_days
    - from_unixtime
    - hour
    - hours_add
    - hours_diff
    - hours_sub
    - jodatime_format
    - last_day
    - makedate
    - microseconds_add
    - microseconds_sub
    - minute
    - minutes_add
    - minutes_diff
    - minutes_sub
    - month
    - monthname
    - months_add
    - months_diff
    - months_sub
    - next_day
    - now
    - previous_day
    - quarter
    - second
    - seconds_add
    - seconds_diff
    - seconds_sub
    - str_to_date
    - str_to_jodatime
    - str2date
    - time_slice
    - time_to_sec
    - timediff
    - timestamp
    - timestampadd
    - timestampdiff
    - to_date
    - to_days
    - to_iso8601
    - to_tera_date
    - to_tera_timestamp
    - unix_timestamp
    - utc_timestamp
    - week
    - week_iso
    - weekofyear
    - weeks_add
    - weeks_diff
    - weeks_sub
    - year
    - years_add
    - years_diff
    - years_sub
  - Aggregate Functions
    - any_value
    - approx_count_distinct
    - array_agg
    - avg
    - bitmap
    - bitmap_agg
    - count
    - count_if
    - corr
    - covar_pop
    - covar_samp
    - group_concat
    - grouping
    - grouping_id
    - hll_empty
    - hll_hash
    - hll_raw_agg
    - hll_union
    - hll_union_agg
    - max
    - max_by
    - min
    - min_by
    - multi_distinct_sum
    - multi_distinct_count
    - percentile_approx
    - percentile_cont
    - percentile_disc
    - retention
    - stddev
    - stddev_samp
    - sum
    - variance, variance_pop, var_pop
    - var_samp
    - window_funnel
  - Geographic 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
    - ends_with
    - find_in_set
    - group_concat
    - hex
    - hex_decode_binary
    - hex_decode_string
    - instr
    - lcase
    - left
    - length
    - locate
    - lower
    - lpad
    - ltrim
    - money_format
    - null_or_empty
    - parse_url
    - repeat
    - replace
    - reverse
    - right
    - rpad
    - rtrim
    - space
    - split
    - split_part
    - substring_index
    - starts_with
    - strleft
    - strright
    - str_to_map
    - substring
    - trim
    - ucase
    - unhex
    - upper
    - url_decode
    - url_encode
  - Pattern Matching Functions
    - like
    - regexp
    - regexp_extract
    - regexp_extract_all
    - regexp_replace
  - JSON Functions
    - Overview of JSON functions and operators
    - JSON operators
    - JSON constructor functions
    - JSON query and processing functions
  - Bit Functions
    - bitand
    - bitnot
    - bitor
    - bitxor
    - bit_shift_left
    - bit_shift_right
    - bit_shift_right_logical
  - Bitmap Functions
    - bitmap_and
    - bitmap_or
    - bitmap_andnot
    - bitmap_xor
    - bitmap_contains
    - bitmap_empty
    - bitmap_has_any
    - bitmap_hash
    - bitmap_intersect
    - bitmap_max
    - bitmap_min
    - bitmap_union
    - bitmap_union_count
    - bitmap_remove
    - bitmap_to_array
    - bitmap_from_string
    - bitmap_to_string
    - to_bitmap
    - base64_to_bitmap
  - Array Functions
    - all_match
    - any_match
    - array_agg
    - array_append
    - array_avg
    - array_concat
    - array_contains
    - array_contains_all
    - array_cum_sum
    - array_difference
    - array_distinct
    - array_filter
    - array_generate
    - array_intersect
    - array_join
    - array_length
    - array_map
    - array_max
    - array_min
    - array_position
    - array_remove
    - array_slice
    - array_sort
    - array_sortby
    - array_sum
    - arrays_overlap
    - array_to_bitmap
    - cardinality
    - element_at
    - reverse
    - unnest
  - 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
  - Binary Functions
    - to_binary
    - from_binary
  - cast function
  - hash function
  - Cryptographic Functions
    - aes_encrypt
    - aes_decrypt
    - base64_decode_binary
    - base64_decode_string
    - from_base64
    - md5
    - md5sum
    - md5sum_numeric
    - sha2
    - sm3
    - to_base64
  - Math Functions
    - abs
    - acos
    - asin
    - atan
    - atan2
    - bin
    - ceil
    - ceiling
    - conv
    - cos
    - cosh
    - cosine_similarity
    - cosine_similarity_norm
    - cot
    - degrees
    - divide
    - e
    - exp
    - floor
    - fmod
    - greatest
    - least
    - ln
    - log
    - log2
    - log10
    - mod
    - multiply
    - negative
    - pi
    - pmod
    - positive
    - pow
    - radians
    - rand
    - round
    - sign
    - sin
    - sinh
    - sqrt
    - square
    - tan
    - tanh
    - truncate
  - Pattern Matching Functions
    - like
    - regexp
    - regexp_extract
    - regexp_extract_all
    - regexp_replace
  - Percentile Functions
    - percentile_approx_raw
    - percentile_empty
    - percentile_hash
    - percentile_union
  - Scalar Functions
    - hll_cardinality
  - Struct Functions
    - named_struct
    - row
  - Table Functions
    - files
    - generate_series
    - json_each
    - unnest
  - Utility Functions
    - catalog
    - current_role
    - current_version
    - database
    - host_name
    - isnull
    - isnotnull
    - last_query_id
    - sleep
    - uuid
    - uuid_numeric
    - version
- AUTO_INCREMENT
- Generated columns
- System variables
- System limits
- Information Schema
- System Metadatabase
API
- Overview
- Actions
  - Clusters
    - Create and Manage Clusters
    - Query Clusters
      - List clusters
      - Query status of a cluster
  - Identity and Access Management
    - Tokens
      - Create access token
    - Members and roles
  - Organization and Account
    - Get account list
  - Usage and Billing
Terraform Provider
- Introduction
- Deployment on AWS
- Deployment on Azure
Run scripts

triggers

triggers provides information about triggers.

The following fields are provided in triggers:

Field	Description
TRIGGER_CATALOG	The name of the catalog to which the trigger belongs. This value is always `def`.
TRIGGER_SCHEMA	The name of the database to which the trigger belongs.
TRIGGER_NAME	The name of the trigger.
EVENT_MANIPULATION	The trigger event. This is the type of operation on the associated table for which the trigger activates. The value is `INSERT` (a row was inserted), `DELETE` (a row was deleted), or `UPDATE` (a row was modified).
EVENT_OBJECT_CATALOG	Every trigger is associated with exactly one table. The catalog in which this table occurs.
EVENT_OBJECT_SCHEMA	Every trigger is associated with exactly one table. The database in which this table occurs.
EVENT_OBJECT_TABLE	The name of the table that the trigger is associated with.
ACTION_ORDER	The ordinal position of the trigger's action within the list of triggers on the same table with the same `EVENT_MANIPULATION` and `ACTION_TIMING` values.
ACTION_CONDITION	This value is always `NULL`.
ACTION_STATEMENT	The trigger body; that is, the statement executed when the trigger activates. This text uses UTF-8 encoding.
ACTION_ORIENTATION	This value is always `ROW`.
ACTION_TIMING	Whether the trigger activates before or after the triggering event. The value is `BEFORE` or `AFTER`.
ACTION_REFERENCE_OLD_TABLE	This value is always `NULL`.
ACTION_REFERENCE_NEW_TABLE	This value is always `NULL`.
ACTION_REFERENCE_OLD_ROW	The old column identifiers. The value is always `OLD`.
ACTION_REFERENCE_NEW_ROW	The new column identifiers. The value is always `NEW`.
CREATED	The date and time when the trigger was created. This is a `DATETIME(2)` value (with a fractional part in hundredths of seconds) for triggers.
SQL_MODE	The SQL mode in effect when the trigger was created, and under which the trigger executes.
DEFINER	The user named in the `DEFINER` clause (often the user who created the trigger).
CHARACTER_SET_CLIENT
COLLATION_CONNECTION
DATABASE_COLLATION	The collation of the database with which the trigger is associated.

In this article

triggers