{"id":"tables_create","name":"Tables Create","alias":"TablesCreate","aliases":[],"description_short":"Agent that creates a BigQuery table in the customer's catalog dataset","description_long":"Create a new table in the project's catalog.\n    Provide a table name and a list of column definitions (name, type, mode, description).\n    ","description_tool_prompt":"Create a new table in the project's catalog.\n    Provide a table name and a list of column definitions (name, type, mode, description).\n    ","source":null,"conversation_examples":[],"tags":[],"available_in_chat":false,"available_in_deepthink":false,"available_in_mcp":true,"mcp_audience":"all","config":{"type":"object","properties":{},"required":[]},"item":{"type":"object","properties":{"table_name":{"description":"Name of the table to create (will be prefixed with the project catalog and must not match a managed table family)","title":"Table Name","type":"string"},"columns":{"description":"List of column definitions for the table","items":{"$ref":"#/$defs/ColumnDefinition"},"title":"Columns","type":"array"},"ttl_hours":{"anyOf":[{"type":"number"},{"type":"null"}],"default":null,"description":"Optional time-to-live in hours. If set, the table will be automatically deleted after this duration.","title":"Ttl Hours"}},"required":["table_name","columns"],"$defs":{"ColumnDefinition":{"description":"Definition of a column in the table.","properties":{"name":{"description":"Name of the column","title":"Name","type":"string"},"type":{"description":"BigQuery column type","enum":["STRING","BYTES","INTEGER","INT64","FLOAT","FLOAT64","NUMERIC","BIGNUMERIC","BOOLEAN","BOOL","TIMESTAMP","DATE","TIME","DATETIME","GEOGRAPHY","RECORD","STRUCT","JSON"],"title":"Type","type":"string"},"mode":{"default":"NULLABLE","description":"Column mode","enum":["NULLABLE","REQUIRED","REPEATED"],"title":"Mode","type":"string"},"description":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null,"description":"Optional description of the column","title":"Description"},"fields":{"anyOf":[{"items":{"$ref":"#/$defs/ColumnDefinition"},"type":"array"},{"type":"null"}],"default":null,"description":"Nested fields for RECORD type columns","title":"Fields"}},"required":["name","type"],"title":"ColumnDefinition","type":"object"}}},"response":{"properties":{"table_name":{"description":"Name of the created table","title":"Table Name","type":"string"},"created":{"description":"Whether the table was created","title":"Created","type":"boolean"},"message":{"description":"Status message","title":"Message","type":"string"}},"required":["table_name","created","message"],"title":"TablesCreateProcessedItem","type":"object"},"has_canvas":false,"open_canvas_automatically":false}