Skip to main content

​
Overview

Google Cloud BigQuery data warehouse for analytics and machine learning. Through Langdock’s integration, you can access and manage BigQuery directly from your conversations.
Authentication: OAuth Category: Data & Analytics Availability: All workspace plans

​
Available Actions

​
List datasets

bigquery.list_datasets
Lists all datasets in a BigQuery project Requires Confirmation: No Parameters:
  • projectId (TEXT, Required): The Google Cloud project ID containing the datasets
Output: Returns the operation result

​
List tables

bigquery.list_tables
Lists all tables in a BigQuery dataset Requires Confirmation: No Parameters:
  • projectId (TEXT, Required): The Google Cloud project ID
  • datasetId (TEXT, Required): The dataset ID containing the tables
Output: Returns the operation result

​
Get table schema

bigquery.get_table_schema
Gets the schema information for a specific BigQuery table Requires Confirmation: No Parameters:
  • projectId (TEXT, Required): The Google Cloud project ID
  • datasetId (TEXT, Required): The dataset ID containing the table
  • tableId (TEXT, Required): The table ID to get schema information for
Output: Returns the operation result

​
Execute query

bigquery.execute_query
Executes a SQL query in BigQuery and returns the results Requires Confirmation: No Parameters:
  • projectId (TEXT, Required): The Google Cloud project ID to execute the query in
  • query (MULTI_LINE_TEXT, Required): The SQL query to execute in BigQuery
  • useLegacySql (BOOLEAN, Optional): Whether to use legacy SQL syntax (default: false for Standard SQL)
Output: Returns the operation result

​
Get table data

bigquery.get_table_data
Retrieves actual data rows from a BigQuery table Requires Confirmation: No Parameters:
  • projectId (TEXT, Required): The Google Cloud project ID
  • datasetId (TEXT, Required): The dataset ID containing the table
  • tableId (TEXT, Required): The table ID to retrieve data from
  • maxResults (NUMBER, Optional): Maximum number of rows to return (optional)
Output: Returns the operation result

​
Create dataset

bigquery.create_dataset
Creates a new dataset in BigQuery Requires Confirmation: No Parameters:
  • projectId (TEXT, Required): The Google Cloud project ID
  • datasetId (TEXT, Required): The ID for the new dataset
  • description (TEXT, Optional): Optional description for the dataset
  • location (TEXT, Optional): Geographic location for the dataset (e.g., US, EU)
Output: Returns the operation result

​
Create table

bigquery.create_table
Creates a new table in a BigQuery dataset Requires Confirmation: No Parameters:
  • projectId (TEXT, Required): The Google Cloud project ID
  • datasetId (TEXT, Required): The dataset ID to create the table in
  • tableId (TEXT, Required): The ID for the new table
  • description (TEXT, Optional): Optional description for the table
  • schema (MULTI_LINE_TEXT, Optional): Table schema as JSON array of field objects (optional)
Output: Returns the operation result

​
Insert table data

bigquery.insert_table_data
Inserts data rows into a BigQuery table Requires Confirmation: No Parameters:
  • projectId (TEXT, Required): The Google Cloud project ID
  • datasetId (TEXT, Required): The dataset ID containing the table
  • tableId (TEXT, Required): The table ID to insert data into
  • rows (MULTI_LINE_TEXT, Required): JSON array of row objects to insert
  • ignoreUnknownValues (BOOLEAN, Optional): Whether to ignore unknown values in the data
  • skipInvalidRows (BOOLEAN, Optional): Whether to skip rows that contain invalid data
Output: Returns the operation result

​
Get dataset info

bigquery.get_dataset_info
Gets detailed information about a BigQuery dataset Requires Confirmation: No Parameters:
  • projectId (TEXT, Required): The Google Cloud project ID
  • datasetId (TEXT, Required): The dataset ID to get information for
Output: Returns the operation result