Schema Info

Schema Name: sfdl_dev_dynamodb.storedgeapirequests_api_requests

created: 2019-12-07 05:01:59
disabled: False
format: raw
id: 1452
is_partitioned: True
is_schema_datatyped: False

name:

{
    "database": "sfdl_dev_dynamodb",
    "table": "storedgeapirequests_api_requests"
}

type: dynamodb

Schema Versions: 3

Version 4684435

created: 2021-02-25 13:07:48

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_dynamodb`",
    "DROP TABLE IF EXISTS `sfdl_dev_dynamodb.storedgeapirequests_api_requests`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_dynamodb.storedgeapirequests_api_requests`\n(\n`request_id`STRING,`facility_id`STRING,`created_at_Id`STRING,`status_code`STRING,`client_application_id`STRING,`controller_action`STRING,`company_id`STRING,`company_name`STRING,`created_at`STRING,`response_meta`STRING,`request_path`STRING,`response_time`STRING,`time_to_live`STRING,`facility_name`STRING,`target_resource`STRING,`client_application_name`STRING\n)\nPARTITIONED BY (dt string)\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-dynamodb-storedgeapirequests-dev/raw_incremental/api_requests'\n",
    "MSCK REPAIR TABLE sfdl_dev_dynamodb.storedgeapirequests_api_requests"
]

hive_path: s3://sfdl-dynamodb-storedgeapirequests-dev/raw_incremental/api_requests
id: 4684435
processed: 1

raw_data:

{
    "client_application_id": 52532,
    "client_application_name": "ideal movers & storage, inc. gate application",
    "company_id": 51227,
    "company_name": "ideal movers & storage, inc.",
    "controller_action": "index",
    "created_at": "2021-02-25T00:02:27-06:00",
    "created_at_Id": "2021-02-25T00:02:27-06:00_a1fb8a6f-5ef4-423d-b94e-d3a1a070b45a",
    "facility_id": 163976,
    "facility_name": "ideal movers & storage, inc.",
    "request_id": "a1fb8a6f-5ef4-423d-b94e-d3a1a070b45a",
    "request_path": "/v1/8eaa0984-0aad-47bb-97a3-b74519555556/gate_codes.json?updated_since=2021-02-24%2015%3a14%3a56%20-05%3a00&page=1",
    "response_meta": "{\"configuration\":{\"gate_provider_name\":\"storlogix\",\"gate_provider_dump_path\":\"C:\\\\PTI\",\"gate_provider_dump_file_name\":\"PTI.DAT\",\"gate_provider_consume_file_name\":\"N/A\",\"auto_generate_gate_code\":false,\"prefix_gate_code_with_unit_number\":false,\"gate_code_is_unit_and_phone_number\":false,\"minimum_gate_code_length\":4,\"maximum_gate_code_length\":10,\"minimum_gate_code_value\":1,\"maximum_gate_code_value\":4294967296,\"multiple_facilities_supported\":true,\"gate_lockout_account_balance\":0.0,\"gate_time_zone\":1,\"gate_keypad_zone\":null,\"gate_security_level\":null,\"gate_account_name\":null,\"gate_provider_run_inline\":false,\"gate_panel_id\":null},\"pagination\":{\"current_page\":1,\"total_pages\":1,\"per_page\":0,\"total_entries\":0,\"previous_page\":null,\"next_page\":null},\"status_code\":200,\"status_message\":\"OK\",\"status_cat\":\"https://http.cat/200\",\"request_method\":\"GET\",\"request_id\":\"6ef83c13-5576-4504-b65d-c269549274a0\",\"parameters\":{\"updated_since\":\"2021-02-24 15:14:56 -05:00\",\"page\":\"1\",\"facility_id\":\"8eaa0984-0aad-47bb-97a3-b74519555556\"}}",
    "response_time": 0.09047508239746094,
    "status_code": 200,
    "target_resource": "gate_codes",
    "time_to_live": 1622008947
}

schema_attributes:

{
    "client_application_id": "string",
    "client_application_name": "string",
    "company_id": "string",
    "company_name": "string",
    "controller_action": "string",
    "created_at": "string",
    "created_at_Id": "string",
    "facility_id": "string",
    "facility_name": "string",
    "request_id": "string",
    "request_path": "string",
    "response_meta": "string",
    "response_time": "string",
    "status_code": "string",
    "target_resource": "string",
    "time_to_live": "string"
}

