Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_equipment_types

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4748078

created: 2024-11-05 22:34:11

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_equipment_types`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_equipment_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_equipment_types/2024-11-05/1730866352'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_equipment_types"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_sites_equipment_types/2024-11-05/1730866352
id: 4748078
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: 2395
schema_scan_id: 6674110
updated: 2024-11-05 22:34:22

Version 4747684

created: 2024-11-05 22:23:19

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_equipment_types`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_equipment_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_equipment_types/2024-11-05/1730866288'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_equipment_types"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_sites_equipment_types/2024-11-05/1730866288
id: 4747684
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: 2395
schema_scan_id: 6673716
updated: 2024-11-05 22:23:30

Version 4747361

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_equipment_types`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_equipment_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_equipment_types/2024-11-05/1730866224'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_equipment_types"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_sites_equipment_types/2024-11-05/1730866224
id: 4747361
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: 2395
schema_scan_id: 6673393
updated: 2024-11-05 22:13:45

Version 4746542

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_equipment_types`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_equipment_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_equipment_types/2024-11-04/1730785641'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_equipment_types"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_sites_equipment_types/2024-11-04/1730785641
id: 4746542
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: 2395
schema_scan_id: 6671765
updated: 2024-11-05 04:08:45

Version 4745912

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_equipment_types`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_equipment_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_equipment_types/2024-11-04/1730785077'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_equipment_types"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_sites_equipment_types/2024-11-04/1730785077
id: 4745912
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: 2395
schema_scan_id: 6671132
updated: 2024-11-05 03:42:58

Version 4745338

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_equipment_types`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_equipment_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_equipment_types/2024-11-04/1730784771'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_equipment_types"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_sites_equipment_types/2024-11-04/1730784771
id: 4745338
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: 2395
schema_scan_id: 6670555
updated: 2024-11-05 03:27:01

Version 4743874

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_equipment_types`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_equipment_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_equipment_types/2024-11-04/1730784168'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_equipment_types"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_sites_equipment_types/2024-11-04/1730784168
id: 4743874
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: 2395
schema_scan_id: 6669091
updated: 2024-11-05 02:48:20

Version 4743608

created: 2024-11-05 02:41:08

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_equipment_types`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_equipment_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_equipment_types/2024-11-04/1730784006'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_equipment_types"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_sites_equipment_types/2024-11-04/1730784006
id: 4743608
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: 2395
schema_scan_id: 6668826
updated: 2024-11-05 02:41:19

Version 4743223

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_equipment_types`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_equipment_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_equipment_types/2024-11-04/1730783862'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_equipment_types"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_sites_equipment_types/2024-11-04/1730783862
id: 4743223
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: 2395
schema_scan_id: 6668440
updated: 2024-11-05 02:31:03

Version 4742300

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_equipment_types`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_equipment_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_equipment_types/2024-11-04/1730783718'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_equipment_types"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_sites_equipment_types/2024-11-04/1730783718
id: 4742300
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: 2395
schema_scan_id: 6667517
updated: 2024-11-05 02:06:48

Version 4741586

created: 2024-11-05 01:47:28

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_equipment_types`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_equipment_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_equipment_types/2024-11-04/1730783597'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_equipment_types"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_sites_equipment_types/2024-11-04/1730783597
id: 4741586
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: 2395
schema_scan_id: 6666803
updated: 2024-11-05 01:47:41

Version 4740718

created: 2024-11-05 01:24:39

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_equipment_types`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_equipment_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_equipment_types/2024-11-04/1730783474'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_equipment_types"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_sites_equipment_types/2024-11-04/1730783474
id: 4740718
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: 2395
schema_scan_id: 6665935
updated: 2024-11-05 01:24:50

Version 4740005

created: 2024-11-05 01:05:48

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_equipment_types`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_equipment_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_equipment_types/2024-11-04/1730783255'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_equipment_types"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_sites_equipment_types/2024-11-04/1730783255
id: 4740005
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: 2395
schema_scan_id: 6665222
updated: 2024-11-05 01:06:02

Version 4739221

created: 2024-11-05 00:44:56

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_equipment_types`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_equipment_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_equipment_types/2024-11-04/1730782858'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_equipment_types"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_sites_equipment_types/2024-11-04/1730782858
id: 4739221
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: 2395
schema_scan_id: 6664436
updated: 2024-11-05 00:45:09

