Analyzing Network Traffic with VPC Flow Logs Reviews

I had to change src to dest to make the first query work: #standardSQL SELECT jsonPayload.dest_vpc.vpc_name, SUM(CAST(jsonPayload.bytes_sent AS INT64)) AS bytes, jsonPayload.dest_vpc.subnetwork_name, jsonPayload.connection.src_ip, jsonPayload.connection.src_port, jsonPayload.connection.dest_ip, jsonPayload.connection.dest_port, jsonPayload.connection.protocol FROM `qwiklabs-gcp-00-8dee8b82c3e8.bq_vpcflows.compute_googleapis_com_vpc_flows_20241011` GROUP BY jsonPayload.dest_vpc.vpc_name, jsonPayload.dest_vpc.subnetwork_name, jsonPayload.connection.src_ip, jsonPayload.connection.src_port, jsonPayload.connection.dest_ip, jsonPayload.connection.dest_port, jsonPayload.connection.protocol ORDER BY bytes DESC LIMIT 15

Alma Fabiola S. · Reviewed over 1 year ago

Saif S. · Reviewed over 1 year ago

Venkata Chamikar G. · Reviewed over 1 year ago

Gana Novitasari C. · Reviewed over 1 year ago

PULIPATI S. · Reviewed over 1 year ago

Srestha P. · Reviewed over 1 year ago

Esteban C. · Reviewed over 1 year ago

David W. · Reviewed over 1 year ago

MANI C. · Reviewed over 1 year ago

Wilson m. · Reviewed over 1 year ago

Anas K. · Reviewed over 1 year ago

Akash M. · Reviewed over 1 year ago

Marcel E. · Reviewed over 1 year ago

Arnold Mashava A. · Reviewed over 1 year ago

Khargharia A. · Reviewed over 1 year ago

Aishwarya K. · Reviewed over 1 year ago

Diptendu G. · Reviewed over 1 year ago

Isha K. · Reviewed over 1 year ago

not simple

Vaishnavi M. · Reviewed over 1 year ago

Mohammad Taufiq B. · Reviewed over 1 year ago

Jayesh Ghevare G. · Reviewed over 1 year ago

Rushikesh P. · Reviewed over 1 year ago

Jacek S. · Reviewed over 1 year ago

Suchir M. · Reviewed over 1 year ago

Raksha M. · Reviewed over 1 year ago