Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookcharters_ports

created: 2024-10-08 17:42:23
disabled: False
format: raw
id: 2483
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4748139

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcharters_ports`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcharters_ports`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `hub_port`  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_newbookcharters_ports/2024-11-05/1730866404'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcharters_ports"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcharters_ports/2024-11-05/1730866404
id: 4748139
processed: 1

raw_data:

{
    "active": 5,
    "hub_port": 4,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "hub_port": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2483
schema_scan_id: 6674172
updated: 2024-11-05 22:36:13

Version 4747899

created: 2024-11-05 22:28:53

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcharters_ports`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcharters_ports`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `hub_port`  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_newbookcharters_ports/2024-11-05/1730866330'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcharters_ports"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcharters_ports/2024-11-05/1730866330
id: 4747899
processed: 1

raw_data:

{
    "active": 5,
    "hub_port": 4,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "hub_port": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2483
schema_scan_id: 6673931
updated: 2024-11-05 22:29:04

Version 4747480

created: 2024-11-05 22:17:57

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcharters_ports`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcharters_ports`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `hub_port`  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_newbookcharters_ports/2024-11-05/1730866249'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcharters_ports"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcharters_ports/2024-11-05/1730866249
id: 4747480
processed: 1

raw_data:

{
    "active": 5,
    "hub_port": 4,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "hub_port": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2483
schema_scan_id: 6673513
updated: 2024-11-05 22:18:08

Version 4746745

created: 2024-11-05 04:20:11

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcharters_ports`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcharters_ports`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `hub_port`  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_newbookcharters_ports/2024-11-04/1730785668'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcharters_ports"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcharters_ports/2024-11-04/1730785668
id: 4746745
processed: 1

raw_data:

{
    "active": 5,
    "hub_port": 4,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "hub_port": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2483
schema_scan_id: 6671970
updated: 2024-11-05 04:20:22

Version 4745904

created: 2024-11-05 03:42:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcharters_ports`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcharters_ports`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `hub_port`  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_newbookcharters_ports/2024-11-04/1730785093'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcharters_ports"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcharters_ports/2024-11-04/1730785093
id: 4745904
processed: 1

raw_data:

{
    "active": 5,
    "hub_port": 4,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "hub_port": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2483
schema_scan_id: 6671123
updated: 2024-11-05 03:42:43

Version 4745127

created: 2024-11-05 03:21:17

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcharters_ports`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcharters_ports`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `hub_port`  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_newbookcharters_ports/2024-11-04/1730784788'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcharters_ports"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcharters_ports/2024-11-04/1730784788
id: 4745127
processed: 1

raw_data:

{
    "active": 5,
    "hub_port": 4,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "hub_port": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2483
schema_scan_id: 6670344
updated: 2024-11-05 03:21:28

Version 4744739

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcharters_ports`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcharters_ports`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `hub_port`  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_newbookcharters_ports/2024-11-04/1730784184'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcharters_ports"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcharters_ports/2024-11-04/1730784184
id: 4744739
processed: 1

raw_data:

{
    "active": 5,
    "hub_port": 4,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "hub_port": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2483
schema_scan_id: 6669956
updated: 2024-11-05 03:11:19

Version 4743144

created: 2024-11-05 02:28:48

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcharters_ports`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcharters_ports`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `hub_port`  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_newbookcharters_ports/2024-11-04/1730784022'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcharters_ports"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcharters_ports/2024-11-04/1730784022
id: 4743144
processed: 1

raw_data:

{
    "active": 5,
    "hub_port": 4,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "hub_port": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2483
schema_scan_id: 6668363
updated: 2024-11-05 02:29:02

Version 4742561

created: 2024-11-05 02:13:29

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcharters_ports`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcharters_ports`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `hub_port`  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_newbookcharters_ports/2024-11-04/1730783875'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcharters_ports"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcharters_ports/2024-11-04/1730783875
id: 4742561
processed: 1

raw_data:

{
    "active": 5,
    "hub_port": 4,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "hub_port": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2483
schema_scan_id: 6667778
updated: 2024-11-05 02:13:40

Version 4742245

created: 2024-11-05 02:05:01

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcharters_ports`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcharters_ports`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `hub_port`  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_newbookcharters_ports/2024-11-04/1730783735'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcharters_ports"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcharters_ports/2024-11-04/1730783735
id: 4742245
processed: 1

raw_data:

{
    "active": 5,
    "hub_port": 4,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "hub_port": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2483
schema_scan_id: 6667462
updated: 2024-11-05 02:05:12

Version 4741860

created: 2024-11-05 01:54:43

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcharters_ports`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcharters_ports`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `hub_port`  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_newbookcharters_ports/2024-11-04/1730783641'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcharters_ports"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcharters_ports/2024-11-04/1730783641
id: 4741860
processed: 1

raw_data:

{
    "active": 5,
    "hub_port": 4,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "hub_port": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2483
schema_scan_id: 6667077
updated: 2024-11-05 01:54:56

Version 4740953

created: 2024-11-05 01:30:50

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcharters_ports`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcharters_ports`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `hub_port`  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_newbookcharters_ports/2024-11-04/1730783491'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcharters_ports"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcharters_ports/2024-11-04/1730783491
id: 4740953
processed: 1

raw_data:

{
    "active": 5,
    "hub_port": 4,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "hub_port": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2483
schema_scan_id: 6666170
updated: 2024-11-05 01:31:04

Version 4740122

created: 2024-11-05 01:08:57

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcharters_ports`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcharters_ports`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `hub_port`  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_newbookcharters_ports/2024-11-04/1730783272'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcharters_ports"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcharters_ports/2024-11-04/1730783272
id: 4740122
processed: 1

raw_data:

{
    "active": 5,
    "hub_port": 4,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "hub_port": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2483
schema_scan_id: 6665339
updated: 2024-11-05 01:09:11

Version 4739124

created: 2024-11-05 00:42:29

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcharters_ports`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcharters_ports`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `hub_port`  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_newbookcharters_ports/2024-11-04/1730782874'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcharters_ports"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcharters_ports/2024-11-04/1730782874
id: 4739124
processed: 1

raw_data:

{
    "active": 5,
    "hub_port": 4,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "hub_port": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2483
schema_scan_id: 6664339
updated: 2024-11-05 00:42:40

Version 4738435

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcharters_ports`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcharters_ports`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `hub_port`  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_newbookcharters_ports/2024-11-04/1730782742'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcharters_ports"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcharters_ports/2024-11-04/1730782742
id: 4738435
processed: 1

raw_data:

{
    "active": 5,
    "hub_port": 4,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "hub_port": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2483
schema_scan_id: 6663646
updated: 2024-11-05 00:24:37

Schema Scans: 15

Last at 2024-11-05 22:36:02

Scan 6674172

duration: 0:00:11.347451

exit_message:

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

id: 6674172

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_newbookcharters_ports/2024-11-05/1730866404",
        "key": "raw/newbookdev_newbookcharters_ports/2024-11-05/1730866404/charters_ports.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcharters_ports",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12919728776849546454,
        "service_name": "drive-thru",
        "span_id": 3923867978688808500,
        "trace_id": 13053343700121423022
    }
}

running: False
schema_name_id: 2483
start_time: 2024-11-05 22:36:02
success: True
trace_id: 13053343700121423022

Scan 6673931

duration: 0:00:11.477830

exit_message:

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

id: 6673931

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_newbookcharters_ports/2024-11-05/1730866330",
        "key": "raw/newbookdev_newbookcharters_ports/2024-11-05/1730866330/charters_ports.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcharters_ports",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9670689114764508720,
        "service_name": "drive-thru",
        "span_id": 13678572819182426295,
        "trace_id": 8015249786990516896
    }
}

running: False
schema_name_id: 2483
start_time: 2024-11-05 22:28:52
success: True
trace_id: 8015249786990516896

Scan 6673513

duration: 0:00:11.325778

exit_message:

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

id: 6673513

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_newbookcharters_ports/2024-11-05/1730866249",
        "key": "raw/newbookdev_newbookcharters_ports/2024-11-05/1730866249/charters_ports.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcharters_ports",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16266572353396171263,
        "service_name": "drive-thru",
        "span_id": 10581288539592892253,
        "trace_id": 16674993150631393204
    }
}

running: False
schema_name_id: 2483
start_time: 2024-11-05 22:17:57
success: True
trace_id: 16674993150631393204

Scan 6671970

duration: 0:00:11.530489

exit_message:

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

id: 6671970

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_newbookcharters_ports/2024-11-04/1730785668",
        "key": "raw/newbookdev_newbookcharters_ports/2024-11-04/1730785668/charters_ports.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcharters_ports",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12898962137094421211,
        "service_name": "drive-thru",
        "span_id": 11906173992792829332,
        "trace_id": 251948465905539823
    }
}

running: False
schema_name_id: 2483
start_time: 2024-11-05 04:20:10
success: True
trace_id: 251948465905539823

Scan 6671123

duration: 0:00:11.436871

exit_message:

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

id: 6671123

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_newbookcharters_ports/2024-11-04/1730785093",
        "key": "raw/newbookdev_newbookcharters_ports/2024-11-04/1730785093/charters_ports.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcharters_ports",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10872037250489375642,
        "service_name": "drive-thru",
        "span_id": 3150631470415215507,
        "trace_id": 11064986688125885895
    }
}

running: False
schema_name_id: 2483
start_time: 2024-11-05 03:42:32
success: True
trace_id: 11064986688125885895

Scan 6670344

duration: 0:00:11.258444

exit_message:

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

id: 6670344

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_newbookcharters_ports/2024-11-04/1730784788",
        "key": "raw/newbookdev_newbookcharters_ports/2024-11-04/1730784788/charters_ports.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcharters_ports",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 122448526709645917,
        "service_name": "drive-thru",
        "span_id": 11947568715766427041,
        "trace_id": 17591567614966255727
    }
}

running: False
schema_name_id: 2483
start_time: 2024-11-05 03:21:17
success: True
trace_id: 17591567614966255727

Scan 6669956

duration: 0:00:11.148321

exit_message:

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

id: 6669956

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_newbookcharters_ports/2024-11-04/1730784184",
        "key": "raw/newbookdev_newbookcharters_ports/2024-11-04/1730784184/charters_ports.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcharters_ports",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14616833549903480067,
        "service_name": "drive-thru",
        "span_id": 11022543845381023490,
        "trace_id": 17055233188513170419
    }
}

running: False
schema_name_id: 2483
start_time: 2024-11-05 03:11:08
success: True
trace_id: 17055233188513170419

Scan 6668363

duration: 0:00:13.908611

exit_message:

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

id: 6668363

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_newbookcharters_ports/2024-11-04/1730784022",
        "key": "raw/newbookdev_newbookcharters_ports/2024-11-04/1730784022/charters_ports.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcharters_ports",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3605352639686014473,
        "service_name": "drive-thru",
        "span_id": 11392201444144161555,
        "trace_id": 3003670562456429844
    }
}

