Schema Info

Schema Name: sfdl_prod_rds.sparefoot_sparefoot_location

created: 2022-11-29 15:23:28
disabled: False
format: raw
id: 1232
is_partitioned: False
is_schema_datatyped: False

name:

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

type: rds

Schema Versions: 15

Version 1718428

created: 2026-04-17 14:44:23

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_location`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_location`\n(\n `city`  string , `country`  string , `is_address_real`  smallint , `latitude`  double , `location_id`  int , `location_label`  string , `longitude`  double , `override`  smallint , `state`  string , `street_address_1`  string , `street_address_2`  string , `timestamp`  timestamp , `zip`  string , `zip_full`  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_location/2026-04-17/1776455044'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_location"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_location/2026-04-17/1776455044
id: 1718428
processed: 1

raw_data:

{
    "city": "string",
    "country": "string",
    "is_address_real": "int16",
    "latitude": "double",
    "location_id": "int32",
    "location_label": "string",
    "longitude": "double",
    "override": "int16",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "timestamp": "timestamp[ns]",
    "zip": "string",
    "zip_full": "string"
}

schema_attributes:

{
    "city": "string",
    "country": "string",
    "is_address_real": "smallint",
    "latitude": "double",
    "location_id": "int",
    "location_label": "string",
    "longitude": "double",
    "override": "smallint",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "timestamp": "timestamp",
    "zip": "string",
    "zip_full": "string"
}

schema_name_id: 1232
schema_scan_id: 162194401
updated: 2026-04-17 14:44:37

Version 1718266

created: 2026-04-17 09:40:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_location`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_location`\n(\n `city`  string , `country`  string , `is_address_real`  smallint , `latitude`  double , `location_id`  int , `location_label`  string , `longitude`  double , `override`  smallint , `state`  string , `street_address_1`  string , `street_address_2`  string , `timestamp`  timestamp , `zip`  string , `zip_full`  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_location/2026-04-17/1776436781'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_location"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_location/2026-04-17/1776436781
id: 1718266
processed: 1

raw_data:

{
    "city": "string",
    "country": "string",
    "is_address_real": "int16",
    "latitude": "double",
    "location_id": "int32",
    "location_label": "string",
    "longitude": "double",
    "override": "int16",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "timestamp": "timestamp[ns]",
    "zip": "string",
    "zip_full": "string"
}

schema_attributes:

{
    "city": "string",
    "country": "string",
    "is_address_real": "smallint",
    "latitude": "double",
    "location_id": "int",
    "location_label": "string",
    "longitude": "double",
    "override": "smallint",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "timestamp": "timestamp",
    "zip": "string",
    "zip_full": "string"
}

schema_name_id: 1232
schema_scan_id: 162178641
updated: 2026-04-17 09:40:28

Version 1717483

created: 2026-04-17 00:31:08

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_location`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_location`\n(\n `city`  string , `country`  string , `is_address_real`  smallint , `latitude`  double , `location_id`  int , `location_label`  string , `longitude`  double , `override`  smallint , `state`  string , `street_address_1`  string , `street_address_2`  string , `timestamp`  timestamp , `zip`  string , `zip_full`  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_location/2026-04-17/1776403841'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_location"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_location/2026-04-17/1776403841
id: 1717483
processed: 1

raw_data:

{
    "city": "string",
    "country": "string",
    "is_address_real": "int16",
    "latitude": "double",
    "location_id": "int32",
    "location_label": "string",
    "longitude": "double",
    "override": "int16",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "timestamp": "timestamp[ns]",
    "zip": "string",
    "zip_full": "string"
}

schema_attributes:

{
    "city": "string",
    "country": "string",
    "is_address_real": "smallint",
    "latitude": "double",
    "location_id": "int",
    "location_label": "string",
    "longitude": "double",
    "override": "smallint",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "timestamp": "timestamp",
    "zip": "string",
    "zip_full": "string"
}

schema_name_id: 1232
schema_scan_id: 162163715
updated: 2026-04-17 00:31:19

Version 1717359

created: 2026-04-16 20:32:24

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_location`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_location`\n(\n `city`  string , `country`  string , `is_address_real`  smallint , `latitude`  double , `location_id`  int , `location_label`  string , `longitude`  double , `override`  smallint , `state`  string , `street_address_1`  string , `street_address_2`  string , `timestamp`  timestamp , `zip`  string , `zip_full`  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_location/2026-04-16/1776389524'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_location"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_location/2026-04-16/1776389524
id: 1717359
processed: 1

raw_data:

{
    "city": "string",
    "country": "string",
    "is_address_real": "int16",
    "latitude": "double",
    "location_id": "int32",
    "location_label": "string",
    "longitude": "double",
    "override": "int16",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "timestamp": "timestamp[ns]",
    "zip": "string",
    "zip_full": "string"
}

schema_attributes:

{
    "city": "string",
    "country": "string",
    "is_address_real": "smallint",
    "latitude": "double",
    "location_id": "int",
    "location_label": "string",
    "longitude": "double",
    "override": "smallint",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "timestamp": "timestamp",
    "zip": "string",
    "zip_full": "string"
}

schema_name_id: 1232
schema_scan_id: 162156226
updated: 2026-04-16 20:32:38

Version 1717205

created: 2026-04-16 14:47:29

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_location`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_location`\n(\n `city`  string , `country`  string , `is_address_real`  smallint , `latitude`  double , `location_id`  int , `location_label`  string , `longitude`  double , `override`  smallint , `state`  string , `street_address_1`  string , `street_address_2`  string , `timestamp`  timestamp , `zip`  string , `zip_full`  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_location/2026-04-16/1776368789'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_location"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_location/2026-04-16/1776368789
id: 1717205
processed: 1

raw_data:

{
    "city": "string",
    "country": "string",
    "is_address_real": "int16",
    "latitude": "double",
    "location_id": "int32",
    "location_label": "string",
    "longitude": "double",
    "override": "int16",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "timestamp": "timestamp[ns]",
    "zip": "string",
    "zip_full": "string"
}

schema_attributes:

{
    "city": "string",
    "country": "string",
    "is_address_real": "smallint",
    "latitude": "double",
    "location_id": "int",
    "location_label": "string",
    "longitude": "double",
    "override": "smallint",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "timestamp": "timestamp",
    "zip": "string",
    "zip_full": "string"
}

schema_name_id: 1232
schema_scan_id: 162138818
updated: 2026-04-16 14:47:43

Version 1717052

created: 2026-04-16 09:45:13

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_location`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_location`\n(\n `city`  string , `country`  string , `is_address_real`  smallint , `latitude`  double , `location_id`  int , `location_label`  string , `longitude`  double , `override`  smallint , `state`  string , `street_address_1`  string , `street_address_2`  string , `timestamp`  timestamp , `zip`  string , `zip_full`  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_location/2026-04-16/1776350676'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_location"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_location/2026-04-16/1776350676
id: 1717052
processed: 1

raw_data:

{
    "city": "string",
    "country": "string",
    "is_address_real": "int16",
    "latitude": "double",
    "location_id": "int32",
    "location_label": "string",
    "longitude": "double",
    "override": "int16",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "timestamp": "timestamp[ns]",
    "zip": "string",
    "zip_full": "string"
}

schema_attributes:

{
    "city": "string",
    "country": "string",
    "is_address_real": "smallint",
    "latitude": "double",
    "location_id": "int",
    "location_label": "string",
    "longitude": "double",
    "override": "smallint",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "timestamp": "timestamp",
    "zip": "string",
    "zip_full": "string"
}

schema_name_id: 1232
schema_scan_id: 162122926
updated: 2026-04-16 09:45:24

Version 1716253

created: 2026-04-16 00:46:10

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_location`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_location`\n(\n `city`  string , `country`  string , `is_address_real`  smallint , `latitude`  double , `location_id`  int , `location_label`  string , `longitude`  double , `override`  smallint , `state`  string , `street_address_1`  string , `street_address_2`  string , `timestamp`  timestamp , `zip`  string , `zip_full`  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_location/2026-04-16/1776318350'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_location"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_location/2026-04-16/1776318350
id: 1716253
processed: 1

raw_data:

{
    "city": "string",
    "country": "string",
    "is_address_real": "int16",
    "latitude": "double",
    "location_id": "int32",
    "location_label": "string",
    "longitude": "double",
    "override": "int16",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "timestamp": "timestamp[ns]",
    "zip": "string",
    "zip_full": "string"
}

schema_attributes:

{
    "city": "string",
    "country": "string",
    "is_address_real": "smallint",
    "latitude": "double",
    "location_id": "int",
    "location_label": "string",
    "longitude": "double",
    "override": "smallint",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "timestamp": "timestamp",
    "zip": "string",
    "zip_full": "string"
}

schema_name_id: 1232
schema_scan_id: 162107892
updated: 2026-04-16 00:46:22

Version 1716079

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_location`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_location`\n(\n `city`  string , `country`  string , `is_address_real`  smallint , `latitude`  double , `location_id`  int , `location_label`  string , `longitude`  double , `override`  smallint , `state`  string , `street_address_1`  string , `street_address_2`  string , `timestamp`  timestamp , `zip`  string , `zip_full`  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_location/2026-04-15/1776302248'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_location"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_location/2026-04-15/1776302248
id: 1716079
processed: 1

raw_data:

{
    "city": "string",
    "country": "string",
    "is_address_real": "int16",
    "latitude": "double",
    "location_id": "int32",
    "location_label": "string",
    "longitude": "double",
    "override": "int16",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "timestamp": "timestamp[ns]",
    "zip": "string",
    "zip_full": "string"
}

schema_attributes:

{
    "city": "string",
    "country": "string",
    "is_address_real": "smallint",
    "latitude": "double",
    "location_id": "int",
    "location_label": "string",
    "longitude": "double",
    "override": "smallint",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "timestamp": "timestamp",
    "zip": "string",
    "zip_full": "string"
}

schema_name_id: 1232
schema_scan_id: 162100284
updated: 2026-04-15 20:18:21

Version 1716011

created: 2026-04-15 14:49:46

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_location`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_location`\n(\n `city`  string , `country`  string , `is_address_real`  smallint , `latitude`  double , `location_id`  int , `location_label`  string , `longitude`  double , `override`  smallint , `state`  string , `street_address_1`  string , `street_address_2`  string , `timestamp`  timestamp , `zip`  string , `zip_full`  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_location/2026-04-15/1776282555'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_location"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_location/2026-04-15/1776282555
id: 1716011
processed: 1

raw_data:

{
    "city": "string",
    "country": "string",
    "is_address_real": "int16",
    "latitude": "double",
    "location_id": "int32",
    "location_label": "string",
    "longitude": "double",
    "override": "int16",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "timestamp": "timestamp[ns]",
    "zip": "string",
    "zip_full": "string"
}

schema_attributes:

{
    "city": "string",
    "country": "string",
    "is_address_real": "smallint",
    "latitude": "double",
    "location_id": "int",
    "location_label": "string",
    "longitude": "double",
    "override": "smallint",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "timestamp": "timestamp",
    "zip": "string",
    "zip_full": "string"
}

schema_name_id: 1232
schema_scan_id: 162083056
updated: 2026-04-15 14:49:57

Version 1715807

created: 2026-04-15 09:02:30

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_location`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_location`\n(\n `city`  string , `country`  string , `is_address_real`  smallint , `latitude`  double , `location_id`  int , `location_label`  string , `longitude`  double , `override`  smallint , `state`  string , `street_address_1`  string , `street_address_2`  string , `timestamp`  timestamp , `zip`  string , `zip_full`  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_location/2026-04-15/1776261532'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_location"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_location/2026-04-15/1776261532
id: 1715807
processed: 1

raw_data:

{
    "city": "string",
    "country": "string",
    "is_address_real": "int16",
    "latitude": "double",
    "location_id": "int32",
    "location_label": "string",
    "longitude": "double",
    "override": "int16",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "timestamp": "timestamp[ns]",
    "zip": "string",
    "zip_full": "string"
}

schema_attributes:

{
    "city": "string",
    "country": "string",
    "is_address_real": "smallint",
    "latitude": "double",
    "location_id": "int",
    "location_label": "string",
    "longitude": "double",
    "override": "smallint",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "timestamp": "timestamp",
    "zip": "string",
    "zip_full": "string"
}

schema_name_id: 1232
schema_scan_id: 162066098
updated: 2026-04-15 09:02:50

Version 1715056

created: 2026-04-15 00:31:29

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_location`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_location`\n(\n `city`  string , `country`  string , `is_address_real`  smallint , `latitude`  double , `location_id`  int , `location_label`  string , `longitude`  double , `override`  smallint , `state`  string , `street_address_1`  string , `street_address_2`  string , `timestamp`  timestamp , `zip`  string , `zip_full`  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_location/2026-04-15/1776231071'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_location"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_location/2026-04-15/1776231071
id: 1715056
processed: 1

raw_data:

{
    "city": "string",
    "country": "string",
    "is_address_real": "int16",
    "latitude": "double",
    "location_id": "int32",
    "location_label": "string",
    "longitude": "double",
    "override": "int16",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "timestamp": "timestamp[ns]",
    "zip": "string",
    "zip_full": "string"
}

schema_attributes:

{
    "city": "string",
    "country": "string",
    "is_address_real": "smallint",
    "latitude": "double",
    "location_id": "int",
    "location_label": "string",
    "longitude": "double",
    "override": "smallint",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "timestamp": "timestamp",
    "zip": "string",
    "zip_full": "string"
}

schema_name_id: 1232
schema_scan_id: 162052039
updated: 2026-04-15 00:31:43

Version 1714937

created: 2026-04-14 20:48:13

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_location`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_location`\n(\n `city`  string , `country`  string , `is_address_real`  smallint , `latitude`  double , `location_id`  int , `location_label`  string , `longitude`  double , `override`  smallint , `state`  string , `street_address_1`  string , `street_address_2`  string , `timestamp`  timestamp , `zip`  string , `zip_full`  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_location/2026-04-14/1776217660'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_location"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_location/2026-04-14/1776217660
id: 1714937
processed: 1

raw_data:

{
    "city": "string",
    "country": "string",
    "is_address_real": "int16",
    "latitude": "double",
    "location_id": "int32",
    "location_label": "string",
    "longitude": "double",
    "override": "int16",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "timestamp": "timestamp[ns]",
    "zip": "string",
    "zip_full": "string"
}

schema_attributes:

{
    "city": "string",
    "country": "string",
    "is_address_real": "smallint",
    "latitude": "double",
    "location_id": "int",
    "location_label": "string",
    "longitude": "double",
    "override": "smallint",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "timestamp": "timestamp",
    "zip": "string",
    "zip_full": "string"
}

schema_name_id: 1232
schema_scan_id: 162044408
updated: 2026-04-14 20:48:27

Version 1714768

created: 2026-04-14 14:30:33

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_location`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_location`\n(\n `city`  string , `country`  string , `is_address_real`  smallint , `latitude`  double , `location_id`  int , `location_label`  string , `longitude`  double , `override`  smallint , `state`  string , `street_address_1`  string , `street_address_2`  string , `timestamp`  timestamp , `zip`  string , `zip_full`  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_location/2026-04-14/1776195006'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_location"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_location/2026-04-14/1776195006
id: 1714768
processed: 1

raw_data:

{
    "city": "string",
    "country": "string",
    "is_address_real": "int16",
    "latitude": "double",
    "location_id": "int32",
    "location_label": "string",
    "longitude": "double",
    "override": "int16",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "timestamp": "timestamp[ns]",
    "zip": "string",
    "zip_full": "string"
}

schema_attributes:

{
    "city": "string",
    "country": "string",
    "is_address_real": "smallint",
    "latitude": "double",
    "location_id": "int",
    "location_label": "string",
    "longitude": "double",
    "override": "smallint",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "timestamp": "timestamp",
    "zip": "string",
    "zip_full": "string"
}

schema_name_id: 1232
schema_scan_id: 162026355
updated: 2026-04-14 14:30:45

Version 1714611

created: 2026-04-14 09:19:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_location`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_location`\n(\n `city`  string , `country`  string , `is_address_real`  smallint , `latitude`  double , `location_id`  int , `location_label`  string , `longitude`  double , `override`  smallint , `state`  string , `street_address_1`  string , `street_address_2`  string , `timestamp`  timestamp , `zip`  string , `zip_full`  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_location/2026-04-14/1776176354'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_location"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_location/2026-04-14/1776176354
id: 1714611
processed: 1

raw_data:

{
    "city": "string",
    "country": "string",
    "is_address_real": "int16",
    "latitude": "double",
    "location_id": "int32",
    "location_label": "string",
    "longitude": "double",
    "override": "int16",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "timestamp": "timestamp[ns]",
    "zip": "string",
    "zip_full": "string"
}

schema_attributes:

{
    "city": "string",
    "country": "string",
    "is_address_real": "smallint",
    "latitude": "double",
    "location_id": "int",
    "location_label": "string",
    "longitude": "double",
    "override": "smallint",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "timestamp": "timestamp",
    "zip": "string",
    "zip_full": "string"
}

schema_name_id: 1232
schema_scan_id: 162011048
updated: 2026-04-14 09:19:43

Version 1713854

created: 2026-04-14 00:32:24

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_location`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_location`\n(\n `city`  string , `country`  string , `is_address_real`  smallint , `latitude`  double , `location_id`  int , `location_label`  string , `longitude`  double , `override`  smallint , `state`  string , `street_address_1`  string , `street_address_2`  string , `timestamp`  timestamp , `zip`  string , `zip_full`  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_location/2026-04-14/1776144706'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_location"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_location/2026-04-14/1776144706
id: 1713854
processed: 1

raw_data:

{
    "city": "string",
    "country": "string",
    "is_address_real": "int16",
    "latitude": "double",
    "location_id": "int32",
    "location_label": "string",
    "longitude": "double",
    "override": "int16",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "timestamp": "timestamp[ns]",
    "zip": "string",
    "zip_full": "string"
}

schema_attributes:

{
    "city": "string",
    "country": "string",
    "is_address_real": "smallint",
    "latitude": "double",
    "location_id": "int",
    "location_label": "string",
    "longitude": "double",
    "override": "smallint",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "timestamp": "timestamp",
    "zip": "string",
    "zip_full": "string"
}

schema_name_id: 1232
schema_scan_id: 161996418
updated: 2026-04-14 00:32:38

Schema Scans: 15

Last at 2026-04-17 14:44:23

Scan 162194401

duration: 0:00:14.495669

exit_message:

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

id: 162194401

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_location/2026-04-17/1776455044",
        "key": "raw/sparefoot_location/2026-04-17/1776455044/location_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_location",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 18307024072484138904,
        "service_name": "sparefoot",
        "span_id": 15394576238178187643,
        "trace_id": 18307024072484138904
    }
}

running: False
schema_name_id: 1232
start_time: 2026-04-17 14:44:23
success: True
trace_id: 18307024072484138904

Scan 162178641

duration: 0:00:14.562234

exit_message:

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

id: 162178641

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_location/2026-04-17/1776436781",
        "key": "raw/sparefoot_location/2026-04-17/1776436781/location_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_location",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 8444784985458150759,
        "service_name": "sparefoot",
        "span_id": 10730777119903642758,
        "trace_id": 8444784985458150759
    }
}

running: False
schema_name_id: 1232
start_time: 2026-04-17 09:40:13
success: True
trace_id: 8444784985458150759

Scan 162163715

duration: 0:00:12.121246

exit_message:

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

id: 162163715

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_location/2026-04-17/1776403841",
        "key": "raw/sparefoot_location/2026-04-17/1776403841/location_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_location",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 9791506534904444128,
        "service_name": "sparefoot",
        "span_id": 11528581469478145802,
        "trace_id": 9791506534904444128
    }
}

running: False
schema_name_id: 1232
start_time: 2026-04-17 00:31:07
success: True
trace_id: 9791506534904444128

Scan 162156226

duration: 0:00:14.477260

exit_message:

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

id: 162156226

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_location/2026-04-16/1776389524",
        "key": "raw/sparefoot_location/2026-04-16/1776389524/location_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_location",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 824480232723706618,
        "service_name": "sparefoot",
        "span_id": 13978276395696315700,
        "trace_id": 824480232723706618
    }
}

running: False
schema_name_id: 1232
start_time: 2026-04-16 20:32:24
success: True
trace_id: 824480232723706618

Scan 162138818

duration: 0:00:14.547447

exit_message:

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

id: 162138818

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_location/2026-04-16/1776368789",
        "key": "raw/sparefoot_location/2026-04-16/1776368789/location_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_location",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 9540354150642665328,
        "service_name": "sparefoot",
        "span_id": 13111567726289507729,
        "trace_id": 9540354150642665328
    }
}

running: False
schema_name_id: 1232
start_time: 2026-04-16 14:47:29
success: True
trace_id: 9540354150642665328

Scan 162122926

duration: 0:00:11.979805

exit_message:

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

id: 162122926

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_location/2026-04-16/1776350676",
        "key": "raw/sparefoot_location/2026-04-16/1776350676/location_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_location",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 10659303917455371459,
        "service_name": "sparefoot",
        "span_id": 7595485535581320937,
        "trace_id": 10659303917455371459
    }
}

running: False
schema_name_id: 1232
start_time: 2026-04-16 09:45:12
success: True
trace_id: 10659303917455371459

Scan 162107892

duration: 0:00:11.861828

exit_message:

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

id: 162107892

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_location/2026-04-16/1776318350",
        "key": "raw/sparefoot_location/2026-04-16/1776318350/location_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_location",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 5538395734262393005,
        "service_name": "sparefoot",
        "span_id": 409390009940950754,
        "trace_id": 5538395734262393005
    }
}

running: False
schema_name_id: 1232
start_time: 2026-04-16 00:46:10
success: True
trace_id: 5538395734262393005

Scan 162100284

duration: 0:00:12.271975

exit_message:

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

id: 162100284

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_location/2026-04-15/1776302248",
        "key": "raw/sparefoot_location/2026-04-15/1776302248/location_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_location",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 2615892957740205882,
        "service_name": "sparefoot",
        "span_id": 276031479056798694,
        "trace_id": 2615892957740205882
    }
}

