Schema Info

Schema Name: sfdl_dev_rds.sparefoot_facility_tenants

created: 2022-03-15 22:39:24
disabled: False
format: raw
id: 1779
is_partitioned: False
is_schema_datatyped: True

name:

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

type: rds

Schema Versions: 2

Version 4689045

created: 2022-03-16 16:41:57

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`",
    "DROP TABLE IF EXISTS `sfdl_dev_rds.sparefoot_facility_tenants`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_rds.sparefoot_facility_tenants`\n(\n`unit_number`varchar(255),`customer_phone`bigint,`modified`timestamp,`last_payment_amount`decimal(10,0),`alt_first_name`varchar(255),`alt_last_name`varchar(255),`created`timestamp,`customer_state`varchar(255),`id`varchar(32),`customer_email`varchar(255),`customer_id`varchar(255),`customer_first_name`varchar(255),`move_in_date`date,`customer_zip`varchar(11),`company_name`varchar(255),`customer_address2`varchar(255),`listing_avail_id`int,`api_facility_id`varchar(32),`facility_id`int,`lifetime_value`decimal(10,0),`rent_rate`string,`lead_id`varchar(32),`confirmation_code`varchar(32),`customer_cell_phone`bigint,`match_run_id`int,`unit_dimensions`varchar(255),`customer_work_phone`bigint,`customer_city`varchar(255),`customer_last_name`varchar(255),`customer_home_phone`bigint,`customer_address1`varchar(255),`alt_email`varchar(255),`customer_work_email`varchar(255),`move_out_date`date,`source_type`varchar(255),`unit_id`varchar(32),`facility_name`varchar(255),`alt_phone`bigint,`corporation_id`int\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/separated_dt/facility_tenants/2022-03-16/1647466815'\n",
    "MSCK REPAIR TABLE sfdl_dev_rds.sparefoot_facility_tenants"
]

hive_path: s3://sfdl-rds-sparefoot-dev/separated_dt/facility_tenants/2022-03-16/1647466815
id: 4689045
processed: 1

raw_data:

{
    "alt_email": "",
    "alt_first_name": "",
    "alt_last_name": "",
    "alt_phone": null,
    "api_facility_id": "125d108d324e424b962f46116a61020a",
    "company_name": null,
    "confirmation_code": null,
    "corporation_id": 9052,
    "created": "2022-02-12 12:43:00",
    "customer_address1": null,
    "customer_address2": null,
    "customer_cell_phone": 9168245400,
    "customer_city": null,
    "customer_email": "[email protected]",
    "customer_first_name": "Adessa",
    "customer_home_phone": null,
    "customer_id": "ecaf11c8057b43d9bc9bfcf053f87eb2",
    "customer_last_name": "Salon Suites",
    "customer_phone": null,
    "customer_state": null,
    "customer_work_email": null,
    "customer_work_phone": null,
    "customer_zip": null,
    "facility_id": null,
    "facility_name": "Trojan Storage of Sacramento",
    "id": "e014dd71c8b90ada4c37aa03026b2402",
    "last_payment_amount": null,
    "lead_id": null,
    "lifetime_value": null,
    "listing_avail_id": 205976,
    "match_run_id": null,
    "modified": "2022-03-16 12:04:54",
    "move_in_date": "2022-02-11",
    "move_out_date": null,
    "rent_rate": 182.0,
    "source_type": null,
    "unit_dimensions": "9x10",
    "unit_id": "737d8e60043b4e088bcaa963cef27ae6",
    "unit_number": null
}

schema_attributes:

