Community연구 & 데이터 분석github.com

google/bigquery-basics

BigQuery에서 데이터셋, 테이블, 작업을 관리하고 BigQuery ML 및 Gemini와 통합하여 고급 데이터 분석 및 AI 기반 인사이트를 제공합니다. BigQuery와 상호작용하거나, SQL 쿼리를 실행하거나, BigQuery 리소스를 관리하거나, BigQuery의 내장 ML 기능을 활용해야 할 때 사용하세요. 데이터 분석, BigQuery로 데이터 수집, 또는 BigQuery에서 AI 애플리케이션을 개발할 때도 사용합니다.

bigquery-basics란 무엇인가요?

이 스킬은 Google Cloud의 BigQuery 서비스와의 상호작용을 자동화합니다. BigQuery는 대규모 데이터 웨어하우스로서, 이를 통해 데이터셋 생성 및 관리, 테이블 정의, SQL 쿼리 실행, 배치/스트리밍 로드 작업을 수행할 수 있습니다. 또한 BigQuery ML을 활용해 SQL만으로 머신러닝 모델을 생성 및 평가하고, Gemini 모델을 통해 텍스트 분석이나 임베딩 생성 같은 고급 AI 기능을 통합합니다. 주로 Claude Code, Cursor, Codex 등 터미널 기반 AI 코딩 에이전트에서 실행되며, `bq` CLI나 BigQuery API를 자동으로 호출하여 데이터 분석, ETL, ML 워크플로우를 간소화합니다. 데이터 엔지니어나 AI 개발자에게 유용하며, 대규모 데이터 세트를 다루는 작업을 효율적으로 처리할 수 있게 해줍니다.

지원 대상~Claude Code~Codex CLI~Cursor✓Gemini CLI
npx skills add https://github.com/google/skills/tree/main/skills/bigquery-basics

Installed? Explore more 연구 & 데이터 분석 skills: affaan-m/uspto-database, affaan-m/scholar-evaluation, affaan-m/literature-review · View all 6 →

즐겨 사용하는 AI에게 물어보기

이 에이전트 스킬이 미리 로드된 새 채팅을 엽니다.

문서

bigquery-basics은(는) 무엇을 하나요?

BigQuery에서 데이터셋, 테이블, 작업을 관리하고 BigQuery ML 및 Gemini와 통합하여 고급 데이터 분석 및 AI 기반 인사이트를 제공합니다. BigQuery와 상호작용하거나, SQL 쿼리를 실행하거나, BigQuery 리소스를 관리하거나, BigQuery의 내장 ML 기능을 활용해야 할 때 사용하세요. 데이터 분석, BigQuery로 데이터 수집, 또는 BigQuery에서 AI 애플리케이션을 개발할 때도 사용합니다.

Individual skills in this repo

This repo contains 18 individual skills — each has its own dedicated page.

google/agent-platform-skill-registry

Interact with the Gemini Enterprise Agent Platform Skill Registry to create and search for available skills. Use this skill to enable agents to register functionality or discover new capabilities.

google/alloydb-basics

Manages clusters, instances, and backups for AlloyDB for PostgreSQL, and integrates with AlloyDB model context protocol (MCP) tools for automated database operations.

google/cloud-run-basics

Manages Cloud Run services, jobs, and worker pools. Use when you need to deploy applications responding to HTTP requests (services), run event-triggered or scheduled tasks (jobs), or handle always-on pull-based background processing (worker pools).

google/cloud-sql-basics

This file generates or explains Cloud SQL resources. Use this file when the user asks to create a Cloud SQL instance or database for MySQL, PostgreSQL, or SQL Server. Cloud SQL manages third-party MySQL, PostgreSQL, and SQL Server instances as resources in Cloud SQL. For example, when Cloud SQL creates an open-source MySQL instance, the resulting resource is a Cloud SQL for MySQL instance that Google Cloud manages. Cloud SQL handles backups, high availability, and secure connectivity for relational database workloads.

google/firebase-basics

Use this skill whenever you are working on a project that uses Firebase products or services, especially for mobile or web apps.

google/gemini-api

