'bigquery' 검색 결과

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.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Creating datasets and tables
• Analyzing data with SQL queries
• Ingesting data and managing processing jobs

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.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Clean and transform BigQuery data with Python
• Preview data and check column types
• Visualize aggregated or sampled data

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.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Create BigQuery datasets and tables
• Search and aggregate data with SQL
• Load data and manage processing jobs

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.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Assess downstream effects of a table failure
• Check dependencies before changing or deleting a view
• Evaluate the impact of pausing data updates

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.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Investigate failed or slow BigQuery jobs
• Locate bottlenecks in execution stages
• Diagnose sudden increases in query or capacity costs

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.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Migrating Snowflake dbt models to BigQuery in bulk
• Preserving dbt references and incremental processing logic
• Adapting JSON, array, and STRUCT access during migration

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.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Forecasting future values from time-series data
• Detecting anomalies and investigating drivers of change
• Searching documents by meaning

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.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Check BigQuery pipeline code before production use
• Estimate job counts and cost risks in loops
• Review duplicate writes when rerunning failed jobs

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.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Investigating agent latency and execution errors
• Configuring prompt and response logging
• Analyzing agent events in BigQuery

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.

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.

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).

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.

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.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Evaluate workloads against Google Cloud best practices
• Inspect rules for SAP and SQL Server workloads
• Run evaluations using custom organizational rules

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.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Comparing GKE costs across projects
• Finding the most expensive namespace or workload
• Investigating a sudden increase in cluster costs

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.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Investigating data origins during a quality issue
• Summarizing data sources and destinations
• Tracing the flow of a specific column

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.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Compare On-Demand pricing with Editions
• Review storage billing models and retention periods
• Design table partitioning and clustering

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.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Retrieve execution details for a slow job
• Check compute capacity contention and queue delays
• Review reserved capacity and autoscaling limits

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.

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.

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".

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.

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.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Designing a mobile backend on Cloud Run
• Planning a SaaS architecture on GKE
• Building an event analytics pipeline with BigQuery

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.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Translate SQL from PostgreSQL to BigQuery
• Review slow queries for performance improvements
• Calculate retention rates and funnel conversion

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.

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.

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.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Designing a data platform across multiple clouds
• Planning data ingestion and AI serving components
• Preparing infrastructure code and deployment instructions

GCPプロジェクト単位でBigQuery認証を設定するスキル。 gcloud設定プロファイルで複数プロジェクトを安全に分離管理。 「BigQueryに繋ぎたい」「BQ認証」「gcloud認証」「データ分析の認証設定」等のリクエストで発動。

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.

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.

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.