BigQuery Basics
Independent PiSkill directory guide. The original skill remains hosted by Google Skills.
What is BigQuery Basics?
Supports BigQuery datasets, tables, SQL queries, ingestion, analysis, permissions, client libraries, and common data-platform workflows on Google Cloud.
What does BigQuery Basics do?
BigQuery Basics is a Google skill for common analytics and data-platform work with BigQuery. It covers datasets, tables, SQL queries, ingestion, permissions and client libraries so an agent can move from project setup to querying and managing analytical data.
Who is BigQuery Basics best for?
- Data analysts using Google Cloud
- Teams building BigQuery-based analytics
- Developers loading application data into a warehouse
- Projects automating BigQuery through client libraries
Common use cases
- Create datasets and tables
- Run analytical SQL queries
- Load or ingest data into BigQuery
- Configure access and use a client library
How does BigQuery Basics work?
The skill establishes project and dataset context, then guides table creation, ingestion and SQL analysis using BigQuery-native patterns. It also includes permission and client-library considerations so the workflow can be used from applications as well as the console.
Key benefits
- Covers the core BigQuery workflow
- Useful for both analysts and developers
- Combines SQL, ingestion and permissions
- Fits common Google Cloud data-platform tasks
Things to know
- Query cost depends on data scanned and architecture
- Schema and partitioning choices affect performance
- Sensitive data requires appropriate IAM and governance controls
Compatible tools
Frequently asked questions
What does the BigQuery Basics skill cover?
Can it help load data into BigQuery?
Related skills
Cloud SQL Basics
Guides creation and management of Google Cloud SQL databases for PostgreSQL, MySQL, and SQL Server, including connectivity, backups, high availability, IAM, and Terraform workflows.
HF Memory Estimator
Estimates the memory required to load Safetensors or GGUF model weights for inference, helping users judge whether a model fits available hardware before deployment.
Hugging Face Datasets
Guides Dataset Viewer API workflows for discovering subsets and splits, paging through rows, searching and filtering data, retrieving Parquet files, and inspecting dataset statistics.
Hugging Face LLM Trainer
Guides training and fine-tuning language or vision models with TRL or Unsloth while using Hugging Face Jobs infrastructure for execution.
XLSX
Helps agents create, edit, inspect, and analyze spreadsheet files while preserving formulas, formatting, existing templates, and common financial-modeling conventions.
Cloud Run Basics
Helps agents deploy and manage Google Cloud Run services, jobs, and worker pools for serverless HTTP apps, scheduled tasks, and background workloads.