Schema Info

Schema Name: sfdl_prod_rds.sparefoot_sparefoot_inventory

created: 2025-04-22 18:24:33
disabled: False
format: raw
id: 3514
is_partitioned: True
is_schema_datatyped: False

name:

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

type: rds

Schema Versions: 1

Version 1275695

created: 2025-04-22 18:24:33

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_inventory`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_inventory`\n(\n `available_units`  int , `climate_controlled`  smallint , `date_created`  timestamp , `dt_partition`  string , `inventory_id`  int , `length`  double , `listing_avail_id`  int , `total_units`  int , `width`  double \n)\nPARTITIONED BY (dt string)\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_incremental/sparefoot_inventory'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_inventory"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory
id: 1275695
processed: 1

raw_data:

{
    "available_units": "int32",
    "climate_controlled": "int16",
    "date_created": "timestamp[ns]",
    "dt_partition": "null",
    "inventory_id": "int32",
    "length": "double",
    "listing_avail_id": "int32",
    "total_units": "int32",
    "width": "double"
}

schema_attributes:

{
    "available_units": "int",
    "climate_controlled": "smallint",
    "date_created": "timestamp",
    "dt_partition": "string",
    "inventory_id": "int",
    "length": "double",
    "listing_avail_id": "int",
    "total_units": "int",
    "width": "double"
}

schema_name_id: 3514
schema_scan_id: 140980960
updated: 2025-04-22 18:25:00

Schema Scans: 1

Last at 2025-04-22 18:24:33

Scan 140980960

duration: 0:00:36.312970

exit_message:

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

id: 140980960

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "partition": {
        "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2025-04-22",
        "name": "dt",
        "type": "string",
        "value": "2025-04-22"
    },
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory",
        "key": "raw_incremental/sparefoot_inventory/dt=2025-04-22/inventory.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_inventory",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 4676743217954237860,
        "service_name": "sparefoot",
        "span_id": 1914820250840135410,
        "trace_id": 4676743217954237860
    }
}

running: False
schema_name_id: 3514
start_time: 2025-04-22 18:24:33
success: True
trace_id: 4676743217954237860

Partitions:

count: 88

ddl:

[
    "ALTER TABLE\n    `sfdl_prod_rds.sparefoot_sparefoot_inventory`\nADD\n\n\n PARTITION (dt='2014-01-09') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2014-01-09/'\n PARTITION (dt='2014-01-10') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2014-01-10/'\n PARTITION (dt='2014-03-17') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2014-03-17/'\n PARTITION (dt='2014-03-18') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2014-03-18/'\n PARTITION (dt='2014-04-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2014-04-01/'\n PARTITION (dt='2014-05-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2014-05-01/'\n PARTITION (dt='2014-06-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2014-06-01/'\n PARTITION (dt='2014-07-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2014-07-01/'\n PARTITION (dt='2014-08-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2014-08-01/'\n PARTITION (dt='2014-09-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2014-09-01/'\n PARTITION (dt='2014-10-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2014-10-01/'\n PARTITION (dt='2014-11-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2014-11-01/'\n PARTITION (dt='2014-12-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2014-12-01/'\n PARTITION (dt='2015-01-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2015-01-01/'\n PARTITION (dt='2015-02-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2015-02-01/'\n PARTITION (dt='2015-03-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2015-03-01/'\n PARTITION (dt='2015-04-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2015-04-01/'\n PARTITION (dt='2015-05-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2015-05-01/'\n PARTITION (dt='2015-06-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2015-06-01/'\n PARTITION (dt='2015-07-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2015-07-01/'\n PARTITION (dt='2015-08-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2015-08-01/'\n PARTITION (dt='2015-09-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2015-09-01/'\n PARTITION (dt='2015-10-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2015-10-01/'\n PARTITION (dt='2015-11-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2015-11-01/'\n PARTITION (dt='2015-12-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2015-12-01/'\n PARTITION (dt='2016-01-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2016-01-01/'\n PARTITION (dt='2016-02-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2016-02-01/'\n PARTITION (dt='2016-02-09') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2016-02-09/'\n PARTITION (dt='2016-03-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2016-03-01/'\n PARTITION (dt='2016-04-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2016-04-01/'\n PARTITION (dt='2016-05-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2016-05-01/'\n PARTITION (dt='2016-06-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2016-06-01/'\n PARTITION (dt='2016-07-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2016-07-01/'\n PARTITION (dt='2016-08-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2016-08-01/'\n PARTITION (dt='2016-09-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2016-09-01/'\n PARTITION (dt='2016-10-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2016-10-01/'\n PARTITION (dt='2016-11-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2016-11-01/'\n PARTITION (dt='2016-12-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2016-12-01/'\n PARTITION (dt='2017-01-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2017-01-01/'\n PARTITION (dt='2017-02-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2017-02-01/'\n PARTITION (dt='2017-03-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2017-03-01/'\n PARTITION (dt='2017-04-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2017-04-01/'\n PARTITION (dt='2017-05-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2017-05-01/'\n PARTITION (dt='2017-06-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2017-06-01/'\n PARTITION (dt='2017-07-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2017-07-01/'\n PARTITION (dt='2017-08-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2017-08-01/'\n PARTITION (dt='2017-09-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2017-09-01/'\n PARTITION (dt='2017-10-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2017-10-01/'\n PARTITION (dt='2017-11-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2017-11-01/'\n PARTITION (dt='2017-12-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2017-12-01/'\n PARTITION (dt='2018-01-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2018-01-01/'\n PARTITION (dt='2018-02-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2018-02-01/'\n PARTITION (dt='2018-03-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2018-03-01/'\n PARTITION (dt='2018-04-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2018-04-01/'\n PARTITION (dt='2018-05-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2018-05-01/'\n PARTITION (dt='2018-06-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2018-06-01/'\n PARTITION (dt='2018-07-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2018-07-01/'\n PARTITION (dt='2018-08-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2018-08-01/'\n PARTITION (dt='2018-09-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2018-09-01/'\n PARTITION (dt='2018-10-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2018-10-01/'\n PARTITION (dt='2018-10-03') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2018-10-03/'\n PARTITION (dt='2018-11-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2018-11-01/'\n PARTITION (dt='2018-12-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2018-12-01/'\n PARTITION (dt='2019-01-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2019-01-01/'\n PARTITION (dt='2019-02-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2019-02-01/'\n PARTITION (dt='2019-03-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2019-03-01/'\n PARTITION (dt='2019-04-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2019-04-01/'\n PARTITION (dt='2019-05-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2019-05-01/'\n PARTITION (dt='2019-06-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2019-06-01/'\n PARTITION (dt='2019-07-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2019-07-01/'\n PARTITION (dt='2019-08-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2019-08-01/'\n PARTITION (dt='2019-09-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2019-09-01/'\n PARTITION (dt='2019-10-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2019-10-01/'\n PARTITION (dt='2019-11-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2019-11-01/'\n PARTITION (dt='2019-12-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2019-12-01/'\n PARTITION (dt='2020-01-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2020-01-01/'\n PARTITION (dt='2020-02-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2020-02-01/'\n PARTITION (dt='2020-03-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2020-03-01/'\n PARTITION (dt='2020-04-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2020-04-01/'\n PARTITION (dt='2020-05-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2020-05-01/'\n PARTITION (dt='2020-06-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2020-06-01/'\n PARTITION (dt='2020-07-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2020-07-01/'\n PARTITION (dt='2020-08-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2020-08-01/'\n PARTITION (dt='2020-09-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2020-09-01/'\n PARTITION (dt='2020-10-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2020-10-01/'\n PARTITION (dt='2020-11-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2020-11-01/'\n PARTITION (dt='2020-11-02') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2020-11-02/'\n PARTITION (dt='2025-04-22') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2025-04-22/'\n;"
]

