Schema Info
Schema Name: sfdl_stage_rds.sparefoot_sparefoot_tableau_annotation
- created: 2022-08-12 10:55:15
- disabled: False
- format: raw
- id: 1376
- is_partitioned: False
- is_schema_datatyped: False
- name:
{ "database": "sfdl_stage_rds", "table": "sparefoot_sparefoot_tableau_annotation" } - type: rds
Schema Versions: 15
-
Version 906524
- created: 2026-04-17 00:06:32
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`", "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_tableau_annotation`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_tableau_annotation/2026-04-17/1776402388'\n", "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_tableau_annotation" ] - hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_tableau_annotation/2026-04-17/1776402388
- id: 906524
- 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: 1376
- schema_scan_id: 6415089
- updated: 2026-04-17 00:06:46
-
Version 906310
- created: 2026-04-16 00:06:16
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`", "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_tableau_annotation`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_tableau_annotation/2026-04-16/1776315950'\n", "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_tableau_annotation" ] - hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_tableau_annotation/2026-04-16/1776315950
- id: 906310
- 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: 1376
- schema_scan_id: 6414543
- updated: 2026-04-16 00:06:29
-
Version 906120
- created: 2026-04-15 00:10:09
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`", "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_tableau_annotation`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_tableau_annotation/2026-04-15/1776229797'\n", "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_tableau_annotation" ] - hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_tableau_annotation/2026-04-15/1776229797
- id: 906120
- 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: 1376
- schema_scan_id: 6414081
- updated: 2026-04-15 00:10:20
-
Version 905884
- created: 2026-04-14 00:07:38
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`", "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_tableau_annotation`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_tableau_annotation/2026-04-14/1776143254'\n", "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_tableau_annotation" ] - hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_tableau_annotation/2026-04-14/1776143254
- id: 905884
- 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: 1376
- schema_scan_id: 6413548
- updated: 2026-04-14 00:07:51
-
Version 905659
- created: 2026-04-13 00:08:33
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`", "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_tableau_annotation`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_tableau_annotation/2026-04-13/1776056892'\n", "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_tableau_annotation" ] - hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_tableau_annotation/2026-04-13/1776056892
- id: 905659
- 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: 1376
- schema_scan_id: 6412987
- updated: 2026-04-13 00:08:44
-
Version 905479
- created: 2026-04-12 00:08:13
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`", "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_tableau_annotation`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_tableau_annotation/2026-04-12/1775970489'\n", "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_tableau_annotation" ] - hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_tableau_annotation/2026-04-12/1775970489
- id: 905479
- 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: 1376
- schema_scan_id: 6412629
- updated: 2026-04-12 00:08:26
-
Version 905284
- created: 2026-04-11 00:09:51
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`", "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_tableau_annotation`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_tableau_annotation/2026-04-11/1775884183'\n", "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_tableau_annotation" ] - hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_tableau_annotation/2026-04-11/1775884183
- id: 905284
- 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: 1376
- schema_scan_id: 6412256
- updated: 2026-04-11 00:10:05
-
Version 905065
- created: 2026-04-10 00:07:53
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`", "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_tableau_annotation`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_tableau_annotation/2026-04-10/1775797668'\n", "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_tableau_annotation" ] - hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_tableau_annotation/2026-04-10/1775797668
- id: 905065
- 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: 1376
- schema_scan_id: 6411745
- updated: 2026-04-10 00:08:04
-
Version 904847
- created: 2026-04-09 00:12:06
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`", "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_tableau_annotation`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_tableau_annotation/2026-04-09/1775711511'\n", "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_tableau_annotation" ] - hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_tableau_annotation/2026-04-09/1775711511
- id: 904847
- 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: 1376
- schema_scan_id: 6411233
- updated: 2026-04-09 00:12:20
-
Version 904652
- created: 2026-04-08 00:12:31
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`", "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_tableau_annotation`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_tableau_annotation/2026-04-08/1775625145'\n", "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_tableau_annotation" ] - hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_tableau_annotation/2026-04-08/1775625145
- id: 904652
- 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: 1376
- schema_scan_id: 6410749
- updated: 2026-04-08 00:12:44
-
Version 904415
- created: 2026-04-07 00:07:56
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`", "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_tableau_annotation`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_tableau_annotation/2026-04-07/1775538473'\n", "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_tableau_annotation" ] - hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_tableau_annotation/2026-04-07/1775538473
- id: 904415
- 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: 1376
- schema_scan_id: 6410217
- updated: 2026-04-07 00:08:08
-
Version 904204
- created: 2026-04-06 00:06:14
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`", "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_tableau_annotation`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_tableau_annotation/2026-04-06/1775451969'\n", "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_tableau_annotation" ] - hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_tableau_annotation/2026-04-06/1775451969
- id: 904204
- 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: 1376
- schema_scan_id: 6409676
- updated: 2026-04-06 00:06:28
-
Version 904012
- created: 2026-04-05 00:08:45
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`", "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_tableau_annotation`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_tableau_annotation/2026-04-05/1775365716'\n", "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_tableau_annotation" ] - hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_tableau_annotation/2026-04-05/1775365716
- id: 904012
- 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: 1376
- schema_scan_id: 6409306
- updated: 2026-04-05 00:08:57
-
Version 903839
- created: 2026-04-04 00:12:34
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`", "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_tableau_annotation`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_tableau_annotation/2026-04-04/1775279548'\n", "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_tableau_annotation" ] - hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_tableau_annotation/2026-04-04/1775279548
- id: 903839
- 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: 1376
- schema_scan_id: 6408956
- updated: 2026-04-04 00:12:48
-
Version 903613
- created: 2026-04-03 00:10:44
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`", "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_tableau_annotation`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_tableau_annotation/2026-04-03/1775193025'\n", "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_tableau_annotation" ] - hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_tableau_annotation/2026-04-03/1775193025
- id: 903613
- 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: 1376
- schema_scan_id: 6408447
- updated: 2026-04-03 00:10:58
Schema Scans: 15
Last at 2026-04-17 00:06:31
-
Scan 6415089
- duration: 0:00:14.339674
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6415089
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-rds-sparefoot-stage", "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_tableau_annotation/2026-04-17/1776402388", "key": "raw/sparefoot_tableau_annotation/2026-04-17/1776402388/tableau_annotation.parquet.gz" }, "schema": { "name": "sfdl_stage_rds.sparefoot_sparefoot_tableau_annotation", "type": "rds" }, "trace_context": { "parent_id": 2017071927650584076, "service_name": "sparefoot", "span_id": 15030011804491949372, "trace_id": 2017071927650584076 } } - running: False
- schema_name_id: 1376
- start_time: 2026-04-17 00:06:31
- success: True
- trace_id: 2017071927650584076
-
Scan 6414543
- duration: 0:00:14.252050
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6414543
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-rds-sparefoot-stage", "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_tableau_annotation/2026-04-16/1776315950", "key": "raw/sparefoot_tableau_annotation/2026-04-16/1776315950/tableau_annotation.parquet.gz" }, "schema": { "name": "sfdl_stage_rds.sparefoot_sparefoot_tableau_annotation", "type": "rds" }, "trace_context": { "parent_id": 7747049567046914052, "service_name": "sparefoot", "span_id": 16231288938290475237, "trace_id": 7747049567046914052 } } - running: False
- schema_name_id: 1376
- start_time: 2026-04-16 00:06:15
- success: True
- trace_id: 7747049567046914052
-
Scan 6414081
- duration: 0:00:11.705876
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6414081
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-rds-sparefoot-stage", "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_tableau_annotation/2026-04-15/1776229797", "key": "raw/sparefoot_tableau_annotation/2026-04-15/1776229797/tableau_annotation.parquet.gz" }, "schema": { "name": "sfdl_stage_rds.sparefoot_sparefoot_tableau_annotation", "type": "rds" }, "trace_context": { "parent_id": 3035173892642458633, "service_name": "sparefoot", "span_id": 10046357321312069740, "trace_id": 3035173892642458633 } } - running: False
- schema_name_id: 1376
- start_time: 2026-04-15 00:10:09
- success: True
- trace_id: 3035173892642458633
-
Scan 6413548
- duration: 0:00:14.300982
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6413548
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-rds-sparefoot-stage", "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_tableau_annotation/2026-04-14/1776143254", "key": "raw/sparefoot_tableau_annotation/2026-04-14/1776143254/tableau_annotation.parquet.gz" }, "schema": { "name": "sfdl_stage_rds.sparefoot_sparefoot_tableau_annotation", "type": "rds" }, "trace_context": { "parent_id": 12071299423552559642, "service_name": "sparefoot", "span_id": 14303473993837508438, "trace_id": 12071299423552559642 } } - running: False
- schema_name_id: 1376
- start_time: 2026-04-14 00:07:37
- success: True
- trace_id: 12071299423552559642
-
Scan 6412987
- duration: 0:00:11.654659
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6412987
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-rds-sparefoot-stage", "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_tableau_annotation/2026-04-13/1776056892", "key": "raw/sparefoot_tableau_annotation/2026-04-13/1776056892/tableau_annotation.parquet.gz" }, "schema": { "name": "sfdl_stage_rds.sparefoot_sparefoot_tableau_annotation", "type": "rds" }, "trace_context": { "parent_id": 2518085941280226039, "service_name": "sparefoot", "span_id": 2451876267002430478, "trace_id": 2518085941280226039 } } - running: False
- schema_name_id: 1376
- start_time: 2026-04-13 00:08:32
- success: True
- trace_id: 2518085941280226039
-
Scan 6412629
- duration: 0:00:14.194185
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6412629
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-rds-sparefoot-stage", "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_tableau_annotation/2026-04-12/1775970489", "key": "raw/sparefoot_tableau_annotation/2026-04-12/1775970489/tableau_annotation.parquet.gz" }, "schema": { "name": "sfdl_stage_rds.sparefoot_sparefoot_tableau_annotation", "type": "rds" }, "trace_context": { "parent_id": 11866289383415367713, "service_name": "sparefoot", "span_id": 2939293277533889651, "trace_id": 11866289383415367713 } } - running: False
- schema_name_id: 1376
- start_time: 2026-04-12 00:08:12
- success: True
- trace_id: 11866289383415367713
-
Scan 6412256
- duration: 0:00:14.413977
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6412256
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-rds-sparefoot-stage", "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_tableau_annotation/2026-04-11/1775884183", "key": "raw/sparefoot_tableau_annotation/2026-04-11/1775884183/tableau_annotation.parquet.gz" }, "schema": { "name": "sfdl_stage_rds.sparefoot_sparefoot_tableau_annotation", "type": "rds" }, "trace_context": { "parent_id": 2803299212661379992, "service_name": "sparefoot", "span_id": 16018683309047527578, "trace_id": 2803299212661379992 } } - running: False
- schema_name_id: 1376
- start_time: 2026-04-11 00:09:51
- success: True
- trace_id: 2803299212661379992
-
Scan 6411745
- duration: 0:00:11.757280
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6411745
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-rds-sparefoot-stage", "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_tableau_annotation/2026-04-10/1775797668", "key": "raw/sparefoot_tableau_annotation/2026-04-10/1775797668/tableau_annotation.parquet.gz" }, "schema": { "name": "sfdl_stage_rds.sparefoot_sparefoot_tableau_annotation", "type": "rds" }, "trace_context": { "parent_id": 4502864306325766590, "service_name": "sparefoot", "span_id": 14266418952412587034, "trace_id": 4502864306325766590 } } - running: False
- schema_name_id: 1376
- start_time: 2026-04-10 00:07:52
- success: True
- trace_id: 4502864306325766590
-
Scan 6411233
- duration: 0:00:14.338905
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6411233
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-rds-sparefoot-stage", "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_tableau_annotation/2026-04-09/1775711511", "key": "raw/sparefoot_tableau_annotation/2026-04-09/1775711511/tableau_annotation.parquet.gz" }, "schema": { "name": "sfdl_stage_rds.sparefoot_sparefoot_tableau_annotation", "type": "rds" }, "trace_context": { "parent_id": 14502872572268327189, "service_name": "sparefoot", "span_id": 17378641730364971974, "trace_id": 14502872572268327189 } } - running: False
- schema_name_id: 1376
- start_time: 2026-04-09 00:12:05
- success: True
- trace_id: 14502872572268327189
-
Scan 6410749
- duration: 0:00:14.245481
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6410749
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-rds-sparefoot-stage", "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_tableau_annotation/2026-04-08/1775625145", "key": "raw/sparefoot_tableau_annotation/2026-04-08/1775625145/tableau_annotation.parquet.gz" }, "schema": { "name": "sfdl_stage_rds.sparefoot_sparefoot_tableau_annotation", "type": "rds" }, "trace_context": { "parent_id": 8805789716850068546, "service_name": "sparefoot", "span_id": 17249266417747839499, "trace_id": 8805789716850068546 } } - running: False
- schema_name_id: 1376
- start_time: 2026-04-08 00:12:30
- success: True
- trace_id: 8805789716850068546
-
Scan 6410217
- duration: 0:00:11.852626
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6410217
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-rds-sparefoot-stage", "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_tableau_annotation/2026-04-07/1775538473", "key": "raw/sparefoot_tableau_annotation/2026-04-07/1775538473/tableau_annotation.parquet.gz" }, "schema": { "name": "sfdl_stage_rds.sparefoot_sparefoot_tableau_annotation", "type": "rds" }, "trace_context": { "parent_id": 18074731666858106768, "service_name": "sparefoot", "span_id": 12598521635495124340, "trace_id": 18074731666858106768 } } - running: False
- schema_name_id: 1376
- start_time: 2026-04-07 00:07:56
- success: True
- trace_id: 18074731666858106768
-
Scan 6409676
- duration: 0:00:14.222729
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6409676
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-rds-sparefoot-stage", "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_tableau_annotation/2026-04-06/1775451969", "key": "raw/sparefoot_tableau_annotation/2026-04-06/1775451969/tableau_annotation.parquet.gz" }, "schema": { "name": "sfdl_stage_rds.sparefoot_sparefoot_tableau_annotation", "type": "rds" }, "trace_context": { "parent_id": 13899105921677685069, "service_name": "sparefoot", "span_id": 10090497025827504683, "trace_id": 13899105921677685069 } } - running: False
- schema_name_id: 1376
- start_time: 2026-04-06 00:06:14
- success: True
- trace_id: 13899105921677685069
-
Scan 6409306
- duration: 0:00:11.725253
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6409306
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-rds-sparefoot-stage", "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_tableau_annotation/2026-04-05/1775365716", "key": "raw/sparefoot_tableau_annotation/2026-04-05/1775365716/tableau_annotation.parquet.gz" }, "schema": { "name": "sfdl_stage_rds.sparefoot_sparefoot_tableau_annotation", "type": "rds" }, "trace_context": { "parent_id": 16577437881145128877, "service_name": "sparefoot", "span_id": 752187620521240414, "trace_id": 16577437881145128877 } } - running: False
- schema_name_id: 1376
- start_time: 2026-04-05 00:08:45
- success: True
- trace_id: 16577437881145128877
-
Scan 6408956
- duration: 0:00:14.297920
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6408956
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-rds-sparefoot-stage", "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_tableau_annotation/2026-04-04/1775279548", "key": "raw/sparefoot_tableau_annotation/2026-04-04/1775279548/tableau_annotation.parquet.gz" }, "schema": { "name": "sfdl_stage_rds.sparefoot_sparefoot_tableau_annotation", "type": "rds" }, "trace_context": { "parent_id": 271206040588988099, "service_name": "sparefoot", "span_id": 2766404282496019588, "trace_id": 271206040588988099 } } - running: False
- schema_name_id: 1376
- start_time: 2026-04-04 00:12:34
- success: True
- trace_id: 271206040588988099
-
Scan 6408447
- duration: 0:00:14.385479
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6408447
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-rds-sparefoot-stage", "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_tableau_annotation/2026-04-03/1775193025", "key": "raw/sparefoot_tableau_annotation/2026-04-03/1775193025/tableau_annotation.parquet.gz" }, "schema": { "name": "sfdl_stage_rds.sparefoot_sparefoot_tableau_annotation", "type": "rds" }, "trace_context": { "parent_id": 12296897412038394310, "service_name": "sparefoot", "span_id": 172014003692893634, "trace_id": 12296897412038394310 } } - running: False
- schema_name_id: 1376
- start_time: 2026-04-03 00:10:43
- success: True
- trace_id: 12296897412038394310
- 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 00:06:32
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_tableau_annotation/2026-04-17/1776402388'\n", "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_tableau_annotation`", "repair_table": "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_tableau_annotation" }
- hostname: schemamanager-5c55c886bf-h2ts4
- name: schema_manager
- process_start: 2025-10-21 13:03:27
- sf_env: stage
- version: 2112174301
{
"name": {
"created": "2022-08-12 10:55:15",
"disabled": false,
"format": "raw",
"id": 1376,
"is_partitioned": false,
"is_schema_datatyped": false,
"name": {
"database": "sfdl_stage_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 00:06:32",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_tableau_annotation/2026-04-17/1776402388'\n",
"drop_table": "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_tableau_annotation`",
"repair_table": "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_tableau_annotation"
}
},
"server": {
"hostname": "schemamanager-5c55c886bf-h2ts4",
"name": "schema_manager",
"process_start": "2025-10-21 13:03:27",
"sf_env": "stage",
"version": "2112174301"
}
}