REST Resource: customers.tempTables

    • Temp tables in Ads Data Hub are created using CREATE TABLE temp_table AS (...) and remain active for 72 hours.

    • Temp tables have a JSON representation including fields such as name, tablePath, customer IDs, queryType, usableQueryTypes, columns, createTime, and operation.

    • The queryType defines the type of query that created the table, with possible values including ANALYSIS, USER_LIST, and SPECIAL_ENDPOINT.

    • Methods available for temp tables include get to retrieve a specific table and list to list all temp tables created by a customer.

    Resource: TempTable

    Defines a temp table created by an Ads Data Hub query. Temp tables are created using CREATE TABLE temp_table AS (...) in an Ads Data Hub query. Temp tables remain active for 72 hours before needing to be refreshed.

    JSON representation 
     { 
 "name" 
 : 
 string 
 , 
 "tablePath" 
 : 
 string 
 , 
 "adsDataCustomerId" 
 : 
 string 
 , 
 "matchDataCustomerId" 
 : 
 string 
 , 
 "queryType" 
 : 
 enum (  QueryType 
 
) 
 , 
 "usableQueryTypes" 
 : 
 [ 
 enum (  QueryType 
 
) 
 ] 
 , 
 "columns" 
 : 
 [ 
 { 
 object (  Column 
 
) 
 } 
 ] 
 , 
 "createTime" 
 : 
 string 
 , 
 "operation" 
 : 
 string 
 }
    Fields
    name

    string

    Name that uniquely identifies a table. It has the form customers/[customerId]/tempTables/[resource_id]. The resource ID is generated by the server.
    tablePath

    string

    Fully qualified table path, e.g. 'tmp.table'
    adsDataCustomerId

    string ( int64 format)

    Linked Ads Data Hub customer ID used when executing the original temp table query.
    matchDataCustomerId

    string ( int64 format)

    Linked Ads Data Hub customer ID used when executing the original temp table query.
    queryType

    enum ( QueryType )

    Type of query that created the table. Temp tables are only accessible to to queries of the same type unless usableQueryTypes is set.
    usableQueryTypes[]

    enum ( QueryType )

    Types of queries that can access this temp table. If empty, this temp table is only accessible to queries of the same type as its queryType.
    columns[]

    object ( Column )

    A list of table columns.
    createTime

    string ( Timestamp format)

    Timestamp when the temp table is created, in micros.

    A timestamp in RFC3339 UTC "Zulu" format, with nanosecond resolution and up to nine fractional digits. Examples: "2014-10-02T15:01:23Z" and "2014-10-02T15:01:23.045123456Z" .
    operation

    string

    Operation that created the temp table. It has the form operations/[jobId]

    QueryType

    Query type.

    Enums
    QUERY_TYPE_UNSPECIFIED No query type specified.
    ANALYSIS An AnalysisQuery.
    USER_LIST A UserListQuery.
    SPECIAL_ENDPOINT A query triggered by a special endpoint.

    Methods

    get

    		Retrieves the requested Ads Data Hub temp table.

    list

    		Lists the Ads Data Hub temp tables that the customer has created.
    Design a Mobile Site
    View Site in Mobile | Classic
    Share by: