...
Introduction
Tags beginning with db.snowflake identify events generated by Snowflake.
Valid tags and data tables
The full tag must have 4 four levels. The first two are fixed asdb.snowflake. The third level identifies the type of events sent, and the fourth level indicates the event subtype.
...
Technology
...
Brand
...
Type
...
...
db
...
snowflake
...
history
...
access
login
sessions
These are the valid tags and corresponding data tables that will receive the parsers' data:
Product / Service | Tag | Data table |
|---|---|---|
Snowflake |
|
|
|
| |
|
|
For more information, read more about Devo tags.
Table structure
This is These are the set fields displayed by in these tables.:
db.snowflake.history.access
| Anchor | ||||
|---|---|---|---|---|
|
Field | Type | Extra Label field | |
|---|---|---|---|
eventdate |
| ||
hostname |
| ||
devo_pulling_id |
| ||
query_id |
| - | |
query_start_time |
| ||
user_name |
| ||
direct_objects_accessed |
| - | |
base_objects_accessed |
| - | |
objects_modified |
| - | |
hostchain |
| ✓ | |
tag |
| ✓ | |
rawMessage |
| ✓ |
db.snowflake.history.login
| Anchor | ||||
|---|---|---|---|---|
|
Field | Type | Extra Label field | |
|---|---|---|---|
eventdate |
| ||
hostname |
| - | |
devo_pulling_id |
| - | |
event_id |
| - | |
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 |
| - | |
hostchain |
| ✓ | |
tag |
| ✓ | |
rawMessage |
| ✓ |
db.snowflake.history.session
| Anchor | ||||
|---|---|---|---|---|
|
Field | Type | Extra Label field | |
|---|---|---|---|
eventdate |
| - | |
hostname |
| - | |
devo_pulling_id |
| - | |
session_id |
| - | |
created_on |
| ||
user_name |
| ||
authentication_method |
| - | |
login_event_id |
| - | |
client_application_version |
| ||
client_application_id |
| ||
client_environment__application |
| ||
client_environment__os |
| - | |
client_environment__os_version |
| - | |
client_environment__python_version |
| - | |
client_environment__python_runtime |
| ||
client_environment__python_compiler |
| ||
client_environment__tracing |
| ||
client_environment__login_timeout |
| ||
client_environment__network_timeout |
| ||
client_environment__node |
| ||
client_environment__v8 |
| - | |
client_environment__uv |
| ||
client_environment__zlib |
| ||
client_environment__brotli |
| - | |
client_environment__ares |
| - | |
client_environment__modules |
| - | |
client_environment__nghttp2 |
| - | |
client_environment__napi |
| ||
client_environment__llhttp |
| - | |
client_environment__openssl |
| - | |
client_environment__cldr |
| - | |
client_environment__icu |
| ||
client_environment__tz |
| ||
client_environment__unicode |
| ||
client_environment__ocsp_mode |
| - | |
client_build_id |
| - | |
client_version |
| ||
hostchain |
| ✓ | |
tag |
| ✓ | |
rawMessage |
| ✓ |