Schema Info

Schema Name: sfdl_dev_rds.sparefoot_facility_yields

created: 2022-03-15 17:34:56
disabled: False
format: raw
id: 1763
is_partitioned: False
is_schema_datatyped: True

name:

{
    "database": "sfdl_dev_rds",
    "table": "sparefoot_facility_yields"
}

type: rds

Schema Versions: 4

Version 4689036

created: 2022-03-16 16:37:23

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`",
    "DROP TABLE IF EXISTS `sfdl_dev_rds.sparefoot_facility_yields`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_rds.sparefoot_facility_yields`\n(\n`use_override_move_in_rate`tinyint,`avg_medium_unit_price`decimal(6,2),`avg_small_unit_price`decimal(6,2),`override_submit_rate_expire`date,`resale_small_unit_price`decimal(6,2),`use_override_cpa`tinyint,`override_move_in_rate_expire`date,`move_in_rate`string,`cpa`string,`avg_large_unit_price`decimal(6,2),`override_cpa`string,`override_cpa_expire`date,`last_modified`timestamp,`geo_specific_npv`string,`use_override_submit_rate`tinyint,`resale_large_unit_price`decimal(6,2),`listing_avail_id`int,`resale_medium_unit_price`decimal(6,2),`submit_rate`string,`override_move_in_rate`string,`override_submit_rate`string\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\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-dev/raw/facility_yields/2022-03-16/1647466626'\n",
    "MSCK REPAIR TABLE sfdl_dev_rds.sparefoot_facility_yields"
]

hive_path: s3://sfdl-rds-sparefoot-dev/raw/facility_yields/2022-03-16/1647466626
id: 4689036
processed: 1

raw_data:

{
    "avg_large_unit_price": 100.0,
    "avg_medium_unit_price": 59.0,
    "avg_small_unit_price": 52.0,
    "cpa": 111.92,
    "geo_specific_npv": 116.56,
    "last_modified": "2019-04-17 09:45:57",
    "listing_avail_id": 201748,
    "move_in_rate": 0.5714,
    "override_cpa": 92.18,
    "override_cpa_expire": "2016-12-21",
    "override_move_in_rate": 0.50619,
    "override_move_in_rate_expire": "2016-12-21",
    "override_submit_rate": 0.09485,
    "override_submit_rate_expire": "2016-12-21",
    "resale_large_unit_price": null,
    "resale_medium_unit_price": null,
    "resale_small_unit_price": null,
    "submit_rate": 0.07447,
    "use_override_cpa": 0,
    "use_override_move_in_rate": 0,
    "use_override_submit_rate": 0
}

schema_attributes:

{
    "avg_large_unit_price": "string",
    "avg_medium_unit_price": "string",
    "avg_small_unit_price": "string",
    "cpa": "string",
    "geo_specific_npv": "string",
    "last_modified": "timestamp",
    "listing_avail_id": "int",
    "move_in_rate": "string",
    "override_cpa": "string",
    "override_cpa_expire": "date",
    "override_move_in_rate": "string",
    "override_move_in_rate_expire": "date",
    "override_submit_rate": "string",
    "override_submit_rate_expire": "date",
    "resale_large_unit_price": "string",
    "resale_medium_unit_price": "string",
    "resale_small_unit_price": "string",
    "submit_rate": "string",
    "use_override_cpa": "tinyint",
    "use_override_move_in_rate": "tinyint",
    "use_override_submit_rate": "tinyint"
}

schema_name_id: 1763
schema_scan_id: 5904799
updated: 2022-03-16 16:37:35

Version 4689004

