Snowflake - Tracking your 400 $ free credit usage

Two queries you can use to track your free credits. For a trial account that is not yet converted to a paid account, a tile is shown in the left menu space. When converting the account (in my case, using CoCo I had to add a credit card) to paid, the rile disappears and these 2 queries will show you the status.

SELECT
FREE_USAGE_BALANCE AS REMAINING_CREDIT_DOLLARS
FROM SNOWFLAKE.ORGANIZATION_USAGE.REMAINING_BALANCE_DAILY
ORDER BY DATE DESC
LIMIT 1;

SELECT
SERVICE_TYPE,
ROUND(SUM(USAGE_IN_CURRENCY), 2) AS COST_DOLLARS
FROM SNOWFLAKE.ORGANIZATION_USAGE.USAGE_IN_CURRENCY_DAILY
WHERE USAGE_DATE >= DATEADD('day', -90, CURRENT_DATE())
GROUP BY SERVICE_TYPE
HAVING COST_DOLLARS > 0
ORDER BY COST_DOLLARS DESC