Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbooksecurity_areas_linked

created: 2024-10-08 18:27:51
disabled: False
format: raw
id: 2988
is_partitioned: False
is_schema_datatyped: True

name:

{
    "database": "sfdl_dev_drivethru",
    "table": "newbookdev_newbooksecurity_areas_linked"
}

type: drivethrucsv

Schema Versions: 15

Version 4749416

created: 2024-11-05 23:48:31

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooksecurity_areas_linked`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooksecurity_areas_linked`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `security_area_id`  string , `security_gate_id`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooksecurity_areas_linked/2024-11-05/1730866597'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooksecurity_areas_linked"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooksecurity_areas_linked/2024-11-05/1730866597
id: 4749416
processed: 1

raw_data:

{
    "active": 5,
    "id": 2,
    "newbook_region": 0,
    "security_area_id": 3,
    "security_gate_id": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "newbook_region": "string",
    "security_area_id": "string",
    "security_gate_id": "string",
    "tenant": "string"
}

schema_name_id: 2988
schema_scan_id: 6675459
updated: 2024-11-05 23:48:42

Version 4749100

created: 2024-11-05 23:20:17

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooksecurity_areas_linked`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooksecurity_areas_linked`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `security_area_id`  string , `security_gate_id`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooksecurity_areas_linked/2024-11-05/1730866539'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooksecurity_areas_linked"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooksecurity_areas_linked/2024-11-05/1730866539
id: 4749100
processed: 1

raw_data:

{
    "active": 5,
    "id": 2,
    "newbook_region": 0,
    "security_area_id": 3,
    "security_gate_id": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "newbook_region": "string",
    "security_area_id": "string",
    "security_gate_id": "string",
    "tenant": "string"
}

schema_name_id: 2988
schema_scan_id: 6675132
updated: 2024-11-05 23:20:28

Version 4748373

created: 2024-11-05 22:44:01

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooksecurity_areas_linked`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooksecurity_areas_linked`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `security_area_id`  string , `security_gate_id`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooksecurity_areas_linked/2024-11-05/1730866425'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooksecurity_areas_linked"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooksecurity_areas_linked/2024-11-05/1730866425
id: 4748373
processed: 1

raw_data:

{
    "active": 5,
    "id": 2,
    "newbook_region": 0,
    "security_area_id": 3,
    "security_gate_id": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "newbook_region": "string",
    "security_area_id": "string",
    "security_gate_id": "string",
    "tenant": "string"
}

schema_name_id: 2988
schema_scan_id: 6674406
updated: 2024-11-05 22:44:12

Version 4747029

created: 2024-11-05 04:42:44

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooksecurity_areas_linked`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooksecurity_areas_linked`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `security_area_id`  string , `security_gate_id`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooksecurity_areas_linked/2024-11-04/1730785790'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooksecurity_areas_linked"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooksecurity_areas_linked/2024-11-04/1730785790
id: 4747029
processed: 1

raw_data:

{
    "active": 5,
    "id": 2,
    "newbook_region": 0,
    "security_area_id": 3,
    "security_gate_id": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "newbook_region": "string",
    "security_area_id": "string",
    "security_gate_id": "string",
    "tenant": "string"
}

schema_name_id: 2988
schema_scan_id: 6672261
updated: 2024-11-05 04:42:55

Version 4746439

created: 2024-11-05 04:03:08

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooksecurity_areas_linked`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooksecurity_areas_linked`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `security_area_id`  string , `security_gate_id`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooksecurity_areas_linked/2024-11-04/1730785163'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooksecurity_areas_linked"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooksecurity_areas_linked/2024-11-04/1730785163
id: 4746439
processed: 1

raw_data:

{
    "active": 5,
    "id": 2,
    "newbook_region": 0,
    "security_area_id": 3,
    "security_gate_id": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "newbook_region": "string",
    "security_area_id": "string",
    "security_gate_id": "string",
    "tenant": "string"
}

schema_name_id: 2988
schema_scan_id: 6671660
updated: 2024-11-05 04:03:21

Version 4745723

created: 2024-11-05 03:36:58

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooksecurity_areas_linked`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooksecurity_areas_linked`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `security_area_id`  string , `security_gate_id`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooksecurity_areas_linked/2024-11-04/1730784858'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooksecurity_areas_linked"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooksecurity_areas_linked/2024-11-04/1730784858
id: 4745723
processed: 1

