Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_metering_types

created: 2024-10-08 17:35:55
disabled: False
format: raw
id: 2397
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4747905

created: 2024-11-05 22:29:04

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_sites_metering_types/2024-11-05/1730866353
id: 4747905
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "site_id": 3,
    "tenant": 1,
    "type_id": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string",
    "type_id": "string"
}

schema_name_id: 2397
schema_scan_id: 6673937
updated: 2024-11-05 22:29:15

Version 4747646

created: 2024-11-05 22:22:18

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_sites_metering_types/2024-11-05/1730866290
id: 4747646
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "site_id": 3,
    "tenant": 1,
    "type_id": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string",
    "type_id": "string"
}

schema_name_id: 2397
schema_scan_id: 6673678
updated: 2024-11-05 22:22:29

Version 4747366

created: 2024-11-05 22:13:50

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_sites_metering_types/2024-11-05/1730866225
id: 4747366
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "site_id": 3,
    "tenant": 1,
    "type_id": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string",
    "type_id": "string"
}

schema_name_id: 2397
schema_scan_id: 6673398
updated: 2024-11-05 22:14:03

Version 4746557

created: 2024-11-05 04:09:24

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_sites_metering_types/2024-11-04/1730785642
id: 4746557
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "site_id": 3,
    "tenant": 1,
    "type_id": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string",
    "type_id": "string"
}

schema_name_id: 2397
schema_scan_id: 6671780
updated: 2024-11-05 04:09:36

Version 4745895

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_sites_metering_types/2024-11-04/1730785078
id: 4745895
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "site_id": 3,
    "tenant": 1,
    "type_id": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string",
    "type_id": "string"
}

schema_name_id: 2397
schema_scan_id: 6671114
updated: 2024-11-05 03:42:28

Version 4745361

created: 2024-11-05 03:27:26

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_sites_metering_types/2024-11-04/1730784772
id: 4745361
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "site_id": 3,
    "tenant": 1,
    "type_id": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string",
    "type_id": "string"
}

schema_name_id: 2397
schema_scan_id: 6670579
updated: 2024-11-05 03:27:37

Version 4743976

created: 2024-11-05 02:50:46

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_sites_metering_types/2024-11-04/1730784006
id: 4743976
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "site_id": 3,
    "tenant": 1,
    "type_id": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string",
    "type_id": "string"
}

schema_name_id: 2397
schema_scan_id: 6669193
updated: 2024-11-05 02:50:57

Version 4743887

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_sites_metering_types/2024-11-04/1730784169
id: 4743887
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "site_id": 3,
    "tenant": 1,
    "type_id": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string",
    "type_id": "string"
}

schema_name_id: 2397
schema_scan_id: 6669104
updated: 2024-11-05 02:48:39

Version 4743240

created: 2024-11-05 02:31:18

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_sites_metering_types/2024-11-04/1730783862
id: 4743240
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "site_id": 3,
    "tenant": 1,
    "type_id": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string",
    "type_id": "string"
}

schema_name_id: 2397
schema_scan_id: 6668457
updated: 2024-11-05 02:31:31

Version 4742130

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_sites_metering_types/2024-11-04/1730783719
id: 4742130
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "site_id": 3,
    "tenant": 1,
    "type_id": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string",
    "type_id": "string"
}

schema_name_id: 2397
schema_scan_id: 6667347
updated: 2024-11-05 02:02:06

Version 4741790

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_sites_metering_types/2024-11-04/1730783628
id: 4741790
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "site_id": 3,
    "tenant": 1,
    "type_id": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string",
    "type_id": "string"
}

schema_name_id: 2397
schema_scan_id: 6667007
updated: 2024-11-05 01:53:04

Version 4740409

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_sites_metering_types/2024-11-04/1730783474
id: 4740409
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "site_id": 3,
    "tenant": 1,
    "type_id": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string",
    "type_id": "string"
}

schema_name_id: 2397
schema_scan_id: 6665626
updated: 2024-11-05 01:16:42

Version 4739965

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_sites_metering_types/2024-11-04/1730783256
id: 4739965
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "site_id": 3,
    "tenant": 1,
    "type_id": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string",
    "type_id": "string"
}

schema_name_id: 2397
schema_scan_id: 6665183
updated: 2024-11-05 01:04:54

Version 4739330

created: 2024-11-05 00:47:51

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_sites_metering_types/2024-11-04/1730782859
id: 4739330
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "site_id": 3,
    "tenant": 1,
    "type_id": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string",
    "type_id": "string"
}

schema_name_id: 2397
schema_scan_id: 6664545
updated: 2024-11-05 00:48:02

Version 4738791

