Schema Info

Schema Name: sfdl_prod_rds.sparefoot_sparefoot_key_avail_type_of_space

created: 2022-08-18 17:16:12
disabled: False
format: raw
id: 1089
is_partitioned: False
is_schema_datatyped: False

name:

{
    "database": "sfdl_prod_rds",
    "table": "sparefoot_sparefoot_key_avail_type_of_space"
}

type: rds

Schema Versions: 15

Version 1718393

created: 2026-04-17 14:15:33

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_key_avail_type_of_space`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_key_avail_type_of_space`\n(\n `order_by`  smallint , `publish`  smallint , `type_of_space_id`  smallint , `type_of_space_option`  string \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_key_avail_type_of_space/2026-04-17/1776453321'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_key_avail_type_of_space"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_key_avail_type_of_space/2026-04-17/1776453321
id: 1718393
processed: 1

raw_data:

{
    "order_by": "int16",
    "publish": "int16",
    "type_of_space_id": "int16",
    "type_of_space_option": "string"
}

schema_attributes:

{
    "order_by": "smallint",
    "publish": "smallint",
    "type_of_space_id": "smallint",
    "type_of_space_option": "string"
}

schema_name_id: 1089
schema_scan_id: 162194008
updated: 2026-04-17 14:15:46

Version 1718192

created: 2026-04-17 09:11:44

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_key_avail_type_of_space`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_key_avail_type_of_space`\n(\n `order_by`  smallint , `publish`  smallint , `type_of_space_id`  smallint , `type_of_space_option`  string \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_key_avail_type_of_space/2026-04-17/1776435096'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_key_avail_type_of_space"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_key_avail_type_of_space/2026-04-17/1776435096
id: 1718192
processed: 1

raw_data:

{
    "order_by": "int16",
    "publish": "int16",
    "type_of_space_id": "int16",
    "type_of_space_option": "string"
}

schema_attributes:

{
    "order_by": "smallint",
    "publish": "smallint",
    "type_of_space_id": "smallint",
    "type_of_space_option": "string"
}

schema_name_id: 1089
schema_scan_id: 162178208
updated: 2026-04-17 09:11:58

Version 1717459

created: 2026-04-17 00:12:56

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_key_avail_type_of_space`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_key_avail_type_of_space`\n(\n `order_by`  smallint , `publish`  smallint , `type_of_space_id`  smallint , `type_of_space_option`  string \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_key_avail_type_of_space/2026-04-17/1776402653'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_key_avail_type_of_space"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_key_avail_type_of_space/2026-04-17/1776402653
id: 1717459
processed: 1

raw_data:

{
    "order_by": "int16",
    "publish": "int16",
    "type_of_space_id": "int16",
    "type_of_space_option": "string"
}

schema_attributes:

{
    "order_by": "smallint",
    "publish": "smallint",
    "type_of_space_id": "smallint",
    "type_of_space_option": "string"
}

schema_name_id: 1089
schema_scan_id: 162163617
updated: 2026-04-17 00:13:10

Version 1717308

created: 2026-04-16 20:15:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_key_avail_type_of_space`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_key_avail_type_of_space`\n(\n `order_by`  smallint , `publish`  smallint , `type_of_space_id`  smallint , `type_of_space_option`  string \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_key_avail_type_of_space/2026-04-16/1776388326'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_key_avail_type_of_space"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_key_avail_type_of_space/2026-04-16/1776388326
id: 1717308
processed: 1

raw_data:

{
    "order_by": "int16",
    "publish": "int16",
    "type_of_space_id": "int16",
    "type_of_space_option": "string"
}

schema_attributes:

{
    "order_by": "smallint",
    "publish": "smallint",
    "type_of_space_id": "smallint",
    "type_of_space_option": "string"
}

schema_name_id: 1089
schema_scan_id: 162156024
updated: 2026-04-16 20:15:31

Version 1717148

created: 2026-04-16 14:14:55

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_key_avail_type_of_space`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_key_avail_type_of_space`\n(\n `order_by`  smallint , `publish`  smallint , `type_of_space_id`  smallint , `type_of_space_option`  string \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_key_avail_type_of_space/2026-04-16/1776366873'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_key_avail_type_of_space"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_key_avail_type_of_space/2026-04-16/1776366873
id: 1717148
processed: 1

raw_data:

{
    "order_by": "int16",
    "publish": "int16",
    "type_of_space_id": "int16",
    "type_of_space_option": "string"
}

schema_attributes:

{
    "order_by": "smallint",
    "publish": "smallint",
    "type_of_space_id": "smallint",
    "type_of_space_option": "string"
}

schema_name_id: 1089
schema_scan_id: 162138028
updated: 2026-04-16 14:15:07

Version 1716986

created: 2026-04-16 09:11:28

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_key_avail_type_of_space`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_key_avail_type_of_space`\n(\n `order_by`  smallint , `publish`  smallint , `type_of_space_id`  smallint , `type_of_space_option`  string \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_key_avail_type_of_space/2026-04-16/1776348684'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_key_avail_type_of_space"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_key_avail_type_of_space/2026-04-16/1776348684
id: 1716986
processed: 1

raw_data:

{
    "order_by": "int16",
    "publish": "int16",
    "type_of_space_id": "int16",
    "type_of_space_option": "string"
}

schema_attributes:

{
    "order_by": "smallint",
    "publish": "smallint",
    "type_of_space_id": "smallint",
    "type_of_space_option": "string"
}

schema_name_id: 1089
schema_scan_id: 162122510
updated: 2026-04-16 09:11:39

Version 1716185

created: 2026-04-16 00:05:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_key_avail_type_of_space`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_key_avail_type_of_space`\n(\n `order_by`  smallint , `publish`  smallint , `type_of_space_id`  smallint , `type_of_space_option`  string \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_key_avail_type_of_space/2026-04-16/1776315929'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_key_avail_type_of_space"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_key_avail_type_of_space/2026-04-16/1776315929
id: 1716185
processed: 1

raw_data:

{
    "order_by": "int16",
    "publish": "int16",
    "type_of_space_id": "int16",
    "type_of_space_option": "string"
}

schema_attributes:

{
    "order_by": "smallint",
    "publish": "smallint",
    "type_of_space_id": "smallint",
    "type_of_space_option": "string"
}

schema_name_id: 1089
schema_scan_id: 162107733
updated: 2026-04-16 00:05:46

Version 1716114

created: 2026-04-15 20:25:12

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_key_avail_type_of_space`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_key_avail_type_of_space`\n(\n `order_by`  smallint , `publish`  smallint , `type_of_space_id`  smallint , `type_of_space_option`  string \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_key_avail_type_of_space/2026-04-15/1776302700'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_key_avail_type_of_space"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_key_avail_type_of_space/2026-04-15/1776302700
id: 1716114
processed: 1

raw_data:

{
    "order_by": "int16",
    "publish": "int16",
    "type_of_space_id": "int16",
    "type_of_space_option": "string"
}

schema_attributes:

{
    "order_by": "smallint",
    "publish": "smallint",
    "type_of_space_id": "smallint",
    "type_of_space_option": "string"
}

schema_name_id: 1089
schema_scan_id: 162100332
updated: 2026-04-15 20:25:24

Version 1715951

created: 2026-04-15 14:11:56

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_key_avail_type_of_space`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_key_avail_type_of_space`\n(\n `order_by`  smallint , `publish`  smallint , `type_of_space_id`  smallint , `type_of_space_option`  string \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_key_avail_type_of_space/2026-04-15/1776280281'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_key_avail_type_of_space"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_key_avail_type_of_space/2026-04-15/1776280281
id: 1715951
processed: 1

raw_data:

{
    "order_by": "int16",
    "publish": "int16",
    "type_of_space_id": "int16",
    "type_of_space_option": "string"
}

schema_attributes:

{
    "order_by": "smallint",
    "publish": "smallint",
    "type_of_space_id": "smallint",
    "type_of_space_option": "string"
}

schema_name_id: 1089
schema_scan_id: 162081677
updated: 2026-04-15 14:12:07

Version 1715741

created: 2026-04-15 08:37:30

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_key_avail_type_of_space`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_key_avail_type_of_space`\n(\n `order_by`  smallint , `publish`  smallint , `type_of_space_id`  smallint , `type_of_space_option`  string \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_key_avail_type_of_space/2026-04-15/1776260216'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_key_avail_type_of_space"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_key_avail_type_of_space/2026-04-15/1776260216
id: 1715741
processed: 1

raw_data:

{
    "order_by": "int16",
    "publish": "int16",
    "type_of_space_id": "int16",
    "type_of_space_option": "string"
}

schema_attributes:

{
    "order_by": "smallint",
    "publish": "smallint",
    "type_of_space_id": "smallint",
    "type_of_space_option": "string"
}

schema_name_id: 1089
schema_scan_id: 162064288
updated: 2026-04-15 08:37:44

Version 1715043

created: 2026-04-15 00:24:02

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_key_avail_type_of_space`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_key_avail_type_of_space`\n(\n `order_by`  smallint , `publish`  smallint , `type_of_space_id`  smallint , `type_of_space_option`  string \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_key_avail_type_of_space/2026-04-15/1776230631'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_key_avail_type_of_space"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_key_avail_type_of_space/2026-04-15/1776230631
id: 1715043
processed: 1

raw_data:

{
    "order_by": "int16",
    "publish": "int16",
    "type_of_space_id": "int16",
    "type_of_space_option": "string"
}

schema_attributes:

{
    "order_by": "smallint",
    "publish": "smallint",
    "type_of_space_id": "smallint",
    "type_of_space_option": "string"
}

schema_name_id: 1089
schema_scan_id: 162052015
updated: 2026-04-15 00:24:13

Version 1714915

created: 2026-04-14 20:25:24

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_key_avail_type_of_space`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_key_avail_type_of_space`\n(\n `order_by`  smallint , `publish`  smallint , `type_of_space_id`  smallint , `type_of_space_option`  string \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_key_avail_type_of_space/2026-04-14/1776216321'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_key_avail_type_of_space"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_key_avail_type_of_space/2026-04-14/1776216321
id: 1714915
processed: 1

raw_data:

{
    "order_by": "int16",
    "publish": "int16",
    "type_of_space_id": "int16",
    "type_of_space_option": "string"
}

schema_attributes:

{
    "order_by": "smallint",
    "publish": "smallint",
    "type_of_space_id": "smallint",
    "type_of_space_option": "string"
}

schema_name_id: 1089
schema_scan_id: 162044335
updated: 2026-04-14 20:25:35

Version 1714752

created: 2026-04-14 14:17:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_key_avail_type_of_space`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_key_avail_type_of_space`\n(\n `order_by`  smallint , `publish`  smallint , `type_of_space_id`  smallint , `type_of_space_option`  string \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_key_avail_type_of_space/2026-04-14/1776194173'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_key_avail_type_of_space"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_key_avail_type_of_space/2026-04-14/1776194173
id: 1714752
processed: 1

raw_data:

{
    "order_by": "int16",
    "publish": "int16",
    "type_of_space_id": "int16",
    "type_of_space_option": "string"
}

schema_attributes:

{
    "order_by": "smallint",
    "publish": "smallint",
    "type_of_space_id": "smallint",
    "type_of_space_option": "string"
}

schema_name_id: 1089
schema_scan_id: 162026152
updated: 2026-04-14 14:17:32

Version 1714601

created: 2026-04-14 09:11:44

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_key_avail_type_of_space`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_key_avail_type_of_space`\n(\n `order_by`  smallint , `publish`  smallint , `type_of_space_id`  smallint , `type_of_space_option`  string \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_key_avail_type_of_space/2026-04-14/1776175813'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_key_avail_type_of_space"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_key_avail_type_of_space/2026-04-14/1776175813
id: 1714601
processed: 1

raw_data:

{
    "order_by": "int16",
    "publish": "int16",
    "type_of_space_id": "int16",
    "type_of_space_option": "string"
}

schema_attributes:

{
    "order_by": "smallint",
    "publish": "smallint",
    "type_of_space_id": "smallint",
    "type_of_space_option": "string"
}

schema_name_id: 1089
schema_scan_id: 162010972
updated: 2026-04-14 09:11:58

Version 1713828

created: 2026-04-14 00:15:17

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_key_avail_type_of_space`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_key_avail_type_of_space`\n(\n `order_by`  smallint , `publish`  smallint , `type_of_space_id`  smallint , `type_of_space_option`  string \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_key_avail_type_of_space/2026-04-14/1776143713'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_key_avail_type_of_space"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_key_avail_type_of_space/2026-04-14/1776143713
id: 1713828
processed: 1

raw_data:

{
    "order_by": "int16",
    "publish": "int16",
    "type_of_space_id": "int16",
    "type_of_space_option": "string"
}

schema_attributes:

{
    "order_by": "smallint",
    "publish": "smallint",
    "type_of_space_id": "smallint",
    "type_of_space_option": "string"
}

schema_name_id: 1089
schema_scan_id: 161996370
updated: 2026-04-14 00:15:30

Schema Scans: 15

Last at 2026-04-17 14:15:32

Scan 162194008

duration: 0:00:14.185454

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162194008

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_key_avail_type_of_space/2026-04-17/1776453321",
        "key": "raw/sparefoot_key_avail_type_of_space/2026-04-17/1776453321/key_avail_type_of_space.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_key_avail_type_of_space",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 698094603175536249,
        "service_name": "sparefoot",
        "span_id": 2888589277549217167,
        "trace_id": 698094603175536249
    }
}

running: False
schema_name_id: 1089
start_time: 2026-04-17 14:15:32
success: True
trace_id: 698094603175536249

Scan 162178208

duration: 0:00:14.205447

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162178208

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_key_avail_type_of_space/2026-04-17/1776435096",
        "key": "raw/sparefoot_key_avail_type_of_space/2026-04-17/1776435096/key_avail_type_of_space.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_key_avail_type_of_space",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 11097795408234821065,
        "service_name": "sparefoot",
        "span_id": 16853161783500124169,
        "trace_id": 11097795408234821065
    }
}

running: False
schema_name_id: 1089
start_time: 2026-04-17 09:11:44
success: True
trace_id: 11097795408234821065

Scan 162163617

duration: 0:00:14.066881

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162163617

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_key_avail_type_of_space/2026-04-17/1776402653",
        "key": "raw/sparefoot_key_avail_type_of_space/2026-04-17/1776402653/key_avail_type_of_space.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_key_avail_type_of_space",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 1863821712988691078,
        "service_name": "sparefoot",
        "span_id": 15446310018546502456,
        "trace_id": 1863821712988691078
    }
}

running: False
schema_name_id: 1089
start_time: 2026-04-17 00:12:56
success: True
trace_id: 1863821712988691078

Scan 162156024

duration: 0:00:14.121576

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162156024

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_key_avail_type_of_space/2026-04-16/1776388326",
        "key": "raw/sparefoot_key_avail_type_of_space/2026-04-16/1776388326/key_avail_type_of_space.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_key_avail_type_of_space",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 12695446581517448832,
        "service_name": "sparefoot",
        "span_id": 501149069280932629,
        "trace_id": 12695446581517448832
    }
}

running: False
schema_name_id: 1089
start_time: 2026-04-16 20:15:17
success: True
trace_id: 12695446581517448832

Scan 162138028

duration: 0:00:11.622554

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162138028

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_key_avail_type_of_space/2026-04-16/1776366873",
        "key": "raw/sparefoot_key_avail_type_of_space/2026-04-16/1776366873/key_avail_type_of_space.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_key_avail_type_of_space",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 10697555463772613796,
        "service_name": "sparefoot",
        "span_id": 4643445759392541066,
        "trace_id": 10697555463772613796
    }
}

running: False
schema_name_id: 1089
start_time: 2026-04-16 14:14:55
success: True
trace_id: 10697555463772613796

Scan 162122510

duration: 0:00:11.693508

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162122510

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_key_avail_type_of_space/2026-04-16/1776348684",
        "key": "raw/sparefoot_key_avail_type_of_space/2026-04-16/1776348684/key_avail_type_of_space.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_key_avail_type_of_space",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 970939875396210089,
        "service_name": "sparefoot",
        "span_id": 5214202730193369543,
        "trace_id": 970939875396210089
    }
}

running: False
schema_name_id: 1089
start_time: 2026-04-16 09:11:27
success: True
trace_id: 970939875396210089

Scan 162107733

duration: 0:00:14.265172

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162107733

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_key_avail_type_of_space/2026-04-16/1776315929",
        "key": "raw/sparefoot_key_avail_type_of_space/2026-04-16/1776315929/key_avail_type_of_space.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_key_avail_type_of_space",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 3939298242775655026,
        "service_name": "sparefoot",
        "span_id": 14741889581651130485,
        "trace_id": 3939298242775655026
    }
}

running: False
schema_name_id: 1089
start_time: 2026-04-16 00:05:32
success: True
trace_id: 3939298242775655026

Scan 162100332

duration: 0:00:11.915904

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162100332

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_key_avail_type_of_space/2026-04-15/1776302700",
        "key": "raw/sparefoot_key_avail_type_of_space/2026-04-15/1776302700/key_avail_type_of_space.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_key_avail_type_of_space",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 9215263023874920675,
        "service_name": "sparefoot",
        "span_id": 16542543241722622617,
        "trace_id": 9215263023874920675
    }
}