running: False
schema_name_id: 1232
start_time: 2026-04-15 20:18:09
success: True
trace_id: 2615892957740205882

Scan 162083056

duration: 0:00:12.274900

exit_message:

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

id: 162083056

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_location/2026-04-15/1776282555",
        "key": "raw/sparefoot_location/2026-04-15/1776282555/location_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_location",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 10059791706742916388,
        "service_name": "sparefoot",
        "span_id": 10066272988490385071,
        "trace_id": 10059791706742916388
    }
}

running: False
schema_name_id: 1232
start_time: 2026-04-15 14:49:45
success: True
trace_id: 10059791706742916388

Scan 162066098

duration: 0:00:20.727317

exit_message:

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

id: 162066098

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_location/2026-04-15/1776261532",
        "key": "raw/sparefoot_location/2026-04-15/1776261532/location_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_location",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 476980935128242786,
        "service_name": "sparefoot",
        "span_id": 14767191928524072356,
        "trace_id": 476980935128242786
    }
}

running: False
schema_name_id: 1232
start_time: 2026-04-15 09:02:29
success: True
trace_id: 476980935128242786

Scan 162052039

duration: 0:00:14.672154

exit_message:

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

id: 162052039

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_location/2026-04-15/1776231071",
        "key": "raw/sparefoot_location/2026-04-15/1776231071/location_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_location",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 8057636622978793015,
        "service_name": "sparefoot",
        "span_id": 17732480365804703151,
        "trace_id": 8057636622978793015
    }
}