raw_data:

{
    "active": 5,
    "id": 2,
    "newbook_region": 0,
    "security_area_id": 3,
    "security_gate_id": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "newbook_region": "string",
    "security_area_id": "string",
    "security_gate_id": "string",
    "tenant": "string"
}

schema_name_id: 2988
schema_scan_id: 6670940
updated: 2024-11-05 03:37:11

Version 4744306

created: 2024-11-05 02:59:23

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooksecurity_areas_linked`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooksecurity_areas_linked`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `security_area_id`  string , `security_gate_id`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooksecurity_areas_linked/2024-11-04/1730784255'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooksecurity_areas_linked"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooksecurity_areas_linked/2024-11-04/1730784255
id: 4744306
processed: 1

raw_data:

{
    "active": 5,
    "id": 2,
    "newbook_region": 0,
    "security_area_id": 3,
    "security_gate_id": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "newbook_region": "string",
    "security_area_id": "string",
    "security_gate_id": "string",
    "tenant": "string"
}

schema_name_id: 2988
schema_scan_id: 6669523
updated: 2024-11-05 02:59:34

Version 4744121

created: 2024-11-05 02:54:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooksecurity_areas_linked`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooksecurity_areas_linked`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `security_area_id`  string , `security_gate_id`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooksecurity_areas_linked/2024-11-04/1730784092'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooksecurity_areas_linked"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooksecurity_areas_linked/2024-11-04/1730784092
id: 4744121
processed: 1

raw_data:

{
    "active": 5,
    "id": 2,
    "newbook_region": 0,
    "security_area_id": 3,
    "security_gate_id": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "newbook_region": "string",
    "security_area_id": "string",
    "security_gate_id": "string",
    "tenant": "string"
}

schema_name_id: 2988
schema_scan_id: 6669338
updated: 2024-11-05 02:54:45

Version 4743502

created: 2024-11-05 02:38:19

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooksecurity_areas_linked`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooksecurity_areas_linked`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `security_area_id`  string , `security_gate_id`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooksecurity_areas_linked/2024-11-04/1730783929'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooksecurity_areas_linked"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooksecurity_areas_linked/2024-11-04/1730783929
id: 4743502
processed: 1

raw_data:

{
    "active": 5,
    "id": 2,
    "newbook_region": 0,
    "security_area_id": 3,
    "security_gate_id": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "newbook_region": "string",
    "security_area_id": "string",
    "security_gate_id": "string",
    "tenant": "string"
}

schema_name_id: 2988
schema_scan_id: 6668719
updated: 2024-11-05 02:38:32

Version 4742950

created: 2024-11-05 02:23:42

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooksecurity_areas_linked`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooksecurity_areas_linked`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `security_area_id`  string , `security_gate_id`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooksecurity_areas_linked/2024-11-04/1730783806'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooksecurity_areas_linked"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooksecurity_areas_linked/2024-11-04/1730783806
id: 4742950
processed: 1

raw_data:

{
    "active": 5,
    "id": 2,
    "newbook_region": 0,
    "security_area_id": 3,
    "security_gate_id": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "newbook_region": "string",
    "security_area_id": "string",
    "security_gate_id": "string",
    "tenant": "string"
}

schema_name_id: 2988
schema_scan_id: 6668167
updated: 2024-11-05 02:23:55

Version 4742204

created: 2024-11-05 02:03:56

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooksecurity_areas_linked`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooksecurity_areas_linked`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `security_area_id`  string , `security_gate_id`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooksecurity_areas_linked/2024-11-04/1730783694'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooksecurity_areas_linked"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooksecurity_areas_linked/2024-11-04/1730783694
id: 4742204
processed: 1

raw_data:

{
    "active": 5,
    "id": 2,
    "newbook_region": 0,
    "security_area_id": 3,
    "security_gate_id": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "newbook_region": "string",
    "security_area_id": "string",
    "security_gate_id": "string",
    "tenant": "string"
}

schema_name_id: 2988
schema_scan_id: 6667421
updated: 2024-11-05 02:04:07

Version 4740894

created: 2024-11-05 01:29:16

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooksecurity_areas_linked`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooksecurity_areas_linked`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `security_area_id`  string , `security_gate_id`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooksecurity_areas_linked/2024-11-04/1730783563'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooksecurity_areas_linked"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooksecurity_areas_linked/2024-11-04/1730783563
id: 4740894
processed: 1