created: 2022-03-16 11:13:09

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`",
    "DROP TABLE IF EXISTS `sfdl_dev_rds.sparefoot_facility_yields`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_rds.sparefoot_facility_yields`\n(\n`use_override_move_in_rate`tinyint,`avg_medium_unit_price`decimal(6,2),`avg_small_unit_price`decimal(6,2),`override_submit_rate_expire`date,`resale_small_unit_price`decimal(6,2),`use_override_cpa`tinyint,`override_move_in_rate_expire`date,`move_in_rate`string,`cpa`string,`avg_large_unit_price`decimal(6,2),`override_cpa`string,`override_cpa_expire`date,`last_modified`timestamp,`geo_specific_npv`string,`use_override_submit_rate`tinyint,`resale_large_unit_price`decimal(6,2),`listing_avail_id`int,`resale_medium_unit_price`decimal(6,2),`submit_rate`string,`override_move_in_rate`string,`override_submit_rate`string\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\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-dev/raw/facility_yields/2022-03-16/1647447166'\n",
    "MSCK REPAIR TABLE sfdl_dev_rds.sparefoot_facility_yields"
]

hive_path: s3://sfdl-rds-sparefoot-dev/raw/facility_yields/2022-03-16/1647447166
id: 4689004
processed: 1

raw_data:

{
    "avg_large_unit_price": 248.32,
    "avg_medium_unit_price": 99.99,
    "avg_small_unit_price": 69.99,
    "cpa": 204.8,
    "geo_specific_npv": null,
    "last_modified": "2019-08-20 14:19:52",
    "listing_avail_id": 201727,
    "move_in_rate": null,
    "override_cpa": 92.35,
    "override_cpa_expire": "2016-12-18",
    "override_move_in_rate": 0.50607,
    "override_move_in_rate_expire": "2016-12-18",
    "override_submit_rate": 0.09488,
    "override_submit_rate_expire": "2016-12-18",
    "resale_large_unit_price": null,
    "resale_medium_unit_price": null,
    "resale_small_unit_price": null,
    "submit_rate": 0.0,
    "use_override_cpa": 0,
    "use_override_move_in_rate": 0,
    "use_override_submit_rate": 0
}

schema_attributes:

{
    "avg_large_unit_price": "string",
    "avg_medium_unit_price": "string",
    "avg_small_unit_price": "string",
    "cpa": "string",
    "geo_specific_npv": "string",
    "last_modified": "timestamp",
    "listing_avail_id": "int",
    "move_in_rate": "string",
    "override_cpa": "string",
    "override_cpa_expire": "date",
    "override_move_in_rate": "string",
    "override_move_in_rate_expire": "date",
    "override_submit_rate": "string",
    "override_submit_rate_expire": "date",
    "resale_large_unit_price": "string",
    "resale_medium_unit_price": "string",
    "resale_small_unit_price": "string",
    "submit_rate": "string",
    "use_override_cpa": "tinyint",
    "use_override_move_in_rate": "tinyint",
    "use_override_submit_rate": "tinyint"
}

schema_name_id: 1763
schema_scan_id: 5904478
updated: 2022-03-16 11:13:21

Version 4688992

created: 2022-03-15 22:26:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`",
    "DROP TABLE IF EXISTS `sfdl_dev_rds.sparefoot_facility_yields`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_rds.sparefoot_facility_yields`\n(\n`use_override_move_in_rate`tinyint,`avg_medium_unit_price`decimal(6,2),`avg_small_unit_price`decimal(6,2),`override_submit_rate_expire`date,`resale_small_unit_price`decimal(6,2),`use_override_cpa`tinyint,`override_move_in_rate_expire`date,`move_in_rate`string,`cpa`string,`avg_large_unit_price`decimal(6,2),`override_cpa`string,`override_cpa_expire`date,`last_modified`timestamp,`geo_specific_npv`string,`use_override_submit_rate`tinyint,`resale_large_unit_price`decimal(6,2),`listing_avail_id`int,`resale_medium_unit_price`decimal(6,2),`submit_rate`string,`override_move_in_rate`string,`override_submit_rate`string\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\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-dev/raw/facility_yields/2022-03-15/1647401166'\n",
    "MSCK REPAIR TABLE sfdl_dev_rds.sparefoot_facility_yields"
]

