Replace service_type = 'COMPUTE' filters with service_type = 'WAREHOUSE_METERING' due to Snowflake backend change

[stumelius]

The COMPUTE service type no longer exists in the snowflake.organization_usage.rate_sheet_daily table. It has been replaced with WAREHOUSE_METERING.

[stumelius]

I can do a PR for this tomorrow :)

[ian-whitestone]

@stumelius as an FYI, there was a related discussion here: #149

Right now the latest version of the package is setup to handle this and ensure we are able to continue to report on spend.

With that said, I would like to update the models at some point now that everyone should have these new service types populated. If you're open to doing a PR, that would be greatly appreciated. We'd need to do the following:

1. Update stg_rate_sheet_daily to undo the manually handling
2. Update cost_per_query
3. Update hourly_spend

[stumelius]

@ian-whitestone Oh, I didn't notice the service_type transformation in stg_rate_sheet_daily. So, as a quick fix I'll just update the package to the latest version and that should do the trick.

Here's a PR for the long term fix #151

[ian-whitestone]

Thanks so much @stumelius! Will aim to review this weekend when things are quieter :)

[greg-finley]

Hello, seems that this issue can be closed?