Schema Info

Schema Name: sfdl_stage_rds.sparefoot_sparefoot_key_type_of_listing

created: 2022-11-15 01:25:41
disabled: False
format: raw
id: 1480
is_partitioned: False
is_schema_datatyped: False

name:

{
    "database": "sfdl_stage_rds",
    "table": "sparefoot_sparefoot_key_type_of_listing"
}

type: rds

Schema Versions: 15

Version 906568

created: 2026-04-17 00:20:48

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_key_type_of_listing`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_key_type_of_listing`\n(\n `description`  string , `type_of_listing`  string , `type_of_listing_id`  smallint \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_key_type_of_listing/2026-04-17/1776403239'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_key_type_of_listing"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_key_type_of_listing/2026-04-17/1776403239
id: 906568
processed: 1

raw_data:

{
    "description": "string",
    "type_of_listing": "string",
    "type_of_listing_id": "int16"
}

schema_attributes:

{
    "description": "string",
    "type_of_listing": "string",
    "type_of_listing_id": "smallint"
}

schema_name_id: 1480
schema_scan_id: 6415136
updated: 2026-04-17 00:20:59

Version 906352

created: 2026-04-16 00:11:53

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_key_type_of_listing`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_key_type_of_listing`\n(\n `description`  string , `type_of_listing`  string , `type_of_listing_id`  smallint \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_key_type_of_listing/2026-04-16/1776316296'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_key_type_of_listing"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_key_type_of_listing/2026-04-16/1776316296
id: 906352
processed: 1

raw_data:

{
    "description": "string",
    "type_of_listing": "string",
    "type_of_listing_id": "int16"
}

schema_attributes:

{
    "description": "string",
    "type_of_listing": "string",
    "type_of_listing_id": "smallint"
}

schema_name_id: 1480
schema_scan_id: 6414588
updated: 2026-04-16 00:12:04

Version 906115

created: 2026-04-15 00:09:52

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_key_type_of_listing`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_key_type_of_listing`\n(\n `description`  string , `type_of_listing`  string , `type_of_listing_id`  smallint \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_key_type_of_listing/2026-04-15/1776229781'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_key_type_of_listing"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_key_type_of_listing/2026-04-15/1776229781
id: 906115
processed: 1

raw_data:

{
    "description": "string",
    "type_of_listing": "string",
    "type_of_listing_id": "int16"
}

schema_attributes:

{
    "description": "string",
    "type_of_listing": "string",
    "type_of_listing_id": "smallint"
}

schema_name_id: 1480
schema_scan_id: 6414076
updated: 2026-04-15 00:10:06

Version 905913

created: 2026-04-14 00:11:35

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_key_type_of_listing`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_key_type_of_listing`\n(\n `description`  string , `type_of_listing`  string , `type_of_listing_id`  smallint \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_key_type_of_listing/2026-04-14/1776143491'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_key_type_of_listing"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_key_type_of_listing/2026-04-14/1776143491
id: 905913
processed: 1

raw_data:

{
    "description": "string",
    "type_of_listing": "string",
    "type_of_listing_id": "int16"
}

schema_attributes:

{
    "description": "string",
    "type_of_listing": "string",
    "type_of_listing_id": "smallint"
}

schema_name_id: 1480
schema_scan_id: 6413579
updated: 2026-04-14 00:11:48

Version 905666

created: 2026-04-13 00:11:00

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_key_type_of_listing`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_key_type_of_listing`\n(\n `description`  string , `type_of_listing`  string , `type_of_listing_id`  smallint \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_key_type_of_listing/2026-04-13/1776057049'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_key_type_of_listing"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_key_type_of_listing/2026-04-13/1776057049
id: 905666
processed: 1

raw_data:

{
    "description": "string",
    "type_of_listing": "string",
    "type_of_listing_id": "int16"
}

schema_attributes:

{
    "description": "string",
    "type_of_listing": "string",
    "type_of_listing_id": "smallint"
}

schema_name_id: 1480
schema_scan_id: 6412995
updated: 2026-04-13 00:11:12

Version 905500

created: 2026-04-12 00:11:13

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_key_type_of_listing`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_key_type_of_listing`\n(\n `description`  string , `type_of_listing`  string , `type_of_listing_id`  smallint \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_key_type_of_listing/2026-04-12/1775970659'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_key_type_of_listing"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_key_type_of_listing/2026-04-12/1775970659
id: 905500
processed: 1

raw_data:

{
    "description": "string",
    "type_of_listing": "string",
    "type_of_listing_id": "int16"
}

schema_attributes:

{
    "description": "string",
    "type_of_listing": "string",
    "type_of_listing_id": "smallint"
}

schema_name_id: 1480
schema_scan_id: 6412652
updated: 2026-04-12 00:11:24

Version 905275

created: 2026-04-11 00:08:55

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_key_type_of_listing`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_key_type_of_listing`\n(\n `description`  string , `type_of_listing`  string , `type_of_listing_id`  smallint \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_key_type_of_listing/2026-04-11/1775884126'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_key_type_of_listing"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_key_type_of_listing/2026-04-11/1775884126
id: 905275
processed: 1

raw_data:

{
    "description": "string",
    "type_of_listing": "string",
    "type_of_listing_id": "int16"
}

schema_attributes:

{
    "description": "string",
    "type_of_listing": "string",
    "type_of_listing_id": "smallint"
}

schema_name_id: 1480
schema_scan_id: 6412247
updated: 2026-04-11 00:09:08

Version 905064

created: 2026-04-10 00:07:48

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_key_type_of_listing`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_key_type_of_listing`\n(\n `description`  string , `type_of_listing`  string , `type_of_listing_id`  smallint \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_key_type_of_listing/2026-04-10/1775797663'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_key_type_of_listing"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_key_type_of_listing/2026-04-10/1775797663
id: 905064
processed: 1

raw_data:

{
    "description": "string",
    "type_of_listing": "string",
    "type_of_listing_id": "int16"
}

schema_attributes:

{
    "description": "string",
    "type_of_listing": "string",
    "type_of_listing_id": "smallint"
}

schema_name_id: 1480
schema_scan_id: 6411744
updated: 2026-04-10 00:08:02

Version 904846

created: 2026-04-09 00:11:52

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_key_type_of_listing`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_key_type_of_listing`\n(\n `description`  string , `type_of_listing`  string , `type_of_listing_id`  smallint \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_key_type_of_listing/2026-04-09/1775711508'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_key_type_of_listing"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_key_type_of_listing/2026-04-09/1775711508
id: 904846
processed: 1

raw_data:

{
    "description": "string",
    "type_of_listing": "string",
    "type_of_listing_id": "int16"
}

schema_attributes:

{
    "description": "string",
    "type_of_listing": "string",
    "type_of_listing_id": "smallint"
}

schema_name_id: 1480
schema_scan_id: 6411231
updated: 2026-04-09 00:12:03

Version 904653

created: 2026-04-08 00:12:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_key_type_of_listing`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_key_type_of_listing`\n(\n `description`  string , `type_of_listing`  string , `type_of_listing_id`  smallint \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_key_type_of_listing/2026-04-08/1775625139'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_key_type_of_listing"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_key_type_of_listing/2026-04-08/1775625139
id: 904653
processed: 1

raw_data:

{
    "description": "string",
    "type_of_listing": "string",
    "type_of_listing_id": "int16"
}

schema_attributes:

{
    "description": "string",
    "type_of_listing": "string",
    "type_of_listing_id": "smallint"
}

schema_name_id: 1480
schema_scan_id: 6410750
updated: 2026-04-08 00:12:45

Version 904454

created: 2026-04-07 00:15:40

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_key_type_of_listing`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_key_type_of_listing`\n(\n `description`  string , `type_of_listing`  string , `type_of_listing_id`  smallint \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_key_type_of_listing/2026-04-07/1775538938'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_key_type_of_listing"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_key_type_of_listing/2026-04-07/1775538938
id: 904454
processed: 1

raw_data:

{
    "description": "string",
    "type_of_listing": "string",
    "type_of_listing_id": "int16"
}

schema_attributes:

{
    "description": "string",
    "type_of_listing": "string",
    "type_of_listing_id": "smallint"
}

schema_name_id: 1480
schema_scan_id: 6410258
updated: 2026-04-07 00:15:52

Version 904207

created: 2026-04-06 00:06:44

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_key_type_of_listing`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_key_type_of_listing`\n(\n `description`  string , `type_of_listing`  string , `type_of_listing_id`  smallint \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_key_type_of_listing/2026-04-06/1775451997'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_key_type_of_listing"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_key_type_of_listing/2026-04-06/1775451997
id: 904207
processed: 1

raw_data:

{
    "description": "string",
    "type_of_listing": "string",
    "type_of_listing_id": "int16"
}

schema_attributes:

{
    "description": "string",
    "type_of_listing": "string",
    "type_of_listing_id": "smallint"
}

schema_name_id: 1480
schema_scan_id: 6409679
updated: 2026-04-06 00:06:55

Version 904026

created: 2026-04-05 00:10:11

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_key_type_of_listing`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_key_type_of_listing`\n(\n `description`  string , `type_of_listing`  string , `type_of_listing_id`  smallint \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_key_type_of_listing/2026-04-05/1775365804'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_key_type_of_listing"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_key_type_of_listing/2026-04-05/1775365804
id: 904026
processed: 1

raw_data:

{
    "description": "string",
    "type_of_listing": "string",
    "type_of_listing_id": "int16"
}

schema_attributes:

{
    "description": "string",
    "type_of_listing": "string",
    "type_of_listing_id": "smallint"
}

schema_name_id: 1480
schema_scan_id: 6409321
updated: 2026-04-05 00:10:23

Version 903809

created: 2026-04-04 00:09:03

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_key_type_of_listing`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_key_type_of_listing`\n(\n `description`  string , `type_of_listing`  string , `type_of_listing_id`  smallint \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_key_type_of_listing/2026-04-04/1775279336'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_key_type_of_listing"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_key_type_of_listing/2026-04-04/1775279336
id: 903809
processed: 1

raw_data:

{
    "description": "string",
    "type_of_listing": "string",
    "type_of_listing_id": "int16"
}

schema_attributes:

{
    "description": "string",
    "type_of_listing": "string",
    "type_of_listing_id": "smallint"
}

schema_name_id: 1480
schema_scan_id: 6408925
updated: 2026-04-04 00:09:14

Version 903623

created: 2026-04-03 00:12:57

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_key_type_of_listing`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_key_type_of_listing`\n(\n `description`  string , `type_of_listing`  string , `type_of_listing_id`  smallint \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_key_type_of_listing/2026-04-03/1775193168'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_key_type_of_listing"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_key_type_of_listing/2026-04-03/1775193168
id: 903623
processed: 1

raw_data:

{
    "description": "string",
    "type_of_listing": "string",
    "type_of_listing_id": "int16"
}

schema_attributes:

{
    "description": "string",
    "type_of_listing": "string",
    "type_of_listing_id": "smallint"
}

schema_name_id: 1480
schema_scan_id: 6408458
updated: 2026-04-03 00:13:08

Schema Scans: 15

Last at 2026-04-17 00:20:47

Scan 6415136

duration: 0:00:11.518771

exit_message:

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

id: 6415136

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_key_type_of_listing/2026-04-17/1776403239",
        "key": "raw/sparefoot_key_type_of_listing/2026-04-17/1776403239/key_type_of_listing.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_key_type_of_listing",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 7601427970977132547,
        "service_name": "sparefoot",
        "span_id": 3446775376691305706,
        "trace_id": 7601427970977132547
    }
}

running: False
schema_name_id: 1480
start_time: 2026-04-17 00:20:47
success: True
trace_id: 7601427970977132547

Scan 6414588

duration: 0:00:11.632501

exit_message:

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

id: 6414588

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_key_type_of_listing/2026-04-16/1776316296",
        "key": "raw/sparefoot_key_type_of_listing/2026-04-16/1776316296/key_type_of_listing.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_key_type_of_listing",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 13154323483509359639,
        "service_name": "sparefoot",
        "span_id": 110376535554590364,
        "trace_id": 13154323483509359639
    }
}

running: False
schema_name_id: 1480
start_time: 2026-04-16 00:11:53
success: True
trace_id: 13154323483509359639

Scan 6414076

duration: 0:00:14.227825

exit_message:

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

id: 6414076

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_key_type_of_listing/2026-04-15/1776229781",
        "key": "raw/sparefoot_key_type_of_listing/2026-04-15/1776229781/key_type_of_listing.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_key_type_of_listing",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 5133532341115405932,
        "service_name": "sparefoot",
        "span_id": 5004467900664992944,
        "trace_id": 5133532341115405932
    }
}

running: False
schema_name_id: 1480
start_time: 2026-04-15 00:09:51
success: True
trace_id: 5133532341115405932

Scan 6413579

duration: 0:00:14.180475

exit_message:

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

id: 6413579

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_key_type_of_listing/2026-04-14/1776143491",
        "key": "raw/sparefoot_key_type_of_listing/2026-04-14/1776143491/key_type_of_listing.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_key_type_of_listing",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 17488587034190762429,
        "service_name": "sparefoot",
        "span_id": 2181443789622904454,
        "trace_id": 17488587034190762429
    }
}

running: False
schema_name_id: 1480
start_time: 2026-04-14 00:11:34
success: True
trace_id: 17488587034190762429

Scan 6412995

duration: 0:00:11.887116

exit_message:

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

id: 6412995

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_key_type_of_listing/2026-04-13/1776057049",
        "key": "raw/sparefoot_key_type_of_listing/2026-04-13/1776057049/key_type_of_listing.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_key_type_of_listing",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 14445002633093397989,
        "service_name": "sparefoot",
        "span_id": 17334166552766961939,
        "trace_id": 14445002633093397989
    }
}

running: False
schema_name_id: 1480
start_time: 2026-04-13 00:11:00
success: True
trace_id: 14445002633093397989

Scan 6412652

duration: 0:00:11.612154

exit_message:

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

id: 6412652

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_key_type_of_listing/2026-04-12/1775970659",
        "key": "raw/sparefoot_key_type_of_listing/2026-04-12/1775970659/key_type_of_listing.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_key_type_of_listing",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 16111771519671264048,
        "service_name": "sparefoot",
        "span_id": 13961363424108303267,
        "trace_id": 16111771519671264048
    }
}

running: False
schema_name_id: 1480
start_time: 2026-04-12 00:11:13
success: True
trace_id: 16111771519671264048

Scan 6412247

duration: 0:00:14.055106

exit_message:

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

id: 6412247

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_key_type_of_listing/2026-04-11/1775884126",
        "key": "raw/sparefoot_key_type_of_listing/2026-04-11/1775884126/key_type_of_listing.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_key_type_of_listing",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 4132024619087508957,
        "service_name": "sparefoot",
        "span_id": 11686098779077308592,
        "trace_id": 4132024619087508957
    }
}

running: False
schema_name_id: 1480
start_time: 2026-04-11 00:08:54
success: True
trace_id: 4132024619087508957

Scan 6411744

duration: 0:00:14.263575

exit_message:

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

id: 6411744

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_key_type_of_listing/2026-04-10/1775797663",
        "key": "raw/sparefoot_key_type_of_listing/2026-04-10/1775797663/key_type_of_listing.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_key_type_of_listing",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 3680521970332298342,
        "service_name": "sparefoot",
        "span_id": 624062742614348726,
        "trace_id": 3680521970332298342
    }
}