{
    "alt_email": "string",
    "alt_first_name": "string",
    "alt_last_name": "string",
    "alt_phone": "bigint",
    "api_facility_id": "string",
    "company_name": "string",
    "confirmation_code": "string",
    "corporation_id": "int",
    "created": "timestamp",
    "customer_address1": "string",
    "customer_address2": "string",
    "customer_cell_phone": "bigint",
    "customer_city": "string",
    "customer_email": "string",
    "customer_first_name": "string",
    "customer_home_phone": "bigint",
    "customer_id": "string",
    "customer_last_name": "string",
    "customer_phone": "bigint",
    "customer_state": "string",
    "customer_work_email": "string",
    "customer_work_phone": "bigint",
    "customer_zip": "string",
    "facility_id": "int",
    "facility_name": "string",
    "id": "string",
    "last_payment_amount": "string",
    "lead_id": "string",
    "lifetime_value": "string",
    "listing_avail_id": "int",
    "match_run_id": "int",
    "modified": "timestamp",
    "move_in_date": "date",
    "move_out_date": "date",
    "rent_rate": "string",
    "source_type": "string",
    "unit_dimensions": "string",
    "unit_id": "string",
    "unit_number": "string"
}

schema_name_id: 1779
schema_scan_id: 5904808
updated: 2022-03-16 16:42:08

Version 4688998

created: 2022-03-15 22:40:49

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`",
    "DROP TABLE IF EXISTS `sfdl_dev_rds.sparefoot_facility_tenants`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_rds.sparefoot_facility_tenants`\n(\n`id`varchar(32),`confirmation_code`varchar(32),`corporation_id`int,`facility_name`varchar(255),`facility_id`int,`listing_avail_id`int,`api_facility_id`varchar(32),`move_in_date`date,`move_out_date`date,`unit_id`varchar(32),`unit_number`varchar(255),`rent_rate`string,`unit_dimensions`varchar(255),`customer_id`varchar(255),`lead_id`varchar(32),`customer_first_name`varchar(255),`customer_last_name`varchar(255),`customer_address1`varchar(255),`customer_address2`varchar(255),`customer_city`varchar(255),`customer_state`varchar(255),`customer_zip`varchar(11),`customer_email`varchar(255),`customer_work_email`varchar(255),`customer_phone`bigint,`customer_home_phone`bigint,`customer_work_phone`bigint,`customer_cell_phone`bigint,`company_name`varchar(255),`alt_first_name`varchar(255),`alt_last_name`varchar(255),`alt_email`varchar(255),`alt_phone`bigint,`lifetime_value`decimal(10,0),`last_payment_amount`decimal(10,0),`source_type`varchar(255),`match_run_id`int,`created`timestamp,`modified`timestamp\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/separated_dt/facility_tenants/2022-03-15/1647401946'\n",
    "MSCK REPAIR TABLE sfdl_dev_rds.sparefoot_facility_tenants"
]

hive_path: s3://sfdl-rds-sparefoot-dev/separated_dt/facility_tenants/2022-03-15/1647401946
id: 4688998
processed: 1

raw_data:

{
    "alt_email": "",
    "alt_first_name": "REGINALD",
    "alt_last_name": "BARNETTE",
    "alt_phone": 9176731115,
    "api_facility_id": "CCFK FOS",
    "company_name": null,
    "confirmation_code": null,
    "corporation_id": 2698,
    "created": "2022-02-23 11:17:09",
    "customer_address1": "6912 LEESBURG ROAD",
    "customer_address2": "",
    "customer_cell_phone": null,
    "customer_city": "ROXBORO",
    "customer_email": "[email protected]",
    "customer_first_name": "ALTAREQ",
    "customer_home_phone": null,
    "customer_id": "302960",
    "customer_last_name": "BARNETTE",
    "customer_phone": 6785250440,
    "customer_state": "NC",
    "customer_work_email": null,
    "customer_work_phone": null,
    "customer_zip": "27574",
    "facility_id": null,
    "facility_name": "Next Door Self Storage - Ottawa, IL Fosse",
    "id": "cfc06044698ef66107c233f3e67ca954",
    "last_payment_amount": null,
    "lead_id": "139215",
    "lifetime_value": null,
    "listing_avail_id": 149911,
    "match_run_id": null,
    "modified": "2022-03-14 10:17:58",
    "move_in_date": "2022-02-22",
    "move_out_date": null,
    "rent_rate": 230.0,
    "source_type": null,
    "unit_dimensions": "10.0000x40.0000",
    "unit_id": "27245",
    "unit_number": "23062"
}