raw_data:

{
    "active": 5,
    "id": 2,
    "newbook_region": 0,
    "security_area_id": 3,
    "security_gate_id": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "newbook_region": "string",
    "security_area_id": "string",
    "security_gate_id": "string",
    "tenant": "string"
}

schema_name_id: 2988
schema_scan_id: 6666111
updated: 2024-11-05 01:29:29

Version 4740209

created: 2024-11-05 01:11:16

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooksecurity_areas_linked`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooksecurity_areas_linked`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `security_area_id`  string , `security_gate_id`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooksecurity_areas_linked/2024-11-04/1730783345'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooksecurity_areas_linked"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooksecurity_areas_linked/2024-11-04/1730783345
id: 4740209
processed: 1

raw_data:

{
    "active": 5,
    "id": 2,
    "newbook_region": 0,
    "security_area_id": 3,
    "security_gate_id": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "newbook_region": "string",
    "security_area_id": "string",
    "security_gate_id": "string",
    "tenant": "string"
}

schema_name_id: 2988
schema_scan_id: 6665426
updated: 2024-11-05 01:11:30

Version 4739858

created: 2024-11-05 01:01:49

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooksecurity_areas_linked`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooksecurity_areas_linked`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `security_area_id`  string , `security_gate_id`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooksecurity_areas_linked/2024-11-04/1730782943'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooksecurity_areas_linked"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooksecurity_areas_linked/2024-11-04/1730782943
id: 4739858
processed: 1

raw_data:

{
    "active": 5,
    "id": 2,
    "newbook_region": 0,
    "security_area_id": 3,
    "security_gate_id": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "newbook_region": "string",
    "security_area_id": "string",
    "security_gate_id": "string",
    "tenant": "string"
}

schema_name_id: 2988
schema_scan_id: 6665076
updated: 2024-11-05 01:02:00

Version 4738423

created: 2024-11-05 00:24:05

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooksecurity_areas_linked`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooksecurity_areas_linked`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `security_area_id`  string , `security_gate_id`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooksecurity_areas_linked/2024-11-04/1730782760'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooksecurity_areas_linked"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooksecurity_areas_linked/2024-11-04/1730782760
id: 4738423
processed: 1

raw_data:

{
    "active": 5,
    "id": 2,
    "newbook_region": 0,
    "security_area_id": 3,
    "security_gate_id": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "newbook_region": "string",
    "security_area_id": "string",
    "security_gate_id": "string",
    "tenant": "string"
}

schema_name_id: 2988
schema_scan_id: 6663636
updated: 2024-11-05 00:24:16

Schema Scans: 15

Last at 2024-11-05 23:48:30

Scan 6675459

duration: 0:00:11.506993

exit_message:

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

id: 6675459

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-dev",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooksecurity_areas_linked/2024-11-05/1730866597",
        "key": "raw/newbookdev_newbooksecurity_areas_linked/2024-11-05/1730866597/security_areas_linked.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooksecurity_areas_linked",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16982376162334335428,
        "service_name": "drive-thru",
        "span_id": 11958530763032206275,
        "trace_id": 5027645843380635745
    }
}

running: False
schema_name_id: 2988
start_time: 2024-11-05 23:48:30
success: True
trace_id: 5027645843380635745

Scan 6675132

duration: 0:00:11.532332

exit_message:

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

id: 6675132

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-dev",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooksecurity_areas_linked/2024-11-05/1730866539",
        "key": "raw/newbookdev_newbooksecurity_areas_linked/2024-11-05/1730866539/security_areas_linked.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooksecurity_areas_linked",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5156086470265661737,
        "service_name": "drive-thru",
        "span_id": 8346543098863533149,
        "trace_id": 12410117969653478502
    }
}

running: False
schema_name_id: 2988
start_time: 2024-11-05 23:20:17
success: True
trace_id: 12410117969653478502

Scan 6674406

duration: 0:00:11.475479

exit_message:

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

id: 6674406

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-dev",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooksecurity_areas_linked/2024-11-05/1730866425",
        "key": "raw/newbookdev_newbooksecurity_areas_linked/2024-11-05/1730866425/security_areas_linked.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooksecurity_areas_linked",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15940838760368962209,
        "service_name": "drive-thru",
        "span_id": 16166772148814135222,
        "trace_id": 12841417527119885319
    }
}

