Add table snowflake_resource_monitors about steampipe-plugin-snowflake HOT 4 CLOSED

@paulsewardasc Thanks for raising this feature request!

I see you attached a file with some Go code inside, is this code you're currently using to query these resource types in a locally built plugin? I'm not familiar with that particular API or resource type yet, but I took a look at the code and it seemed to be directionally correct.

If it's something you're comfortable contributing, we'd really appreciate a new PR adding that table along with its doc with examples (which can be based off of how you use the table today). We'd be more than happy to provide feedback and review comments in that PR as well.

If this is something you're interested (or not) in contributing, please let us know!

from steampipe-plugin-snowflake.

Hi, I am using this code, it seems to work well. I will get some examples together and document. Not sure how to add a new PR though.

Paul

from steampipe-plugin-snowflake.

select account as "Account",
    name as "Warehouse", 
    credit_quota as "Credit Quota",
    used_credits as "Used Credits",
    remaining_credits as "Remaining Credits",
    to_char(used_credits/credit_quota*100,'9990D9') as "% Used",
    case
        when used_credits/credit_quota*100 > 90 then 'alert'
        when used_credits/credit_quota*100 > 75 then 'warning'
        else 'ok'
    end as type
from snowflake_resource_monitor
where used_credits/credit_quota*100 > 75
order by used_credits/credit_quota desc

from steampipe-plugin-snowflake.

Thanks so much for the contribution @paulsewardasc!

Pull requests are great for review / collaborating in open source and also mean that you’ll be recognized through your commits as a contributor to the project. If you’d like to learn more about how to do a PR here is a good guide https://www.freecodecamp.org/news/how-to-make-your-first-pull-request-on-github-3/

from steampipe-plugin-snowflake.