Use when the user asks about using Gemini in an enterprise environment or explicitly mentions Vertex AI, Google Cloud, or Agent Platform. Guides the usage of the Gemini API on Agent Platform with the Google Gen AI SDK. Covers SDK usage (Python, JS/TS, Go, Java, C#), capabilities like multimodal inputs, tools, media generation, caching, batch prediction, and Live API.

google/gemini-interactions-api

Guides the usage of Gemini Interactions API on Gemini Enterprise Agent Platform. Use when the user wants to use the stateful, server-managed Interactions API for multi-turn conversations, background execution, streaming, structured output, and function calling on the Agent Platform.

google/gke-basics

Plan, create, and configure production-ready Google Kubernetes Engine (GKE) clusters using the golden path Autopilot configuration. Covers Day-0 checklist, Autopilot vs Standard, networking (private clusters, VPC-native, Gateway API), security (Workload Identity, Secret Manager, RBAC hardening), observability, scaling, cost optimization, and AI/ML inference. WHEN: create GKE cluster, provision GKE environment, design GKE networking, secure GKE, optimize GKE cost, GKE autoscaling, GKE inference, GKE upgrade, GKE observability, GKE multi-tenancy, GKE batch, GKE HPC, GKE compute class.

google/google-cloud-networking-observability

Investigates Google Cloud networking issues by analyzing logs, metrics, and diagnostics. Use when investigating VPC Flow Logs (including cost estimation), NAT, firewall, or threat logs, querying latency and throughput metrics, or running Connectivity Tests for path diagnostics. Don't use for generic VM management or non-observability tasks.

google/google-cloud-recipe-auth

Provides expert guidance on authenticating and authorizing to Google Cloud services and APIs, covering human users, service identities, Application Default Credentials (ADC), and best practices for secure access.

google/google-cloud-recipe-networking-observability

Investigates Google Cloud networking issues by analyzing logs, metrics, and diagnostics. Use when investigating VPC Flow Logs, NAT, firewall, or threat logs, querying latency and throughput metrics, or running Connectivity Tests for path diagnostics.

google/google-cloud-recipe-onboarding

Guides a developer's first steps on Google Cloud, covering account creation, billing setup, project management, and deploying a first resource. Use when a new developer wants to initialize their first Google Cloud project, configure billing, and verify deployment. Don't use for enterprise organization setup (use Google Cloud Setup guided flow for that instead). Don't use for complex multi-project architectures.

google/google-cloud-waf-cost-optimization

Generates cost optimization guidance for Google Cloud workloads based on the Google Cloud Well-Architected Framework (WAF). Use this skill to evaluate a workload, identify cost requirements and constraints, and provide actionable recommendations for build, deploy, and manage the workload cost-efficiently in Google Cloud.

google/google-cloud-waf-operational-excellence

Generates operations-focused guidance for Google Cloud workloads based on the design principles and recommendations in the Operational Excellence pillar of the Google Cloud Well-Architected Framework (WAF). Use this skill to evaluate a workload, identify operational requirements, and provide actionable recommendations for deployment, monitoring, and incident management.

google/google-cloud-waf-performance-optimization

Generates performance-focused guidance for Google Cloud workloads based on the design principles and recommendations in the Performance Optimization pillar of the Google Cloud Well-Architected Framework (WAF). Use this skill to evaluate a workload, identify performance requirements, and provide actionable recommendations for resource allocation, modular design, and elasticity.

google/google-cloud-waf-reliability

Generates reliability-focused guidance for Google Cloud workloads based on the design principles and recommendations in the Google Cloud Well-Architected Framework. Use this skill to evaluate a workload, identify reliability requirements, and provide actionable recommendations for build, deploy, and manage the workload reliably in Google Cloud.

google/google-cloud-waf-security

Generates security-focused guidance for Google Cloud workloads based on the design principles and recommendations in the Google Cloud Well-Architected Framework (WAF). Use this skill to evaluate a workload, identify security requirements, and provide actionable recommendations for IAM, network security, data protection, and operational security.

google/google-cloud-waf-sustainability

Generates sustainability-focused guidance for Google Cloud workloads based on the design principles and recommendations in the Google Cloud Well-Architected Framework (WAF). Use this skill to evaluate a workload, identify environmental impact requirements, and provide actionable recommendations to build, deploy, and manage the workload sustainably in Google Cloud.

관련 스킬