running: False
schema_name_id: 2483
start_time: 2024-11-05 02:28:48
success: True
trace_id: 3003670562456429844

Scan 6667778

duration: 0:00:11.503643

exit_message:

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

id: 6667778

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_newbookcharters_ports/2024-11-04/1730783875",
        "key": "raw/newbookdev_newbookcharters_ports/2024-11-04/1730783875/charters_ports.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcharters_ports",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7878542219701634558,
        "service_name": "drive-thru",
        "span_id": 2072029465461789709,
        "trace_id": 12315833053914543368
    }
}

running: False
schema_name_id: 2483
start_time: 2024-11-05 02:13:29
success: True
trace_id: 12315833053914543368

Scan 6667462

duration: 0:00:11.451275

exit_message:

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

id: 6667462

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_newbookcharters_ports/2024-11-04/1730783735",
        "key": "raw/newbookdev_newbookcharters_ports/2024-11-04/1730783735/charters_ports.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcharters_ports",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18288836172541778997,
        "service_name": "drive-thru",
        "span_id": 56986238028460845,
        "trace_id": 8932940538461619424
    }
}

running: False
schema_name_id: 2483
start_time: 2024-11-05 02:05:01
success: True
trace_id: 8932940538461619424

Scan 6667077

duration: 0:00:13.797255

