jksprattler

SELECT
  labels.key as key, labels.value as value, invoice.month,
  (SUM(CAST(cost AS NUMERIC))
      + SUM(IFNULL((SELECT SUM(CAST(c.amount AS NUMERIC))
                    FROM UNNEST(credits) AS c), 0)))
      AS total
FROM `<FIXME_project>.<FIXME_dataset>.gcp_billing_export_resource_v1_<FIXME_BILLING_ACCOUNT_ID>`
CROSS JOIN UNNEST(labels) as labels
  ON labels.key = "<FIXME_KEY>" and labels.value = "<FIXME_VALUE>"
WHERE project.name = "<FIXME_PROJECT>"

jksprattler

{ 
    "editor.fontSize": 14,
    "editor.wordWrap": "on",
    // Controls the font size in pixels of the terminal.
	"terminal.integrated.fontSize": 14,
    // powerline10k - which uses https://github.com/romkatv/powerlevel10k/#recommended-meslo-nerd-font-patched-for-powerlevel10k
    "terminal.integrated.fontFamily": "MesloLGS NF",
    "terminal.integrated.rightClickBehavior": "paste",
    "terminal.integrated.rendererType": "canvas",
    "terminal.integrated.shell.osx": "/bin/zsh",