hive_path: s3://sfdl-rds-sparefoot-dev/raw/facility_yields/2022-03-15/1647401166
id: 4688992
processed: 1

raw_data:

{
    "avg_large_unit_price": 49.0,
    "avg_medium_unit_price": 27.0,
    "avg_small_unit_price": 0.0,
    "cpa": 36.04,
    "geo_specific_npv": 40.24,
    "last_modified": "2019-08-20 14:19:51",
    "listing_avail_id": 201671,
    "move_in_rate": 0.16,
    "override_cpa": 92.32,
    "override_cpa_expire": "2016-12-10",
    "override_move_in_rate": 0.50928,
    "override_move_in_rate_expire": "2016-12-10",
    "override_submit_rate": 0.09517,
    "override_submit_rate_expire": "2016-12-10",
    "resale_large_unit_price": null,
    "resale_medium_unit_price": null,
    "resale_small_unit_price": null,
    "submit_rate": 0.28736,
    "use_override_cpa": 0,
    "use_override_move_in_rate": 0,
    "use_override_submit_rate": 0
}

schema_attributes:

{
    "avg_large_unit_price": "string",
    "avg_medium_unit_price": "string",
    "avg_small_unit_price": "string",
    "cpa": "string",
    "geo_specific_npv": "string",
    "last_modified": "timestamp",
    "listing_avail_id": "int",
    "move_in_rate": "string",
    "override_cpa": "string",
    "override_cpa_expire": "date",
    "override_move_in_rate": "string",
    "override_move_in_rate_expire": "date",
    "override_submit_rate": "string",
    "override_submit_rate_expire": "date",
    "resale_large_unit_price": "string",
    "resale_medium_unit_price": "string",
    "resale_small_unit_price": "string",
    "submit_rate": "string",
    "use_override_cpa": "tinyint",
    "use_override_move_in_rate": "tinyint",
    "use_override_submit_rate": "tinyint"
}

schema_name_id: 1763
schema_scan_id: 5904421
updated: 2022-03-15 22:26:43

Version 4688932

created: 2022-03-15 17:35:10

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`",
    "DROP TABLE IF EXISTS `sfdl_dev_rds.sparefoot_facility_yields`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_rds.sparefoot_facility_yields`\n(\n`listing_avail_id`int,`last_modified`timestamp,`cpa`string,`override_cpa`string,`use_override_cpa`tinyint,`override_cpa_expire`date,`geo_specific_npv`string,`move_in_rate`string,`override_move_in_rate`string,`use_override_move_in_rate`tinyint,`override_move_in_rate_expire`date,`submit_rate`string,`override_submit_rate`string,`use_override_submit_rate`tinyint,`override_submit_rate_expire`date,`avg_small_unit_price`decimal(6,2),`avg_medium_unit_price`decimal(6,2),`avg_large_unit_price`decimal(6,2),`resale_small_unit_price`decimal(6,2),`resale_medium_unit_price`decimal(6,2),`resale_large_unit_price`decimal(6,2)\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\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-dev/raw/facility_yields/2022-03-15/1647383642'\n",
    "MSCK REPAIR TABLE sfdl_dev_rds.sparefoot_facility_yields"
]

hive_path: s3://sfdl-rds-sparefoot-dev/raw/facility_yields/2022-03-15/1647383642
id: 4688932
processed: 1

raw_data:

{
    "avg_large_unit_price": 49.0,
    "avg_medium_unit_price": 27.0,
    "avg_small_unit_price": 0.0,
    "cpa": 36.04,
    "geo_specific_npv": 40.24,
    "last_modified": "2019-08-20 14:19:51",
    "listing_avail_id": 201671,
    "move_in_rate": 0.16,
    "override_cpa": 92.32,
    "override_cpa_expire": "2016-12-10",
    "override_move_in_rate": 0.50928,
    "override_move_in_rate_expire": "2016-12-10",
    "override_submit_rate": 0.09517,
    "override_submit_rate_expire": "2016-12-10",
    "resale_large_unit_price": null,
    "resale_medium_unit_price": null,
    "resale_small_unit_price": null,
    "submit_rate": 0.28736,
    "use_override_cpa": 0,
    "use_override_move_in_rate": 0,
    "use_override_submit_rate": 0
}