exit_message:

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

id: 6667077

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_newbookcharters_ports/2024-11-04/1730783641",
        "key": "raw/newbookdev_newbookcharters_ports/2024-11-04/1730783641/charters_ports.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcharters_ports",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6136576389615020598,
        "service_name": "drive-thru",
        "span_id": 16434460806420830382,
        "trace_id": 6900536727551767015
    }
}

running: False
schema_name_id: 2483
start_time: 2024-11-05 01:54:42
success: True
trace_id: 6900536727551767015

Scan 6666170

duration: 0:00:13.829927

exit_message:

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

id: 6666170

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_newbookcharters_ports/2024-11-04/1730783491",
        "key": "raw/newbookdev_newbookcharters_ports/2024-11-04/1730783491/charters_ports.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcharters_ports",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17193486417412545935,
        "service_name": "drive-thru",
        "span_id": 8739704532089170072,
        "trace_id": 55759609631248207
    }
}

running: False
schema_name_id: 2483
start_time: 2024-11-05 01:30:50
success: True
trace_id: 55759609631248207

Scan 6665339

duration: 0:00:13.876377

exit_message:

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

id: 6665339

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_newbookcharters_ports/2024-11-04/1730783272",
        "key": "raw/newbookdev_newbookcharters_ports/2024-11-04/1730783272/charters_ports.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcharters_ports",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11521580598815818674,
        "service_name": "drive-thru",
        "span_id": 852171442178697708,
        "trace_id": 2140571222902243209
    }
}