running: False
schema_name_id: 1480
start_time: 2026-04-10 00:07:48
success: True
trace_id: 3680521970332298342

Scan 6411231

duration: 0:00:11.668443

exit_message:

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

id: 6411231

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_key_type_of_listing/2026-04-09/1775711508",
        "key": "raw/sparefoot_key_type_of_listing/2026-04-09/1775711508/key_type_of_listing.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_key_type_of_listing",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 11755781281767012209,
        "service_name": "sparefoot",
        "span_id": 6646521183668777945,
        "trace_id": 11755781281767012209
    }
}

running: False
schema_name_id: 1480
start_time: 2026-04-09 00:11:51
success: True
trace_id: 11755781281767012209

Scan 6410750

duration: 0:00:11.587583

exit_message:

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

id: 6410750

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_key_type_of_listing/2026-04-08/1775625139",
        "key": "raw/sparefoot_key_type_of_listing/2026-04-08/1775625139/key_type_of_listing.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_key_type_of_listing",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 16418292923464933150,
        "service_name": "sparefoot",
        "span_id": 7924362103280275325,
        "trace_id": 16418292923464933150
    }
}

running: False
schema_name_id: 1480
start_time: 2026-04-08 00:12:34
success: True
trace_id: 16418292923464933150

Scan 6410258

