REST Resource: customers.tempTables

Stay organized with collections Save and categorize content based on your preferences.

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.