running: False
schema_name_id: 2483
start_time: 2024-11-05 01:08:57
success: True
trace_id: 2140571222902243209

Scan 6664339

duration: 0:00:11.355334

exit_message:

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

id: 6664339

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_newbookcharters_ports/2024-11-04/1730782874",
        "key": "raw/newbookdev_newbookcharters_ports/2024-11-04/1730782874/charters_ports.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcharters_ports",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16430032543996494519,
        "service_name": "drive-thru",
        "span_id": 1653383284262365812,
        "trace_id": 15703218465358797770
    }
}

running: False
schema_name_id: 2483
start_time: 2024-11-05 00:42:29
success: True
trace_id: 15703218465358797770

Scan 6663646

duration: 0:00:13.937078

exit_message:

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

id: 6663646

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_newbookcharters_ports/2024-11-04/1730782742",
        "key": "raw/newbookdev_newbookcharters_ports/2024-11-04/1730782742/charters_ports.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcharters_ports",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10694896663139005583,
        "service_name": "drive-thru",
        "span_id": 8556953820450075386,
        "trace_id": 6254644122725775916
    }
}

running: False
schema_name_id: 2483
start_time: 2024-11-05 00:24:23
success: True
trace_id: 6254644122725775916

Partitions:

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

Schema:

attributes:

{
    "active": "string",
    "hub_port": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string"
}

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcharters_ports`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `hub_port`  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_newbookcharters_ports/2024-11-05/1730866404'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcharters_ports`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcharters_ports"
}

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 17:42:23",
        "disabled": false,
        "format": "raw",
        "id": 2483,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "newbookdev_newbookcharters_ports"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "active": "string",
            "hub_port": "string",
            "id": "string",
            "name": "string",
            "newbook_region": "string",
            "tenant": "string"
        },
        "created": "2024-11-05 22:36:03",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcharters_ports`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `hub_port`  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_newbookcharters_ports/2024-11-05/1730866404'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcharters_ports`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcharters_ports"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}