This is legacy documentation, and may not be complete. To see the latest documentation, if you are a marketer, refer to theMarketerssite. If you are a measurement partner, refer to theMeasurement Partnerssite.
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.
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]
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Missing the information I need","missingTheInformationINeed","thumb-down"],["Too complicated / too many steps","tooComplicatedTooManySteps","thumb-down"],["Out of date","outOfDate","thumb-down"],["Samples / code issue","samplesCodeIssue","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2024-09-18 UTC."],[[["\u003cp\u003eAds Data Hub temp tables are created using \u003ccode\u003eCREATE TABLE temp_table AS (...)\u003c/code\u003e and remain active for 72 hours.\u003c/p\u003e\n"],["\u003cp\u003eTemp tables are accessible by queries of the same type, unless \u003ccode\u003eusableQueryTypes\u003c/code\u003e is explicitly set.\u003c/p\u003e\n"],["\u003cp\u003e\u003ccode\u003eQueryType\u003c/code\u003e defines the type of query creating the table (Analysis, UserList, Special Endpoint).\u003c/p\u003e\n"],["\u003cp\u003eAvailable methods include \u003ccode\u003eget\u003c/code\u003e to retrieve a specific table and \u003ccode\u003elist\u003c/code\u003e to view all created tables.\u003c/p\u003e\n"],["\u003cp\u003eTemp tables store data temporarily and are defined by properties such as name, path, customer IDs, columns, creation time, and the operation that created them.\u003c/p\u003e\n"]]],["Temp tables are defined within Ads Data Hub queries using `CREATE TABLE temp_table AS (...)`. They remain active for 72 hours. Key information includes the table's `name`, `tablePath`, associated customer IDs, `queryType`, accessible `usableQueryTypes`, `columns`, `createTime`, and the creating `operation`. The `queryType` can be `ANALYSIS`, `USER_LIST`, or `SPECIAL_ENDPOINT`, and this will restrict table accessibility unless `usableQueryTypes` is specified. Methods available are `get` to retrieve a temp table and `list` to enumerate created tables.\n"],null,["# REST Resource: customers.tempTables\n\n- [Resource: TempTable](#TempTable)\n - [JSON representation](#TempTable.SCHEMA_REPRESENTATION)\n- [QueryType](#QueryType)\n- [Methods](#METHODS_SUMMARY)\n\nResource: TempTable\n-------------------\n\nDefines 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.\n\n| JSON representation |\n|---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|\n| ``` { \"name\": string, \"tablePath\": string, \"adsDataCustomerId\": string, \"matchDataCustomerId\": string, \"queryType\": enum (/ads-data-hub/reference/rest/v1/customers.tempTables#QueryType), \"usableQueryTypes\": [ enum (/ads-data-hub/reference/rest/v1/customers.tempTables#QueryType) ], \"columns\": [ { object (/ads-data-hub/reference/rest/v1/Column) } ], \"createTime\": string, \"operation\": string } ``` |\n\n| Fields ||\n|-----------------------|---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|\n| `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. |\n| `tablePath` | `string` Fully qualified table path, e.g. 'tmp.table' |\n| `adsDataCustomerId` | `string (`[int64](https://developers.google.com/discovery/v1/type-format)` format)` Linked Ads Data Hub customer ID used when executing the original temp table query. |\n| `matchDataCustomerId` | `string (`[int64](https://developers.google.com/discovery/v1/type-format)` format)` Linked Ads Data Hub customer ID used when executing the original temp table query. |\n| `queryType` | `enum (`[QueryType](/ads-data-hub/reference/rest/v1/customers.tempTables#QueryType)`)` Type of query that created the table. Temp tables are only accessible to to queries of the same type unless usableQueryTypes is set. |\n| `usableQueryTypes[]` | `enum (`[QueryType](/ads-data-hub/reference/rest/v1/customers.tempTables#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. |\n| `columns[]` | `object (`[Column](/ads-data-hub/reference/rest/v1/Column)`)` A list of table columns. |\n| `createTime` | `string (`[Timestamp](https://developers.google.com/protocol-buffers/docs/reference/google.protobuf#google.protobuf.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\"`. |\n| `operation` | `string` Operation that created the temp table. It has the form operations/\\[jobId\\] |\n\nQueryType\n---------\n\nQuery type.\n\n| Enums ||\n|--------------------------|------------------------------------------|\n| `QUERY_TYPE_UNSPECIFIED` | No query type specified. |\n| `ANALYSIS` | An AnalysisQuery. |\n| `USER_LIST` | A UserListQuery. |\n| `SPECIAL_ENDPOINT` | A query triggered by a special endpoint. |\n\n| Methods ------- ||\n|-----------------------------------------------------------------------|-------------------------------------------------------------------|\n| ### [get](/ads-data-hub/reference/rest/v1/customers.tempTables/get) | Retrieves the requested Ads Data Hub temp table. |\n| ### [list](/ads-data-hub/reference/rest/v1/customers.tempTables/list) | Lists the Ads Data Hub temp tables that the customer has created. |"]]
