to verify field references without incurring cost or execution
time. 3.
Retry
Apply identified fixes to the original query and execute.
3. Analysis Guides (Read Only When Needed)
For detailed SQL patterns, field definitions, and advanced troubleshooting, read
the corresponding reference file:
Threat Log Analysis
:
references/threat-analysis.md
VPC Flow Analysis
:
references/vpc-flow-analysis.md
Cloud NAT Analysis
:
references/cloud-nat-analysis.md
Firewall Rule Analysis
:
references/firewall-analysis.md
Networking Metrics
:
references/metrics-analysis.md
Connectivity Test Analysis
:
references/connectivity-tests.md
Boundaries (CRITICAL)
ALWAYS
present the direct answer as soon as it is identified.
NEVER
run more than 2 exploratory queries before showing results.
NEVER
perform secondary verification (for example, don't check VPC flows
after finding a firewall block) without explicit user permission.
ALWAYS
print the generated SQL for review before execution.
ALWAYS
include a link to the Flow Analyzer in the
Google Cloud Console
.
NEVER
query a second data source (such as, BigQuery logs) if the primary
source (for example, Cloud Monitoring metrics) has already provided a
conclusive answer.
DO NOT
compare metrics and logs to "verify" accuracy
unless the user specifically asks why they differ.
NO DISCREPANCY LOOPS
If Tool A provides a result (such as, 80,000
counts) and Tool B provides a different result (for example, 1,000 counts),
DO NOT
initiate a deep dive to explain the difference. Present the
result from the primary tool and STOP.
ALWAYS
perform time-range calculations (such as, "12 hours ago") during
the first turn to save steps.
Conclusive Acceptance of Inactivity
Treat a result of "0", "0 traffic",
"No data found", or "No records found" as a conclusive finding for the
requested timeframe and resource. You MUST report this as the definitive
state and terminate immediately.
Standardized Discovery Path
For all "Top-N" or volume-based discovery
tasks (for example, "highest traffic," "most hits," "top talkers"), you MUST
use BigQuery aggregation on _AllLogs datasets. Manual aggregation of
individual time-series points using the Monitoring API is forbidden due to
step inefficiency.
Ban on Auxiliary Scripting
Execute all data retrieval and parsing logic
as direct tool calls (bq, curl, gcloud). Do NOT write or execute local shell
scripts (.sh) or python files, as these introduce avoidable environment and
permission errors that lead to investigation timeouts.
Discovery Efficiency
For volume analysis (for example, "how many
connections" or "top IPs by bytes"), BigQuery aggregation on VPC Flow logs
(_AllLogs) is the
Primary Source of Truth
. If BigQuery data is
available, it is conclusive. Do NOT query Monitoring API to "double check"
BigQuery counts.