schema_attributes:

{
    "alt_email": "string",
    "alt_first_name": "string",
    "alt_last_name": "string",
    "alt_phone": "bigint",
    "api_facility_id": "string",
    "company_name": "string",
    "confirmation_code": "string",
    "corporation_id": "int",
    "created": "timestamp",
    "customer_address1": "string",
    "customer_address2": "string",
    "customer_cell_phone": "bigint",
    "customer_city": "string",
    "customer_email": "string",
    "customer_first_name": "string",
    "customer_home_phone": "bigint",
    "customer_id": "string",
    "customer_last_name": "string",
    "customer_phone": "bigint",
    "customer_state": "string",
    "customer_work_email": "string",
    "customer_work_phone": "bigint",
    "customer_zip": "string",
    "facility_id": "int",
    "facility_name": "string",
    "id": "string",
    "last_payment_amount": "string",
    "lead_id": "string",
    "lifetime_value": "string",
    "listing_avail_id": "int",
    "match_run_id": "int",
    "modified": "timestamp",
    "move_in_date": "date",
    "move_out_date": "date",
    "rent_rate": "string",
    "source_type": "string",
    "unit_dimensions": "string",
    "unit_id": "string",
    "unit_number": "string"
}

schema_name_id: 1779
schema_scan_id: 5904431
updated: 2022-03-15 22:41:01

Schema Scans: 2

Last at 2022-03-16 16:40:26

Scan 5904808

duration: 0:01:45.520899

exit_message:

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

id: 5904808

payload:

{
    "datatype_dict": {
        "alt_email": "varchar(255)",
        "alt_first_name": "varchar(255)",
        "alt_last_name": "varchar(255)",
        "alt_phone": "bigint",
        "api_facility_id": "varchar(32)",
        "company_name": "varchar(255)",
        "confirmation_code": "varchar(32)",
        "corporation_id": "int",
        "created": "timestamp",
        "customer_address1": "varchar(255)",
        "customer_address2": "varchar(255)",
        "customer_cell_phone": "bigint",
        "customer_city": "varchar(255)",
        "customer_email": "varchar(255)",
        "customer_first_name": "varchar(255)",
        "customer_home_phone": "bigint",
        "customer_id": "varchar(255)",
        "customer_last_name": "varchar(255)",
        "customer_phone": "bigint",
        "customer_state": "varchar(255)",
        "customer_work_email": "varchar(255)",
        "customer_work_phone": "bigint",
        "customer_zip": "varchar(11)",
        "facility_id": "int",
        "facility_name": "varchar(255)",
        "id": "varchar(32)",
        "last_payment_amount": "decimal(10,0)",
        "lead_id": "varchar(32)",
        "lifetime_value": "decimal(10,0)",
        "listing_avail_id": "int",
        "match_run_id": "int",
        "modified": "timestamp",
        "move_in_date": "date",
        "move_out_date": "date",
        "rent_rate": "string",
        "source_type": "varchar(255)",
        "unit_dimensions": "varchar(255)",
        "unit_id": "varchar(32)",
        "unit_number": "varchar(255)"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-dev",
        "hive_path": "s3://sfdl-rds-sparefoot-dev/separated_dt/facility_tenants/2022-03-16/1647466815",
        "key": "separated_dt/facility_tenants/2022-03-16/1647466815/facility_tenants-8.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_rds.sparefoot_facility_tenants",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 15353262712437033322,
        "service_name": "sparefoot",
        "span_id": 14291021396410245969,
        "trace_id": 15353262712437033322
    }
}

