Skip to main content
Documentation
Technology areas
close
AI and ML
Application development
Application hosting
Compute
Data analytics and pipelines
Databases
Distributed, hybrid, and multicloud
Generative AI
Industry solutions
Networking
Observability and monitoring
Security
Storage
Cross-product tools
close
Access and resources management
Costs and usage management
Google Cloud SDK, languages, frameworks, and tools
Infrastructure as code
Migration
Related sites
close
Google Cloud Home
Free Trial and Free Tier
Architecture Center
Blog
Contact Sales
Google Cloud Developer Center
Google Developer Center
Google Cloud Marketplace
Google Cloud Marketplace Documentation
Google Cloud Skills Boost
Google Cloud Solution Center
Google Cloud Support
Google Cloud Tech Youtube Channel
/
English
Deutsch
Español – América Latina
Français
Indonesia
Italiano
Português – Brasil
中文 – 简体
日本語
한국어
Console
Sign in
BigQuery
Guides
Reference
Samples
Resources
Contact Us
Start free
Documentation
Guides
Reference
Samples
Resources
Technology areas
More
Cross-product tools
More
Related sites
More
Console
Contact Us
Start free
Quotas and limits
Quotas and limits reference
Troubleshoot quota errors
BigQuery command-line tool
bq command-line tool reference
SQL in BigQuery
GoogleSQL reference
Query syntax
Pipe syntax
General reference
Data types
Lexical structure and syntax
Conversion rules
Format elements
Collation
Text analysis
Expressions
Function calls
Aggregate function calls
Window function calls
Operators
Conditional expressions
Subqueries
Functions
All functions
AEAD encryption functions
Overview
AEAD.DECRYPT_BYTES
AEAD.DECRYPT_STRING
AEAD.ENCRYPT
DETERMINISTIC_DECRYPT_BYTES
DETERMINISTIC_DECRYPT_STRING
DETERMINISTIC_ENCRYPT
KEYS.ADD_KEY_FROM_RAW_BYTES
KEYS.KEYSET_CHAIN
KEYS.KEYSET_FROM_JSON
KEYS.KEYSET_LENGTH
KEYS.KEYSET_TO_JSON
KEYS.NEW_KEYSET
KEYS.NEW_WRAPPED_KEYSET
KEYS.REWRAP_KEYSET
KEYS.ROTATE_KEYSET
KEYS.ROTATE_WRAPPED_KEYSET
Aggregate functions
Overview
ANY_VALUE
ARRAY_AGG
ARRAY_CONCAT_AGG
AVG
BIT_AND
BIT_OR
BIT_XOR
COUNT
COUNTIF
GROUPING
LOGICAL_AND
LOGICAL_OR
MAX
MAX_BY
MIN
MIN_BY
STRING_AGG
SUM
Approximate aggregate functions
Overview
APPROX_COUNT_DISTINCT
APPROX_QUANTILES
APPROX_TOP_COUNT
APPROX_TOP_SUM
Array functions
Overview
ARRAY
ARRAY_CONCAT
ARRAY_FIRST
ARRAY_LAST
ARRAY_LENGTH
ARRAY_REVERSE
ARRAY_SLICE
ARRAY_TO_STRING
GENERATE_ARRAY
GENERATE_DATE_ARRAY
GENERATE_TIMESTAMP_ARRAY
Bit functions
Overview
BIT_COUNT
Conversion functions
Overview
CAST
PARSE_BIGNUMERIC
PARSE_NUMERIC
SAFE_CAST
Date functions
Overview
CURRENT_DATE
DATE
DATE_ADD
DATE_DIFF
DATE_FROM_UNIX_DATE
DATE_SUB
DATE_TRUNC
EXTRACT (date)
FORMAT_DATE
LAST_DAY (date)
PARSE_DATE
UNIX_DATE
Datetime functions
Overview
CURRENT_DATETIME
DATETIME
DATETIME_ADD
DATETIME_DIFF
DATETIME_SUB
DATETIME_TRUNC
EXTRACT (datetime)
FORMAT_DATETIME
LAST_DAY (datetime)
PARSE_DATETIME
Debugging functions
Overview
ERROR
Differentially private aggregate functions
Overview
AVG (DIFFERENTIAL_PRIVACY)
COUNT (DIFFERENTIAL_PRIVACY)
PERCENTILE_CONT (DIFFERENTIAL_PRIVACY)
SUM (DIFFERENTIAL_PRIVACY)
Federated query functions
Overview
EXTERNAL_QUERY
DLP encryption functions
Overview
DLP_DETERMINISTIC_ENCRYPT
DLP_DETERMINISTIC_DECRYPT
DLP_KEY_CHAIN
Geography functions
Overview