BigQuery

Tools · 5

• query Execute read-only (SELECT) BigQuery SQL queries with configurable maximum results and bytes billed, and security checks to prevent non-SELECT queries
• list_all_datasets List all datasets in the project, returning an array of dataset IDs
• list_all_tables_with_dataset List all tables in a specific dataset with their schemas, requiring a datasetId parameter, and returning table IDs, schemas, time partitioning information, and descriptions
• get_table_information Get table schema and sample data (up to 20 rows) with support for partitioned tables and partition filters, including warnings for queries on partitioned tables without filters
• dry_run_query Check query validity and estimate cost without execution, returning processing size and estimated cost