Ian Whitestone

@stumelius as an FYI, there was a related discussion here: https://github.com/get-select/dbt-snowflake-monitoring/issues/149 Right now the latest version of the package is setup to handle this and ensure we are able to...

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

Another use case brought up by a user if they have some discounts applied so multiplying by the cost per credit is incorrect for true cost.

Hi @yingyingqiqi , no one is currently working to add this. If you are willing to contribute that would be great. You just need to add the columns here: https://github.com/get-select/dbt-snowflake-monitoring/blob/main/models/cost_per_query.sql#L142-L148...

> Also, I would like to add credit to hourly_spend, daily_spend as well , is that ok with you? sounds good 👍 , can we do that in a separate...

Thanks for opening the issue @saperry. Keep us posted on your investigation!

Thanks @kirkbrunson-dave! A PR would be amazing. Let's update the docs to align with what is already in the model. Thanks again for flagging.

@kirkbrunson-dave it looks like an issue with your git command Once you have pushed your commit to your forked repo, you should be able to open a PR from the...

Alternatively, could try and use a range join strategy to reduce the speed. It's likely the cartesian join in the `query_hours` CTE which is killing things.

> Alternatively, could try and use a range join strategy to reduce the speed. It's likely the cartesian join in the query_hours CTE which is killing things. nvm, cartesian join...