# View: login_history_snowflake_usage

**View Name:** login_history_snowflake_usage
**Table Source:** `snowflake.account_usage.login_history`
**File Path:** `login_history_snowflake_usage.view.lkml`

## Overview

- **File Size:** 2180 bytes
- **Lines of Code:** 111
- **Dimensions:** 12
- **Measures:** 3
- **Dimension Groups:** 1
- **Filters:** 0

## Comments & Notes

- dimension: seconds_between_login_attempts {
- type: number
- sql: timediff(seconds, ${event_raw}, lead(${event_raw}) over(partition by ${user_name} order by ${event_raw})) ;;

## Dimensions

| Name | Type |
|------|------|
| `client_ip` | string |
| `error_code` | number |
| `error_message` | string |
| `event_id` | number |
| `event_type` | number |
| `first_authentication_factor` | number |
| `is_success` | yesno |
| `related_event_id` | number |
| `reported_client_type` | string |
| `reported_client_version` | string |
| `second_authentication_factor` | number |
| `user_name` | string |

## Measures

| Name | Type |
|------|------|
| `logins` | count |
| `total_failed_logins` | count |
| `login_failure_rate` | number |

## Dimension Groups

| Name | Type |
|------|------|
| `event` | time |