running: False
schema_name_id: 1232
start_time: 2026-04-15 00:31:28
success: True
trace_id: 8057636622978793015

Scan 162044408

duration: 0:00:14.522430

exit_message:

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

id: 162044408

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_location/2026-04-14/1776217660",
        "key": "raw/sparefoot_location/2026-04-14/1776217660/location_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_location",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 16083643217243239613,
        "service_name": "sparefoot",
        "span_id": 7982546357923804709,
        "trace_id": 16083643217243239613
    }
}

running: False
schema_name_id: 1232
start_time: 2026-04-14 20:48:12
success: True
trace_id: 16083643217243239613

Scan 162026355

duration: 0:00:11.973769

exit_message:

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

id: 162026355

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_location/2026-04-14/1776195006",
        "key": "raw/sparefoot_location/2026-04-14/1776195006/location_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_location",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 4538120326649390071,
        "service_name": "sparefoot",
        "span_id": 5932988203518958155,
        "trace_id": 4538120326649390071
    }
}

running: False
schema_name_id: 1232
start_time: 2026-04-14 14:30:33
success: True
trace_id: 4538120326649390071

Scan 162011048

duration: 0:00:11.960823

exit_message:

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

id: 162011048

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_location/2026-04-14/1776176354",
        "key": "raw/sparefoot_location/2026-04-14/1776176354/location_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_location",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 17996577688642778271,
        "service_name": "sparefoot",
        "span_id": 536225654712620407,
        "trace_id": 17996577688642778271
    }
}