running: False
schema_name_id: 2988
start_time: 2024-11-05 22:44:00
success: True
trace_id: 12841417527119885319

Scan 6672261

duration: 0:00:11.483159

exit_message:

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

id: 6672261

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-dev",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooksecurity_areas_linked/2024-11-04/1730785790",
        "key": "raw/newbookdev_newbooksecurity_areas_linked/2024-11-04/1730785790/security_areas_linked.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooksecurity_areas_linked",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13225219166467108429,
        "service_name": "drive-thru",
        "span_id": 1157835589335793222,
        "trace_id": 10421337184755931774
    }
}

running: False
schema_name_id: 2988
start_time: 2024-11-05 04:42:44
success: True
trace_id: 10421337184755931774

Scan 6671660

duration: 0:00:14.030593

exit_message:

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

id: 6671660

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-dev",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooksecurity_areas_linked/2024-11-04/1730785163",
        "key": "raw/newbookdev_newbooksecurity_areas_linked/2024-11-04/1730785163/security_areas_linked.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooksecurity_areas_linked",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9639157736223181100,
        "service_name": "drive-thru",
        "span_id": 2269180499512849105,
        "trace_id": 2805193379573713511
    }
}

running: False
schema_name_id: 2988
start_time: 2024-11-05 04:03:07
success: True
trace_id: 2805193379573713511

Scan 6670940

duration: 0:00:13.931626

exit_message:

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

id: 6670940

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-dev",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooksecurity_areas_linked/2024-11-04/1730784858",
        "key": "raw/newbookdev_newbooksecurity_areas_linked/2024-11-04/1730784858/security_areas_linked.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooksecurity_areas_linked",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18264360263401157171,
        "service_name": "drive-thru",
        "span_id": 13994779025967452472,
        "trace_id": 13490771349741519325
    }
}

running: False
schema_name_id: 2988
start_time: 2024-11-05 03:36:58
success: True
trace_id: 13490771349741519325

Scan 6669523

duration: 0:00:11.346596

exit_message:

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

id: 6669523

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-dev",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooksecurity_areas_linked/2024-11-04/1730784255",
        "key": "raw/newbookdev_newbooksecurity_areas_linked/2024-11-04/1730784255/security_areas_linked.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooksecurity_areas_linked",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7034686640764134017,
        "service_name": "drive-thru",
        "span_id": 6009622509215000177,
        "trace_id": 13002386898550829483
    }
}

running: False
schema_name_id: 2988
start_time: 2024-11-05 02:59:22
success: True
trace_id: 13002386898550829483

Scan 6669338

duration: 0:00:11.423340

exit_message:

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

id: 6669338

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-dev",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooksecurity_areas_linked/2024-11-04/1730784092",
        "key": "raw/newbookdev_newbooksecurity_areas_linked/2024-11-04/1730784092/security_areas_linked.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooksecurity_areas_linked",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15059133652080695436,
        "service_name": "drive-thru",
        "span_id": 3892954612742556885,
        "trace_id": 7979735848844043547
    }
}

running: False
schema_name_id: 2988
start_time: 2024-11-05 02:54:33
success: True
trace_id: 7979735848844043547

Scan 6668719

duration: 0:00:13.938485

exit_message:

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

id: 6668719

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-dev",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooksecurity_areas_linked/2024-11-04/1730783929",
        "key": "raw/newbookdev_newbooksecurity_areas_linked/2024-11-04/1730783929/security_areas_linked.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooksecurity_areas_linked",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 884168444876866579,
        "service_name": "drive-thru",
        "span_id": 7869528247444249536,
        "trace_id": 9076865392137275312
    }
}

running: False
schema_name_id: 2988
start_time: 2024-11-05 02:38:19
success: True
trace_id: 9076865392137275312

Scan 6668167

duration: 0:00:13.825002

exit_message:

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

id: 6668167

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-dev",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooksecurity_areas_linked/2024-11-04/1730783806",
        "key": "raw/newbookdev_newbooksecurity_areas_linked/2024-11-04/1730783806/security_areas_linked.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooksecurity_areas_linked",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13990894991472381710,
        "service_name": "drive-thru",
        "span_id": 7612700038293693049,
        "trace_id": 77753724521920091
    }
}

