turbot / steampipe-plugin-snowflake Goto Github PK

Describe the bug
The query is using a ">" not a "<" which shows users logged in AFTER today - 30 days.

To reproduce
select
name,
email,
disabled,
last_success_login
from
snowflake_user
where
(last_success_login > now() - interval '30 days')
and last_success_login is not null;

Expected behavior
This should be

select
name,
email,
disabled,
last_success_login
from
snowflake_user
where
(last_success_login < now() - interval '30 days')
and last_success_login is not null;

We us resource monitors to see how many credits have been used, I would like to graph this to show if the slope is changing or if we are near to out limit. "SHOW RESOURCE MONITORS" does this.
table_snowflake_resource_monitor.txt

Is your feature request related to a problem? Please describe.
Views and Table Function in schema Information_Schema is not currently available in the existing plugin.

Describe the solution you'd like
Create tables for Views and Table Function in schema Information_Schema.

Describe alternatives you've considered
I have tried Airbyte, but they also don't have this feature, the other option is to create a python API to pull the data. But it is not ideal.

Additional context
I really like the FDW feature of Postgres and Steampipe has found a perfect market for that use case.