running: False
schema_name_id: 1089
start_time: 2026-04-15 20:25:12
success: True
trace_id: 9215263023874920675

Scan 162081677

duration: 0:00:11.608053

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162081677

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_key_avail_type_of_space/2026-04-15/1776280281",
        "key": "raw/sparefoot_key_avail_type_of_space/2026-04-15/1776280281/key_avail_type_of_space.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_key_avail_type_of_space",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 12237999479761519978,
        "service_name": "sparefoot",
        "span_id": 15869034645585239778,
        "trace_id": 12237999479761519978
    }
}

running: False
schema_name_id: 1089
start_time: 2026-04-15 14:11:56
success: True
trace_id: 12237999479761519978

Scan 162064288

duration: 0:00:14.186365

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162064288

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_key_avail_type_of_space/2026-04-15/1776260216",
        "key": "raw/sparefoot_key_avail_type_of_space/2026-04-15/1776260216/key_avail_type_of_space.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_key_avail_type_of_space",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 6987611531854135757,
        "service_name": "sparefoot",
        "span_id": 3529195717429216382,
        "trace_id": 6987611531854135757
    }
}

running: False
schema_name_id: 1089
start_time: 2026-04-15 08:37:30
success: True
trace_id: 6987611531854135757

Scan 162052015

duration: 0:00:11.545481

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162052015

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_key_avail_type_of_space/2026-04-15/1776230631",
        "key": "raw/sparefoot_key_avail_type_of_space/2026-04-15/1776230631/key_avail_type_of_space.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_key_avail_type_of_space",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 8684820447867748324,
        "service_name": "sparefoot",
        "span_id": 15391983275961026370,
        "trace_id": 8684820447867748324
    }
}

