Creates a materialized view or stored procedure in the project's BigQuery data warehouse for data pre-aggregation.
**When to use this tool:**
- When the user needs to pre-aggregate data from multiple connectors (e.g., cross-channel marketing report)
- When a query is too slow to run on-demand and benefits from materialization
- When the user asks to "create a view", "save this as a table", "materialize this query"
**Naming rules (enforced):**
- Target dataset MUST be 'quanti_agg' (created automatically if it doesn't exist)
- Object name MUST start with 'llm_' prefix (e.g., llm_weekly_spend)
- Format: CREATE MATERIALIZED VIEW quanti_agg.llm_name AS SELECT ...
**SQL format:**
- CREATE MATERIALIZED VIEW: for pre-computed aggregation tables
- CREATE OR REPLACE MATERIALIZED VIEW: to update an existing view
- CREATE PROCEDURE: for complex multi-step transformations
**Example:**
CREATE MATERIALIZED VIEW quanti_agg.llm_weekly_channel_spend AS
SELECT DATE_TRUNC(date, WEEK) as week, channel, SUM(spend) as total_spend
FROM prod_google_ads_v2.campaign_stats
GROUP BY 1, 2
**Limits:** Maximum 20 active aggregation views per project.
Connector