Use the LOGIN_HISTORY view.
Login attempts by Snowflake users within the past 365 days (1 year) can be queried.
SELECT
EVENT_ID,
CONVERT_TIMEZONE('Asia/Tokyo',EVENT_TIMESTAMP) AS JST_EVENT_TIMESTAMP,
EVENT_TYPE,
USER_NAME,
CLIENT_IP,
REPORTED_CLIENT_TYPE,
REPORTED_CLIENT_VERSION,
FIRST_AUTHENTICATION_FACTOR,
SECOND_AUTHENTICATION_FACTOR,
IS_SUCCESS,
ERROR_CODE,
ERROR_MESSAGE,
RELATED_EVENT_ID,
CONNECTION
FROM
SNOWFLAKE.ACCOUNT_USAGE.LOGIN_HISTORY
ORDER BY
EVENT_TIMESTAMP DESC
;