How to get the cost of your Internet Egress in GCP

egress_cost.sql

SELECT labels.key, labels.value, project.name, resource_type, start_time, end_time, SUM(cost) as cost FROM FLATTEN((
      SELECT
        *
      FROM (
          FLATTEN((
            SELECT
              *
            FROM
              [YOUR_TABLE_HERE]),
            labels.key)
          )
        ),
      project.labels.value) 
      WHERE resource_type LIKE "%Internet Egress%"
group by labels.key, labels.value, project.name, resource_type, start_time, end_time ORDER by start_time desc