name: dt

state:

[
    {
        "info": {
            "id": 1490280,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2014-01-09/",
            "name": "dt",
            "value": "2014-01-09"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:07",
                "last_data": "2025-04-22 18:25:07"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490243,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2014-01-10/",
            "name": "dt",
            "value": "2014-01-10"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:04",
                "last_data": "2025-04-22 18:25:04"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490275,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2014-03-17/",
            "name": "dt",
            "value": "2014-03-17"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:07",
                "last_data": "2025-04-22 18:25:07"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490235,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2014-03-18/",
            "name": "dt",
            "value": "2014-03-18"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:04",
                "last_data": "2025-04-22 18:25:04"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490304,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2014-04-01/",
            "name": "dt",
            "value": "2014-04-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:09",
                "last_data": "2025-04-22 18:25:09"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490260,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2014-05-01/",
            "name": "dt",
            "value": "2014-05-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:06",
                "last_data": "2025-04-22 18:25:06"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490294,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2014-06-01/",
            "name": "dt",
            "value": "2014-06-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:08",
                "last_data": "2025-04-22 18:25:08"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490262,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2014-07-01/",
            "name": "dt",
            "value": "2014-07-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:06",
                "last_data": "2025-04-22 18:25:06"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490227,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2014-08-01/",
            "name": "dt",
            "value": "2014-08-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:03",
                "last_data": "2025-04-22 18:25:03"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490236,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2014-09-01/",
            "name": "dt",
            "value": "2014-09-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:04",
                "last_data": "2025-04-22 18:25:04"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490288,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2014-10-01/",
            "name": "dt",
            "value": "2014-10-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:08",
                "last_data": "2025-04-22 18:25:08"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490242,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2014-11-01/",
            "name": "dt",
            "value": "2014-11-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:04",
                "last_data": "2025-04-22 18:25:04"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490221,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2014-12-01/",
            "name": "dt",
            "value": "2014-12-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:03",
                "last_data": "2025-04-22 18:25:03"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490233,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2015-01-01/",
            "name": "dt",
            "value": "2015-01-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:04",
                "last_data": "2025-04-22 18:25:04"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490300,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2015-02-01/",
            "name": "dt",
            "value": "2015-02-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:09",
                "last_data": "2025-04-22 18:25:09"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490273,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2015-03-01/",
            "name": "dt",
            "value": "2015-03-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:07",
                "last_data": "2025-04-22 18:25:07"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490264,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2015-04-01/",
            "name": "dt",
            "value": "2015-04-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:06",
                "last_data": "2025-04-22 18:25:06"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490256,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2015-05-01/",
            "name": "dt",
            "value": "2015-05-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:05",
                "last_data": "2025-04-22 18:25:05"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490269,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2015-06-01/",
            "name": "dt",
            "value": "2015-06-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:06",
                "last_data": "2025-04-22 18:25:06"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490302,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2015-07-01/",
            "name": "dt",
            "value": "2015-07-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:09",
                "last_data": "2025-04-22 18:25:09"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490286,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2015-08-01/",
            "name": "dt",
            "value": "2015-08-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:08",
                "last_data": "2025-04-22 18:25:08"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490295,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2015-09-01/",
            "name": "dt",
            "value": "2015-09-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:08",
                "last_data": "2025-04-22 18:25:08"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490305,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2015-10-01/",
            "name": "dt",
            "value": "2015-10-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:09",
                "last_data": "2025-04-22 18:25:09"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490270,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2015-11-01/",
            "name": "dt",
            "value": "2015-11-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:07",
                "last_data": "2025-04-22 18:25:07"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490225,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2015-12-01/",
            "name": "dt",
            "value": "2015-12-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:03",
                "last_data": "2025-04-22 18:25:03"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490271,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2016-01-01/",
            "name": "dt",
            "value": "2016-01-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:07",
                "last_data": "2025-04-22 18:25:07"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490258,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2016-02-01/",
            "name": "dt",
            "value": "2016-02-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:06",
                "last_data": "2025-04-22 18:25:06"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490251,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2016-02-09/",
            "name": "dt",
            "value": "2016-02-09"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:05",
                "last_data": "2025-04-22 18:25:05"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490277,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2016-03-01/",
            "name": "dt",
            "value": "2016-03-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:07",
                "last_data": "2025-04-22 18:25:07"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490248,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2016-04-01/",
            "name": "dt",
            "value": "2016-04-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:05",
                "last_data": "2025-04-22 18:25:05"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490268,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2016-05-01/",
            "name": "dt",
            "value": "2016-05-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:06",
                "last_data": "2025-04-22 18:25:06"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490222,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2016-06-01/",
            "name": "dt",
            "value": "2016-06-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:03",
                "last_data": "2025-04-22 18:25:03"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490220,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2016-07-01/",
            "name": "dt",
            "value": "2016-07-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:03",
                "last_data": "2025-04-22 18:25:03"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490245,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2016-08-01/",
            "name": "dt",
            "value": "2016-08-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:05",
                "last_data": "2025-04-22 18:25:05"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490253,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2016-09-01/",
            "name": "dt",
            "value": "2016-09-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:05",
                "last_data": "2025-04-22 18:25:05"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490299,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2016-10-01/",
            "name": "dt",
            "value": "2016-10-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:09",
                "last_data": "2025-04-22 18:25:09"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490292,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2016-11-01/",
            "name": "dt",
            "value": "2016-11-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:08",
                "last_data": "2025-04-22 18:25:08"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490230,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2016-12-01/",
            "name": "dt",
            "value": "2016-12-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:04",
                "last_data": "2025-04-22 18:25:04"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490272,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2017-01-01/",
            "name": "dt",
            "value": "2017-01-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:07",
                "last_data": "2025-04-22 18:25:07"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490246,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2017-02-01/",
            "name": "dt",
            "value": "2017-02-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:05",
                "last_data": "2025-04-22 18:25:05"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490247,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2017-03-01/",
            "name": "dt",
            "value": "2017-03-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:05",
                "last_data": "2025-04-22 18:25:05"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490285,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2017-04-01/",
            "name": "dt",
            "value": "2017-04-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:08",
                "last_data": "2025-04-22 18:25:08"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490296,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2017-05-01/",
            "name": "dt",
            "value": "2017-05-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:08",
                "last_data": "2025-04-22 18:25:08"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490250,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2017-06-01/",
            "name": "dt",
            "value": "2017-06-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:05",
                "last_data": "2025-04-22 18:25:05"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490265,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2017-07-01/",
            "name": "dt",
            "value": "2017-07-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:06",
                "last_data": "2025-04-22 18:25:06"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490291,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2017-08-01/",
            "name": "dt",
            "value": "2017-08-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:08",
                "last_data": "2025-04-22 18:25:08"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490266,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2017-09-01/",
            "name": "dt",
            "value": "2017-09-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:06",
                "last_data": "2025-04-22 18:25:06"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490254,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2017-10-01/",
            "name": "dt",
            "value": "2017-10-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:05",
                "last_data": "2025-04-22 18:25:05"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490223,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2017-11-01/",
            "name": "dt",
            "value": "2017-11-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:03",
                "last_data": "2025-04-22 18:25:03"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490281,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2017-12-01/",
            "name": "dt",
            "value": "2017-12-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:07",
                "last_data": "2025-04-22 18:25:07"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490228,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2018-01-01/",
            "name": "dt",
            "value": "2018-01-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:03",
                "last_data": "2025-04-22 18:25:03"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490259,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2018-02-01/",
            "name": "dt",
            "value": "2018-02-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:06",
                "last_data": "2025-04-22 18:25:06"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490301,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2018-03-01/",
            "name": "dt",
            "value": "2018-03-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:09",
                "last_data": "2025-04-22 18:25:09"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490244,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2018-04-01/",
            "name": "dt",
            "value": "2018-04-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:05",
                "last_data": "2025-04-22 18:25:05"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490282,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2018-05-01/",
            "name": "dt",
            "value": "2018-05-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:07",
                "last_data": "2025-04-22 18:25:07"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490284,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2018-06-01/",
            "name": "dt",
            "value": "2018-06-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:08",
                "last_data": "2025-04-22 18:25:08"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490234,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2018-07-01/",
            "name": "dt",
            "value": "2018-07-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:04",
                "last_data": "2025-04-22 18:25:04"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490224,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2018-08-01/",
            "name": "dt",
            "value": "2018-08-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:03",
                "last_data": "2025-04-22 18:25:03"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490263,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2018-09-01/",
            "name": "dt",
            "value": "2018-09-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:06",
                "last_data": "2025-04-22 18:25:06"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490231,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2018-10-01/",
            "name": "dt",
            "value": "2018-10-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:04",
                "last_data": "2025-04-22 18:25:04"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490276,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2018-10-03/",
            "name": "dt",
            "value": "2018-10-03"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:07",
                "last_data": "2025-04-22 18:25:07"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490279,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2018-11-01/",
            "name": "dt",
            "value": "2018-11-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:07",
                "last_data": "2025-04-22 18:25:07"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490293,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2018-12-01/",
            "name": "dt",
            "value": "2018-12-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:08",
                "last_data": "2025-04-22 18:25:08"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490226,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2019-01-01/",
            "name": "dt",
            "value": "2019-01-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:03",
                "last_data": "2025-04-22 18:25:03"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490289,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2019-02-01/",
            "name": "dt",
            "value": "2019-02-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:08",
                "last_data": "2025-04-22 18:25:08"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490283,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2019-03-01/",
            "name": "dt",
            "value": "2019-03-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:08",
                "last_data": "2025-04-22 18:25:08"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490237,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2019-04-01/",
            "name": "dt",
            "value": "2019-04-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:04",
                "last_data": "2025-04-22 18:25:04"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490290,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2019-05-01/",
            "name": "dt",
            "value": "2019-05-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:08",
                "last_data": "2025-04-22 18:25:08"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490274,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2019-06-01/",
            "name": "dt",
            "value": "2019-06-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:07",
                "last_data": "2025-04-22 18:25:07"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490298,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2019-07-01/",
            "name": "dt",
            "value": "2019-07-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:09",
                "last_data": "2025-04-22 18:25:09"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490249,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2019-08-01/",
            "name": "dt",
            "value": "2019-08-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:05",
                "last_data": "2025-04-22 18:25:05"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490278,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2019-09-01/",
            "name": "dt",
            "value": "2019-09-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:07",
                "last_data": "2025-04-22 18:25:07"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490238,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2019-10-01/",
            "name": "dt",
            "value": "2019-10-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:04",
                "last_data": "2025-04-22 18:25:04"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490297,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2019-11-01/",
            "name": "dt",
            "value": "2019-11-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:09",
                "last_data": "2025-04-22 18:25:09"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490239,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2019-12-01/",
            "name": "dt",
            "value": "2019-12-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:04",
                "last_data": "2025-04-22 18:25:04"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490240,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2020-01-01/",
            "name": "dt",
            "value": "2020-01-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:04",
                "last_data": "2025-04-22 18:25:04"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490252,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2020-02-01/",
            "name": "dt",
            "value": "2020-02-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:05",
                "last_data": "2025-04-22 18:25:05"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490255,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2020-03-01/",
            "name": "dt",
            "value": "2020-03-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:05",
                "last_data": "2025-04-22 18:25:05"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490303,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2020-04-01/",
            "name": "dt",
            "value": "2020-04-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:09",
                "last_data": "2025-04-22 18:25:09"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490232,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2020-05-01/",
            "name": "dt",
            "value": "2020-05-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:04",
                "last_data": "2025-04-22 18:25:04"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490257,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2020-06-01/",
            "name": "dt",
            "value": "2020-06-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:06",
                "last_data": "2025-04-22 18:25:06"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490219,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2020-07-01/",
            "name": "dt",
            "value": "2020-07-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:03",
                "last_data": "2025-04-22 18:25:03"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490241,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2020-08-01/",
            "name": "dt",
            "value": "2020-08-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:04",
                "last_data": "2025-04-22 18:25:04"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490287,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2020-09-01/",
            "name": "dt",
            "value": "2020-09-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:08",
                "last_data": "2025-04-22 18:25:08"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490267,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2020-10-01/",
            "name": "dt",
            "value": "2020-10-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:06",
                "last_data": "2025-04-22 18:25:06"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490261,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2020-11-01/",
            "name": "dt",
            "value": "2020-11-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:06",
                "last_data": "2025-04-22 18:25:06"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490229,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2020-11-02/",
            "name": "dt",
            "value": "2020-11-02"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:25:03",
                "last_data": "2025-04-22 18:25:03"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1490218,
            "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2025-04-22/",
            "name": "dt",
            "value": "2025-04-22"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-22 18:24:34",
                "last_data": "2025-04-22 18:24:34"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    }
]

type: string

Schema:

attributes:

{
    "available_units": "int",
    "climate_controlled": "smallint",
    "date_created": "timestamp",
    "dt_partition": "string",
    "inventory_id": "int",
    "length": "double",
    "listing_avail_id": "int",
    "total_units": "int",
    "width": "double"
}

created: 2025-04-22 18:24: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_inventory`\n(\n `available_units`  int , `climate_controlled`  smallint , `date_created`  timestamp , `dt_partition`  string , `inventory_id`  int , `length`  double , `listing_avail_id`  int , `total_units`  int , `width`  double \n)\nPARTITIONED BY (dt string)\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_incremental/sparefoot_inventory'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_inventory`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_inventory"
}

