I am working with the view SNOWFLAKE.ACCOUNT_USAGE.QUERY_HISTORY. It would be extremely helpful to have an exhaustive list of query types that might appear in the column QUERY_TYPE, with the type of commands that generate them. For example, does a PUT command generate a PUT query type? Or is it something like "LOAD"?
If anyone knows where such a list can be found, please post a link. Snowflake's documentation of the view does not provide any list.
Thanks all who have answered so far. Since the consensus is that no such list exists, here is a merge of the entries provided so far with the values found in my own database. Please keep posting additional answers if your DB contains entries not found below. This way, sooner or later, we will have a fairly complete list:
| QUERY_TYPE |
|---|
| CREATE_USER |
| REVOKE |
| DROP_CONSTRAINT |
| RENAME_SCHEMA |
| UPDATE |
| CREATE_VIEW |
| CREATE_TASK |
| RENAME_TABLE |
| INSERT |
| ALTER_TABLE_ADD_COLUMN |
| RENAME_COLUMN |
| MERGE |
| BEGIN_TRANSACTION |
| ALTER_VIEW_MODIFY_SECURITY |
| GRANT |
| ALTER_SESSION |
| DELETE |
| DROP_ROLE |
| DESCRIBE |
| UNKNOWN |
| TRUNCATE_TABLE |
| DROP |
| SHOW |
| ALTER_WAREHOUSE_SUSPEND |
| GET_FILES |
| UNLOAD |
| CREATE_NETWORK_POLICY |
| ALTER_TABLE_DROP_COLUMN |
| CREATE |
| REMOVE_FILES |
| ALTER |
| ALTER_USER |
| PUT_FILES |
| COPY |
| ALTER_ACCOUNT |
| DROP_TASK |
| CREATE_CONSTRAINT |
| DESCRIBE_QUERY |
| SELECT |
| RENAME_USER |
| COMMIT |
| RENAME_VIEW |
| USE |
| CREATE_TABLE |
| ALTER_NETWORK_POLICY |
| CREATE_ROLE |
| ALTER_TABLE_MODIFY_COLUMN |
| SET |
| ALTER_USER_ABORT_ALL_JOBS |
| ROLLBACK |
| LIST_FILES |
| UNSET |
| CREATE_TABLE_AS_SELECT |
| DROP_USER |
| ALTER_WAREHOUSE_RESUME |
| QUERY_TYPE |
| ALTER_PIPE |
| ALTER_ROLE |
| ALTER_TABLE |
| ALTER_TABLE_DROP_CLUSTERING_KEY |
| ALTER_USER_RESET_PASSWORD |
| CREATE_EXTERNAL_TABLE |
| CREATE_MASKING_POLICY |
| CREATE_SEQUENCE |
| CREATE_STREAM |
| DROP_STREAM |
| RENAME_DATABASE |
| RENAME_FILE_FORMAT |
| RENAME_ROLE |
| RENAME_WAREHOUSE |
| RESTORE |
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With