created: 2024-11-05 00:33:43

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_sites_metering_types/2024-11-04/1730782769
id: 4738791
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "site_id": 3,
    "tenant": 1,
    "type_id": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string",
    "type_id": "string"
}

schema_name_id: 2397
schema_scan_id: 6664004
updated: 2024-11-05 00:33:53

Schema Scans: 15

Last at 2024-11-05 22:29:04

Scan 6673937

duration: 0:00:11.466967

exit_message:

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

id: 6673937

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_newbookaccommodation_sites_metering_types/2024-11-05/1730866353",
        "key": "raw/newbookdev_newbookaccommodation_sites_metering_types/2024-11-05/1730866353/accommodation_sites_metering_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_metering_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14041255765661073083,
        "service_name": "drive-thru",
        "span_id": 8323992600555836333,
        "trace_id": 16919068871743176364
    }
}

running: False
schema_name_id: 2397
start_time: 2024-11-05 22:29:04
success: True
trace_id: 16919068871743176364

Scan 6673678

duration: 0:00:11.387350

exit_message:

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

id: 6673678

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_newbookaccommodation_sites_metering_types/2024-11-05/1730866290",
        "key": "raw/newbookdev_newbookaccommodation_sites_metering_types/2024-11-05/1730866290/accommodation_sites_metering_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_metering_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4848322170092533374,
        "service_name": "drive-thru",
        "span_id": 6301627419714642420,
        "trace_id": 16847956628666272175
    }
}

running: False
schema_name_id: 2397
start_time: 2024-11-05 22:22:18
success: True
trace_id: 16847956628666272175

Scan 6673398

duration: 0:00:14.052693

exit_message:

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

id: 6673398

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_newbookaccommodation_sites_metering_types/2024-11-05/1730866225",
        "key": "raw/newbookdev_newbookaccommodation_sites_metering_types/2024-11-05/1730866225/accommodation_sites_metering_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_metering_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 217323769951592210,
        "service_name": "drive-thru",
        "span_id": 5898729782183726948,
        "trace_id": 12899778382552117483
    }
}

running: False
schema_name_id: 2397
start_time: 2024-11-05 22:13:49
success: True
trace_id: 12899778382552117483

Scan 6671780

duration: 0:00:11.550727

exit_message:

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

id: 6671780

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_newbookaccommodation_sites_metering_types/2024-11-04/1730785642",
        "key": "raw/newbookdev_newbookaccommodation_sites_metering_types/2024-11-04/1730785642/accommodation_sites_metering_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_metering_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1968353250942249582,
        "service_name": "drive-thru",
        "span_id": 11084341393936240550,
        "trace_id": 2040697462180329936
    }
}

running: False
schema_name_id: 2397
start_time: 2024-11-05 04:09:24
success: True
trace_id: 2040697462180329936

Scan 6671114

duration: 0:00:11.485980

exit_message:

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

id: 6671114

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_newbookaccommodation_sites_metering_types/2024-11-04/1730785078",
        "key": "raw/newbookdev_newbookaccommodation_sites_metering_types/2024-11-04/1730785078/accommodation_sites_metering_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_metering_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14502733073443001586,
        "service_name": "drive-thru",
        "span_id": 3109119805508903055,
        "trace_id": 12915579801551945959
    }
}

running: False
schema_name_id: 2397
start_time: 2024-11-05 03:42:16
success: True
trace_id: 12915579801551945959

Scan 6670579

duration: 0:00:11.366902

exit_message:

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

id: 6670579

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_newbookaccommodation_sites_metering_types/2024-11-04/1730784772",
        "key": "raw/newbookdev_newbookaccommodation_sites_metering_types/2024-11-04/1730784772/accommodation_sites_metering_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_metering_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9503107471094528821,
        "service_name": "drive-thru",
        "span_id": 6160151410676690480,
        "trace_id": 13758133837326234090
    }
}

running: False
schema_name_id: 2397
start_time: 2024-11-05 03:27:26
success: True
trace_id: 13758133837326234090

Scan 6669193

duration: 0:00:11.236717

exit_message:

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

id: 6669193

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_newbookaccommodation_sites_metering_types/2024-11-04/1730784006",
        "key": "raw/newbookdev_newbookaccommodation_sites_metering_types/2024-11-04/1730784006/accommodation_sites_metering_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_metering_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13620876728564063601,
        "service_name": "drive-thru",
        "span_id": 4254984039333748688,
        "trace_id": 9692983240219523803
    }
}

running: False
schema_name_id: 2397
start_time: 2024-11-05 02:50:46
success: True
trace_id: 9692983240219523803

Scan 6669104

duration: 0:00:11.544786

exit_message:

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

