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 (ADH) temp tables are created within ADH queries and persist for 72 hours.\u003c/p\u003e\n"],["\u003cp\u003eTemp tables are accessible to queries of the same type or those specified in \u003ccode\u003eusableQueryTypes\u003c/code\u003e.\u003c/p\u003e\n"],["\u003cp\u003eADH supports three query types: \u003ccode\u003eANALYSIS\u003c/code\u003e, \u003ccode\u003eUSER_LIST\u003c/code\u003e, and \u003ccode\u003eSPECIAL_ENDPOINT\u003c/code\u003e.\u003c/p\u003e\n"],["\u003cp\u003eDevelopers can manage temp tables using the \u003ccode\u003eget\u003c/code\u003e and \u003ccode\u003elist\u003c/code\u003e methods provided by the ADH API.\u003c/p\u003e\n"]]],["Temp tables, defined by Ads Data Hub queries using `CREATE TABLE`, remain active for 72 hours. These tables have a unique `name` and `tablePath`, linked to Ads Data Hub customer IDs. The `queryType` determines table accessibility, with `usableQueryTypes` expanding it. Key data includes `columns`, `createTime`, and the `operation` that created them. Available methods are `get` to retrieve a specific table and `list` to show all customer-created temp tables. The `QueryType` can be `ANALYSIS`, `USER_LIST`, or `SPECIAL_ENDPOINT`.\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/marketers/reference/rest/v1/customers.tempTables#QueryType), \"usableQueryTypes\": [ enum (/ads-data-hub/marketers/reference/rest/v1/customers.tempTables#QueryType) ], \"columns\": [ { object (/ads-data-hub/marketers/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/marketers/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/marketers/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/marketers/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/marketers/reference/rest/v1/customers.tempTables/get) | Retrieves the requested Ads Data Hub temp table. |\n| ### [list](/ads-data-hub/marketers/reference/rest/v1/customers.tempTables/list) | Lists the Ads Data Hub temp tables that the customer has created. |"]]