running: False
schema_name_id: 1779
start_time: 2022-03-16 16:40:26
success: True
trace_id: 15353262712437033322

Scan 5904431

duration: 0:01:38.812254

exit_message:

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

id: 5904431

payload:

{
    "datatype_dict": {
        "alt_email": "varchar(255)",
        "alt_first_name": "varchar(255)",
        "alt_last_name": "varchar(255)",
        "alt_phone": "bigint",
        "api_facility_id": "varchar(32)",
        "company_name": "varchar(255)",
        "confirmation_code": "varchar(32)",
        "corporation_id": "int",
        "created": "timestamp",
        "customer_address1": "varchar(255)",
        "customer_address2": "varchar(255)",
        "customer_cell_phone": "bigint",
        "customer_city": "varchar(255)",
        "customer_email": "varchar(255)",
        "customer_first_name": "varchar(255)",
        "customer_home_phone": "bigint",
        "customer_id": "varchar(255)",
        "customer_last_name": "varchar(255)",
        "customer_phone": "bigint",
        "customer_state": "varchar(255)",
        "customer_work_email": "varchar(255)",
        "customer_work_phone": "bigint",
        "customer_zip": "varchar(11)",
        "facility_id": "int",
        "facility_name": "varchar(255)",
        "id": "varchar(32)",
        "last_payment_amount": "decimal(10,0)",
        "lead_id": "varchar(32)",
        "lifetime_value": "decimal(10,0)",
        "listing_avail_id": "int",
        "match_run_id": "int",
        "modified": "timestamp",
        "move_in_date": "date",
        "move_out_date": "date",
        "rent_rate": "string",
        "source_type": "varchar(255)",
        "unit_dimensions": "varchar(255)",
        "unit_id": "varchar(32)",
        "unit_number": "varchar(255)"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-dev",
        "hive_path": "s3://sfdl-rds-sparefoot-dev/separated_dt/facility_tenants/2022-03-15/1647401946",
        "key": "separated_dt/facility_tenants/2022-03-15/1647401946/data-8.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_rds.sparefoot_facility_tenants",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 17294361384112765275,
        "service_name": "sparefoot",
        "span_id": 13562044558446811982,
        "trace_id": 17294361384112765275
    }
}

running: False
schema_name_id: 1779
start_time: 2022-03-15 22:39:24
success: True
trace_id: 17294361384112765275

Partitions:

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

Schema:

attributes:

{
    "alt_email": "string",
    "alt_first_name": "string",
    "alt_last_name": "string",
    "alt_phone": "bigint",
    "api_facility_id": "string",
    "company_name": "string",
    "confirmation_code": "string",
    "corporation_id": "int",
    "created": "timestamp",
    "customer_address1": "string",
    "customer_address2": "string",
    "customer_cell_phone": "bigint",
    "customer_city": "string",
    "customer_email": "string",
    "customer_first_name": "string",
    "customer_home_phone": "bigint",
    "customer_id": "string",
    "customer_last_name": "string",
    "customer_phone": "bigint",
    "customer_state": "string",
    "customer_work_email": "string",
    "customer_work_phone": "bigint",
    "customer_zip": "string",
    "facility_id": "int",
    "facility_name": "string",
    "id": "string",
    "last_payment_amount": "string",
    "lead_id": "string",
    "lifetime_value": "string",
    "listing_avail_id": "int",
    "match_run_id": "int",
    "modified": "timestamp",
    "move_in_date": "date",
    "move_out_date": "date",
    "rent_rate": "string",
    "source_type": "string",
    "unit_dimensions": "string",
    "unit_id": "string",
    "unit_number": "string"
}