id: 6669104

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_newbookaccommodation_sites_metering_types/2024-11-04/1730784169",
        "key": "raw/newbookdev_newbookaccommodation_sites_metering_types/2024-11-04/1730784169/accommodation_sites_metering_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_metering_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11931179917839085058,
        "service_name": "drive-thru",
        "span_id": 5768712491677084742,
        "trace_id": 8802788068358854729
    }
}

running: False
schema_name_id: 2397
start_time: 2024-11-05 02:48:27
success: True
trace_id: 8802788068358854729

Scan 6668457

duration: 0:00:13.852154

exit_message:

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

id: 6668457

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_newbookaccommodation_sites_metering_types/2024-11-04/1730783862",
        "key": "raw/newbookdev_newbookaccommodation_sites_metering_types/2024-11-04/1730783862/accommodation_sites_metering_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_metering_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5298783982146576445,
        "service_name": "drive-thru",
        "span_id": 2212528115047510975,
        "trace_id": 11379855832401811652
    }
}

running: False
schema_name_id: 2397
start_time: 2024-11-05 02:31:18
success: True
trace_id: 11379855832401811652

Scan 6667347

duration: 0:00:11.388899

exit_message:

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

id: 6667347

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_newbookaccommodation_sites_metering_types/2024-11-04/1730783719",
        "key": "raw/newbookdev_newbookaccommodation_sites_metering_types/2024-11-04/1730783719/accommodation_sites_metering_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_metering_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16232810549900794662,
        "service_name": "drive-thru",
        "span_id": 513518260342723749,
        "trace_id": 6638448875327447980
    }
}

running: False
schema_name_id: 2397
start_time: 2024-11-05 02:01:54
success: True
trace_id: 6638448875327447980

Scan 6667007

duration: 0:00:13.861362

exit_message:

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

id: 6667007

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_newbookaccommodation_sites_metering_types/2024-11-04/1730783628",
        "key": "raw/newbookdev_newbookaccommodation_sites_metering_types/2024-11-04/1730783628/accommodation_sites_metering_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_metering_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17584863493983373765,
        "service_name": "drive-thru",
        "span_id": 11507271246657887881,
        "trace_id": 14311751615973953982
    }
}

running: False
schema_name_id: 2397
start_time: 2024-11-05 01:52:50
success: True
trace_id: 14311751615973953982

Scan 6665626

duration: 0:00:11.438975

exit_message:

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

id: 6665626

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_newbookaccommodation_sites_metering_types/2024-11-04/1730783474",
        "key": "raw/newbookdev_newbookaccommodation_sites_metering_types/2024-11-04/1730783474/accommodation_sites_metering_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_metering_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 115387714152621392,
        "service_name": "drive-thru",
        "span_id": 15036419445239718978,
        "trace_id": 4872129797398676000
    }
}

running: False
schema_name_id: 2397
start_time: 2024-11-05 01:16:31
success: True
trace_id: 4872129797398676000

Scan 6665183

duration: 0:00:11.317653

exit_message:

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

id: 6665183

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_newbookaccommodation_sites_metering_types/2024-11-04/1730783256",
        "key": "raw/newbookdev_newbookaccommodation_sites_metering_types/2024-11-04/1730783256/accommodation_sites_metering_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_metering_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1047188315042495479,
        "service_name": "drive-thru",
        "span_id": 1346998531285090683,
        "trace_id": 8849228708729257340
    }
}

running: False
schema_name_id: 2397
start_time: 2024-11-05 01:04:42
success: True
trace_id: 8849228708729257340

Scan 6664545

duration: 0:00:11.359275

exit_message:

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

id: 6664545

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_newbookaccommodation_sites_metering_types/2024-11-04/1730782859",
        "key": "raw/newbookdev_newbookaccommodation_sites_metering_types/2024-11-04/1730782859/accommodation_sites_metering_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_metering_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5974889881091569069,
        "service_name": "drive-thru",
        "span_id": 5273819572798957065,
        "trace_id": 2593676708142363333
    }
}

running: False
schema_name_id: 2397
start_time: 2024-11-05 00:47:51
success: True
trace_id: 2593676708142363333

Scan 6664004

duration: 0:00:11.376818

exit_message:

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

id: 6664004

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_newbookaccommodation_sites_metering_types/2024-11-04/1730782769",
        "key": "raw/newbookdev_newbookaccommodation_sites_metering_types/2024-11-04/1730782769/accommodation_sites_metering_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_metering_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15757545342419405759,
        "service_name": "drive-thru",
        "span_id": 16450194794735599440,
        "trace_id": 1332143694672170187
    }
}

running: False
schema_name_id: 2397
start_time: 2024-11-05 00:33:42
success: True
trace_id: 1332143694672170187

Partitions:

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

Schema:

attributes:

{
    "id": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string",
    "type_id": "string"
}

created: 2024-11-05 22:29:04

ddl:

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

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