schema_name_id: 1452
schema_scan_id: 5759332
updated: 2021-02-25 13:08:00

Version 4676118

created: 2020-02-05 05:01:01

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_dynamodb`",
    "DROP TABLE IF EXISTS `sfdl_dev_dynamodb.storedgeapirequests_api_requests`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_dynamodb.storedgeapirequests_api_requests`\n(\n`response_time`STRING,`facility_name`STRING,`company_id`STRING,`facility_id`STRING,`target_resource`STRING,`created_at`STRING,`company_name`STRING,`controller_action`STRING,`client_application_name`STRING,`status_code`STRING,`response_meta`STRING,`request_path`STRING,`created_at_Id`STRING,`client_application_id`STRING,`time_to_live`STRING,`request_id`STRING\n)\nPARTITIONED BY (dt string)\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-dynamodb-storedgeapirequests-dev/separated_dt/api_requests'\n",
    "MSCK REPAIR TABLE sfdl_dev_dynamodb.storedgeapirequests_api_requests"
]

hive_path: s3://sfdl-dynamodb-storedgeapirequests-dev/separated_dt/api_requests
id: 4676118
processed: 1

raw_data:

{
    "client_application_id": 10754,
    "client_application_name": "95-98 storage, llc gate application",
    "company_id": 10439,
    "company_name": "95-98 storage, llc",
    "controller_action": "index",
    "created_at": "2020-02-04T07:20:39-06:00",
    "created_at_Id": "2020-02-04T07:20:39-06:00_3f955be0-a56e-45ab-a121-079fea34be6b",
    "facility_id": 54350,
    "facility_name": "95-98 storage ",
    "request_id": "3f955be0-a56e-45ab-a121-079fea34be6b",
    "request_path": "/v1/851a5216-340b-4014-b9e1-2c0f84f622cf/gate_codes.json?page=1",
    "response_meta": "{\"configuration\":{\"gate_provider_name\":\"doorking\",\"gate_provider_dump_path\":\"C:\\\\Program Files (x86)\\\\DoorKing\\\\DoorKing Account Manager\",\"gate_provider_dump_file_name\":\"Doorking32.exe.csv\",\"gate_provider_consume_file_name\":\"Doorking32.exe\",\"auto_generate_gate_code\":false,\"prefix_gate_code_with_unit_number\":false,\"minimum_gate_code_length\":1,\"maximum_gate_code_length\":5,\"minimum_gate_code_value\":1,\"maximum_gate_code_value\":65000,\"multiple_facilities_supported\":true,\"gate_lockout_account_balance\":0.0,\"gate_time_zone\":null,\"gate_keypad_zone\":null,\"gate_security_level\":1,\"gate_account_name\":\"Doorking32.exe\",\"gate_provider_run_inline\":false,\"gate_panel_id\":null},\"pagination\":{\"current_page\":1,\"total_pages\":1,\"per_page\":91,\"total_entries\":91,\"previous_page\":null,\"next_page\":null},\"status_code\":200,\"status_message\":\"OK\",\"status_cat\":\"https://http.cat/200\",\"request_method\":\"GET\",\"request_id\":\"5f4138d0-798c-48e7-a38a-c68393a65603\",\"parameters\":{\"page\":\"1\",\"facility_id\":\"851a5216-340b-4014-b9e1-2c0f84f622cf\"}}",
    "response_time": 0.3749392032623291,
    "status_code": 200,
    "target_resource": "gate_codes",
    "time_to_live": 1588598439
}

schema_attributes:

{
    "client_application_id": "string",
    "client_application_name": "string",
    "company_id": "string",
    "company_name": "string",
    "controller_action": "string",
    "created_at": "string",
    "created_at_Id": "string",
    "facility_id": "string",
    "facility_name": "string",
    "request_id": "string",
    "request_path": "string",
    "response_meta": "string",
    "response_time": "string",
    "status_code": "string",
    "target_resource": "string",
    "time_to_live": "string"
}

schema_name_id: 1452
schema_scan_id: 5414436
updated: 2020-02-05 05:02:08

