Bulk Operations

Generate DDL for multiple tables and compare table data.

---

Bulk Table Generator

Generate DDL statements for multiple tables at once.

Access: Command Palette → "Generate queries"

Actions

Action	Output
Copy Tables	CREATE TABLE ... COPY
Clone Tables	CREATE TABLE ... CLONE (zero-copy)
Move Tables	COPY + DROP sequence
Drop Tables	DROP TABLE IF EXISTS
Truncate Tables	TRUNCATE TABLE

Workflow

1. Select target (project, dataset, or table)
2. Choose action
3. Enter filter pattern (optional): user*, *_backup, *2023*
4. Review matched tables
5. Generate SQL

Filter Patterns

• * matches any characters
• ? matches single character
• Empty = all tables

Output

-- Clone 3 tables from `project.dataset` | Filter: user*
CREATE TABLE `<target_dataset>.users`
CLONE `project.dataset.users`;

Placeholders auto-selected for multi-cursor editing.

---

Table Comparison

Compare data between two tables or queries.

Access: Right-click table → "Compare with..."

Setup

1. Select two sources (tables or queries)
2. Choose key columns (unique identifiers)
3. Select columns to compare
4. Run comparison

Result Types

Status	Meaning	Color
MATCH	Identical in both	Green
DIFFERENT	Values differ	Yellow
ONLY_IN_A	Missing from B	Red
ONLY_IN_B	Missing from A	Blue

Use Cases

• Migration validation
• ETL pipeline verification
• Data sync debugging
• Regression testing

Tips

• Use immutable columns as keys (IDs, not names)
• Exclude expected differences (timestamps)
• For large tables, add WHERE filters or use TABLESAMPLE