{"id":"tables_load","name":"Tables Load","alias":"TablesLoad","aliases":[],"description_short":"Load a CSV or TSV file into the current project's editable BigQuery catalog","description_long":"Load a CSV or TSV file into the project's editable BigQuery catalog.\n\n    The file can be provided by a public HTTP(S) URL or Base64 content.\n    For a local file, upload it at https://app.botify.com/:organization/:project/o/storage/tmp and pass the returned URL as source_url.\n    \n    CSV/TSV files may be gzip compressed.\n    The operation fails when the destination table exists unless replace_existing is explicitly enabled.\n    ","description_tool_prompt":"Load a CSV or TSV file into the project's editable BigQuery catalog.\n\n    The file can be provided by a public HTTP(S) URL or Base64 content.\n    For a local file, upload it at https://app.botify.com/:organization/:project/o/storage/tmp and pass the returned URL as source_url.\n    \n    CSV/TSV files may be gzip compressed.\n    The operation fails when the destination table exists unless replace_existing is explicitly enabled.\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":"Destination table name in the editable catalog; must not match a managed table family","pattern":"^[A-Za-z_][A-Za-z0-9_]{0,1023}$","title":"Table Name","type":"string"},"table_description":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null,"description":"Optional BigQuery table description","title":"Table Description"},"source_url":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null,"description":"HTTP(S) URL of the source file. Temporary uploaded URLs on https://app.botify.com/:organization/:project/o/storage/tmp are allowed.","title":"Source Url"},"content_base64":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null,"description":"Base64-encoded file content. Prefer source_url for large files.","title":"Content Base64"},"format":{"$ref":"#/$defs/DelimitedFormat","default":"auto","description":"Delimited input format, or auto-detect from the filename"},"columns":{"anyOf":[{"items":{"$ref":"#/$defs/ColumnDefinition"},"type":"array"},{"type":"null"}],"default":null,"description":"Optional explicit BigQuery schema. When omitted, BigQuery infers the schema from the file header and rows.","title":"Columns"},"replace_existing":{"default":false,"description":"Replace an existing table. Disabled by default to prevent unintentional data loss.","title":"Replace Existing","type":"boolean"}},"required":["table_name"],"$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"},"DelimitedFormat":{"enum":["auto","csv","tsv"],"type":"string"}}},"response":{"properties":{"table_name":{"description":"Created or loaded table name","title":"Table Name","type":"string"},"rows_loaded":{"description":"Number of rows loaded","title":"Rows Loaded","type":"integer"},"format":{"description":"Detected file format","title":"Format","type":"string"},"replaced_existing":{"description":"Whether an existing table was replaced","title":"Replaced Existing","type":"boolean"}},"required":["table_name","rows_loaded","format","replaced_existing"],"title":"TablesLoadProcessedItem","type":"object"},"has_canvas":false,"open_canvas_automatically":false}