{
"SNOWFLAKE": {
"ACCOUNT_USAGE": {
"ACCESS_HISTORY": {
"description": "Tracks access to objects by queries, including direct and base objects accessed, modifications, and referenced policies.",
"columns": [
"QUERY_ID", "QUERY_START_TIME", "USER_NAME", "DIRECT_OBJECTS_ACCESSED",
"BASE_OBJECTS_ACCESSED", "OBJECTS_MODIFIED", "OBJECT_MODIFIED_BY_DDL",
"POLICIES_REFERENCED", "PARENT_QUERY_ID", "ROOT_QUERY_ID"
]
},
"AUTOMATIC_CLUSTERING_HISTORY": {
"description": "Records automatic clustering operations, including resource usage and re-clustered data.",
"columns": [
"START_TIME", "END_TIME", "CREDITS_USED", "NUM_BYTES_RECLUSTERED",
"NUM_ROWS_RECLUSTERED", "TABLE_ID", "TABLE_NAME", "SCHEMA_ID",
"SCHEMA_NAME", "DATABASE_ID", "DATABASE_NAME", "INSTANCE_ID"
]
},
"COLUMNS": {
"description": "Metadata about table columns, including data types, constraints, and identity properties.",
"columns": [
"COLUMN_ID", "COLUMN_NAME", "TABLE_ID", "TABLE_NAME", "TABLE_SCHEMA_ID",
"TABLE_SCHEMA", "TABLE_CATALOG_ID", "TABLE_CATALOG", "ORDINAL_POSITION",
"COLUMN_DEFAULT", "IS_NULLABLE", "DATA_TYPE", "CHARACTER_MAXIMUM_LENGTH",
"CHARACTER_OCTET_LENGTH", "NUMERIC_PRECISION", "NUMERIC_PRECISION_RADIX",
"NUMERIC_SCALE", "DATETIME_PRECISION", "INTERVAL_TYPE", "INTERVAL_PRECISION",
"CHARACTER_SET_CATALOG", "CHARACTER_SET_SCHEMA", "CHARACTER_SET_NAME",
"COLLATION_CATALOG", "COLLATION_SCHEMA", "COLLATION_NAME", "DOMAIN_CATALOG",
"DOMAIN_SCHEMA", "DOMAIN_NAME", "UDT_CATALOG", "UDT_SCHEMA", "UDT_NAME",
"SCOPE_CATALOG", "SCOPE_SCHEMA", "SCOPE_NAME", "MAXIMUM_CARDINALITY",
"DTD_IDENTIFIER", "IS_SELF_REFERENCING", "IS_IDENTITY", "IDENTITY_GENERATION",
"IDENTITY_START", "IDENTITY_INCREMENT", "IDENTITY_MAXIMUM", "IDENTITY_MINIMUM",
"IDENTITY_CYCLE", "IDENTITY_ORDERED", "SCHEMA_EVOLUTION_RECORD", "COMMENT",
"DELETED"
]
},
"DATABASE_STORAGE_USAGE_HISTORY": {
"description": "Tracks storage usage for databases, including average bytes and failsafe bytes.",
"columns": [
"USAGE_DATE", "DATABASE_ID", "DATABASE_NAME", "DELETED",
"AVERAGE_DATABASE_BYTES", "AVERAGE_FAILSAFE_BYTES",
"AVERAGE_HYBRID_TABLE_STORAGE_BYTES"
]
},
"DATA_TRANSFER_HISTORY": {
"description": "Records data transfer details between clouds and regions.",
"columns": [
"START_TIME", "END_TIME", "SOURCE_CLOUD", "SOURCE_REGION",
"TARGET_CLOUD", "TARGET_REGION", "BYTES_TRANSFERRED", "TRANSFER_TYPE"
]
},
"GRANTS_TO_ROLES": {
"description": "Details privileges granted to roles, including creation and modification timestamps.",
"columns": [
"CREATED_ON", "MODIFIED_ON", "PRIVILEGE", "GRANTED_ON", "NAME",
"TABLE_CATALOG", "TABLE_SCHEMA", "GRANTED_TO", "GRANTEE_NAME",
"GRANT_OPTION", "GRANTED_BY", "DELETED_ON", "GRANTED_BY_ROLE_TYPE",
"OBJECT_INSTANCE"
]
},
"GRANTS_TO_USERS": {
"description": "Records role grants to users, including creation and deletion details.",
"columns": [
"CREATED_ON", "DELETED_ON", "ROLE", "GRANTED_TO", "GRANTEE_NAME",
"GRANTED_BY"
]
},
"LOGIN_HISTORY": {
"description": "Tracks login attempts, including authentication details and success status.",
"columns": [
"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", "CLIENT_PRIVATE_LINK_ID"
]
},
"METERING_HISTORY": {
"description": "Records resource usage metrics for various services.",
"columns": [
"SERVICE_TYPE", "START_TIME", "END_TIME", "ENTITY_ID", "NAME",
"CREDITS_USED_COMPUTE", "CREDITS_USED_CLOUD_SERVICES", "CREDITS_USED",
"BYTES", "ROWS", "FILES", "BUDGET_ID"
]
},
"OBJECT_DEPENDENCIES": {
"description": "Tracks dependencies between database objects.",
"columns": [
"REFERENCED_DATABASE", "REFERENCED_SCHEMA", "REFERENCED_OBJECT_NAME",
"REFERENCED_OBJECT_ID", "REFERENCED_OBJECT_DOMAIN", "REFERENCING_DATABASE",
"REFERENCING_SCHEMA", "REFERENCING_OBJECT_NAME", "REFERENCING_OBJECT_ID",
"REFERENCING_OBJECT_DOMAIN", "DEPENDENCY_TYPE"
]
},
"PIPE_USAGE_HISTORY": {
"description": "Records usage of data pipelines, including credits and data inserted.",
"columns": [
"PIPE_ID", "PIPE_NAME", "START_TIME", "END_TIME", "CREDITS_USED",
"BYTES_INSERTED", "FILES_INSERTED"
]
},
"QUERY_ACCELERATION_HISTORY": {
"description": "Tracks query acceleration usage, including credits and warehouse details.",
"columns": [
"START_TIME", "END_TIME", "CREDITS_USED", "WAREHOUSE_ID", "WAREHOUSE_NAME"
]
},
"QUERY_HISTORY": {
"description": "Detailed history of executed queries, including performance metrics and resource usage.",
"columns": [
"QUERY_ID", "QUERY_TEXT", "DATABASE_ID", "DATABASE_NAME", "SCHEMA_ID",
"SCHEMA_NAME", "QUERY_TYPE", "SESSION_ID", "USER_NAME", "ROLE_NAME",
"WAREHOUSE_ID", "WAREHOUSE_NAME", "WAREHOUSE_SIZE", "WAREHOUSE_TYPE",
"CLUSTER_NUMBER", "QUERY_TAG", "EXECUTION_STATUS", "ERROR_CODE",
"ERROR_MESSAGE", "START_TIME", "END_TIME", "TOTAL_ELAPSED_TIME",
"BYTES_SCANNED", "PERCENTAGE_SCANNED_FROM_CACHE", "BYTES_WRITTEN",
"BYTES_WRITTEN_TO_RESULT", "BYTES_READ_FROM_RESULT", "ROWS_PRODUCED",
"ROWS_INSERTED", "ROWS_UPDATED", "ROWS_DELETED", "ROWS_UNLOADED",
"BYTES_DELETED", "PARTITIONS_SCANNED", "PARTITIONS_TOTAL",
"BYTES_SPILLED_TO_LOCAL_STORAGE", "BYTES_SPILLED_TO_REMOTE_STORAGE",
"BYTES_SENT_OVER_THE_NETWORK", "COMPILATION_TIME", "EXECUTION_TIME",
"QUEUED_PROVISIONING_TIME", "QUEUED_REPAIR_TIME", "QUEUED_OVERLOAD_TIME",
"TRANSACTION_BLOCKED_TIME", "OUTBOUND_DATA_TRANSFER_CLOUD",
"OUTBOUND_DATA_TRANSFER_REGION", "OUTBOUND_DATA_TRANSFER_BYTES",
"INBOUND_DATA_TRANSFER_CLOUD", "INBOUND_DATA_TRANSFER_REGION",
"INBOUND_DATA_TRANSFER_BYTES", "LIST_EXTERNAL_FILES_TIME",
"CREDITS_USED_CLOUD_SERVICES", "RELEASE_VERSION",
"EXTERNAL_FUNCTION_TOTAL_INVOCATIONS", "EXTERNAL_FUNCTION_TOTAL_SENT_ROWS",
"EXTERNAL_FUNCTION_TOTAL_RECEIVED_ROWS", "EXTERNAL_FUNCTION_TOTAL_SENT_BYTES",
"EXTERNAL_FUNCTION_TOTAL_RECEIVED_BYTES", "QUERY_LOAD_PERCENT",
"IS_CLIENT_GENERATED_STATEMENT", "QUERY_ACCELERATION_BYTES_SCANNED",
"QUERY_ACCELERATION_PARTITIONS_SCANNED", "QUERY_ACCELERATION_UPPER_LIMIT_SCALE_FACTOR",
"TRANSACTION_ID", "CHILD_QUERIES_WAIT_TIME", "ROLE_TYPE", "QUERY_HASH",
"QUERY_HASH_VERSION", "QUERY_PARAMETERIZED_HASH", "QUERY_PARAMETERIZED_HASH_VERSION",
"SECONDARY_ROLE_STATS", "ROWS_WRITTEN_TO_RESULT", "QUERY_RETRY_TIME",
"QUERY_RETRY_CAUSE", "FAULT_HANDLING_TIME", "USER_TYPE", "USER_DATABASE_NAME",
"USER_DATABASE_ID", "USER_SCHEMA_NAME", "USER_SCHEMA_ID"
]
},
"REFERENTIAL_CONSTRAINTS": {
"description": "Details referential constraints between tables, including rules and metadata.",
"columns": [
"CONSTRAINT_CATALOG_ID", "CONSTRAINT_CATALOG", "CONSTRAINT_SCHEMA_ID",
"CONSTRAINT_SCHEMA", "CONSTRAINT_NAME", "UNIQUE_CONSTRAINT_CATALOG_ID",
"UNIQUE_CONSTRAINT_CATALOG", "UNIQUE_CONSTRAINT_SCHEMA_ID",
"UNIQUE_CONSTRAINT_SCHEMA", "UNIQUE_CONSTRAINT_NAME", "MATCH_OPTION",
"UPDATE_RULE", "DELETE_RULE", "COMMENT", "CREATED", "LAST_ALTERED",
"DELETED"
]
},
"REPLICATION_USAGE_HISTORY": {
"description": "Tracks replication usage, including credits and bytes transferred.",
"columns": [
"START_TIME", "END_TIME", "DATABASE_NAME", "DATABASE_ID",
"CREDITS_USED", "BYTES_TRANSFERRED"
]
},
"ROLES": {
"description": "Information about roles, including creation and ownership details.",
"columns": [
"ROLE_ID", "CREATED_ON", "DELETED_ON", "NAME", "COMMENT", "OWNER",
"ROLE_TYPE", "ROLE_DATABASE_NAME", "ROLE_INSTANCE_ID", "OWNER_ROLE_TYPE"
]
},
"SESSIONS": {
"description": "Tracks user sessions, including authentication and client details.",
"columns": [
"SESSION_ID", "CREATED_ON", "USER_NAME", "AUTHENTICATION_METHOD",
"LOGIN_EVENT_ID", "CLIENT_APPLICATION_VERSION", "CLIENT_APPLICATION_ID",
"CLIENT_ENVIRONMENT", "CLIENT_BUILD_ID", "CLIENT_VERSION", "CLOSED_REASON"
]
},
"STAGE_STORAGE_USAGE_HISTORY": {
"description": "Records storage usage for stages.",
"columns": ["USAGE_DATE", "AVERAGE_STAGE_BYTES"]
},
"TABLES": {
"description": "Metadata about tables, including ownership, type, and storage details.",
"columns": [
"TABLE_ID", "TABLE_NAME", "TABLE_SCHEMA_ID", "TABLE_SCHEMA",
"TABLE_CATALOG_ID", "TABLE_CATALOG", "TABLE_OWNER", "TABLE_TYPE",
"IS_TRANSIENT", "IS_ICEBERG", "IS_DYNAMIC", "IS_HYBRID", "CLUSTERING_KEY",
"ROW_COUNT", "BYTES", "RETENTION_TIME", "SELF_REFERENCING_COLUMN_NAME",
"REFERENCE_GENERATION", "USER_DEFINED_TYPE_CATALOG", "USER_DEFINED_TYPE_SCHEMA",
"USER_DEFINED_TYPE_NAME", "IS_INSERTABLE_INTO", "IS_TYPED", "COMMIT_ACTION",
"CREATED", "LAST_ALTERED", "LAST_DDL", "LAST_DDL_BY", "DELETED",
"AUTO_CLUSTERING_ON", "COMMENT", "OWNER_ROLE_TYPE", "INSTANCE_ID"
]
},
"TAG_REFERENCES": {
"description": "Tracks tags applied to objects or columns, including metadata.",
"columns": [
"TAG_DATABASE", "TAG_SCHEMA", "TAG_ID", "TAG_NAME", "TAG_VALUE",
"OBJECT_DATABASE", "OBJECT_SCHEMA", "OBJECT_ID", "OBJECT_NAME",
"OBJECT_DELETED", "DOMAIN", "COLUMN_ID", "COLUMN_NAME", "APPLY_METHOD"
]
},
"TASK_HISTORY": {
"description": "Records task execution details, including status and errors.",
"columns": [
"NAME", "QUERY_TEXT", "CONDITION_TEXT", "SCHEMA_NAME", "TASK_SCHEMA_ID",
"DATABASE_NAME", "TASK_DATABASE_ID", "SCHEDULED_TIME", "COMPLETED_TIME",
"STATE", "RETURN_VALUE", "QUERY_ID", "QUERY_START_TIME", "ERROR_CODE",
"ERROR_MESSAGE", "GRAPH_VERSION", "RUN_ID", "ROOT_TASK_ID", "SCHEDULED_FROM",
"INSTANCE_ID", "ATTEMPT_NUMBER", "CONFIG", "QUERY_HASH", "QUERY_HASH_VERSION",
"QUERY_PARAMETERIZED_HASH", "QUERY_PARAMETERIZED_HASH_VERSION",
"GRAPH_RUN_GROUP_ID", "BACKFILL_INFO"
]
},
"USERS": {
"description": "Details about users, including authentication and role settings.",
"columns": [
"USER_ID", "NAME", "CREATED_ON", "DELETED_ON", "LOGIN_NAME",
"DISPLAY_NAME", "FIRST_NAME", "LAST_NAME", "EMAIL", "MUST_CHANGE_PASSWORD",
"HAS_PASSWORD", "COMMENT", "DISABLED", "SNOWFLAKE_LOCK", "DEFAULT_WAREHOUSE",
"DEFAULT_NAMESPACE", "DEFAULT_ROLE", "EXT_AUTHN_DUO", "EXT_AUTHN_UID",
"HAS_MFA", "BYPASS_MFA_UNTIL", "LAST_SUCCESS_LOGIN", "EXPIRES_AT",
"LOCKED_UNTIL_TIME", "HAS_RSA_PUBLIC_KEY", "PASSWORD_LAST_SET_TIME",
"OWNER", "DEFAULT_SECONDARY_ROLE", "TYPE", "DATABASE_NAME",
"DATABASE_ID", "SCHEMA_NAME", "SCHEMA_ID"
]
},
"VIEWS": {
"description": "Metadata about views, including definitions and ownership.",
"columns": [
"TABLE_ID", "TABLE_NAME", "TABLE_SCHEMA_ID", "TABLE_SCHEMA",
"TABLE_CATALOG_ID", "TABLE_CATALOG", "TABLE_OWNER", "VIEW_DEFINITION",
"CHECK_OPTION", "IS_UPDATABLE", "INSERTABLE_INTO", "IS_SECURE",
"CREATED", "LAST_ALTERED", "LAST_DDL", "LAST_DDL_BY", "DELETED",
"COMMENT", "OWNER_ROLE_TYPE", "INSTANCE_ID"
]
},
"WAREHOUSE_EVENTS_HISTORY": {
"description": "Tracks warehouse events, such as state changes and reasons.",
"columns": [
"TIMESTAMP", "WAREHOUSE_ID", "WAREHOUSE_NAME", "CLUSTER_NUMBER",
"EVENT_NAME", "EVENT_REASON", "EVENT_STATE", "USER_NAME", "ROLE_NAME",
"QUERY_ID", "SIZE", "CLUSTER_COUNT", "WAREHOUSE_TYPE", "RESOURCE_CONSTRAINT"
]
},
"WAREHOUSE_LOAD_HISTORY": {
"description": "Records warehouse load metrics, including running and queued queries.",
"columns": [
"START_TIME", "END_TIME", "WAREHOUSE_ID", "WAREHOUSE_NAME",
"AVG_RUNNING", "AVG_QUEUED_LOAD", "AVG_QUEUED_PROVISIONING", "AVG_BLOCKED"
]
},
"WAREHOUSE_METERING_HISTORY": {
"description": "Tracks warehouse metering, including credits used for compute and cloud services.",
"columns": [
"START_TIME", "END_TIME", "WAREHOUSE_ID", "WAREHOUSE_NAME",
"CREDITS_USED", "CREDITS_USED_COMPUTE", "CREDITS_USED_CLOUD_SERVICES",
"CREDITS_ATTRIBUTED_COMPUTE_QUERIES"
]
}
},
"INFORMATION_SCHEMA": {
"COLUMNS": {
"description": "Metadata about table columns, similar to ACCOUNT_USAGE.COLUMNS but scoped to accessible schemas.",
"columns": [
"TABLE_CATALOG", "TABLE_SCHEMA", "TABLE_NAME", "COLUMN_NAME",
"ORDINAL_POSITION", "COLUMN_DEFAULT", "IS_NULLABLE", "DATA_TYPE",
"CHARACTER_MAXIMUM_LENGTH", "CHARACTER_OCTET_LENGTH", "NUMERIC_PRECISION",
"NUMERIC_PRECISION_RADIX", "NUMERIC_SCALE", "DATETIME_PRECISION",
"INTERVAL_TYPE", "INTERVAL_PRECISION", "CHARACTER_SET_CATALOG",
"CHARACTER_SET_SCHEMA", "CHARACTER_SET_NAME", "COLLATION_CATALOG",
"COLLATION_SCHEMA", "COLLATION_NAME", "DOMAIN_CATALOG", "DOMAIN_SCHEMA",
"DOMAIN_NAME", "UDT_CATALOG", "UDT_SCHEMA", "UDT_NAME", "SCOPE_CATALOG",
"SCOPE_SCHEMA", "SCOPE_NAME", "MAXIMUM_CARDINALITY", "DTD_IDENTIFIER",
"IS_SELF_REFERENCING", "IS_IDENTITY", "IDENTITY_GENERATION",
"IDENTITY_START", "IDENTITY_INCREMENT", "IDENTITY_MAXIMUM",
"IDENTITY_MINIMUM", "IDENTITY_CYCLE", "IDENTITY_ORDERED",
"SCHEMA_EVOLUTION_RECORD", "COMMENT"
]
},
"OBJECT_PRIVILEGES": {
"description": "Details privileges granted on objects, including grantor and grantee information.",
"columns": [
"GRANTOR", "GRANTEE", "GRANTED_TO", "OBJECT_CATALOG", "OBJECT_SCHEMA",
"OBJECT_NAME", "OBJECT_TYPE", "PRIVILEGE_TYPE", "IS_GRANTABLE", "CREATED"
]
},
"REFERENTIAL_CONSTRAINTS": {
"description": "Details referential constraints, similar to ACCOUNT_USAGE.REFERENTIAL_CONSTRAINTS but scoped to accessible schemas.",
"columns": [
"CONSTRAINT_CATALOG", "CONSTRAINT_SCHEMA", "CONSTRAINT_NAME",
"UNIQUE_CONSTRAINT_CATALOG", "UNIQUE_CONSTRAINT_SCHEMA",
"UNIQUE_CONSTRAINT_NAME", "MATCH_OPTION", "UPDATE_RULE", "DELETE_RULE",
"COMMENT", "CREATED", "LAST_ALTERED"
]
},
"TABLES": {
"description": "Metadata about tables, similar to ACCOUNT_USAGE.TABLES but scoped to accessible schemas.",
"columns": [
"TABLE_CATALOG", "TABLE_SCHEMA", "TABLE_NAME", "TABLE_OWNER",
"TABLE_TYPE", "IS_TRANSIENT", "CLUSTERING_KEY", "ROW_COUNT", "BYTES",
"RETENTION_TIME", "SELF_REFERENCING_COLUMN_NAME", "REFERENCE_GENERATION",
"USER_DEFINED_TYPE_CATALOG", "USER_DEFINED_TYPE_SCHEMA",
"USER_DEFINED_TYPE_NAME", "IS_INSERTABLE_INTO", "IS_TYPED",
"COMMIT_ACTION", "CREATED", "LAST_ALTERED", "LAST_DDL", "LAST_DDL_BY",
"AUTO_CLUSTERING_ON", "COMMENT", "IS_TEMPORARY", "IS_ICEBERG",
"IS_DYNAMIC", "IS_IMMUTABLE", "IS_HYBRID"
]
},
"VIEWS": {
"description": "Metadata about views, similar to ACCOUNT_USAGE.VIEWS but scoped to accessible schemas.",
"columns": [
"TABLE_CATALOG", "TABLE_SCHEMA", "TABLE_NAME", "TABLE_OWNER",
"VIEW_DEFINITION", "CHECK_OPTION", "IS_UPDATABLE", "INSERTABLE_INTO",
"IS_SECURE", "CREATED", "LAST_ALTERED", "LAST_DDL", "LAST_DDL_BY",
"COMMENT"
]
}
}
}
}
Armaan Khan
Posted on
cols available
For further actions, you may consider blocking this person and/or reporting abuse
Top comments (0)