Schema Info
Schema Name: sfdl_prod_rds.sparefoot_sparefoot_tableau_annotation
- created: 2022-08-18 17:21:04
- disabled: False
- format: raw
- id: 1110
- is_partitioned: False
- is_schema_datatyped: False
- name:
{ "database": "sfdl_prod_rds", "table": "sparefoot_sparefoot_tableau_annotation" } - type: rds
Schema Versions: 15
-
Version 1718359
- created: 2026-04-17 14:07:03
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`", "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_tableau_annotation`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_tableau_annotation`\n(\n `annotation` string , `annotation_date` timestamp , `created_by` string , `insert_time` timestamp , `tableau_annotation_id` int , `tableau_annotation_key_id` int , `update_time` timestamp \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-rds-sparefoot-prod/raw/sparefoot_tableau_annotation/2026-04-17/1776452805'\n", "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_tableau_annotation" ] - hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_tableau_annotation/2026-04-17/1776452805
- id: 1718359
- processed: 1
- raw_data:
{ "annotation": "string", "annotation_date": "timestamp[ns]", "created_by": "string", "insert_time": "timestamp[ns]", "tableau_annotation_id": "int32", "tableau_annotation_key_id": "int32", "update_time": "timestamp[ns]" } - schema_attributes:
{ "annotation": "string", "annotation_date": "timestamp", "created_by": "string", "insert_time": "timestamp", "tableau_annotation_id": "int", "tableau_annotation_key_id": "int", "update_time": "timestamp" } - schema_name_id: 1110
- schema_scan_id: 162193886
- updated: 2026-04-17 14:07:17
-
Version 1718178
- created: 2026-04-17 09:10:20
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`", "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_tableau_annotation`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_tableau_annotation`\n(\n `annotation` string , `annotation_date` timestamp , `created_by` string , `insert_time` timestamp , `tableau_annotation_id` int , `tableau_annotation_key_id` int , `update_time` timestamp \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-rds-sparefoot-prod/raw/sparefoot_tableau_annotation/2026-04-17/1776435016'\n", "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_tableau_annotation" ] - hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_tableau_annotation/2026-04-17/1776435016
- id: 1718178
- processed: 1
- raw_data:
{ "annotation": "string", "annotation_date": "timestamp[ns]", "created_by": "string", "insert_time": "timestamp[ns]", "tableau_annotation_id": "int32", "tableau_annotation_key_id": "int32", "update_time": "timestamp[ns]" } - schema_attributes:
{ "annotation": "string", "annotation_date": "timestamp", "created_by": "string", "insert_time": "timestamp", "tableau_annotation_id": "int", "tableau_annotation_key_id": "int", "update_time": "timestamp" } - schema_name_id: 1110
- schema_scan_id: 162178190
- updated: 2026-04-17 09:10:31
-
Version 1717466
- created: 2026-04-17 00:13:28
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`", "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_tableau_annotation`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_tableau_annotation`\n(\n `annotation` string , `annotation_date` timestamp , `created_by` string , `insert_time` timestamp , `tableau_annotation_id` int , `tableau_annotation_key_id` int , `update_time` timestamp \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-rds-sparefoot-prod/raw/sparefoot_tableau_annotation/2026-04-17/1776402771'\n", "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_tableau_annotation" ] - hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_tableau_annotation/2026-04-17/1776402771
- id: 1717466
- processed: 1
- raw_data:
{ "annotation": "string", "annotation_date": "timestamp[ns]", "created_by": "string", "insert_time": "timestamp[ns]", "tableau_annotation_id": "int32", "tableau_annotation_key_id": "int32", "update_time": "timestamp[ns]" } - schema_attributes:
{ "annotation": "string", "annotation_date": "timestamp", "created_by": "string", "insert_time": "timestamp", "tableau_annotation_id": "int", "tableau_annotation_key_id": "int", "update_time": "timestamp" } - schema_name_id: 1110
- schema_scan_id: 162163624
- updated: 2026-04-17 00:13:42
-
Version 1717343
- created: 2026-04-16 20:23:50
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`", "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_tableau_annotation`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_tableau_annotation`\n(\n `annotation` string , `annotation_date` timestamp , `created_by` string , `insert_time` timestamp , `tableau_annotation_id` int , `tableau_annotation_key_id` int , `update_time` timestamp \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-rds-sparefoot-prod/raw/sparefoot_tableau_annotation/2026-04-16/1776388898'\n", "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_tableau_annotation" ] - hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_tableau_annotation/2026-04-16/1776388898
- id: 1717343
- processed: 1
- raw_data:
{ "annotation": "string", "annotation_date": "timestamp[ns]", "created_by": "string", "insert_time": "timestamp[ns]", "tableau_annotation_id": "int32", "tableau_annotation_key_id": "int32", "update_time": "timestamp[ns]" } - schema_attributes:
{ "annotation": "string", "annotation_date": "timestamp", "created_by": "string", "insert_time": "timestamp", "tableau_annotation_id": "int", "tableau_annotation_key_id": "int", "update_time": "timestamp" } - schema_name_id: 1110
- schema_scan_id: 162156137
- updated: 2026-04-16 20:24:01
-
Version 1717168
- created: 2026-04-16 14:15:53
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`", "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_tableau_annotation`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_tableau_annotation`\n(\n `annotation` string , `annotation_date` timestamp , `created_by` string , `insert_time` timestamp , `tableau_annotation_id` int , `tableau_annotation_key_id` int , `update_time` timestamp \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-rds-sparefoot-prod/raw/sparefoot_tableau_annotation/2026-04-16/1776366949'\n", "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_tableau_annotation" ] - hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_tableau_annotation/2026-04-16/1776366949
- id: 1717168
- processed: 1
- raw_data:
{ "annotation": "string", "annotation_date": "timestamp[ns]", "created_by": "string", "insert_time": "timestamp[ns]", "tableau_annotation_id": "int32", "tableau_annotation_key_id": "int32", "update_time": "timestamp[ns]" } - schema_attributes:
{ "annotation": "string", "annotation_date": "timestamp", "created_by": "string", "insert_time": "timestamp", "tableau_annotation_id": "int", "tableau_annotation_key_id": "int", "update_time": "timestamp" } - schema_name_id: 1110
- schema_scan_id: 162138061
- updated: 2026-04-16 14:16:06
-
Version 1716957
- created: 2026-04-16 09:07:25
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`", "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_tableau_annotation`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_tableau_annotation`\n(\n `annotation` string , `annotation_date` timestamp , `created_by` string , `insert_time` timestamp , `tableau_annotation_id` int , `tableau_annotation_key_id` int , `update_time` timestamp \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-rds-sparefoot-prod/raw/sparefoot_tableau_annotation/2026-04-16/1776348431'\n", "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_tableau_annotation" ] - hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_tableau_annotation/2026-04-16/1776348431
- id: 1716957
- processed: 1
- raw_data:
{ "annotation": "string", "annotation_date": "timestamp[ns]", "created_by": "string", "insert_time": "timestamp[ns]", "tableau_annotation_id": "int32", "tableau_annotation_key_id": "int32", "update_time": "timestamp[ns]" } - schema_attributes:
{ "annotation": "string", "annotation_date": "timestamp", "created_by": "string", "insert_time": "timestamp", "tableau_annotation_id": "int", "tableau_annotation_key_id": "int", "update_time": "timestamp" } - schema_name_id: 1110
- schema_scan_id: 162122451
- updated: 2026-04-16 09:07:39
-
Version 1716233
- created: 2026-04-16 00:16:46
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`", "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_tableau_annotation`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_tableau_annotation`\n(\n `annotation` string , `annotation_date` timestamp , `created_by` string , `insert_time` timestamp , `tableau_annotation_id` int , `tableau_annotation_key_id` int , `update_time` timestamp \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-rds-sparefoot-prod/raw/sparefoot_tableau_annotation/2026-04-16/1776316592'\n", "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_tableau_annotation" ] - hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_tableau_annotation/2026-04-16/1776316592
- id: 1716233
- processed: 1
- raw_data:
{ "annotation": "string", "annotation_date": "timestamp[ns]", "created_by": "string", "insert_time": "timestamp[ns]", "tableau_annotation_id": "int32", "tableau_annotation_key_id": "int32", "update_time": "timestamp[ns]" } - schema_attributes:
{ "annotation": "string", "annotation_date": "timestamp", "created_by": "string", "insert_time": "timestamp", "tableau_annotation_id": "int", "tableau_annotation_key_id": "int", "update_time": "timestamp" } - schema_name_id: 1110
- schema_scan_id: 162107817
- updated: 2026-04-16 00:16:59
-
Version 1716124
- created: 2026-04-15 20:25:48
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`", "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_tableau_annotation`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_tableau_annotation`\n(\n `annotation` string , `annotation_date` timestamp , `created_by` string , `insert_time` timestamp , `tableau_annotation_id` int , `tableau_annotation_key_id` int , `update_time` timestamp \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-rds-sparefoot-prod/raw/sparefoot_tableau_annotation/2026-04-15/1776302744'\n", "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_tableau_annotation" ] - hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_tableau_annotation/2026-04-15/1776302744
- id: 1716124
- processed: 1
- raw_data:
{ "annotation": "string", "annotation_date": "timestamp[ns]", "created_by": "string", "insert_time": "timestamp[ns]", "tableau_annotation_id": "int32", "tableau_annotation_key_id": "int32", "update_time": "timestamp[ns]" } - schema_attributes:
{ "annotation": "string", "annotation_date": "timestamp", "created_by": "string", "insert_time": "timestamp", "tableau_annotation_id": "int", "tableau_annotation_key_id": "int", "update_time": "timestamp" } - schema_name_id: 1110
- schema_scan_id: 162100346
- updated: 2026-04-15 20:25:59
-
Version 1715993
- created: 2026-04-15 14:20:32
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`", "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_tableau_annotation`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_tableau_annotation`\n(\n `annotation` string , `annotation_date` timestamp , `created_by` string , `insert_time` timestamp , `tableau_annotation_id` int , `tableau_annotation_key_id` int , `update_time` timestamp \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-rds-sparefoot-prod/raw/sparefoot_tableau_annotation/2026-04-15/1776280829'\n", "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_tableau_annotation" ] - hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_tableau_annotation/2026-04-15/1776280829
- id: 1715993
- processed: 1
- raw_data:
{ "annotation": "string", "annotation_date": "timestamp[ns]", "created_by": "string", "insert_time": "timestamp[ns]", "tableau_annotation_id": "int32", "tableau_annotation_key_id": "int32", "update_time": "timestamp[ns]" } - schema_attributes:
{ "annotation": "string", "annotation_date": "timestamp", "created_by": "string", "insert_time": "timestamp", "tableau_annotation_id": "int", "tableau_annotation_key_id": "int", "update_time": "timestamp" } - schema_name_id: 1110
- schema_scan_id: 162081813
- updated: 2026-04-15 14:20:46
-
Version 1715797
- created: 2026-04-15 08:46:39
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`", "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_tableau_annotation`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_tableau_annotation`\n(\n `annotation` string , `annotation_date` timestamp , `created_by` string , `insert_time` timestamp , `tableau_annotation_id` int , `tableau_annotation_key_id` int , `update_time` timestamp \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-rds-sparefoot-prod/raw/sparefoot_tableau_annotation/2026-04-15/1776260592'\n", "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_tableau_annotation" ] - hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_tableau_annotation/2026-04-15/1776260592
- id: 1715797
- processed: 1
- raw_data:
{ "annotation": "string", "annotation_date": "timestamp[ns]", "created_by": "string", "insert_time": "timestamp[ns]", "tableau_annotation_id": "int32", "tableau_annotation_key_id": "int32", "update_time": "timestamp[ns]" } - schema_attributes:
{ "annotation": "string", "annotation_date": "timestamp", "created_by": "string", "insert_time": "timestamp", "tableau_annotation_id": "int", "tableau_annotation_key_id": "int", "update_time": "timestamp" } - schema_name_id: 1110
- schema_scan_id: 162064613
- updated: 2026-04-15 08:46:50
-
Version 1715003
- created: 2026-04-15 00:08:17
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`", "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_tableau_annotation`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_tableau_annotation`\n(\n `annotation` string , `annotation_date` timestamp , `created_by` string , `insert_time` timestamp , `tableau_annotation_id` int , `tableau_annotation_key_id` int , `update_time` timestamp \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-rds-sparefoot-prod/raw/sparefoot_tableau_annotation/2026-04-15/1776229683'\n", "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_tableau_annotation" ] - hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_tableau_annotation/2026-04-15/1776229683
- id: 1715003
- processed: 1
- raw_data:
{ "annotation": "string", "annotation_date": "timestamp[ns]", "created_by": "string", "insert_time": "timestamp[ns]", "tableau_annotation_id": "int32", "tableau_annotation_key_id": "int32", "update_time": "timestamp[ns]" } - schema_attributes:
{ "annotation": "string", "annotation_date": "timestamp", "created_by": "string", "insert_time": "timestamp", "tableau_annotation_id": "int", "tableau_annotation_key_id": "int", "update_time": "timestamp" } - schema_name_id: 1110
- schema_scan_id: 162051946
- updated: 2026-04-15 00:08:31
-
Version 1714866
- created: 2026-04-14 20:10:56
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`", "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_tableau_annotation`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_tableau_annotation`\n(\n `annotation` string , `annotation_date` timestamp , `created_by` string , `insert_time` timestamp , `tableau_annotation_id` int , `tableau_annotation_key_id` int , `update_time` timestamp \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-rds-sparefoot-prod/raw/sparefoot_tableau_annotation/2026-04-14/1776215437'\n", "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_tableau_annotation" ] - hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_tableau_annotation/2026-04-14/1776215437
- id: 1714866
- processed: 1
- raw_data:
{ "annotation": "string", "annotation_date": "timestamp[ns]", "created_by": "string", "insert_time": "timestamp[ns]", "tableau_annotation_id": "int32", "tableau_annotation_key_id": "int32", "update_time": "timestamp[ns]" } - schema_attributes:
{ "annotation": "string", "annotation_date": "timestamp", "created_by": "string", "insert_time": "timestamp", "tableau_annotation_id": "int", "tableau_annotation_key_id": "int", "update_time": "timestamp" } - schema_name_id: 1110
- schema_scan_id: 162044210
- updated: 2026-04-14 20:11:07
-
Version 1714734
- created: 2026-04-14 14:15:37
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`", "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_tableau_annotation`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_tableau_annotation`\n(\n `annotation` string , `annotation_date` timestamp , `created_by` string , `insert_time` timestamp , `tableau_annotation_id` int , `tableau_annotation_key_id` int , `update_time` timestamp \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-rds-sparefoot-prod/raw/sparefoot_tableau_annotation/2026-04-14/1776194091'\n", "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_tableau_annotation" ] - hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_tableau_annotation/2026-04-14/1776194091
- id: 1714734
- processed: 1
- raw_data:
{ "annotation": "string", "annotation_date": "timestamp[ns]", "created_by": "string", "insert_time": "timestamp[ns]", "tableau_annotation_id": "int32", "tableau_annotation_key_id": "int32", "update_time": "timestamp[ns]" } - schema_attributes:
{ "annotation": "string", "annotation_date": "timestamp", "created_by": "string", "insert_time": "timestamp", "tableau_annotation_id": "int", "tableau_annotation_key_id": "int", "update_time": "timestamp" } - schema_name_id: 1110
- schema_scan_id: 162026114
- updated: 2026-04-14 14:15:51
-
Version 1714596
- created: 2026-04-14 09:11:14
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`", "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_tableau_annotation`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_tableau_annotation`\n(\n `annotation` string , `annotation_date` timestamp , `created_by` string , `insert_time` timestamp , `tableau_annotation_id` int , `tableau_annotation_key_id` int , `update_time` timestamp \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-rds-sparefoot-prod/raw/sparefoot_tableau_annotation/2026-04-14/1776175790'\n", "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_tableau_annotation" ] - hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_tableau_annotation/2026-04-14/1776175790
- id: 1714596
- processed: 1
- raw_data:
{ "annotation": "string", "annotation_date": "timestamp[ns]", "created_by": "string", "insert_time": "timestamp[ns]", "tableau_annotation_id": "int32", "tableau_annotation_key_id": "int32", "update_time": "timestamp[ns]" } - schema_attributes:
{ "annotation": "string", "annotation_date": "timestamp", "created_by": "string", "insert_time": "timestamp", "tableau_annotation_id": "int", "tableau_annotation_key_id": "int", "update_time": "timestamp" } - schema_name_id: 1110
- schema_scan_id: 162010967
- updated: 2026-04-14 09:11:25
-
Version 1713816
- created: 2026-04-14 00:13:27
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`", "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_tableau_annotation`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_tableau_annotation`\n(\n `annotation` string , `annotation_date` timestamp , `created_by` string , `insert_time` timestamp , `tableau_annotation_id` int , `tableau_annotation_key_id` int , `update_time` timestamp \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-rds-sparefoot-prod/raw/sparefoot_tableau_annotation/2026-04-14/1776143604'\n", "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_tableau_annotation" ] - hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_tableau_annotation/2026-04-14/1776143604
- id: 1713816
- processed: 1
- raw_data:
{ "annotation": "string", "annotation_date": "timestamp[ns]", "created_by": "string", "insert_time": "timestamp[ns]", "tableau_annotation_id": "int32", "tableau_annotation_key_id": "int32", "update_time": "timestamp[ns]" } - schema_attributes:
{ "annotation": "string", "annotation_date": "timestamp", "created_by": "string", "insert_time": "timestamp", "tableau_annotation_id": "int", "tableau_annotation_key_id": "int", "update_time": "timestamp" } - schema_name_id: 1110
- schema_scan_id: 161996355
- updated: 2026-04-14 00:13:41
Schema Scans: 15
Last at 2026-04-17 14:07:02
-
Scan 162193886
- duration: 0:00:14.400537
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162193886
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-rds-sparefoot-prod", "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_tableau_annotation/2026-04-17/1776452805", "key": "raw/sparefoot_tableau_annotation/2026-04-17/1776452805/tableau_annotation.parquet.gz" }, "schema": { "name": "sfdl_prod_rds.sparefoot_sparefoot_tableau_annotation", "type": "rds" }, "trace_context": { "parent_id": 8602982962444285877, "service_name": "sparefoot", "span_id": 9284127249975657641, "trace_id": 8602982962444285877 } } - running: False
- schema_name_id: 1110
- start_time: 2026-04-17 14:07:02
- success: True
- trace_id: 8602982962444285877
-
Scan 162178190
- duration: 0:00:11.657808
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162178190
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-rds-sparefoot-prod", "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_tableau_annotation/2026-04-17/1776435016", "key": "raw/sparefoot_tableau_annotation/2026-04-17/1776435016/tableau_annotation.parquet.gz" }, "schema": { "name": "sfdl_prod_rds.sparefoot_sparefoot_tableau_annotation", "type": "rds" }, "trace_context": { "parent_id": 17321477929885477465, "service_name": "sparefoot", "span_id": 941109977450088809, "trace_id": 17321477929885477465 } } - running: False
- schema_name_id: 1110
- start_time: 2026-04-17 09:10:20
- success: True
- trace_id: 17321477929885477465
-
Scan 162163624
- duration: 0:00:14.177281
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162163624
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-rds-sparefoot-prod", "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_tableau_annotation/2026-04-17/1776402771", "key": "raw/sparefoot_tableau_annotation/2026-04-17/1776402771/tableau_annotation.parquet.gz" }, "schema": { "name": "sfdl_prod_rds.sparefoot_sparefoot_tableau_annotation", "type": "rds" }, "trace_context": { "parent_id": 13889656122878888882, "service_name": "sparefoot", "span_id": 7212308618105775246, "trace_id": 13889656122878888882 } } - running: False
- schema_name_id: 1110
- start_time: 2026-04-17 00:13:28
- success: True
- trace_id: 13889656122878888882
-
Scan 162156137
- duration: 0:00:11.768089
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162156137
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-rds-sparefoot-prod", "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_tableau_annotation/2026-04-16/1776388898", "key": "raw/sparefoot_tableau_annotation/2026-04-16/1776388898/tableau_annotation.parquet.gz" }, "schema": { "name": "sfdl_prod_rds.sparefoot_sparefoot_tableau_annotation", "type": "rds" }, "trace_context": { "parent_id": 5782795085807280605, "service_name": "sparefoot", "span_id": 13052383662987294658, "trace_id": 5782795085807280605 } } - running: False
- schema_name_id: 1110
- start_time: 2026-04-16 20:23:50
- success: True
- trace_id: 5782795085807280605
-
Scan 162138061
- duration: 0:00:14.267243
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162138061
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-rds-sparefoot-prod", "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_tableau_annotation/2026-04-16/1776366949", "key": "raw/sparefoot_tableau_annotation/2026-04-16/1776366949/tableau_annotation.parquet.gz" }, "schema": { "name": "sfdl_prod_rds.sparefoot_sparefoot_tableau_annotation", "type": "rds" }, "trace_context": { "parent_id": 14627989525233718562, "service_name": "sparefoot", "span_id": 15278419643714335348, "trace_id": 14627989525233718562 } } - running: False
- schema_name_id: 1110
- start_time: 2026-04-16 14:15:52
- success: True
- trace_id: 14627989525233718562
-
Scan 162122451
- duration: 0:00:14.602721
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162122451
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-rds-sparefoot-prod", "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_tableau_annotation/2026-04-16/1776348431", "key": "raw/sparefoot_tableau_annotation/2026-04-16/1776348431/tableau_annotation.parquet.gz" }, "schema": { "name": "sfdl_prod_rds.sparefoot_sparefoot_tableau_annotation", "type": "rds" }, "trace_context": { "parent_id": 3781039572626349973, "service_name": "sparefoot", "span_id": 3631222028816301824, "trace_id": 3781039572626349973 } } - running: False
- schema_name_id: 1110
- start_time: 2026-04-16 09:07:25
- success: True
- trace_id: 3781039572626349973
-
Scan 162107817
- duration: 0:00:14.157257
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162107817
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-rds-sparefoot-prod", "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_tableau_annotation/2026-04-16/1776316592", "key": "raw/sparefoot_tableau_annotation/2026-04-16/1776316592/tableau_annotation.parquet.gz" }, "schema": { "name": "sfdl_prod_rds.sparefoot_sparefoot_tableau_annotation", "type": "rds" }, "trace_context": { "parent_id": 13328868387445447533, "service_name": "sparefoot", "span_id": 7829730302366277025, "trace_id": 13328868387445447533 } } - running: False
- schema_name_id: 1110
- start_time: 2026-04-16 00:16:45
- success: True
- trace_id: 13328868387445447533
-
Scan 162100346
- duration: 0:00:11.733938
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162100346
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-rds-sparefoot-prod", "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_tableau_annotation/2026-04-15/1776302744", "key": "raw/sparefoot_tableau_annotation/2026-04-15/1776302744/tableau_annotation.parquet.gz" }, "schema": { "name": "sfdl_prod_rds.sparefoot_sparefoot_tableau_annotation", "type": "rds" }, "trace_context": { "parent_id": 17467258724102998278, "service_name": "sparefoot", "span_id": 6614132705410021975, "trace_id": 17467258724102998278 } } - running: False
- schema_name_id: 1110
- start_time: 2026-04-15 20:25:47
- success: True
- trace_id: 17467258724102998278
-
Scan 162081813
- duration: 0:00:14.241348
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162081813
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-rds-sparefoot-prod", "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_tableau_annotation/2026-04-15/1776280829", "key": "raw/sparefoot_tableau_annotation/2026-04-15/1776280829/tableau_annotation.parquet.gz" }, "schema": { "name": "sfdl_prod_rds.sparefoot_sparefoot_tableau_annotation", "type": "rds" }, "trace_context": { "parent_id": 3581625763050960524, "service_name": "sparefoot", "span_id": 16307247559159313484, "trace_id": 3581625763050960524 } } - running: False
- schema_name_id: 1110
- start_time: 2026-04-15 14:20:32
- success: True
- trace_id: 3581625763050960524
-
Scan 162064613
- duration: 0:00:11.692908
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162064613
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-rds-sparefoot-prod", "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_tableau_annotation/2026-04-15/1776260592", "key": "raw/sparefoot_tableau_annotation/2026-04-15/1776260592/tableau_annotation.parquet.gz" }, "schema": { "name": "sfdl_prod_rds.sparefoot_sparefoot_tableau_annotation", "type": "rds" }, "trace_context": { "parent_id": 16820889101492874503, "service_name": "sparefoot", "span_id": 15604389461811361591, "trace_id": 16820889101492874503 } } - running: False
- schema_name_id: 1110
- start_time: 2026-04-15 08:46:39
- success: True
- trace_id: 16820889101492874503
-
Scan 162051946
- duration: 0:00:14.145801
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162051946
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-rds-sparefoot-prod", "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_tableau_annotation/2026-04-15/1776229683", "key": "raw/sparefoot_tableau_annotation/2026-04-15/1776229683/tableau_annotation.parquet.gz" }, "schema": { "name": "sfdl_prod_rds.sparefoot_sparefoot_tableau_annotation", "type": "rds" }, "trace_context": { "parent_id": 5966225313810358724, "service_name": "sparefoot", "span_id": 6298929621508768897, "trace_id": 5966225313810358724 } } - running: False
- schema_name_id: 1110
- start_time: 2026-04-15 00:08:17
- success: True
- trace_id: 5966225313810358724
-
Scan 162044210
- duration: 0:00:11.912914
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162044210
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-rds-sparefoot-prod", "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_tableau_annotation/2026-04-14/1776215437", "key": "raw/sparefoot_tableau_annotation/2026-04-14/1776215437/tableau_annotation.parquet.gz" }, "schema": { "name": "sfdl_prod_rds.sparefoot_sparefoot_tableau_annotation", "type": "rds" }, "trace_context": { "parent_id": 950744630595711364, "service_name": "sparefoot", "span_id": 3047914444130712156, "trace_id": 950744630595711364 } } - running: False
- schema_name_id: 1110
- start_time: 2026-04-14 20:10:56
- success: True
- trace_id: 950744630595711364
-
Scan 162026114
- duration: 0:00:14.361455
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162026114
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-rds-sparefoot-prod", "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_tableau_annotation/2026-04-14/1776194091", "key": "raw/sparefoot_tableau_annotation/2026-04-14/1776194091/tableau_annotation.parquet.gz" }, "schema": { "name": "sfdl_prod_rds.sparefoot_sparefoot_tableau_annotation", "type": "rds" }, "trace_context": { "parent_id": 6755408881578741275, "service_name": "sparefoot", "span_id": 1314845223014599277, "trace_id": 6755408881578741275 } } - running: False
- schema_name_id: 1110
- start_time: 2026-04-14 14:15:36
- success: True
- trace_id: 6755408881578741275
-
Scan 162010967
- duration: 0:00:11.674908
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162010967
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-rds-sparefoot-prod", "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_tableau_annotation/2026-04-14/1776175790", "key": "raw/sparefoot_tableau_annotation/2026-04-14/1776175790/tableau_annotation.parquet.gz" }, "schema": { "name": "sfdl_prod_rds.sparefoot_sparefoot_tableau_annotation", "type": "rds" }, "trace_context": { "parent_id": 3885408064408270019, "service_name": "sparefoot", "span_id": 15618924436288595522, "trace_id": 3885408064408270019 } } - running: False
- schema_name_id: 1110
- start_time: 2026-04-14 09:11:14
- success: True
- trace_id: 3885408064408270019
-
Scan 161996355
- duration: 0:00:14.153397
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161996355
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-rds-sparefoot-prod", "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_tableau_annotation/2026-04-14/1776143604", "key": "raw/sparefoot_tableau_annotation/2026-04-14/1776143604/tableau_annotation.parquet.gz" }, "schema": { "name": "sfdl_prod_rds.sparefoot_sparefoot_tableau_annotation", "type": "rds" }, "trace_context": { "parent_id": 16949393377183117283, "service_name": "sparefoot", "span_id": 14418949845986529771, "trace_id": 16949393377183117283 } } - running: False
- schema_name_id: 1110
- start_time: 2026-04-14 00:13:27
- success: True
- trace_id: 16949393377183117283
- attributes:
{ "annotation": "string", "annotation_date": "timestamp", "created_by": "string", "insert_time": "timestamp", "tableau_annotation_id": "int", "tableau_annotation_key_id": "int", "update_time": "timestamp" } - created: 2026-04-17 14:07:03
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_tableau_annotation`\n(\n `annotation` string , `annotation_date` timestamp , `created_by` string , `insert_time` timestamp , `tableau_annotation_id` int , `tableau_annotation_key_id` int , `update_time` timestamp \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-rds-sparefoot-prod/raw/sparefoot_tableau_annotation/2026-04-17/1776452805'\n", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_tableau_annotation`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_tableau_annotation" }
- hostname: schemamanager-5475496c57-7dpqb
- name: schema_manager
- process_start: 2026-01-09 11:27:47
- sf_env: prod
- version: 2112174301
{
"name": {
"created": "2022-08-18 17:21:04",
"disabled": false,
"format": "raw",
"id": 1110,
"is_partitioned": false,
"is_schema_datatyped": false,
"name": {
"database": "sfdl_prod_rds",
"table": "sparefoot_sparefoot_tableau_annotation"
},
"type": "rds"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"annotation": "string",
"annotation_date": "timestamp",
"created_by": "string",
"insert_time": "timestamp",
"tableau_annotation_id": "int",
"tableau_annotation_key_id": "int",
"update_time": "timestamp"
},
"created": "2026-04-17 14:07:03",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_tableau_annotation`\n(\n `annotation` string , `annotation_date` timestamp , `created_by` string , `insert_time` timestamp , `tableau_annotation_id` int , `tableau_annotation_key_id` int , `update_time` timestamp \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-rds-sparefoot-prod/raw/sparefoot_tableau_annotation/2026-04-17/1776452805'\n",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_tableau_annotation`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_tableau_annotation"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}