{"id":"tables_query_export","name":"Tables Query Export","alias":"TablesQueryExport","aliases":[],"description_short":"Export BigQuery query results to CSV or Parquet and upload to GCS for download","description_long":"Export query results to CSV or Parquet format with compression (gz or zstd).\n    The query must be a single read-only statement: use tables_query to create\n    or remove catalog tables.\n    Always prefix tables with \"catalog.\" (ex: catalog.crawl_pages_20251201).\n    Give the user web_url. It works for users logged in to Botify with access to\n    the project. To fetch the file from a program, use temporary_url. It needs no\n    login and expires 15 minutes after the export.\n    ","description_tool_prompt":"Export query results to CSV or Parquet format with compression (gz or zstd). Give the user web_url. It works for users logged in to Botify with access to the project. To fetch the file from a program, use temporary_url. It needs no login and expires 15 minutes after the export.\nThe query must be a single read-only statement: use tables_query to create or remove catalog tables.\nAlways prefix tables with \"catalog.\" (ex: catalog.crawl_pages_20251201).\n\nCrawl tables exist in two flavours: SiteCrawler (catalog.crawl_pages_<crawl>) and AlertPanel (catalog.alert_panel_crawl_pages_<crawl>). AlertPanel crawls only cover a small subset of URLs, so use the SiteCrawler table by default - including when picking the most recent crawl - and only use an alert_panel_ table when AlertPanel data is explicitly requested.","source":null,"conversation_examples":[],"tags":[],"available_in_chat":false,"available_in_deepthink":false,"available_in_mcp":true,"mcp_audience":"all","config":{"type":"object","properties":{"bigquery_billing":{"default":"auto","description":"Who pays BigQuery for the query. 'botify': Botify runs it, and the data it scans is charged in credits. 'organization': it runs in your organization's own GCP project, configured by Botify, which Google bills directly; a flat fee per query is charged in credits instead of the scan. 'auto': your organization's project when one is configured, else Botify.","enum":["auto","botify","organization"],"title":"Bigquery Billing","type":"string"}},"required":[]},"item":{"type":"object","properties":{"query":{"description":"BigQuery SQL query to execute (a single SELECT statement)","title":"Query","type":"string"},"format":{"default":"csv","description":"Export format: csv or parquet","enum":["csv","parquet"],"title":"Format","type":"string"},"compression":{"default":"gz","description":"Compression type: gz or zstd","enum":["gz","zstd"],"title":"Compression","type":"string"},"max_rows":{"anyOf":[{"minimum":1,"type":"integer"},{"type":"null"}],"default":null,"description":"Maximum number of rows to export (no limit if null)","title":"Max Rows"}},"required":["query"]},"response":{"properties":{"download_url":{"description":"Original storage URL for the file","title":"Download Url","type":"string"},"web_url":{"description":"Download URL served by the Botify API. Open it in a browser while logged in to Botify with access to the project.","title":"Web Url","type":"string"},"temporary_url":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null,"description":"Download URL that needs no login, for a program that fetches the file. It expires 15 minutes after the export. Null when the URL could not be signed.","title":"Temporary Url"},"format":{"description":"Export format used","title":"Format","type":"string"},"compression":{"description":"Compression type used","title":"Compression","type":"string"},"row_count":{"description":"Number of rows exported","title":"Row Count","type":"integer"}},"required":["download_url","web_url","format","compression","row_count"],"title":"TablesQueryExportProcessedItem","type":"object"},"has_canvas":false,"open_canvas_automatically":false}