array_concat
Examples:
examples.sql
Documentation Index
Fetch the complete documentation index at: /llms.txt
Use this file to discover all available pages before exploring further.
SDF is now a part of dbt Labs. Get live CTA previews, inline errors, and mesh support natively in the dbt platform. Learn more ยท Migrate to Fusion
array_concatSELECT ARRAY_CONCAT([1, 2], [3, 4], [5, 6]) as count_to_six; -- value '[1,2,3,4,5,6]'
function array_concat(array<$1>, ...) returns array<$1>
array_lengthfunction array_length(array<$1>) returns bigint
array_reversefunction array_reverse(array<$1>) returns array<$1>
array_to_stringfunction array_to_string(array<$1>, string) returns string
function array_to_string(array<$1>, string, string) returns string
generate_arrayfunction generate_array $1($1, $1) returns array<int>
where $1 in (bigint, double)
function generate_array $1($1, $1, $1) returns array<int>
where $1 in (bigint, double)
generate_date_arrayfunction generate_date_array(date, date) returns array[date]
function generate_date_array(date, date, interval) returns array[date]
generate_timestamp_arrayfunction generate_timestamp_array $1, $2($1, $2, interval) returns array<timestamp>
where $1 in (timestamp, string)
and $2 in (timestamp, string)