95 skills · sorted by relevance
Work with BigQuery to create datasets and tables, run SQL queries, ingest data, and manage processing jobs. The skill also covers connections to BigQuery ML and Gemini for machine learning and AI analysis.
Generate Python code to clean, transform, analyze, visualize, and model BigQuery data with BigQuery DataFrames. The skill keeps processing in the cloud and uses familiar table operations, with guidance for previews, schema checks, and machine learning.
Manage BigQuery datasets, tables, views, and jobs, and run SQL queries for basic data analysis. Provides setup examples and references for data ingestion, command-line operations, client libraries, access permissions, and infrastructure configuration.
Assess how changes, failures, or paused updates to a BigQuery table or view affect downstream assets. Trace data lineage, the relationships showing where data flows, and summarize dependent tables, dashboards, and processes with direct and indirect impacts.
Investigate failing or slow BigQuery jobs and unexpected cost increases. Compare execution details and resource usage with a normal baseline to isolate bottlenecks, identify likely causes, and determine practical remediation steps.
Convert Snowflake dbt SQL models to BigQuery through a bulk migration workflow. Preserve Jinja template logic while adapting configuration, explicit type conversions, JSON access, and deduplication patterns, with translated files saved in their directory structure.
Write SQL that uses BigQuery’s built-in machine learning and generative AI for forecasting, anomaly detection, identifying drivers of change, searching by meaning, and classifying or summarizing text stored in your data.
Review Python and BigQuery pipelines for excessive costs, duplicate writes on reruns, and hard-to-diagnose failures. Receive a structured assessment with specific function and line references, prioritized fixes, and rough estimates of the largest cost risks.
Set up monitoring for deployed agents to inspect execution paths, latency, and model interactions. It explains Cloud Trace, prompt and response logging, BigQuery analytics, and external monitoring integrations, with checks for missing data and unwanted content capture.
Analyzes the downstream impact (blast radius) when a BigQuery table or view is broken, stale, or modified. Identifies all downstream tables, dashboards, and processes that will be affected. Use when: - Performing a blast radius or impact analysis for a BigQuery table or view. - Assessing the consequences of modifying, deleting, or pausing updates to a BigQuery asset. - Identifying downstream dependencies (tables, dashboards, processes) of a BigQuery asset. Don't use for: - General BigQuery querying or data analysis (use BigQuery-related tools instead). - Non-BigQuery assets (e.g., Cloud Storage files) unless they are part of the BigQuery lineage. - Creating or modifying lineage links directly.
The English summary is being prepared. Showing the original description.
Analyzes Google Cloud BigQuery slot consumption, query costs, and execution bottlenecks using INFORMATION_SCHEMA. Use when diagnosing slow BigQuery queries, slot starvation, high on-demand query costs, unpartitioned table scans, or join performance issues. Don't use for generic BigQuery administration (use bigquery-basics), BigQuery ML (use bigquery-ai-ml), or DataFrame operations (use bigquery-bigframes).
The English summary is being prepared. Showing the original description.
Evaluate Google Cloud workloads against built-in best practices or custom organizational rules using Workload Manager. Use public client libraries or the REST API to run checks, review violations and scanned resources, and export results to BigQuery.
Trace where BigQuery and Cloud Storage data comes from and where it goes. The skill summarizes table or column lineage, meaning data origins and movement, in a readable Markdown report to support data quality investigations.
Answers questions about GKE spending using BigQuery billing exports and live cluster metrics. It breaks down costs by project, namespace, or workload and compares requested computing resources with actual usage to investigate cost increases.
Retrieve BigQuery execution records and resource metrics using the right tool for each task. The skill guides monitoring tool selection and SQL queries for performance investigations, capacity analysis, and reviews of billable compute and storage usage.
Review BigQuery capacity, table layouts, storage retention, and SQL to improve cost efficiency. Compare billing options, plan partitioned tables, and evaluate search indexes, stored aggregation results, and BI Engine for suitable workloads.
Manages datasets, tables, and jobs in BigQuery, and integrates with BigQuery ML and Gemini for advanced data analytics and AI-driven insights. Use when you need to interact with BigQuery, run SQL queries, manage BigQuery resources, or leverage BigQuery's built-in ML capabilities. Also use when performing data analysis, ingesting data into BigQuery, or developing AI applications on BigQuery.
The English summary is being prepared. Showing the original description.
Create a BigQuery materialization to stream Estuary collections into BigQuery tables. Use when setting up BigQuery as a destination for captured data. Use when user says "send to BigQuery", "load into BigQuery", "materialize to BigQuery", or "BigQuery destination".
The English summary is being prepared. Showing the original description.
Design Google Cloud infrastructure around application needs, scale, and budget. Get service recommendations, cost estimates, infrastructure configuration files, and deployment guidance, with support for automated delivery and security configuration reviews.
Write and improve SQL for major data warehouses, accounting for differences in their syntax. Use it to build analytical queries, translate existing SQL, investigate errors, and review slow queries for performance improvements.
Generates Python code using BigQuery DataFrames (BigFrames), the pandas/scikit-learn-style API over BigQuery. Use when writing BigFrames code or doing pandas-style dataframe/ML work against BigQuery (e.g. in a notebook). Don't use for SQL-first workflows or the google-cloud-bigquery client library — use bigquery-basics.
The English summary is being prepared. Showing the original description.
Design a shared data platform across Google Cloud, AWS, and Azure for analytics and AI. The skill turns requirements into architecture diagrams, infrastructure code, deployment instructions, and validation checks using Apache Iceberg and BigQuery data agents.
GCPプロジェクト単位でBigQuery認証を設定するスキル。 gcloud設定プロファイルで複数プロジェクトを安全に分離管理。 「BigQueryに繋ぎたい」「BQ認証」「gcloud認証」「データ分析の認証設定」等のリクエストで発動。
The English summary is being prepared. Showing the original description.
Interleave layer bridging the BigQuery cluster to plurigrid/asi. Routes BigQuery queries through asi's DuckDB stack, wires patent search into asi knowledge graph, connects Looker Studio dashboards to CatColab, and feeds BigQuery ML into the lolita physics emulation pipeline.
The English summary is being prepared. Showing the original description.