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.