materialize-bigquery-create SKILL.md skillA

materialize-bigquery-create from estuary/agent-skills is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.

Install it, pinned
mdr add estuary/agent-skills/materialize-bigquery-create@git:20260505.8873932

Pins git:20260505.8873932 in mdr.lock. Pin the fingerprint instead.

Audit grade
A, 17 of 17 checks passed
Kind
SKILL.md skill
Repository
estuary/agent-skills
Path
skills/materialize-bigquery-create/SKILL.md
Versions recorded
1
Latest version
git:20260505.8873932, committed May 5, 2026
Size
7,761 bytes
Repository stars
7
License
Apache-2.0

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

Collected from public GitHub. Every version is saved exactly as it was and never changes. Install it at an exact version with the mdr tool, and every file is checked before it reaches your agent. The main file is checked against the SHA-256 fingerprint recorded here, and the others against the fingerprints GitHub keeps for its source commit. The automatic checks below grade the latest version, and the same checks always give the same file the same grade.

What the file says

# Create BigQuery Materialization

Create a BigQuery materialization using flowctl to stream data from Estuary collections into BigQuery tables.

**Applies to**: materialize-bigquery

## Step 0: Load Connector Documentation

Before proceeding, fetch the official connector docs for prerequisites, config reference, and setup instructions.

**Load the docs page:**
https://docs.estuary.dev/reference/Connectors/materialization-connectors/BigQuery/

Use WebFetch to load this page. It covers:

- Prerequisites (GCS bucket, service account, IAM roles, dataset)
- Full config property reference
- gcloud CLI commands for setup
- Advanced options (delta updates, hard deletes, sync schedule)

**Search Kapa for tribal knowledge** (if the Estuary MCP is configured):

```
Search kapa ai knowledge sources for "materialize bigquery common issues"
```

If Kapa MCP is not configured, the user can set it up: https://docs.estuary.dev/features/mcp-integration/

This skill provides the **flowctl workflow** and **troubleshooting** that docs don't cover.

## Step 1: Gather Requirements

Before writing any YAML, ask the user:

1. **GCP project ID?** — The Google Cloud project
…

Read the whole file at its exact version.

How to install

The exact contents, by fingerprint
mdr add estuary/agent-skills/materialize-bigquery-create@sha256:4a4be67663377a2b

The line at the top of this page pins the label git:20260505.8873932, which is what most people want. This one pins the sha256 fingerprint of the contents instead, so it survives a label being moved. Either way the exact version is written to mdr.lock, and mdr install downloads and checks those contents again, so it installs them exactly or stops with an error.

Badge

mdr badge