running: False
schema_name_id: 2988
start_time: 2024-11-05 02:23:41
success: True
trace_id: 77753724521920091

Scan 6667421

duration: 0:00:11.392362

exit_message:

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

id: 6667421

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-dev",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooksecurity_areas_linked/2024-11-04/1730783694",
        "key": "raw/newbookdev_newbooksecurity_areas_linked/2024-11-04/1730783694/security_areas_linked.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooksecurity_areas_linked",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9543499105188440500,
        "service_name": "drive-thru",
        "span_id": 556870179965432662,
        "trace_id": 9751810373443476519
    }
}

running: False
schema_name_id: 2988
start_time: 2024-11-05 02:03:55
success: True
trace_id: 9751810373443476519

Scan 6666111

duration: 0:00:13.965208

exit_message:

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

id: 6666111

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-dev",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooksecurity_areas_linked/2024-11-04/1730783563",
        "key": "raw/newbookdev_newbooksecurity_areas_linked/2024-11-04/1730783563/security_areas_linked.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooksecurity_areas_linked",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5097991470730472167,
        "service_name": "drive-thru",
        "span_id": 1951709165015506985,
        "trace_id": 12594888821117864695
    }
}

running: False
schema_name_id: 2988
start_time: 2024-11-05 01:29:16
success: True
trace_id: 12594888821117864695

Scan 6665426

duration: 0:00:13.859479

exit_message:

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

id: 6665426

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-dev",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooksecurity_areas_linked/2024-11-04/1730783345",
        "key": "raw/newbookdev_newbooksecurity_areas_linked/2024-11-04/1730783345/security_areas_linked.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooksecurity_areas_linked",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11008674962530806548,
        "service_name": "drive-thru",
        "span_id": 4899639276479328284,
        "trace_id": 11468187465826825096
    }
}

running: False
schema_name_id: 2988
start_time: 2024-11-05 01:11:16
success: True
trace_id: 11468187465826825096

Scan 6665076

duration: 0:00:11.447764

exit_message:

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

id: 6665076

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-dev",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooksecurity_areas_linked/2024-11-04/1730782943",
        "key": "raw/newbookdev_newbooksecurity_areas_linked/2024-11-04/1730782943/security_areas_linked.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooksecurity_areas_linked",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4999879217035598165,
        "service_name": "drive-thru",
        "span_id": 6703314421624230309,
        "trace_id": 13367162390917061220
    }
}

running: False
schema_name_id: 2988
start_time: 2024-11-05 01:01:48
success: True
trace_id: 13367162390917061220

Scan 6663636

duration: 0:00:11.246039

exit_message:

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

id: 6663636

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-dev",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooksecurity_areas_linked/2024-11-04/1730782760",
        "key": "raw/newbookdev_newbooksecurity_areas_linked/2024-11-04/1730782760/security_areas_linked.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooksecurity_areas_linked",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 179450258255872871,
        "service_name": "drive-thru",
        "span_id": 12597156102178093793,
        "trace_id": 2076930997874224090
    }
}

running: False
schema_name_id: 2988
start_time: 2024-11-05 00:24:05
success: True
trace_id: 2076930997874224090

Partitions:

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

Schema:

attributes:

{
    "active": "string",
    "id": "string",
    "newbook_region": "string",
    "security_area_id": "string",
    "security_gate_id": "string",
    "tenant": "string"
}

created: 2024-11-05 23:48:31

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooksecurity_areas_linked`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `security_area_id`  string , `security_gate_id`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooksecurity_areas_linked/2024-11-05/1730866597'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooksecurity_areas_linked`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooksecurity_areas_linked"
}

Server:

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

Raw:

{
    "name": {
        "created": "2024-10-08 18:27:51",
        "disabled": false,
        "format": "raw",
        "id": 2988,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "newbookdev_newbooksecurity_areas_linked"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "active": "string",
            "id": "string",
            "newbook_region": "string",
            "security_area_id": "string",
            "security_gate_id": "string",
            "tenant": "string"
        },
        "created": "2024-11-05 23:48:31",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooksecurity_areas_linked`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `security_area_id`  string , `security_gate_id`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooksecurity_areas_linked/2024-11-05/1730866597'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooksecurity_areas_linked`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooksecurity_areas_linked"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}