search

snowflakedb / SnowAlert

Security Analytics Using The Snowflake Data Warehouse
Apache License 2.0
184 stars 57 forks source link

Monitoring Snowflake accounts #474

Open edulop91 opened 3 years ago

edulop91 commented 3 years ago

I was wondering if you had any thoughts around using SnowAlert to gather data on other Snowflake accounts? Things that might be interesting are users, roles, databases, schemas, and associated grants.

sfc-gh-afedorov commented 3 years ago

That definitely sounds like it can be useful, but not immediately sure how to modify db.py to be able to isolate multiple connections. Breaking that code into a separate pypi module is in our backlog, happy to share TDD when it is more fully baked, if interested.

Once that's ready to use, should be easy to make a data connector.

sfc-gh-afedorov commented 3 years ago

Could you describe the use-case in more details? I think the intended solution for what you're thinking might be Snowflake Orgs. Does that not meet your use-case, or is there something else that we can add separately?