running: False
schema_name_id: 1232
start_time: 2026-04-14 09:19:31
success: True
trace_id: 17996577688642778271

Scan 161996418

duration: 0:00:14.542623

exit_message:

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

id: 161996418

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_location/2026-04-14/1776144706",
        "key": "raw/sparefoot_location/2026-04-14/1776144706/location_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_location",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 7634636869653043330,
        "service_name": "sparefoot",
        "span_id": 15748160734481873490,
        "trace_id": 7634636869653043330
    }
}

running: False
schema_name_id: 1232
start_time: 2026-04-14 00:32:24
success: True
trace_id: 7634636869653043330

Partitions:

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

Schema:

attributes:

{
    "city": "string",
    "country": "string",
    "is_address_real": "smallint",
    "latitude": "double",
    "location_id": "int",
    "location_label": "string",
    "longitude": "double",
    "override": "smallint",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "timestamp": "timestamp",
    "zip": "string",
    "zip_full": "string"
}

created: 2026-04-17 14:44:23

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_location`\n(\n `city`  string , `country`  string , `is_address_real`  smallint , `latitude`  double , `location_id`  int , `location_label`  string , `longitude`  double , `override`  smallint , `state`  string , `street_address_1`  string , `street_address_2`  string , `timestamp`  timestamp , `zip`  string , `zip_full`  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_location/2026-04-17/1776455044'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_location`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_location"
}

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-11-29 15:23:28",
        "disabled": false,
        "format": "raw",
        "id": 1232,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_prod_rds",
            "table": "sparefoot_sparefoot_location"
        },
        "type": "rds"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "city": "string",
            "country": "string",
            "is_address_real": "smallint",
            "latitude": "double",
            "location_id": "int",
            "location_label": "string",
            "longitude": "double",
            "override": "smallint",
            "state": "string",
            "street_address_1": "string",
            "street_address_2": "string",
            "timestamp": "timestamp",
            "zip": "string",
            "zip_full": "string"
        },
        "created": "2026-04-17 14:44:23",
        "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_location`\n(\n `city`  string , `country`  string , `is_address_real`  smallint , `latitude`  double , `location_id`  int , `location_label`  string , `longitude`  double , `override`  smallint , `state`  string , `street_address_1`  string , `street_address_2`  string , `timestamp`  timestamp , `zip`  string , `zip_full`  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_location/2026-04-17/1776455044'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_location`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_location"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}