Zurück zu Utils
Snowflake · View
login_history
Fehlgeschlagene Anmeldeversuche pro Benutzer, einschließlich IP-Adresse, Client-Typ und Fehlermeldung. Nützlich zur Erkennung unbefugter Zugriffsversuche.
Quelle: SNOWFLAKE.ACCOUNT_USAGE.LOGIN_HISTORY · Latenz: ~2h
| Spalte | Beschreibung |
|---|---|
| date | Datum |
| user_name | Benutzer |
| client_ip | IP-Adresse des Clients |
| reported_client_type | z.B. SNOWFLAKE_UI, JDBC_DRIVER |
| reported_client_version | Client-Versionsstring |
| first_authentication_factor | z.B. PASSWORD, OAUTH |
| error_message | Snowflake-Fehlermeldung |
Quellcode
create_admin_views.sql
create or replace view login_history
comment = 'Failed login attempts per user (source: SNOWFLAKE.ACCOUNT_USAGE)'
as
select event_timestamp::date as date
, user_name
, client_ip
, reported_client_type
, reported_client_version
, first_authentication_factor
, error_message
from snowflake.account_usage.login_history
where is_success = 'NO'
order by event_timestamp desc;