Version 4738792

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_equipment_types`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_equipment_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_equipment_types/2024-11-04/1730782769'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_equipment_types"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_sites_equipment_types/2024-11-04/1730782769
id: 4738792
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: 2395
schema_scan_id: 6664005
updated: 2024-11-05 00:33:57

Schema Scans: 15

Last at 2024-11-05 22:34:10

Scan 6674110

duration: 0:00:11.481755

exit_message:

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

id: 6674110

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_equipment_types/2024-11-05/1730866352",
        "key": "raw/newbookdev_newbookaccommodation_sites_equipment_types/2024-11-05/1730866352/accommodation_sites_equipment_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_equipment_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15188333014773637472,
        "service_name": "drive-thru",
        "span_id": 17625213254007122490,
        "trace_id": 1589936859974815918
    }
}

running: False
schema_name_id: 2395
start_time: 2024-11-05 22:34:10
success: True
trace_id: 1589936859974815918

Scan 6673716

duration: 0:00:11.479220

exit_message:

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

id: 6673716

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_equipment_types/2024-11-05/1730866288",
        "key": "raw/newbookdev_newbookaccommodation_sites_equipment_types/2024-11-05/1730866288/accommodation_sites_equipment_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_equipment_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13826895673380667893,
        "service_name": "drive-thru",
        "span_id": 6018693329546201801,
        "trace_id": 6467693684073569011
    }
}

running: False
schema_name_id: 2395
start_time: 2024-11-05 22:23:19
success: True
trace_id: 6467693684073569011

Scan 6673393

duration: 0:00:14.051921

exit_message:

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

id: 6673393

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_equipment_types/2024-11-05/1730866224",
        "key": "raw/newbookdev_newbookaccommodation_sites_equipment_types/2024-11-05/1730866224/accommodation_sites_equipment_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_equipment_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 608971200016857926,
        "service_name": "drive-thru",
        "span_id": 3117885411752485509,
        "trace_id": 11962209189777124683
    }
}

running: False
schema_name_id: 2395
start_time: 2024-11-05 22:13:31
success: True
trace_id: 11962209189777124683

Scan 6671765

duration: 0:00:11.422640

exit_message:

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

id: 6671765

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_equipment_types/2024-11-04/1730785641",
        "key": "raw/newbookdev_newbookaccommodation_sites_equipment_types/2024-11-04/1730785641/accommodation_sites_equipment_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_equipment_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13031427742450437287,
        "service_name": "drive-thru",
        "span_id": 17344833229922500504,
        "trace_id": 10581959517298522528
    }
}

running: False
schema_name_id: 2395
start_time: 2024-11-05 04:08:34
success: True
trace_id: 10581959517298522528

Scan 6671132

duration: 0:00:11.429591

exit_message:

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

id: 6671132

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_equipment_types/2024-11-04/1730785077",
        "key": "raw/newbookdev_newbookaccommodation_sites_equipment_types/2024-11-04/1730785077/accommodation_sites_equipment_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_equipment_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15822842901176245981,
        "service_name": "drive-thru",
        "span_id": 12298855327201331137,
        "trace_id": 9373283926844343626
    }
}

running: False
schema_name_id: 2395
start_time: 2024-11-05 03:42:47
success: True
trace_id: 9373283926844343626

Scan 6670555

duration: 0:00:11.425430

exit_message:

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

id: 6670555

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_equipment_types/2024-11-04/1730784771",
        "key": "raw/newbookdev_newbookaccommodation_sites_equipment_types/2024-11-04/1730784771/accommodation_sites_equipment_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_equipment_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6417276104574331765,
        "service_name": "drive-thru",
        "span_id": 12422751125100397995,
        "trace_id": 6400038655615366228
    }
}

running: False
schema_name_id: 2395
start_time: 2024-11-05 03:26:49
success: True
trace_id: 6400038655615366228

Scan 6669091

duration: 0:00:11.263944

exit_message:

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

id: 6669091

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_equipment_types/2024-11-04/1730784168",
        "key": "raw/newbookdev_newbookaccommodation_sites_equipment_types/2024-11-04/1730784168/accommodation_sites_equipment_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_equipment_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17212814169897472907,
        "service_name": "drive-thru",
        "span_id": 10678139223518937502,
        "trace_id": 16103465119288169367
    }
}

running: False
schema_name_id: 2395
start_time: 2024-11-05 02:48:09
success: True
trace_id: 16103465119288169367

Scan 6668826

duration: 0:00:11.390963

exit_message:

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

id: 6668826

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_equipment_types/2024-11-04/1730784006",
        "key": "raw/newbookdev_newbookaccommodation_sites_equipment_types/2024-11-04/1730784006/accommodation_sites_equipment_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_equipment_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11732541378516132921,
        "service_name": "drive-thru",
        "span_id": 6107396333498893734,
        "trace_id": 5189713960352020499
    }
}

running: False
schema_name_id: 2395
start_time: 2024-11-05 02:41:08
success: True
trace_id: 5189713960352020499

Scan 6668440

duration: 0:00:13.765845

exit_message:

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

id: 6668440

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_equipment_types/2024-11-04/1730783862",
        "key": "raw/newbookdev_newbookaccommodation_sites_equipment_types/2024-11-04/1730783862/accommodation_sites_equipment_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_equipment_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10204654508386794210,
        "service_name": "drive-thru",
        "span_id": 11690774276923958501,
        "trace_id": 9013184702563072645
    }
}

running: False
schema_name_id: 2395
start_time: 2024-11-05 02:30:50
success: True
trace_id: 9013184702563072645

Scan 6667517

duration: 0:00:13.855478

exit_message:

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

id: 6667517

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_equipment_types/2024-11-04/1730783718",
        "key": "raw/newbookdev_newbookaccommodation_sites_equipment_types/2024-11-04/1730783718/accommodation_sites_equipment_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_equipment_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1204679940343932066,
        "service_name": "drive-thru",
        "span_id": 9279093035238453815,
        "trace_id": 9767411792743700532
    }
}

running: False
schema_name_id: 2395
start_time: 2024-11-05 02:06:34
success: True
trace_id: 9767411792743700532

Scan 6666803

duration: 0:00:13.825161

exit_message:

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

id: 6666803

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_equipment_types/2024-11-04/1730783597",
        "key": "raw/newbookdev_newbookaccommodation_sites_equipment_types/2024-11-04/1730783597/accommodation_sites_equipment_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_equipment_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2597871904423911197,
        "service_name": "drive-thru",
        "span_id": 10058721336712340437,
        "trace_id": 10909774537181766499
    }
}

running: False
schema_name_id: 2395
start_time: 2024-11-05 01:47:27
success: True
trace_id: 10909774537181766499

Scan 6665935

duration: 0:00:11.258907

exit_message:

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

id: 6665935

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_equipment_types/2024-11-04/1730783474",
        "key": "raw/newbookdev_newbookaccommodation_sites_equipment_types/2024-11-04/1730783474/accommodation_sites_equipment_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_equipment_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9712782574954174307,
        "service_name": "drive-thru",
        "span_id": 3885438822211848106,
        "trace_id": 11685481974921113359
    }
}

running: False
schema_name_id: 2395
start_time: 2024-11-05 01:24:38
success: True
trace_id: 11685481974921113359

Scan 6665222

duration: 0:00:13.982198

exit_message:

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

id: 6665222

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_equipment_types/2024-11-04/1730783255",
        "key": "raw/newbookdev_newbookaccommodation_sites_equipment_types/2024-11-04/1730783255/accommodation_sites_equipment_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_equipment_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5019563641179637530,
        "service_name": "drive-thru",
        "span_id": 18413138977284483687,
        "trace_id": 4847127567333449336
    }
}

running: False
schema_name_id: 2395
start_time: 2024-11-05 01:05:48
success: True
trace_id: 4847127567333449336

Scan 6664436

duration: 0:00:13.806999

exit_message:

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

id: 6664436

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_equipment_types/2024-11-04/1730782858",
        "key": "raw/newbookdev_newbookaccommodation_sites_equipment_types/2024-11-04/1730782858/accommodation_sites_equipment_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_equipment_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17657398098136102254,
        "service_name": "drive-thru",
        "span_id": 11021540811148396654,
        "trace_id": 2001408524526099742
    }
}

running: False
schema_name_id: 2395
start_time: 2024-11-05 00:44:55
success: True
trace_id: 2001408524526099742

Scan 6664005

duration: 0:00:13.858156

exit_message:

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

id: 6664005

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_equipment_types/2024-11-04/1730782769",
        "key": "raw/newbookdev_newbookaccommodation_sites_equipment_types/2024-11-04/1730782769/accommodation_sites_equipment_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_equipment_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2555907543655774541,
        "service_name": "drive-thru",
        "span_id": 7843119690601941806,
        "trace_id": 4656945569593177731
    }
}

running: False
schema_name_id: 2395
start_time: 2024-11-05 00:33:43
success: True
trace_id: 4656945569593177731

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:34:11

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_equipment_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_equipment_types/2024-11-05/1730866352'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_equipment_types`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_equipment_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:40",
        "disabled": false,
        "format": "raw",
        "id": 2395,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "newbookdev_newbookaccommodation_sites_equipment_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:34:11",
        "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_equipment_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_equipment_types/2024-11-05/1730866352'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_equipment_types`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_equipment_types"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}