Version 4675914

created: 2020-01-14 11:07:35

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_dynamodb`",
    "DROP TABLE IF EXISTS `sfdl_dev_dynamodb.storedgeapirequests_api_requests`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_dynamodb.storedgeapirequests_api_requests`\n(\n`company_name`STRING,`controller_action`STRING,`facility_name`STRING,`created_at_Id`STRING,`request_id`STRING,`company_id`STRING,`facility_id`STRING,`client_application_id`STRING,`request_path`STRING,`target_resource`STRING,`time_to_live`STRING,`response_time`STRING,`response_meta`STRING,`created_at`STRING,`status_code`STRING\n)\nPARTITIONED BY (dt string)\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-dynamodb-storedgeapirequests-dev/separated_dt/api_requests'\n",
    "MSCK REPAIR TABLE sfdl_dev_dynamodb.storedgeapirequests_api_requests"
]

hive_path: s3://sfdl-dynamodb-storedgeapirequests-dev/separated_dt/api_requests
id: 4675914
processed: 1

raw_data:

{
    "client_application_id": 6431,
    "company_id": 6281,
    "company_name": "eagle self storage",
    "controller_action": "index",
    "created_at": "2020-01-13T00:01:37-06:00",
    "created_at_Id": "2020-01-13T00:01:37-06:00_404ff6a5-e46c-4760-b1c0-47e4ce415f6c",
    "facility_id": 27125,
    "facility_name": "eagle self storage - macon",
    "request_id": "404ff6a5-e46c-4760-b1c0-47e4ce415f6c",
    "request_path": "/v1/de85ffb8-a776-48d0-a5d4-de78c64a02b7/gate_codes.json?updated_since=2020-01-11%2010%3a21%3a02%20-05%3a00&page=1",
    "response_meta": "{\"configuration\":{\"gate_provider_name\":\"digigate\",\"gate_provider_dump_path\":\"C:\\\\digi\",\"gate_provider_dump_file_name\":\"link.fil\",\"gate_provider_consume_file_name\":\"digisend.exe\",\"auto_generate_gate_code\":false,\"prefix_gate_code_with_unit_number\":false,\"minimum_gate_code_length\":4,\"maximum_gate_code_length\":10,\"minimum_gate_code_value\":1000,\"maximum_gate_code_value\":9999999999,\"multiple_facilities_supported\":false,\"gate_lockout_account_balance\":0.0,\"gate_time_zone\":0,\"gate_keypad_zone\":0,\"gate_security_level\":null,\"gate_account_name\":null,\"gate_provider_run_inline\":false,\"gate_panel_id\":null},\"pagination\":{\"current_page\":1,\"total_pages\":1,\"per_page\":0,\"total_entries\":0,\"previous_page\":null,\"next_page\":null},\"status_message\":\"OK\",\"status_cat\":\"https://http.cat/200\",\"request_method\":\"GET\",\"parameters\":{\"updated_since\":\"2020-01-11 10:21:02 -05:00\",\"page\":\"1\",\"facility_id\":\"de85ffb8-a776-48d0-a5d4-de78c64a02b7\"}}",
    "response_time": 0.07404208183288574,
    "status_code": 200,
    "target_resource": "gate_codes",
    "time_to_live": 1586671297
}

schema_attributes:

{
    "client_application_id": "string",
    "company_id": "string",
    "company_name": "string",
    "controller_action": "string",
    "created_at": "string",
    "created_at_Id": "string",
    "facility_id": "string",
    "facility_name": "string",
    "request_id": "string",
    "request_path": "string",
    "response_meta": "string",
    "response_time": "string",
    "status_code": "string",
    "target_resource": "string",
    "time_to_live": "string"
}

schema_name_id: 1452
schema_scan_id: 5372701
updated: 2020-01-14 11:07:58

Schema Scans: 3

Last at 2021-02-25 13:07:00

Scan 5759332

duration: 0:01:02.275706

exit_message:

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

