snowflake-cloud-data-platformaudit-logging
How to access Audit Logs using 'SNOWFLAKE' shared DB in Snowflake
While exploring Snowflake documentation on Audit Logging (user login history, object creation/deletion, query execution history etc), I found the below information.
But in my trail account, I didn't find any shared DB with name 'SNOWFLAKE'.
Would apreciate if someone can throw more light on this feature.
Neeraj
Solution
Changing the role in right upper corner is not sufficient. Yo uneed to change the role in the context.
After that, 'SNOWFLAKE' shared DB will be visible.
- Azure Data Factory V2 Copy Activity is not cleaning/deleting staged files/containers after copying data to the destination (Like: Snowflake)
- Count / Sum JSON variant attribute Flatten
- Difference between LATERAL FLATTEN(...) and TABLE(FLATTEN(...)) in Snowflake
- How to merge nested json in snowflake?
- Alternatives to sliding window frames with RANGE on snowflake
- Snowflake SQL Range between interval
- Snowflake SQL stored procedure not working
- How to add a hyphen after an nth character in Snowflake
- How to query a Snowpark dataframe, with SQL, from Snowflake?
- Snowflake improve search join IP over Network
- Create OBJECT with column values as Key in Snowflake
- Information_schema INVALID IDENTIFIER from snowflake when trying to access query history through a python script
- How can I efficiently transform a two-column range into an expanded table?
- Stored Procedure: add parameter for month or hour
- parquet files generated by snowflake are not readable by other tools
- Dynamically lateral flatten in Snowflake
- snowflake Time travel data is not available
- Exactly what dialect of SQL does snowflake support
- Snowflake - get notified of any task errors when copy is set to "on_error = continue"
- Snowflake - Lateral flatten
- Snowflake SQLAlchemy - Create table with Timestamp?
- How to parse nested json in snowflake using lateral flatten
- Create nested queries with SQLAlchemy
- How to include count column with filter to calculate percentage out of a total where total has different filters in Snowflake?
- how to add Interval time in snowflake using a parameter
- How to find count of groups a particular IDs belong to in Snowflake?
- How to replace strings in a column if exist in a list with dbt jinja?
- Snowflake - want to revert back to previous version of table before I replaced it
- SQL to parse very long string into many columns
- Function in a query does not return more than one row when reading from another record in a table