skills.rest
Orvanta-Cloud
Orvanta-CloudOFFICIAL
Explore all skills by this author →
WebsiteGitHub

write-script-bigquery

Create and test BigQuery SQL queries with local and workspace execution.

Updated May 28, 2026
Search Tags:#SQL#data analysis#scripting#BigQuery#query authoring
One-click install
npx skills add https://github.com/Orvanta-Cloud/orvanta-cli-docs --skill write-script-bigquery-orvanta-cloud
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: write-script-bigquery
Source: https://github.com/Orvanta-Cloud/orvanta-cli-docs/tree/main/skills/write-script-bigquery
Command: npx skills add https://github.com/Orvanta-Cloud/orvanta-cli-docs --skill write-script-bigquery-orvanta-cloud

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

This Skill addresses the challenge of writing and testing BigQuery queries, streamlining the process for users who need to author and execute SQL queries against the BigQuery platform.

Core Features & Use Cases

  • Query Authoring: Facilitates the creation of SQL queries for BigQuery.
  • Preview and Execution: Allows users to preview and run queries locally or in the workspace.
  • Metadata Generation: Generates .script.yaml and .lock files for the script.
  • Sync and Deployment: Offers deployment of local changes to the workspace.
  • Use Case: Ideal for developers and data analysts who need to author and test complex BigQuery queries efficiently.

Quick Start

Use the orvanta script preview <script_path> command to preview your BigQuery script locally.

Frequently Asked Questions about write-script-bigquery

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I author and test BigQuery queries locally?▼

Yes, this Skill allows you to preview and run BigQuery queries directly in your workspace. It streamlines the execution of SQL queries against the BigQuery platform, facilitating both local and workspace testing environments.

Do I need SQL knowledge to use this BigQuery scripting tool?▼

Yes, you need SQL knowledge and BigQuery access to use this tool. It is designed for developers and data analysts who need to author and test complex BigQuery queries, streamlining the creation and execution process.

How do I deploy local BigQuery script changes to the workspace?▼

You can deploy local BigQuery script changes to the workspace using the Skill's sync and deployment features. This functionality allows you to seamlessly push your locally authored and tested SQL queries to your workspace environment.

What metadata files are generated when writing BigQuery queries?▼

When writing BigQuery queries, the Skill generates `.script.yaml` and `.lock` files. This metadata provides structure and versioning for your SQL scripts, ensuring consistency during local testing and workspace deployment.

What is the best way to streamline BigQuery query authoring for data analysis?▼

The best way to streamline BigQuery query authoring is using a dedicated scripting Skill that supports local preview, execution, and metadata generation. This approach efficiently manages complex SQL queries for data analysis workflows.

Related Skills

Explore More Data & Analytics Skills→
QcasaresQcasares

sql-toolkit

Execute SQL queries against SQLite, PostgreSQL, and MySQL databases.

Community
Intermediate
wangx7wangx7

bigquery-basics

Manage BigQuery datasets, tables, and jobs via CLI, client libraries, and MCP servers.

Community
Intermediate
kubiyabotkubiyabot
16

grafana

Manage Grafana dashboards, alerts, and data sources via the HTTP API.

Official
Intermediate
mattmacleod16-svgmattmacleod16-svg
1

sql-queries

Translate and optimize SQL queries across Snowflake, BigQuery, Databricks, and PostgreSQL.

Community
Intermediate