{
"ALL_TABLES_DETAILED_ANALYSIS": [
"DATABASE_NAME TEXT",
"TABLE_SCHEMA TEXT",
"TABLE_NAME TEXT",
"OWNER TEXT",
"TABLE_CREATION_DATE TIMESTAMP_LTZ",
"CURRENT_ROW_COUNT NUMBER",
"SIZE_GB FLOAT",
"SIZE_BUCKET TEXT",
"SNOWFLAKE_TABLE_TYPE TEXT",
"TIME_TRAVEL_DAYS NUMBER",
"HAS_TIME_TRAVEL BOOLEAN",
"IS_EXTERNAL_TABLE BOOLEAN",
"IS_DYNAMIC_TABLE TEXT",
"IS_TRANSIENT_TABLE TEXT",
"HAS_CLUSTERING_KEY BOOLEAN",
"LAST_ACCESSED_TIMESTAMP TIMESTAMP_LTZ",
"IS_UNUSED_IN_LAST_6_MONTHS BOOLEAN",
"TOTAL_QUERIES_ACCESSING_TABLE NUMBER",
"TOTAL_CLOUD_SERVICE_CREDITS_FOR_TABLE FLOAT",
"HIGH_SCAN_QUERIES_ACCESSING_TABLE NUMBER",
"TOTAL_QUERY_ELAPSED_TIME_MS NUMBER",
"TOTAL_BYTES_SPILLED_LOCAL_FOR_TABLE NUMBER",
"TOTAL_BYTES_SPILLED_REMOTE_FOR_TABLE NUMBER",
"DATABASE_FAILSAFE_SIZE_GB FLOAT",
"ANALYSIS_RUN_TIMESTAMP TIMESTAMP_LTZ"
],
"QUERY_DETAILS_COMPLETE": [
"QUERY_ID TEXT",
"QUERY_TEXT TEXT",
"QUERY_HASH TEXT",
"QUERY_HASH_VERSION NUMBER",
"QUERY_PARAMETERIZED_HASH TEXT",
"QUERY_PARAMETERIZED_HASH_VERSION NUMBER",
"QUERY_TYPE TEXT",
"QUERY_TAG TEXT",
"START_TIME TIMESTAMP_LTZ",
"END_TIME TIMESTAMP_LTZ",
"TOTAL_ELAPSED_TIME NUMBER",
"COMPILATION_TIME NUMBER",
"EXECUTION_TIME NUMBER",
"QUEUED_PROVISIONING_TIME NUMBER",
"QUEUED_REPAIR_TIME NUMBER",
"QUEUED_OVERLOAD_TIME NUMBER",
"TRANSACTION_BLOCKED_TIME NUMBER",
"CHILD_QUERIES_WAIT_TIME NUMBER",
"QUERY_RETRY_TIME NUMBER",
"QUERY_RETRY_CAUSE TEXT",
"FAULT_HANDLING_TIME NUMBER",
"LIST_EXTERNAL_FILES_TIME NUMBER",
"USER_NAME TEXT",
"USER_TYPE TEXT",
"ROLE_NAME TEXT",
"ROLE_TYPE TEXT",
"SECONDARY_ROLE_STATS TEXT",
"SESSION_ID NUMBER",
"WAREHOUSE_ID NUMBER",
"WAREHOUSE_NAME TEXT",
"WAREHOUSE_SIZE TEXT",
"WAREHOUSE_TYPE TEXT",
"CLUSTER_NUMBER NUMBER",
"QUERY_LOAD_PERCENT NUMBER",
"DATABASE_ID NUMBER",
"DATABASE_NAME TEXT",
"SCHEMA_ID NUMBER",
"SCHEMA_NAME TEXT",
"USER_DATABASE_ID NUMBER",
"USER_DATABASE_NAME TEXT",
"USER_SCHEMA_ID NUMBER",
"USER_SCHEMA_NAME TEXT",
"EXECUTION_STATUS TEXT",
"ERROR_CODE TEXT",
"ERROR_MESSAGE TEXT",
"IS_CLIENT_GENERATED_STATEMENT BOOLEAN",
"BYTES_SCANNED NUMBER",
"PERCENTAGE_SCANNED_FROM_CACHE FLOAT",
"BYTES_WRITTEN NUMBER",
"BYTES_WRITTEN_TO_RESULT NUMBER",
"BYTES_READ_FROM_RESULT NUMBER",
"ROWS_PRODUCED NUMBER",
"ROWS_WRITTEN_TO_RESULT NUMBER",
"ROWS_INSERTED NUMBER",
"ROWS_UPDATED NUMBER",
"ROWS_DELETED NUMBER",
"ROWS_UNLOADED NUMBER",
"BYTES_DELETED NUMBER",
"PARTITIONS_SCANNED NUMBER",
"PARTITIONS_TOTAL NUMBER",
"PARTITION_SCAN_PERCENTAGE FLOAT",
"BYTES_SPILLED_TO_LOCAL_STORAGE NUMBER",
"BYTES_SPILLED_TO_REMOTE_STORAGE NUMBER",
"BYTES_SENT_OVER_THE_NETWORK NUMBER",
"CREDITS_USED_CLOUD_SERVICES FLOAT",
"OUTBOUND_DATA_TRANSFER_CLOUD TEXT",
"OUTBOUND_DATA_TRANSFER_REGION TEXT",
"OUTBOUND_DATA_TRANSFER_BYTES NUMBER",
"INBOUND_DATA_TRANSFER_CLOUD TEXT",
"INBOUND_DATA_TRANSFER_REGION TEXT",
"INBOUND_DATA_TRANSFER_BYTES NUMBER",
"EXTERNAL_FUNCTION_TOTAL_INVOCATIONS NUMBER",
"EXTERNAL_FUNCTION_TOTAL_SENT_ROWS NUMBER",
"EXTERNAL_FUNCTION_TOTAL_RECEIVED_ROWS NUMBER",
"EXTERNAL_FUNCTION_TOTAL_SENT_BYTES NUMBER",
"EXTERNAL_FUNCTION_TOTAL_RECEIVED_BYTES NUMBER",
"QUERY_ACCELERATION_BYTES_SCANNED NUMBER",
"QUERY_ACCELERATION_PARTITIONS_SCANNED NUMBER",
"QUERY_ACCELERATION_UPPER_LIMIT_SCALE_FACTOR NUMBER",
"TRANSACTION_ID NUMBER",
"RELEASE_VERSION TEXT",
"COMPILATION_TIME_PERCENTAGE FLOAT",
"EXECUTION_TIME_PERCENTAGE FLOAT",
"ROWS_PER_MB_SCANNED FLOAT",
"PERFORMANCE_CATEGORY TEXT",
"CACHE_EFFICIENCY TEXT",
"SPILL_CLASSIFICATION TEXT",
"ANALYSIS_TIMESTAMP TIMESTAMP_LTZ",
"ANALYSIS_DATE DATE"
],
"QUERY_HISTORY_SUMMARY": [
"QUERY_ID TEXT",
"QUERY_HASH TEXT",
"QUERY_PARAMETERIZED_HASH TEXT",
"QUERY_TEXT_PREVIEW TEXT",
"QUERY_TYPE TEXT",
"QUERY_TAG TEXT",
"START_TIME TIMESTAMP_LTZ",
"END_TIME TIMESTAMP_LTZ",
"TOTAL_ELAPSED_TIME NUMBER",
"COMPILATION_TIME NUMBER",
"EXECUTION_TIME NUMBER",
"USER_NAME TEXT",
"USER_TYPE TEXT",
"ROLE_NAME TEXT",
"ROLE_TYPE TEXT",
"SESSION_ID NUMBER",
"WAREHOUSE_ID NUMBER",
"WAREHOUSE_NAME TEXT",
"WAREHOUSE_SIZE TEXT",
"WAREHOUSE_TYPE TEXT",
"CLUSTER_NUMBER NUMBER",
"DATABASE_ID NUMBER",
"DATABASE_NAME TEXT",
"SCHEMA_ID NUMBER",
"SCHEMA_NAME TEXT",
"USER_DATABASE_NAME TEXT",
"USER_SCHEMA_NAME TEXT",
"EXECUTION_STATUS TEXT",
"ERROR_CODE TEXT",
"ERROR_MESSAGE_PREVIEW TEXT",
"BYTES_SCANNED NUMBER",
"PERCENTAGE_SCANNED_FROM_CACHE FLOAT",
"BYTES_WRITTEN NUMBER",
"ROWS_PRODUCED NUMBER",
"ROWS_INSERTED NUMBER",
"ROWS_UPDATED NUMBER",
"ROWS_DELETED NUMBER",
"CREDITS_USED_CLOUD_SERVICES FLOAT",
"BYTES_SPILLED_TO_LOCAL_STORAGE NUMBER",
"BYTES_SPILLED_TO_REMOTE_STORAGE NUMBER",
"PARTITIONS_SCANNED NUMBER",
"PARTITIONS_TOTAL NUMBER",
"QUEUED_PROVISIONING_TIME NUMBER",
"QUEUED_REPAIR_TIME NUMBER",
"QUEUED_OVERLOAD_TIME NUMBER",
"TRANSACTION_BLOCKED_TIME NUMBER",
"DURATION_BUCKET TEXT",
"CREDIT_BUCKET TEXT",
"SPILL_STATUS TEXT",
"QUEUE_STATUS TEXT",
"ANALYSIS_TIMESTAMP TIMESTAMP_LTZ",
"ANALYSIS_DATE DATE"
],
"WAREHOUSE_ANALYTICS_DASHBOARD_with_queries": [
"WAREHOUSE_ID NUMBER(38,0)",
"WAREHOUSE_NAME VARCHAR(16777216)",
"WAREHOUSE_SIZE VARCHAR(16777216)",
"WAREHOUSE_TYPE VARCHAR(16777216)",
"CLUSTER_COUNT VARCHAR(16777216)",
"SUSPEND_POLICY VARCHAR(16777216)",
"MIN_CLUSTER_COUNT VARCHAR(16777216)",
"MAX_CLUSTER_COUNT VARCHAR(16777216)",
"QUERIES_1_10_SEC NUMBER(18,0)",
"QUERIES_10_20_SEC NUMBER(18,0)",
"QUERIES_20_60_SEC NUMBER(18,0)",
"QUERIES_1_3_MIN NUMBER(18,0)",
"QUERIES_3_5_MIN NUMBER(18,0)",
"QUERIES_5_PLUS_MIN NUMBER(18,0)",
"QUEUED_1_2_MIN NUMBER(18,0)",
"QUEUED_2_5_MIN NUMBER(18,0)",
"QUEUED_5_10_MIN NUMBER(18,0)",
"QUEUED_10_20_MIN NUMBER(18,0)",
"QUEUED_20_PLUS_MIN NUMBER(18,0)",
"QUERIES_SPILLED_LOCAL NUMBER(18,0)",
"QUERIES_SPILLED_REMOTE NUMBER(18,0)",
"TOTAL_BYTES_SPILLED_LOCAL NUMBER(38,0)",
"TOTAL_BYTES_SPILLED_REMOTE NUMBER(38,0)",
"FAILED_QUERIES NUMBER(18,0)",
"SUCCESSFUL_QUERIES NUMBER(18,0)",
"RUNNING_QUERIES NUMBER(18,0)",
"QUERIES_0_20_CENTS NUMBER(18,0)",
"QUERIES_20_40_CENTS NUMBER(18,0)",
"QUERIES_40_60_CENTS NUMBER(18,0)",
"QUERIES_60_80_CENTS NUMBER(18,0)",
"QUERIES_80_100_CENTS NUMBER(18,0)",
"QUERIES_100_PLUS_CENTS NUMBER(18,0)",
"QUERY_IDS OBJECT",
"TOTAL_QUERIES NUMBER(18,0)",
"TOTAL_CREDITS_USED NUMBER(38,9)",
"TOTAL_COMPUTE_CREDITS NUMBER(38,9)",
"TOTAL_CLOUD_SERVICES_CREDITS NUMBER(38,9)",
"ANALYSIS_TIMESTAMP TIMESTAMP_LTZ(9)",
"ANALYSIS_DATE DATE"
],
"user_query_performance_report": [
"USER_NAME VARCHAR(16777216)",
"TOTAL_QUERIES NUMBER(18,0)",
"WAREHOUSES_USED NUMBER(18,0)",
"DATABASES_ACCESSED NUMBER(18,0)",
"TOTAL_CREDITS FLOAT",
"AVG_EXECUTION_TIME_MS NUMBER(38,2)",
"AVG_BYTES_PER_ROW NUMBER(38,2)",
"TOTAL_DATA_SCANNED_GB FLOAT",
"FAILURE_CANCELLATION_RATE_PCT NUMBER(24,2)",
"SPILLED_QUERIES NUMBER(13,0)",
"OVER_PROVISIONED_QUERIES NUMBER(13,0)",
"PEAK_HOUR_LONG_RUNNING_QUERIES NUMBER(13,0)",
"SELECT_STAR_QUERIES NUMBER(13,0)",
"UNPARTITIONED_SCAN_QUERIES NUMBER(13,0)",
"REPEATED_QUERIES NUMBER(19,0)",
"COMPLEX_JOIN_QUERIES NUMBER(13,0)",
"ZERO_RESULT_QUERIES NUMBER(13,0)",
"HIGH_COMPILE_QUERIES NUMBER(13,0)",
"UNTAGGED_QUERIES NUMBER(13,0)",
"UNLIMITED_ORDER_BY_QUERIES NUMBER(13,0)",
"LARGE_GROUP_BY_QUERIES NUMBER(13,0)",
"SLOW_QUERIES NUMBER(13,0)",
"EXPENSIVE_DISTINCT_QUERIES NUMBER(13,0)",
"INEFFICIENT_LIKE_QUERIES NUMBER(13,0)",
"NO_RESULTS_WITH_SCAN_QUERIES NUMBER(13,0)",
"CARTESIAN_JOIN_QUERIES NUMBER(13,0)",
"HIGH_COMPILE_RATIO_QUERIES NUMBER(13,0)",
"WEIGHTED_SCORE NUMBER(34,0)",
"COST_STATUS VARCHAR(9)",
"RECOMMENDATIONS ARRAY",
"QUERY_SAMPLES OBJECT"
],
"dashboard_analytic": [
"NAME VARCHAR(16777216)",
"TYPE VARCHAR(8)",
"OWNER VARCHAR(16777216)",
"SIZE_GB FLOAT",
"COUNT_0_1_GB NUMBER(13,0)",
"SIZE_0_1_GB FLOAT",
"COUNT_1_5_GB NUMBER(13,0)",
"SIZE_1_5_GB FLOAT",
"COUNT_5_PLUS_GB NUMBER(13,0)",
"SIZE_5_PLUS_GB FLOAT",
"FAILSAFE_SIZE_GB FLOAT",
"TIME_TRAVEL_TABLES NUMBER(13,0)",
"UNUSED_TABLES NUMBER(13,0)",
"EXTERNAL_TABLES NUMBER(13,0)",
"MATERIALIZED_VIEWS NUMBER(13,0)",
"DYNAMIC_TABLES NUMBER(13,0)",
"RECOMMENDED_TRANSIENT_TABLES NUMBER(13,0)",
"AUTO_CLUSTERING_TABLES NUMBER(13,0)",
"POTENTIAL_STORAGE_SAVED VARCHAR(3)",
"CREDITS_USED FLOAT",
"HIGH_SCAN_QUERIES NUMBER(13,0)",
"TABLES_RECOMMENDED_FOR_CLUSTERING ARRAY"
]
}
{
"1-10_SECONDS_QUERIES": ["query_id1", "query_id2"],
"10-20_SECONDS_QUERIES": [],
"20-60_SECONDS_QUERIES": ["query_id3"],
"1-3_MINUTES_QUERIES": [],
"3-5_MINUTES_QUERIES": ["query_id4"],
"5_PLUS_MINUTES_QUERIES": [],
"1-2_MINUTES_QUEUED": [],
"2-5_MINUTES_QUEUED": ["query_id5"],
"5-10_MINUTES_QUEUED": [],
"10-20_MINUTES_QUEUED": [],
"20_PLUS_MINUTES_QUEUED": [],
"SPILLED_LOCAL_QUERIES": ["query_id1"],
"SPILLED_REMOTE_QUERIES": [],
"FAILED_QUERIES": [],
"SUCCESSFUL_QUERIES": ["query_id1", "query_id2", "query_id3", "query_id4"],
"RUNNING_QUERIES": ["query_id5"],
"0-20_CENTS_QUERIES": ["query_id1", "query_id2"],
"20-40_CENTS_QUERIES": [],
"40-60_CENTS_QUERIES": ["query_id3"],
"60-80_CENTS_QUERIES": [],
"80-100_CENTS_QUERIES": [],
"100_PLUS_CENTS_QUERIES": ["query_id4", "query_id5"]
}
Top comments (0)