Table functions (built in)

GoogleSQL for BigQuery supports built-in table functions.

This topic includes functions that produce columns of a table.You can only use these functions in theFROM clause.

Function list

NameSummary
APPENDS Returns all rows appended to a table for a given time range.
For more information, seeTime series functions.
CHANGES Returns all rows that have changed in a table for a given time range.
For more information, seeTime series functions.
EXTERNAL_OBJECT_TRANSFORM Produces an object table with the original columns plus one or more additional columns.
GAP_FILL Finds and fills gaps in a time series.
For more information, seeTime series functions.
RANGE_SESSIONIZE Produces a table of sessionized ranges.
For more information, seeRange functions.

EXTERNAL_OBJECT_TRANSFORM

EXTERNAL_OBJECT_TRANSFORM(TABLEobject_table_name,transform_types_array)

Description

This function returns a transformed object table with the original columns plusone or more additional columns, depending on thetransform_types valuesspecified.

This function only supportsobject tablesas inputs. Subqueries or any other types of tables aren't supported.

object_table_name is the name of the object table to be transformed, inthe formatdataset_name.object_table_name.

transform_types_array is an array ofSTRING literals. Currently, the onlysupportedtransform_types_array value isSIGNED_URL. SpecifyingSIGNED_URLcreates read-only signed URLs for the objects in the identified object table,which are returned in asigned_url column. Generated signed URLs arevalid for 6 hours.

Return Type

TABLE

Example

Run the following query to return URIs and signed URLs for the objects in themydataset.myobjecttable object table.

SELECTuri,signed_urlFROMEXTERNAL_OBJECT_TRANSFORM(TABLEmydataset.myobjecttable,['SIGNED_URL']);--Theprecedingstatementreturnsresultssimilartothefollowing:/*-----------------------------------------------------------------------------------------------------------------------------+ |  uri                                 | signed_url                                                                           | +-----------------------------------------------------------------------------------------------------------------------------+ | gs://myobjecttable/1234_Main_St.jpeg | https://storage.googleapis.com/mybucket/1234_Main_St.jpeg?X-Goog-Algorithm=1234abcd… | +-----------------------------------------------------------------------------------------------------------------------------+ | gs://myobjecttable/345_River_Rd.jpeg | https://storage.googleapis.com/mybucket/345_River_Rd.jpeg?X-Goog-Algorithm=2345bcde… | +-----------------------------------------------------------------------------------------------------------------------------*/

Except as otherwise noted, the content of this page is licensed under theCreative Commons Attribution 4.0 License, and code samples are licensed under theApache 2.0 License. For details, see theGoogle Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.

Last updated 2025-12-15 UTC.