created: 2022-03-16 16:41:57

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_tenants`\n(\n`unit_number`varchar(255),`customer_phone`bigint,`modified`timestamp,`last_payment_amount`decimal(10,0),`alt_first_name`varchar(255),`alt_last_name`varchar(255),`created`timestamp,`customer_state`varchar(255),`id`varchar(32),`customer_email`varchar(255),`customer_id`varchar(255),`customer_first_name`varchar(255),`move_in_date`date,`customer_zip`varchar(11),`company_name`varchar(255),`customer_address2`varchar(255),`listing_avail_id`int,`api_facility_id`varchar(32),`facility_id`int,`lifetime_value`decimal(10,0),`rent_rate`string,`lead_id`varchar(32),`confirmation_code`varchar(32),`customer_cell_phone`bigint,`match_run_id`int,`unit_dimensions`varchar(255),`customer_work_phone`bigint,`customer_city`varchar(255),`customer_last_name`varchar(255),`customer_home_phone`bigint,`customer_address1`varchar(255),`alt_email`varchar(255),`customer_work_email`varchar(255),`move_out_date`date,`source_type`varchar(255),`unit_id`varchar(32),`facility_name`varchar(255),`alt_phone`bigint,`corporation_id`int\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/separated_dt/facility_tenants/2022-03-16/1647466815'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_rds.sparefoot_facility_tenants`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_rds.sparefoot_facility_tenants"
}

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 22:39:24",
        "disabled": false,
        "format": "raw",
        "id": 1779,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_rds",
            "table": "sparefoot_facility_tenants"
        },
        "type": "rds"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "alt_email": "string",
            "alt_first_name": "string",
            "alt_last_name": "string",
            "alt_phone": "bigint",
            "api_facility_id": "string",
            "company_name": "string",
            "confirmation_code": "string",
            "corporation_id": "int",
            "created": "timestamp",
            "customer_address1": "string",
            "customer_address2": "string",
            "customer_cell_phone": "bigint",
            "customer_city": "string",
            "customer_email": "string",
            "customer_first_name": "string",
            "customer_home_phone": "bigint",
            "customer_id": "string",
            "customer_last_name": "string",
            "customer_phone": "bigint",
            "customer_state": "string",
            "customer_work_email": "string",
            "customer_work_phone": "bigint",
            "customer_zip": "string",
            "facility_id": "int",
            "facility_name": "string",
            "id": "string",
            "last_payment_amount": "string",
            "lead_id": "string",
            "lifetime_value": "string",
            "listing_avail_id": "int",
            "match_run_id": "int",
            "modified": "timestamp",
            "move_in_date": "date",
            "move_out_date": "date",
            "rent_rate": "string",
            "source_type": "string",
            "unit_dimensions": "string",
            "unit_id": "string",
            "unit_number": "string"
        },
        "created": "2022-03-16 16:41:57",
        "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_tenants`\n(\n`unit_number`varchar(255),`customer_phone`bigint,`modified`timestamp,`last_payment_amount`decimal(10,0),`alt_first_name`varchar(255),`alt_last_name`varchar(255),`created`timestamp,`customer_state`varchar(255),`id`varchar(32),`customer_email`varchar(255),`customer_id`varchar(255),`customer_first_name`varchar(255),`move_in_date`date,`customer_zip`varchar(11),`company_name`varchar(255),`customer_address2`varchar(255),`listing_avail_id`int,`api_facility_id`varchar(32),`facility_id`int,`lifetime_value`decimal(10,0),`rent_rate`string,`lead_id`varchar(32),`confirmation_code`varchar(32),`customer_cell_phone`bigint,`match_run_id`int,`unit_dimensions`varchar(255),`customer_work_phone`bigint,`customer_city`varchar(255),`customer_last_name`varchar(255),`customer_home_phone`bigint,`customer_address1`varchar(255),`alt_email`varchar(255),`customer_work_email`varchar(255),`move_out_date`date,`source_type`varchar(255),`unit_id`varchar(32),`facility_name`varchar(255),`alt_phone`bigint,`corporation_id`int\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/separated_dt/facility_tenants/2022-03-16/1647466815'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_rds.sparefoot_facility_tenants`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_rds.sparefoot_facility_tenants"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}