running: False
schema_name_id: 1089
start_time: 2026-04-15 00:24:01
success: True
trace_id: 8684820447867748324

Scan 162044335

duration: 0:00:11.580514

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162044335

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_key_avail_type_of_space/2026-04-14/1776216321",
        "key": "raw/sparefoot_key_avail_type_of_space/2026-04-14/1776216321/key_avail_type_of_space.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_key_avail_type_of_space",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 16963175901764864659,
        "service_name": "sparefoot",
        "span_id": 7836591954246740525,
        "trace_id": 16963175901764864659
    }
}

running: False
schema_name_id: 1089
start_time: 2026-04-14 20:25:24
success: True
trace_id: 16963175901764864659

Scan 162026152

duration: 0:00:14.388785

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162026152

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_key_avail_type_of_space/2026-04-14/1776194173",
        "key": "raw/sparefoot_key_avail_type_of_space/2026-04-14/1776194173/key_avail_type_of_space.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_key_avail_type_of_space",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 9699756547163751,
        "service_name": "sparefoot",
        "span_id": 13018126456443497913,
        "trace_id": 9699756547163751
    }
}

running: False
schema_name_id: 1089
start_time: 2026-04-14 14:17:18
success: True
trace_id: 9699756547163751

Scan 162010972

duration: 0:00:14.146966

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162010972

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_key_avail_type_of_space/2026-04-14/1776175813",
        "key": "raw/sparefoot_key_avail_type_of_space/2026-04-14/1776175813/key_avail_type_of_space.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_key_avail_type_of_space",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 18270035053647528024,
        "service_name": "sparefoot",
        "span_id": 4757399474605264299,
        "trace_id": 18270035053647528024
    }
}