schema_attributes:

{
    "avg_large_unit_price": "string",
    "avg_medium_unit_price": "string",
    "avg_small_unit_price": "string",
    "cpa": "string",
    "geo_specific_npv": "string",
    "last_modified": "timestamp",
    "listing_avail_id": "int",
    "move_in_rate": "string",
    "override_cpa": "string",
    "override_cpa_expire": "date",
    "override_move_in_rate": "string",
    "override_move_in_rate_expire": "date",
    "override_submit_rate": "string",
    "override_submit_rate_expire": "date",
    "resale_large_unit_price": "string",
    "resale_medium_unit_price": "string",
    "resale_small_unit_price": "string",
    "submit_rate": "string",
    "use_override_cpa": "tinyint",
    "use_override_move_in_rate": "tinyint",
    "use_override_submit_rate": "tinyint"
}

schema_name_id: 1763
schema_scan_id: 5904283
updated: 2022-03-15 17:35:21

Schema Scans: 4

Last at 2022-03-16 16:37:10

Scan 5904799

duration: 0:00:27.246299

exit_message:

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

id: 5904799

payload:

{
    "datatype_dict": {
        "avg_large_unit_price": "decimal(6,2)",
        "avg_medium_unit_price": "decimal(6,2)",
        "avg_small_unit_price": "decimal(6,2)",
        "cpa": "string",
        "geo_specific_npv": "string",
        "last_modified": "timestamp",
        "listing_avail_id": "int",
        "move_in_rate": "string",
        "override_cpa": "string",
        "override_cpa_expire": "date",
        "override_move_in_rate": "string",
        "override_move_in_rate_expire": "date",
        "override_submit_rate": "string",
        "override_submit_rate_expire": "date",
        "resale_large_unit_price": "decimal(6,2)",
        "resale_medium_unit_price": "decimal(6,2)",
        "resale_small_unit_price": "decimal(6,2)",
        "submit_rate": "string",
        "use_override_cpa": "tinyint",
        "use_override_move_in_rate": "tinyint",
        "use_override_submit_rate": "tinyint"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-dev",
        "hive_path": "s3://sfdl-rds-sparefoot-dev/raw/facility_yields/2022-03-16/1647466626",
        "key": "raw/facility_yields/2022-03-16/1647466626/facility_yields-8.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_rds.sparefoot_facility_yields",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 709609593512239415,
        "service_name": "sparefoot",
        "span_id": 16274943423330744858,
        "trace_id": 709609593512239415
    }
}

running: False
schema_name_id: 1763
start_time: 2022-03-16 16:37:10
success: True
trace_id: 709609593512239415

Scan 5904478

duration: 0:00:28.232137

exit_message:

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

id: 5904478

payload:

{
    "datatype_dict": {
        "avg_large_unit_price": "decimal(6,2)",
        "avg_medium_unit_price": "decimal(6,2)",
        "avg_small_unit_price": "decimal(6,2)",
        "cpa": "string",
        "geo_specific_npv": "string",
        "last_modified": "timestamp",
        "listing_avail_id": "int",
        "move_in_rate": "string",
        "override_cpa": "string",
        "override_cpa_expire": "date",
        "override_move_in_rate": "string",
        "override_move_in_rate_expire": "date",
        "override_submit_rate": "string",
        "override_submit_rate_expire": "date",
        "resale_large_unit_price": "decimal(6,2)",
        "resale_medium_unit_price": "decimal(6,2)",
        "resale_small_unit_price": "decimal(6,2)",
        "submit_rate": "string",
        "use_override_cpa": "tinyint",
        "use_override_move_in_rate": "tinyint",
        "use_override_submit_rate": "tinyint"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-dev",
        "hive_path": "s3://sfdl-rds-sparefoot-dev/raw/facility_yields/2022-03-16/1647447166",
        "key": "raw/facility_yields/2022-03-16/1647447166/data-8.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_rds.sparefoot_facility_yields",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 1826246078593764081,
        "service_name": "sparefoot",
        "span_id": 17878022369796880989,
        "trace_id": 1826246078593764081
    }
}