duration: 0:00:11.672140

exit_message:

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

id: 6410258

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_key_type_of_listing/2026-04-07/1775538938",
        "key": "raw/sparefoot_key_type_of_listing/2026-04-07/1775538938/key_type_of_listing.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_key_type_of_listing",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 12889202999761106846,
        "service_name": "sparefoot",
        "span_id": 9989269481357348807,
        "trace_id": 12889202999761106846
    }
}

running: False
schema_name_id: 1480
start_time: 2026-04-07 00:15:40
success: True
trace_id: 12889202999761106846

Scan 6409679

duration: 0:00:11.703253

exit_message:

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

id: 6409679

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_key_type_of_listing/2026-04-06/1775451997",
        "key": "raw/sparefoot_key_type_of_listing/2026-04-06/1775451997/key_type_of_listing.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_key_type_of_listing",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 16642831154909436103,
        "service_name": "sparefoot",
        "span_id": 15465443762426310066,
        "trace_id": 16642831154909436103
    }
}

running: False
schema_name_id: 1480
start_time: 2026-04-06 00:06:43
success: True
trace_id: 16642831154909436103

Scan 6409321

duration: 0:00:11.601940

exit_message:

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

id: 6409321

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_key_type_of_listing/2026-04-05/1775365804",
        "key": "raw/sparefoot_key_type_of_listing/2026-04-05/1775365804/key_type_of_listing.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_key_type_of_listing",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 16226781609610962856,
        "service_name": "sparefoot",
        "span_id": 6961435779130664403,
        "trace_id": 16226781609610962856
    }
}