[![mdr](https://markdownregistry.com/badge/art_h7x4qefxkqfyj75t.svg)](https://markdownregistry.com/a/art_h7x4qefxkqfyj75t)

2 badge image fetches in 30 days. What the badge shows.

Versions

The registry has recorded 1 version of this file, committed on May 5, 2026.

versioncommittedcommitsizeaudit
git:20260505.8873932 latest2026-05-05 8873932 7,761 BA view

Audit of the latest version

A  17 of 17 checks passed. Fixed automatic checks with no AI involved, so the same checks give the same answer every run.
  • pass: Frontmatter block present
  • pass: Frontmatter declares a name
  • pass: Frontmatter declares a description
  • pass: Size between 200 bytes and 200 KB (7761 bytes)
  • pass: No zero-width or bidi control characters
  • pass: No instruction hidden inside an HTML comment
  • pass: No link to an exfiltration or paste host
  • pass: No credential-shaped string
  • pass: No instruction to send local credentials anywhere
  • pass: No text hidden with inline styles
  • pass: No prompt-injection phrasing
  • pass: No curl or wget piped into a shell
  • pass: No recursive delete of root, home or parent
  • pass: No instruction to read or print local credentials
  • pass: No base64 blob over 200 characters
  • pass: No link to a raw IP address
  • pass: No script tag

Source

GitHub

estuary/agent-skills · 7 stars · license Apache-2.0 · pushed 2026-11-04 · branch main

API

GET https://markdownregistry.com/api/v1/artifacts/art_h7x4qefxkqfyj75t
GET https://markdownregistry.com/api/v1/resolve?ref=estuary/agent-skills/materialize-bigquery-create
GET https://markdownregistry.com/api/v1/blob/4a4be67663377a2b4604677c0cdaca61a2f9b937b06956d9d9b2b9972db8328b

Your AI assistant does the legwork. You hear about the deals worth your word. Hand yours the standing instructions at modelranch.com and it joins the network that reads files like this one.

Guides: the SKILL.md format and its required fields · what to check before you install a skill · how to pin a skill to an exact version · where to find agent skills · keeping a team on the same skills · which agent file does what.

More from estuary/agent-skills

capture-alpaca-create SKILL.md skill
estuary/agent-skills · skills/capture-alpaca-create/SKILL.md · Create an Alpaca capture using flowctl to stream stock trade data into Estuary collections. Use when setting up an…
git:20260924.c6e4810 · audit A · 7 stars
capture-generic-create SKILL.md skill
estuary/agent-skills · skills/capture-generic-create/SKILL.md · Create a capture for ANY Estuary connector using dynamic schema discovery. Use when the user wants to capture from a…
git:20260924.c6e4810 · audit A · 7 stars
capture-http-ingest-create SKILL.md skill
estuary/agent-skills · skills/capture-http-ingest-create/SKILL.md · Create an HTTP Ingest (webhook) capture to receive data via HTTP POST requests. Use when setting up webhooks from…
git:20260924.c6e4810 · audit A · 7 stars
capture-hubspot-create SKILL.md skill
estuary/agent-skills · skills/capture-hubspot-create/SKILL.md · Create a HubSpot Real-Time capture using flowctl to stream CRM data into Estuary collections. Use when setting up a…
git:20260924.c6e4810 · audit A · 7 stars
capture-mongodb-create SKILL.md skill
estuary/agent-skills · skills/capture-mongodb-create/SKILL.md · Create a MongoDB CDC capture using flowctl. Use when setting up real-time streaming from MongoDB Atlas, DocumentDB, or…
git:20260924.c6e4810 · audit A · 7 stars
capture-mysql-create SKILL.md skill
estuary/agent-skills · skills/capture-mysql-create/SKILL.md · Create a MySQL CDC capture using flowctl with binlog replication. Use when setting up streaming from MySQL, Amazon RDS…
git:20260924.c6e4810 · audit A · 7 stars
capture-postgres-create SKILL.md skill
estuary/agent-skills · skills/capture-postgres-create/SKILL.md · Create a new PostgreSQL CDC capture from scratch using flowctl. Covers all Postgres variants (vanilla, Aurora, RDS…
git:20260924.c6e4810 · audit A · 7 stars
capture-sqlserver-create SKILL.md skill
estuary/agent-skills · skills/capture-sqlserver-create/SKILL.md · Create a SQL Server CDC capture using flowctl. Use when setting up real-time streaming from SQL Server, Azure SQL…
git:20260924.c6e4810 · audit A · 7 stars
derivation-aggregate-metrics SKILL.md skill
estuary/agent-skills · skills/derivation-aggregate-metrics/SKILL.md · Create an Estuary derivation that continuously aggregates metrics (daily totals, running counts, min/max, lifetime…
git:20260707.6b608bf · audit A · 7 stars
derivation-basics SKILL.md skill
estuary/agent-skills · skills/derivation-basics/SKILL.md · Foundation for writing Estuary derivations — what they are, language choice (SQL/TypeScript/Python), project layout…
git:20260707.6b608bf · audit A · 7 stars
derivation-filter-transform SKILL.md skill
estuary/agent-skills · skills/derivation-filter-transform/SKILL.md · Create an Estuary derivation for stateless filtering, field selection, and per-document field transformation. Use for…
git:20260707.6b608bf · audit A · 7 stars
derivation-flatten-array SKILL.md skill
estuary/agent-skills · skills/derivation-flatten-array/SKILL.md · Create an Estuary derivation that flattens a nested array into one output document per array element. Use for…
git:20260707.6b608bf · audit A · 7 stars

Every file in estuary/agent-skills

Browse by kind, by grade A, or by owner.