REST Resource: customers.tempTables

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

  • Temp tables are accessible by queries of the same type, unless usableQueryTypes is explicitly set.

  • QueryType defines the type of query creating the table (Analysis, UserList, Special Endpoint).

  • Available methods include get to retrieve a specific table and list to view all created tables.

  • Temp tables store data temporarily and are defined by properties such as name, path, customer IDs, columns, creation time, and the operation that created them.

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.