Server:

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

Raw:

{
    "name": {
        "created": "2025-04-22 18:24:33",
        "disabled": false,
        "format": "raw",
        "id": 3514,
        "is_partitioned": true,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_prod_rds",
            "table": "sparefoot_sparefoot_inventory"
        },
        "type": "rds"
    },
    "partition": {
        "count": 88,
        "ddl": [
            "ALTER TABLE\n    `sfdl_prod_rds.sparefoot_sparefoot_inventory`\nADD\n\n\n PARTITION (dt='2014-01-09') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2014-01-09/'\n PARTITION (dt='2014-01-10') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2014-01-10/'\n PARTITION (dt='2014-03-17') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2014-03-17/'\n PARTITION (dt='2014-03-18') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2014-03-18/'\n PARTITION (dt='2014-04-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2014-04-01/'\n PARTITION (dt='2014-05-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2014-05-01/'\n PARTITION (dt='2014-06-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2014-06-01/'\n PARTITION (dt='2014-07-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2014-07-01/'\n PARTITION (dt='2014-08-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2014-08-01/'\n PARTITION (dt='2014-09-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2014-09-01/'\n PARTITION (dt='2014-10-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2014-10-01/'\n PARTITION (dt='2014-11-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2014-11-01/'\n PARTITION (dt='2014-12-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2014-12-01/'\n PARTITION (dt='2015-01-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2015-01-01/'\n PARTITION (dt='2015-02-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2015-02-01/'\n PARTITION (dt='2015-03-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2015-03-01/'\n PARTITION (dt='2015-04-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2015-04-01/'\n PARTITION (dt='2015-05-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2015-05-01/'\n PARTITION (dt='2015-06-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2015-06-01/'\n PARTITION (dt='2015-07-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2015-07-01/'\n PARTITION (dt='2015-08-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2015-08-01/'\n PARTITION (dt='2015-09-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2015-09-01/'\n PARTITION (dt='2015-10-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2015-10-01/'\n PARTITION (dt='2015-11-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2015-11-01/'\n PARTITION (dt='2015-12-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2015-12-01/'\n PARTITION (dt='2016-01-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2016-01-01/'\n PARTITION (dt='2016-02-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2016-02-01/'\n PARTITION (dt='2016-02-09') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2016-02-09/'\n PARTITION (dt='2016-03-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2016-03-01/'\n PARTITION (dt='2016-04-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2016-04-01/'\n PARTITION (dt='2016-05-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2016-05-01/'\n PARTITION (dt='2016-06-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2016-06-01/'\n PARTITION (dt='2016-07-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2016-07-01/'\n PARTITION (dt='2016-08-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2016-08-01/'\n PARTITION (dt='2016-09-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2016-09-01/'\n PARTITION (dt='2016-10-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2016-10-01/'\n PARTITION (dt='2016-11-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2016-11-01/'\n PARTITION (dt='2016-12-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2016-12-01/'\n PARTITION (dt='2017-01-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2017-01-01/'\n PARTITION (dt='2017-02-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2017-02-01/'\n PARTITION (dt='2017-03-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2017-03-01/'\n PARTITION (dt='2017-04-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2017-04-01/'\n PARTITION (dt='2017-05-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2017-05-01/'\n PARTITION (dt='2017-06-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2017-06-01/'\n PARTITION (dt='2017-07-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2017-07-01/'\n PARTITION (dt='2017-08-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2017-08-01/'\n PARTITION (dt='2017-09-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2017-09-01/'\n PARTITION (dt='2017-10-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2017-10-01/'\n PARTITION (dt='2017-11-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2017-11-01/'\n PARTITION (dt='2017-12-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2017-12-01/'\n PARTITION (dt='2018-01-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2018-01-01/'\n PARTITION (dt='2018-02-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2018-02-01/'\n PARTITION (dt='2018-03-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2018-03-01/'\n PARTITION (dt='2018-04-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2018-04-01/'\n PARTITION (dt='2018-05-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2018-05-01/'\n PARTITION (dt='2018-06-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2018-06-01/'\n PARTITION (dt='2018-07-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2018-07-01/'\n PARTITION (dt='2018-08-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2018-08-01/'\n PARTITION (dt='2018-09-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2018-09-01/'\n PARTITION (dt='2018-10-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2018-10-01/'\n PARTITION (dt='2018-10-03') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2018-10-03/'\n PARTITION (dt='2018-11-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2018-11-01/'\n PARTITION (dt='2018-12-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2018-12-01/'\n PARTITION (dt='2019-01-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2019-01-01/'\n PARTITION (dt='2019-02-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2019-02-01/'\n PARTITION (dt='2019-03-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2019-03-01/'\n PARTITION (dt='2019-04-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2019-04-01/'\n PARTITION (dt='2019-05-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2019-05-01/'\n PARTITION (dt='2019-06-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2019-06-01/'\n PARTITION (dt='2019-07-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2019-07-01/'\n PARTITION (dt='2019-08-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2019-08-01/'\n PARTITION (dt='2019-09-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2019-09-01/'\n PARTITION (dt='2019-10-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2019-10-01/'\n PARTITION (dt='2019-11-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2019-11-01/'\n PARTITION (dt='2019-12-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2019-12-01/'\n PARTITION (dt='2020-01-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2020-01-01/'\n PARTITION (dt='2020-02-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2020-02-01/'\n PARTITION (dt='2020-03-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2020-03-01/'\n PARTITION (dt='2020-04-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2020-04-01/'\n PARTITION (dt='2020-05-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2020-05-01/'\n PARTITION (dt='2020-06-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2020-06-01/'\n PARTITION (dt='2020-07-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2020-07-01/'\n PARTITION (dt='2020-08-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2020-08-01/'\n PARTITION (dt='2020-09-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2020-09-01/'\n PARTITION (dt='2020-10-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2020-10-01/'\n PARTITION (dt='2020-11-01') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2020-11-01/'\n PARTITION (dt='2020-11-02') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2020-11-02/'\n PARTITION (dt='2025-04-22') location 's3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2025-04-22/'\n;"
        ],
        "name": "dt",
        "state": [
            {
                "info": {
                    "id": 1490280,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2014-01-09/",
                    "name": "dt",
                    "value": "2014-01-09"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:07",
                        "last_data": "2025-04-22 18:25:07"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490243,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2014-01-10/",
                    "name": "dt",
                    "value": "2014-01-10"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:04",
                        "last_data": "2025-04-22 18:25:04"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490275,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2014-03-17/",
                    "name": "dt",
                    "value": "2014-03-17"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:07",
                        "last_data": "2025-04-22 18:25:07"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490235,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2014-03-18/",
                    "name": "dt",
                    "value": "2014-03-18"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:04",
                        "last_data": "2025-04-22 18:25:04"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490304,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2014-04-01/",
                    "name": "dt",
                    "value": "2014-04-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:09",
                        "last_data": "2025-04-22 18:25:09"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490260,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2014-05-01/",
                    "name": "dt",
                    "value": "2014-05-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:06",
                        "last_data": "2025-04-22 18:25:06"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490294,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2014-06-01/",
                    "name": "dt",
                    "value": "2014-06-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:08",
                        "last_data": "2025-04-22 18:25:08"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490262,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2014-07-01/",
                    "name": "dt",
                    "value": "2014-07-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:06",
                        "last_data": "2025-04-22 18:25:06"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490227,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2014-08-01/",
                    "name": "dt",
                    "value": "2014-08-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:03",
                        "last_data": "2025-04-22 18:25:03"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490236,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2014-09-01/",
                    "name": "dt",
                    "value": "2014-09-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:04",
                        "last_data": "2025-04-22 18:25:04"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490288,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2014-10-01/",
                    "name": "dt",
                    "value": "2014-10-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:08",
                        "last_data": "2025-04-22 18:25:08"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490242,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2014-11-01/",
                    "name": "dt",
                    "value": "2014-11-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:04",
                        "last_data": "2025-04-22 18:25:04"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490221,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2014-12-01/",
                    "name": "dt",
                    "value": "2014-12-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:03",
                        "last_data": "2025-04-22 18:25:03"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490233,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2015-01-01/",
                    "name": "dt",
                    "value": "2015-01-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:04",
                        "last_data": "2025-04-22 18:25:04"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490300,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2015-02-01/",
                    "name": "dt",
                    "value": "2015-02-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:09",
                        "last_data": "2025-04-22 18:25:09"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490273,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2015-03-01/",
                    "name": "dt",
                    "value": "2015-03-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:07",
                        "last_data": "2025-04-22 18:25:07"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490264,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2015-04-01/",
                    "name": "dt",
                    "value": "2015-04-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:06",
                        "last_data": "2025-04-22 18:25:06"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490256,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2015-05-01/",
                    "name": "dt",
                    "value": "2015-05-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:05",
                        "last_data": "2025-04-22 18:25:05"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490269,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2015-06-01/",
                    "name": "dt",
                    "value": "2015-06-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:06",
                        "last_data": "2025-04-22 18:25:06"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490302,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2015-07-01/",
                    "name": "dt",
                    "value": "2015-07-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:09",
                        "last_data": "2025-04-22 18:25:09"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490286,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2015-08-01/",
                    "name": "dt",
                    "value": "2015-08-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:08",
                        "last_data": "2025-04-22 18:25:08"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490295,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2015-09-01/",
                    "name": "dt",
                    "value": "2015-09-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:08",
                        "last_data": "2025-04-22 18:25:08"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490305,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2015-10-01/",
                    "name": "dt",
                    "value": "2015-10-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:09",
                        "last_data": "2025-04-22 18:25:09"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490270,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2015-11-01/",
                    "name": "dt",
                    "value": "2015-11-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:07",
                        "last_data": "2025-04-22 18:25:07"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490225,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2015-12-01/",
                    "name": "dt",
                    "value": "2015-12-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:03",
                        "last_data": "2025-04-22 18:25:03"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490271,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2016-01-01/",
                    "name": "dt",
                    "value": "2016-01-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:07",
                        "last_data": "2025-04-22 18:25:07"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490258,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2016-02-01/",
                    "name": "dt",
                    "value": "2016-02-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:06",
                        "last_data": "2025-04-22 18:25:06"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490251,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2016-02-09/",
                    "name": "dt",
                    "value": "2016-02-09"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:05",
                        "last_data": "2025-04-22 18:25:05"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490277,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2016-03-01/",
                    "name": "dt",
                    "value": "2016-03-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:07",
                        "last_data": "2025-04-22 18:25:07"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490248,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2016-04-01/",
                    "name": "dt",
                    "value": "2016-04-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:05",
                        "last_data": "2025-04-22 18:25:05"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490268,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2016-05-01/",
                    "name": "dt",
                    "value": "2016-05-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:06",
                        "last_data": "2025-04-22 18:25:06"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490222,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2016-06-01/",
                    "name": "dt",
                    "value": "2016-06-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:03",
                        "last_data": "2025-04-22 18:25:03"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490220,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2016-07-01/",
                    "name": "dt",
                    "value": "2016-07-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:03",
                        "last_data": "2025-04-22 18:25:03"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490245,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2016-08-01/",
                    "name": "dt",
                    "value": "2016-08-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:05",
                        "last_data": "2025-04-22 18:25:05"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490253,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2016-09-01/",
                    "name": "dt",
                    "value": "2016-09-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:05",
                        "last_data": "2025-04-22 18:25:05"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490299,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2016-10-01/",
                    "name": "dt",
                    "value": "2016-10-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:09",
                        "last_data": "2025-04-22 18:25:09"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490292,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2016-11-01/",
                    "name": "dt",
                    "value": "2016-11-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:08",
                        "last_data": "2025-04-22 18:25:08"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490230,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2016-12-01/",
                    "name": "dt",
                    "value": "2016-12-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:04",
                        "last_data": "2025-04-22 18:25:04"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490272,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2017-01-01/",
                    "name": "dt",
                    "value": "2017-01-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:07",
                        "last_data": "2025-04-22 18:25:07"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490246,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2017-02-01/",
                    "name": "dt",
                    "value": "2017-02-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:05",
                        "last_data": "2025-04-22 18:25:05"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490247,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2017-03-01/",
                    "name": "dt",
                    "value": "2017-03-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:05",
                        "last_data": "2025-04-22 18:25:05"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490285,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2017-04-01/",
                    "name": "dt",
                    "value": "2017-04-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:08",
                        "last_data": "2025-04-22 18:25:08"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490296,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2017-05-01/",
                    "name": "dt",
                    "value": "2017-05-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:08",
                        "last_data": "2025-04-22 18:25:08"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490250,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2017-06-01/",
                    "name": "dt",
                    "value": "2017-06-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:05",
                        "last_data": "2025-04-22 18:25:05"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490265,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2017-07-01/",
                    "name": "dt",
                    "value": "2017-07-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:06",
                        "last_data": "2025-04-22 18:25:06"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490291,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2017-08-01/",
                    "name": "dt",
                    "value": "2017-08-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:08",
                        "last_data": "2025-04-22 18:25:08"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490266,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2017-09-01/",
                    "name": "dt",
                    "value": "2017-09-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:06",
                        "last_data": "2025-04-22 18:25:06"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490254,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2017-10-01/",
                    "name": "dt",
                    "value": "2017-10-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:05",
                        "last_data": "2025-04-22 18:25:05"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490223,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2017-11-01/",
                    "name": "dt",
                    "value": "2017-11-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:03",
                        "last_data": "2025-04-22 18:25:03"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490281,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2017-12-01/",
                    "name": "dt",
                    "value": "2017-12-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:07",
                        "last_data": "2025-04-22 18:25:07"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490228,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2018-01-01/",
                    "name": "dt",
                    "value": "2018-01-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:03",
                        "last_data": "2025-04-22 18:25:03"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490259,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2018-02-01/",
                    "name": "dt",
                    "value": "2018-02-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:06",
                        "last_data": "2025-04-22 18:25:06"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490301,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2018-03-01/",
                    "name": "dt",
                    "value": "2018-03-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:09",
                        "last_data": "2025-04-22 18:25:09"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490244,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2018-04-01/",
                    "name": "dt",
                    "value": "2018-04-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:05",
                        "last_data": "2025-04-22 18:25:05"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490282,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2018-05-01/",
                    "name": "dt",
                    "value": "2018-05-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:07",
                        "last_data": "2025-04-22 18:25:07"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490284,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2018-06-01/",
                    "name": "dt",
                    "value": "2018-06-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:08",
                        "last_data": "2025-04-22 18:25:08"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490234,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2018-07-01/",
                    "name": "dt",
                    "value": "2018-07-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:04",
                        "last_data": "2025-04-22 18:25:04"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490224,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2018-08-01/",
                    "name": "dt",
                    "value": "2018-08-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:03",
                        "last_data": "2025-04-22 18:25:03"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490263,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2018-09-01/",
                    "name": "dt",
                    "value": "2018-09-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:06",
                        "last_data": "2025-04-22 18:25:06"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490231,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2018-10-01/",
                    "name": "dt",
                    "value": "2018-10-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:04",
                        "last_data": "2025-04-22 18:25:04"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490276,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2018-10-03/",
                    "name": "dt",
                    "value": "2018-10-03"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:07",
                        "last_data": "2025-04-22 18:25:07"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490279,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2018-11-01/",
                    "name": "dt",
                    "value": "2018-11-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:07",
                        "last_data": "2025-04-22 18:25:07"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490293,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2018-12-01/",
                    "name": "dt",
                    "value": "2018-12-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:08",
                        "last_data": "2025-04-22 18:25:08"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490226,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2019-01-01/",
                    "name": "dt",
                    "value": "2019-01-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:03",
                        "last_data": "2025-04-22 18:25:03"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490289,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2019-02-01/",
                    "name": "dt",
                    "value": "2019-02-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:08",
                        "last_data": "2025-04-22 18:25:08"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490283,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2019-03-01/",
                    "name": "dt",
                    "value": "2019-03-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:08",
                        "last_data": "2025-04-22 18:25:08"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490237,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2019-04-01/",
                    "name": "dt",
                    "value": "2019-04-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:04",
                        "last_data": "2025-04-22 18:25:04"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490290,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2019-05-01/",
                    "name": "dt",
                    "value": "2019-05-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:08",
                        "last_data": "2025-04-22 18:25:08"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490274,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2019-06-01/",
                    "name": "dt",
                    "value": "2019-06-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:07",
                        "last_data": "2025-04-22 18:25:07"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490298,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2019-07-01/",
                    "name": "dt",
                    "value": "2019-07-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:09",
                        "last_data": "2025-04-22 18:25:09"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490249,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2019-08-01/",
                    "name": "dt",
                    "value": "2019-08-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:05",
                        "last_data": "2025-04-22 18:25:05"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490278,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2019-09-01/",
                    "name": "dt",
                    "value": "2019-09-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:07",
                        "last_data": "2025-04-22 18:25:07"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490238,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2019-10-01/",
                    "name": "dt",
                    "value": "2019-10-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:04",
                        "last_data": "2025-04-22 18:25:04"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490297,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2019-11-01/",
                    "name": "dt",
                    "value": "2019-11-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:09",
                        "last_data": "2025-04-22 18:25:09"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490239,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2019-12-01/",
                    "name": "dt",
                    "value": "2019-12-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:04",
                        "last_data": "2025-04-22 18:25:04"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490240,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2020-01-01/",
                    "name": "dt",
                    "value": "2020-01-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:04",
                        "last_data": "2025-04-22 18:25:04"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490252,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2020-02-01/",
                    "name": "dt",
                    "value": "2020-02-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:05",
                        "last_data": "2025-04-22 18:25:05"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490255,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2020-03-01/",
                    "name": "dt",
                    "value": "2020-03-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:05",
                        "last_data": "2025-04-22 18:25:05"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490303,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2020-04-01/",
                    "name": "dt",
                    "value": "2020-04-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:09",
                        "last_data": "2025-04-22 18:25:09"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490232,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2020-05-01/",
                    "name": "dt",
                    "value": "2020-05-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:04",
                        "last_data": "2025-04-22 18:25:04"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490257,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2020-06-01/",
                    "name": "dt",
                    "value": "2020-06-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:06",
                        "last_data": "2025-04-22 18:25:06"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490219,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2020-07-01/",
                    "name": "dt",
                    "value": "2020-07-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:03",
                        "last_data": "2025-04-22 18:25:03"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490241,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2020-08-01/",
                    "name": "dt",
                    "value": "2020-08-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:04",
                        "last_data": "2025-04-22 18:25:04"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490287,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2020-09-01/",
                    "name": "dt",
                    "value": "2020-09-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:08",
                        "last_data": "2025-04-22 18:25:08"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490267,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2020-10-01/",
                    "name": "dt",
                    "value": "2020-10-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:06",
                        "last_data": "2025-04-22 18:25:06"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490261,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2020-11-01/",
                    "name": "dt",
                    "value": "2020-11-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:06",
                        "last_data": "2025-04-22 18:25:06"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490229,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2020-11-02/",
                    "name": "dt",
                    "value": "2020-11-02"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:25:03",
                        "last_data": "2025-04-22 18:25:03"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1490218,
                    "location": "s3://sfdl-rds-sparefoot-prod/raw_incremental/sparefoot_inventory/dt=2025-04-22/",
                    "name": "dt",
                    "value": "2025-04-22"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-22 18:24:34",
                        "last_data": "2025-04-22 18:24:34"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            }
        ],
        "type": "string"
    },
    "schema": {
        "attributes": {
            "available_units": "int",
            "climate_controlled": "smallint",
            "date_created": "timestamp",
            "dt_partition": "string",
            "inventory_id": "int",
            "length": "double",
            "listing_avail_id": "int",
            "total_units": "int",
            "width": "double"
        },
        "created": "2025-04-22 18:24: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_inventory`\n(\n `available_units`  int , `climate_controlled`  smallint , `date_created`  timestamp , `dt_partition`  string , `inventory_id`  int , `length`  double , `listing_avail_id`  int , `total_units`  int , `width`  double \n)\nPARTITIONED BY (dt string)\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_incremental/sparefoot_inventory'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_inventory`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_inventory"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}