id: 5759332

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "partition": {
        "location": "s3://sfdl-dynamodb-storedgeapirequests-dev/raw_incremental/api_requests/dt=2021-02-25",
        "name": "dt",
        "type": "string",
        "value": "2021-02-25"
    },
    "s3": {
        "bucket": "sfdl-dynamodb-storedgeapirequests-dev",
        "hive_path": "s3://sfdl-dynamodb-storedgeapirequests-dev/raw_incremental/api_requests",
        "key": "raw_incremental/api_requests/dt=2021-02-25/api_requests_0.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_dynamodb.storedgeapirequests_api_requests",
        "type": "dynamodb"
    }
}

running: False
schema_name_id: 1452
start_time: 2021-02-25 13:07:00
success: True
trace_id: 12835859454171709014

Scan 5414436

duration: 0:00:29.182966

exit_message:

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

id: 5414436

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "partition": {
        "location": "s3://sfdl-dynamodb-storedgeapirequests-dev/separated_dt/api_requests/dt=2020-02-04/",
        "name": "dt",
        "type": "string",
        "value": "2020-02-04"
    },
    "s3": {
        "bucket": "sfdl-dynamodb-storedgeapirequests-dev",
        "hive_path": "s3://sfdl-dynamodb-storedgeapirequests-dev/separated_dt/api_requests",
        "key": "separated_dt/api_requests/dt=2020-02-04/api_request_22_0.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_dynamodb.storedgeapirequests_api_requests",
        "type": "dynamodb"
    }
}

running: False
schema_name_id: 1452
start_time: 2020-02-05 05:01:01
success: True
trace_id: 12882550087143958421

Scan 5372701

duration: 0:00:16.741120

exit_message:

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

id: 5372701

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "partition": {
        "location": "s3://sfdl-dynamodb-storedgeapirequests-dev/separated_dt/api_requests/dt=2020-01-13/",
        "name": "dt",
        "type": "string",
        "value": "2020-01-13"
    },
    "s3": {
        "bucket": "sfdl-dynamodb-storedgeapirequests-dev",
        "hive_path": "s3://sfdl-dynamodb-storedgeapirequests-dev/separated_dt/api_requests",
        "key": "separated_dt/api_requests/dt=2020-01-13/api_request_13.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_dynamodb.storedgeapirequests_api_requests",
        "type": "dynamodb"
    }
}

running: False
schema_name_id: 1452
start_time: 2020-01-14 11:07:35
success: True
trace_id: 18025570782274369743

Partitions:

count: 3

ddl:

[
    "ALTER TABLE\n    `sfdl_dev_dynamodb.storedgeapirequests_api_requests`\nADD\n\n\n PARTITION (dt='2021-03-30') location 's3://sfdl-dynamodb-storedgeapirequests-dev/raw_incremental/api_requests/dt=2021-03-30/'\n PARTITION (dt='2021-03-31') location 's3://sfdl-dynamodb-storedgeapirequests-dev/raw_incremental/api_requests/dt=2021-03-31/'\n PARTITION (dt='2021-04-01') location 's3://sfdl-dynamodb-storedgeapirequests-dev/raw_incremental/api_requests/dt=2021-04-01/'\n;"
]

name: dt

state:

[
    {
        "info": {
            "id": 172817,
            "location": "s3://sfdl-dynamodb-storedgeapirequests-dev/raw_incremental/api_requests/dt=2021-03-30/",
            "name": "dt",
            "value": "2021-03-30"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2021-03-31 09:08:43",
                "last_data": "2021-03-31 09:08:43"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 172850,
            "location": "s3://sfdl-dynamodb-storedgeapirequests-dev/raw_incremental/api_requests/dt=2021-03-31/",
            "name": "dt",
            "value": "2021-03-31"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2021-04-01 09:09:08",
                "last_data": "2021-04-01 09:09:08"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 172887,
            "location": "s3://sfdl-dynamodb-storedgeapirequests-dev/raw_incremental/api_requests/dt=2021-04-01/",
            "name": "dt",
            "value": "2021-04-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2021-04-02 09:11:18",
                "last_data": "2021-04-02 09:11:18"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    }
]

type: string

Schema:

attributes:

{
    "client_application_id": "string",
    "client_application_name": "string",
    "company_id": "string",
    "company_name": "string",
    "controller_action": "string",
    "created_at": "string",
    "created_at_Id": "string",
    "facility_id": "string",
    "facility_name": "string",
    "request_id": "string",
    "request_path": "string",
    "response_meta": "string",
    "response_time": "string",
    "status_code": "string",
    "target_resource": "string",
    "time_to_live": "string"
}

created: 2021-02-25 13:07:48

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_dynamodb`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_dynamodb.storedgeapirequests_api_requests`\n(\n`request_id`STRING,`facility_id`STRING,`created_at_Id`STRING,`status_code`STRING,`client_application_id`STRING,`controller_action`STRING,`company_id`STRING,`company_name`STRING,`created_at`STRING,`response_meta`STRING,`request_path`STRING,`response_time`STRING,`time_to_live`STRING,`facility_name`STRING,`target_resource`STRING,`client_application_name`STRING\n)\nPARTITIONED BY (dt string)\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-dynamodb-storedgeapirequests-dev/raw_incremental/api_requests'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_dynamodb.storedgeapirequests_api_requests`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_dynamodb.storedgeapirequests_api_requests"
}

