Confirmed on latest main (f9736738).

Root cause

View names are derived solely from event type with no reference to table_id:

# line 2298
view_name = "v_" + event_type.lower()

table_id is only used in the FROM clause (line 2305) to point the view at the correct table. Since CREATE OR REPLACE VIEW (line 1786) is used, the last plugin instance to run _create_analytics_views silently overwrites all views created by earlier instances in the same dataset.

Example (same dataset, two tables):

Plugin A: table_id="agent_events_prod" → creates v_llm_request pointing at agent_events_prod
Plugin B: table_id="agent_events_staging" → creates v_llm_request pointing at agent_events_staging
Result: v_llm_request now points at staging only — prod views are gone.

The collision is dataset-scoped: view names are unqualified within the dataset, so any two plugin instances writing to different tables in the same dataset will clobber each other's views.

Suggested fix

Namespace the view name by table_id:

# Current (line 2298):
view_name = "v_" + event_type.lower()

# Fixed:
view_name = f"v_{self.table_id}_{event_type.lower()}"

This produces v_agent_events_prod_llm_request vs v_agent_events_staging_llm_request — no collision.

Breaking-change consideration

Changing the default view names would be a breaking change, because existing queries may depend on names like v_llm_request.

Safer options:

Add a configurable view_prefix / view_name_prefix to BigQueryLoggerConfig and keep the current default ("v") for backward compatibility. Users with multiple tables in one dataset opt into distinct prefixes.
Only derive unique names automatically when a non-default prefix is set.
Consider always prefixing by table_id only in a future major release.

Option 1 is the least disruptive path — it fixes the collision for multi-table users without changing anything for existing single-table deployments.

BQ AA Plugin Overrite #5099

Description

Metadata

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Issue actions