REST Resource: customers.tempTables

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),
  "columns": [
    {
      object(Column)
    }
  ]
}
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.

columns[]

object(Column)

A list of table columns.

QueryType

Query type.

Enums
QUERY_TYPE_UNSPECIFIED No query type specified.
ANALYSIS The table can be accessed through an AnalysisQuery.
USER_LIST The table can be accessed through a UserListQuery.

Methods

get

Retrieves the requested Ads Data Hub temp table.

list

Lists the Ads Data Hub temp tables that the customer has created.