running: False
schema_name_id: 1480
start_time: 2026-04-05 00:10:11
success: True
trace_id: 16226781609610962856

Scan 6408925

duration: 0:00:11.553259

exit_message:

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

id: 6408925

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_key_type_of_listing/2026-04-04/1775279336",
        "key": "raw/sparefoot_key_type_of_listing/2026-04-04/1775279336/key_type_of_listing.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_key_type_of_listing",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 4935757571988183021,
        "service_name": "sparefoot",
        "span_id": 15189260306684298736,
        "trace_id": 4935757571988183021
    }
}

running: False
schema_name_id: 1480
start_time: 2026-04-04 00:09:03
success: True
trace_id: 4935757571988183021

Scan 6408458

duration: 0:00:11.651587

exit_message:

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

id: 6408458

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_key_type_of_listing/2026-04-03/1775193168",
        "key": "raw/sparefoot_key_type_of_listing/2026-04-03/1775193168/key_type_of_listing.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_key_type_of_listing",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 8863722181568241580,
        "service_name": "sparefoot",
        "span_id": 3514995188676421357,
        "trace_id": 8863722181568241580
    }
}

running: False
schema_name_id: 1480
start_time: 2026-04-03 00:12:56
success: True
trace_id: 8863722181568241580

Partitions:

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

Schema:

attributes:

{
    "description": "string",
    "type_of_listing": "string",
    "type_of_listing_id": "smallint"
}

created: 2026-04-17 00:20:48

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_key_type_of_listing`\n(\n `description`  string , `type_of_listing`  string , `type_of_listing_id`  smallint \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_key_type_of_listing/2026-04-17/1776403239'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_key_type_of_listing`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_key_type_of_listing"
}

Server:

hostname: schemamanager-5c55c886bf-h2ts4
name: schema_manager
process_start: 2025-10-21 13:03:27
sf_env: stage
version: 2112174301

Raw:

{
    "name": {
        "created": "2022-11-15 01:25:41",
        "disabled": false,
        "format": "raw",
        "id": 1480,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_stage_rds",
            "table": "sparefoot_sparefoot_key_type_of_listing"
        },
        "type": "rds"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "description": "string",
            "type_of_listing": "string",
            "type_of_listing_id": "smallint"
        },
        "created": "2026-04-17 00:20:48",
        "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_key_type_of_listing`\n(\n `description`  string , `type_of_listing`  string , `type_of_listing_id`  smallint \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_key_type_of_listing/2026-04-17/1776403239'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_key_type_of_listing`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_key_type_of_listing"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}