Server:

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

Raw:

{
    "name": {
        "created": "2019-12-07 05:01:59",
        "disabled": false,
        "format": "raw",
        "id": 1452,
        "is_partitioned": true,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_dev_dynamodb",
            "table": "storedgeapirequests_api_requests"
        },
        "type": "dynamodb"
    },
    "partition": {
        "count": 3,
        "ddl": [
            "ALTER TABLE\n    `sfdl_dev_dynamodb.storedgeapirequests_api_requests`\nADD\n\n\n PARTITION (dt='2021-03-30') location 's3://sfdl-dynamodb-storedgeapirequests-dev/raw_incremental/api_requests/dt=2021-03-30/'\n PARTITION (dt='2021-03-31') location 's3://sfdl-dynamodb-storedgeapirequests-dev/raw_incremental/api_requests/dt=2021-03-31/'\n PARTITION (dt='2021-04-01') location 's3://sfdl-dynamodb-storedgeapirequests-dev/raw_incremental/api_requests/dt=2021-04-01/'\n;"
        ],
        "name": "dt",
        "state": [
            {
                "info": {
                    "id": 172817,
                    "location": "s3://sfdl-dynamodb-storedgeapirequests-dev/raw_incremental/api_requests/dt=2021-03-30/",
                    "name": "dt",
                    "value": "2021-03-30"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2021-03-31 09:08:43",
                        "last_data": "2021-03-31 09:08:43"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 172850,
                    "location": "s3://sfdl-dynamodb-storedgeapirequests-dev/raw_incremental/api_requests/dt=2021-03-31/",
                    "name": "dt",
                    "value": "2021-03-31"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2021-04-01 09:09:08",
                        "last_data": "2021-04-01 09:09:08"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 172887,
                    "location": "s3://sfdl-dynamodb-storedgeapirequests-dev/raw_incremental/api_requests/dt=2021-04-01/",
                    "name": "dt",
                    "value": "2021-04-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2021-04-02 09:11:18",
                        "last_data": "2021-04-02 09:11:18"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            }
        ],
        "type": "string"
    },
    "schema": {
        "attributes": {
            "client_application_id": "string",
            "client_application_name": "string",
            "company_id": "string",
            "company_name": "string",
            "controller_action": "string",
            "created_at": "string",
            "created_at_Id": "string",
            "facility_id": "string",
            "facility_name": "string",
            "request_id": "string",
            "request_path": "string",
            "response_meta": "string",
            "response_time": "string",
            "status_code": "string",
            "target_resource": "string",
            "time_to_live": "string"
        },
        "created": "2021-02-25 13:07:48",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_dynamodb`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_dynamodb.storedgeapirequests_api_requests`\n(\n`request_id`STRING,`facility_id`STRING,`created_at_Id`STRING,`status_code`STRING,`client_application_id`STRING,`controller_action`STRING,`company_id`STRING,`company_name`STRING,`created_at`STRING,`response_meta`STRING,`request_path`STRING,`response_time`STRING,`time_to_live`STRING,`facility_name`STRING,`target_resource`STRING,`client_application_name`STRING\n)\nPARTITIONED BY (dt string)\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-dynamodb-storedgeapirequests-dev/raw_incremental/api_requests'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_dynamodb.storedgeapirequests_api_requests`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_dynamodb.storedgeapirequests_api_requests"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}