Terug naar Utils
Snowflake · View
login_history
Mislukte inlogpogingen per gebruiker, inclusief IP-adres, clienttype en foutmelding. Handig voor het opsporen van ongeautoriseerde toegangspogingen.
Bron: SNOWFLAKE.ACCOUNT_USAGE.LOGIN_HISTORY · Latentie: ~2h
| Kolom | Beschrijving |
|---|---|
| date | Datum |
| user_name | Gebruiker |
| client_ip | IP-adres van de client |
| reported_client_type | Bijv. SNOWFLAKE_UI, JDBC_DRIVER |
| reported_client_version | Versie van de client |
| first_authentication_factor | Bijv. PASSWORD, OAUTH |
| error_message | Foutmelding van Snowflake |
Broncode
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;