mzinni

SELECT
    month,
    balance,
    future_balance
FROM
    (SELECT
        STRFTIME_UTC_USEC(usage_end_time, '%Y%m') as month,
        SUM(cost) + SUM(credits.amount) as balance,
        null as future_balance
    FROM [data-analytics-pocs:public.gcp_billing_export_v1_EXAMPL_E0XD3A_DB33F1]

mzinni

SELECT id, resource_type, category, resource_id, parent_resource_type, parent_resource_id, IFNULL(resource_data->>'$.displayName', '') as resource_data_displayname, IFNULL(resource_data->>'$.name', '') as resource_data_name 
FROM gcp_inventory 
WHERE inventory_index_id = (SELECT id FROM inventory_index ORDER BY completed_at_datetime DESC LIMIT 1) 
AND (category='resource') 
AND (resource_type='organization' OR resource_type='project' OR resource_type='folder' OR resource_type='appengine_app' OR resource_type='kubernetes_cluster' OR resource_type='cloudsqlinstance');

mzinni

SELECT id FROM inventory_index WHERE inventory_status = “SUCCESS” ORDER BY completed_at_datetime DESC LIMIT 1;