running: False
schema_name_id: 1763
start_time: 2022-03-16 11:12:55
success: True
trace_id: 1826246078593764081

Scan 5904421

duration: 0:00:28.273668

exit_message:

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

id: 5904421

payload:

{
    "datatype_dict": {
        "avg_large_unit_price": "decimal(6,2)",
        "avg_medium_unit_price": "decimal(6,2)",
        "avg_small_unit_price": "decimal(6,2)",
        "cpa": "string",
        "geo_specific_npv": "string",
        "last_modified": "timestamp",
        "listing_avail_id": "int",
        "move_in_rate": "string",
        "override_cpa": "string",
        "override_cpa_expire": "date",
        "override_move_in_rate": "string",
        "override_move_in_rate_expire": "date",
        "override_submit_rate": "string",
        "override_submit_rate_expire": "date",
        "resale_large_unit_price": "decimal(6,2)",
        "resale_medium_unit_price": "decimal(6,2)",
        "resale_small_unit_price": "decimal(6,2)",
        "submit_rate": "string",
        "use_override_cpa": "tinyint",
        "use_override_move_in_rate": "tinyint",
        "use_override_submit_rate": "tinyint"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-dev",
        "hive_path": "s3://sfdl-rds-sparefoot-dev/raw/facility_yields/2022-03-15/1647401166",
        "key": "raw/facility_yields/2022-03-15/1647401166/data-8.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_rds.sparefoot_facility_yields",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 14736994263901160839,
        "service_name": "sparefoot",
        "span_id": 14416040984134981750,
        "trace_id": 14736994263901160839
    }
}

running: False
schema_name_id: 1763
start_time: 2022-03-15 22:26:17
success: True
trace_id: 14736994263901160839

Scan 5904283

duration: 0:00:28.153907

exit_message:

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

id: 5904283

payload:

{
    "datatype_dict": {
        "avg_large_unit_price": "decimal(6,2)",
        "avg_medium_unit_price": "decimal(6,2)",
        "avg_small_unit_price": "decimal(6,2)",
        "cpa": "string",
        "geo_specific_npv": "string",
        "last_modified": "timestamp",
        "listing_avail_id": "int",
        "move_in_rate": "string",
        "override_cpa": "string",
        "override_cpa_expire": "date",
        "override_move_in_rate": "string",
        "override_move_in_rate_expire": "date",
        "override_submit_rate": "string",
        "override_submit_rate_expire": "date",
        "resale_large_unit_price": "decimal(6,2)",
        "resale_medium_unit_price": "decimal(6,2)",
        "resale_small_unit_price": "decimal(6,2)",
        "submit_rate": "string",
        "use_override_cpa": "tinyint",
        "use_override_move_in_rate": "tinyint",
        "use_override_submit_rate": "tinyint"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-dev",
        "hive_path": "s3://sfdl-rds-sparefoot-dev/raw/facility_yields/2022-03-15/1647383642",
        "key": "raw/facility_yields/2022-03-15/1647383642/data-8.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_rds.sparefoot_facility_yields",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 3363363697616435751,
        "service_name": "sparefoot",
        "span_id": 10649113735201922282,
        "trace_id": 3363363697616435751
    }
}

running: False
schema_name_id: 1763
start_time: 2022-03-15 17:34:56
success: True
trace_id: 3363363697616435751

Partitions:

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

Schema:

attributes:

{
    "avg_large_unit_price": "string",
    "avg_medium_unit_price": "string",
    "avg_small_unit_price": "string",
    "cpa": "string",
    "geo_specific_npv": "string",
    "last_modified": "timestamp",
    "listing_avail_id": "int",
    "move_in_rate": "string",
    "override_cpa": "string",
    "override_cpa_expire": "date",
    "override_move_in_rate": "string",
    "override_move_in_rate_expire": "date",
    "override_submit_rate": "string",
    "override_submit_rate_expire": "date",
    "resale_large_unit_price": "string",
    "resale_medium_unit_price": "string",
    "resale_small_unit_price": "string",
    "submit_rate": "string",
    "use_override_cpa": "tinyint",
    "use_override_move_in_rate": "tinyint",
    "use_override_submit_rate": "tinyint"
}

created: 2022-03-16 16:37:23

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_rds.sparefoot_facility_yields`\n(\n`use_override_move_in_rate`tinyint,`avg_medium_unit_price`decimal(6,2),`avg_small_unit_price`decimal(6,2),`override_submit_rate_expire`date,`resale_small_unit_price`decimal(6,2),`use_override_cpa`tinyint,`override_move_in_rate_expire`date,`move_in_rate`string,`cpa`string,`avg_large_unit_price`decimal(6,2),`override_cpa`string,`override_cpa_expire`date,`last_modified`timestamp,`geo_specific_npv`string,`use_override_submit_rate`tinyint,`resale_large_unit_price`decimal(6,2),`listing_avail_id`int,`resale_medium_unit_price`decimal(6,2),`submit_rate`string,`override_move_in_rate`string,`override_submit_rate`string\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\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-dev/raw/facility_yields/2022-03-16/1647466626'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_rds.sparefoot_facility_yields`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_rds.sparefoot_facility_yields"
}

Server:

hostname: schemamanager-5447774fc6-4w58v
name: schema_manager
process_start: 2026-04-02 21:43:44
sf_env: dev
version: 2427328685

Raw:

{
    "name": {
        "created": "2022-03-15 17:34:56",
        "disabled": false,
        "format": "raw",
        "id": 1763,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_rds",
            "table": "sparefoot_facility_yields"
        },
        "type": "rds"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "avg_large_unit_price": "string",
            "avg_medium_unit_price": "string",
            "avg_small_unit_price": "string",
            "cpa": "string",
            "geo_specific_npv": "string",
            "last_modified": "timestamp",
            "listing_avail_id": "int",
            "move_in_rate": "string",
            "override_cpa": "string",
            "override_cpa_expire": "date",
            "override_move_in_rate": "string",
            "override_move_in_rate_expire": "date",
            "override_submit_rate": "string",
            "override_submit_rate_expire": "date",
            "resale_large_unit_price": "string",
            "resale_medium_unit_price": "string",
            "resale_small_unit_price": "string",
            "submit_rate": "string",
            "use_override_cpa": "tinyint",
            "use_override_move_in_rate": "tinyint",
            "use_override_submit_rate": "tinyint"
        },
        "created": "2022-03-16 16:37:23",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_rds.sparefoot_facility_yields`\n(\n`use_override_move_in_rate`tinyint,`avg_medium_unit_price`decimal(6,2),`avg_small_unit_price`decimal(6,2),`override_submit_rate_expire`date,`resale_small_unit_price`decimal(6,2),`use_override_cpa`tinyint,`override_move_in_rate_expire`date,`move_in_rate`string,`cpa`string,`avg_large_unit_price`decimal(6,2),`override_cpa`string,`override_cpa_expire`date,`last_modified`timestamp,`geo_specific_npv`string,`use_override_submit_rate`tinyint,`resale_large_unit_price`decimal(6,2),`listing_avail_id`int,`resale_medium_unit_price`decimal(6,2),`submit_rate`string,`override_move_in_rate`string,`override_submit_rate`string\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\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-dev/raw/facility_yields/2022-03-16/1647466626'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_rds.sparefoot_facility_yields`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_rds.sparefoot_facility_yields"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}