Back to source list
Official
Premium
Snowflake Config
Snowflake Config plugin pulls configuration information out of Snowflake and loads it into any supported CloudQuery destination
Publisher
cloudquery
Latest version
v5.1.13
Type
Source
Platforms
Date Published
Snowflake User Access History
The snowflake_user_access_history table shows data for Snowflake User Access History.
This table shows results for
select * from 'SNOWFLAKE'.'ACCOUNT_USAGE'.'ACCESS_HISTORY' where user_name = <user>Primary Keys #
| Name | Type |
|---|---|
| query_id | utf8 |
| request_account | utf8 |
| user_name | utf8 |
Columns #
| Name | Type |
|---|---|
| base_objects_accessed | list<item: json, nullable> |
| _cq_id | uuid |
| _cq_parent_id | uuid |
| direct_objects_accessed | list<item: json, nullable> |
| objects_modified | list<item: json, nullable> |
| objects_modified_by_ddl | json |
| parent_query_id | json |
| policies_referenced | json |
| query_id | utf8 |
| query_start_time | timestamp[us, tz=UTC] |
| request_account | utf8 |
| root_query_id | json |
| user_name | utf8 |
Relations
This table depends on:
Snowflake Users