...
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.
...
...
Brand
...
Type
...
Subtype
...
db
...
snowflake
...
history
...
access
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.
How is the data sent to Devo?
Use the Snowflake collector.
Table structure
This is These are the set fields displayed by in these tables:
db.snowflake.history.access
| Anchor | ||||
|---|---|---|---|---|
|
Field | Type | Extra |
|---|
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 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 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 |
| ✓ |