Stay organized with collections Save and categorize content based on your preferences.
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 the FROM clause.
EXTERNAL_OBJECT_TRANSFORM
EXTERNAL_OBJECT_TRANSFORM(TABLE object_table_name, transform_types_array)
Description
This function returns a transformed object table with the original columns plus one or more additional columns, depending on the transform_types values specified.
This function only supports object tables as inputs. Subqueries or any other types of tables aren't supported.
object_table_name is the name of the object table to be transformed, in the format dataset_name.object_table_name.
transform_types_array is an array of STRING literals. Currently, the only supported transform_types_array value is SIGNED_URL. Specifying SIGNED_URL creates read-only signed URLs for the objects in the identified object table, which are returned in a signed_url column. Generated signed URLs are valid for 6 hours.
Return Type
TABLE
Example
Run the following query to return URIs and signed URLs for the objects in the mydataset.myobjecttable object table.
SELECT uri, signed_url
FROM EXTERNAL_OBJECT_TRANSFORM(TABLE mydataset.myobjecttable, ['SIGNED_URL']);
--The preceding statement returns results similar to the following:
/*-----------------------------------------------------------------------------------------------------------------------------*
| 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 the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2025-08-07 UTC.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-08-07 UTC."],[[["GoogleSQL for BigQuery supports built-in table functions that produce columns of a table and can only be used in the `FROM` clause."],["The `EXTERNAL_OBJECT_TRANSFORM` function produces a transformed object table with additional columns, supporting only object tables as inputs."],["`EXTERNAL_OBJECT_TRANSFORM` can generate read-only signed URLs for objects within the table, accessible in a `signed_url` column, which are valid for six hours."],["The table functions `APPENDS`, `CHANGES`, `GAP_FILL` and `RANGE_SESSIONIZE` are available for use, and are categorized respectively as time series and range functions."]]],[]]
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4