running: False
schema_name_id: 1089
start_time: 2026-04-14 09:11:43
success: True
trace_id: 18270035053647528024

Scan 161996370

duration: 0:00:14.104121

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161996370

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_key_avail_type_of_space/2026-04-14/1776143713",
        "key": "raw/sparefoot_key_avail_type_of_space/2026-04-14/1776143713/key_avail_type_of_space.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_key_avail_type_of_space",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 12059118968666112260,
        "service_name": "sparefoot",
        "span_id": 11689274340295348951,
        "trace_id": 12059118968666112260
    }
}

running: False
schema_name_id: 1089
start_time: 2026-04-14 00:15:16
success: True
trace_id: 12059118968666112260

Partitions:

count: 0
ddl: None
name: None
state:
```
[]
```
type: None

Schema:

attributes:

{
    "order_by": "smallint",
    "publish": "smallint",
    "type_of_space_id": "smallint",
    "type_of_space_option": "string"
}

created: 2026-04-17 14:15:33

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_key_avail_type_of_space`\n(\n `order_by`  smallint , `publish`  smallint , `type_of_space_id`  smallint , `type_of_space_option`  string \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_key_avail_type_of_space/2026-04-17/1776453321'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_key_avail_type_of_space`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_key_avail_type_of_space"
}

Server:

hostname: schemamanager-5475496c57-7dpqb
name: schema_manager
process_start: 2026-01-09 11:27:47
sf_env: prod
version: 2112174301

Raw:

{
    "name": {
        "created": "2022-08-18 17:16:12",
        "disabled": false,
        "format": "raw",
        "id": 1089,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_prod_rds",
            "table": "sparefoot_sparefoot_key_avail_type_of_space"
        },
        "type": "rds"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "order_by": "smallint",
            "publish": "smallint",
            "type_of_space_id": "smallint",
            "type_of_space_option": "string"
        },
        "created": "2026-04-17 14:15:33",
        "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_key_avail_type_of_space`\n(\n `order_by`  smallint , `publish`  smallint , `type_of_space_id`  smallint , `type_of_space_option`  string \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_key_avail_type_of_space/2026-04-17/1776453321'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_key_avail_type_of_space`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_key_avail_type_of_space"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}