API_Request In-database Function Syntax | Google Cloud Vertex AI - API_Request In-database Function Syntax - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905
SELECT * FROM tapidb.API_Request(
    ON { table | view | (query) } AS InputTable
    USING
    AUTHORIZATION('{"key": "gcp vertex access token", 
                    ["region" : "gcp_region", 
                    "project" : "gcp_project_name"]}')
    ENDPOINT('vertex-ai endpoint name' | 'vertex-ai endpoint URL')
    [CONTENT_TYPE({'json' | 'csv' | 'json-with-keys'})]
    [API_TYPE('vertex-ai')]
    [KEY_START_INDEX('0')]
    [CONTENT_FORMAT('string to represent how the row should be formatted')]
) AS alias;