Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookequipment_guests_on_site

created: 2024-10-08 17:56:46
disabled: False
format: raw
id: 2683
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4748628

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookequipment_guests_on_site/2024-11-05/1730866482
id: 4748628
processed: 1

raw_data:

{
    "equipment_id": 4,
    "id": 2,
    "newbook_region": 0,
    "occupied": 5,
    "site_id": 3,
    "tenant": 1,
    "timestamp": 6
}

schema_attributes:

{
    "equipment_id": "string",
    "id": "string",
    "newbook_region": "string",
    "occupied": "string",
    "site_id": "string",
    "tenant": "string",
    "timestamp": "string"
}

schema_name_id: 2683
schema_scan_id: 6674660
updated: 2024-11-05 22:54:17

Version 4748195

created: 2024-11-05 22:37:41

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookequipment_guests_on_site/2024-11-05/1730866396
id: 4748195
processed: 1

raw_data:

{
    "equipment_id": 4,
    "id": 2,
    "newbook_region": 0,
    "occupied": 5,
    "site_id": 3,
    "tenant": 1,
    "timestamp": 6
}

schema_attributes:

{
    "equipment_id": "string",
    "id": "string",
    "newbook_region": "string",
    "occupied": "string",
    "site_id": "string",
    "tenant": "string",
    "timestamp": "string"
}

schema_name_id: 2683
schema_scan_id: 6674227
updated: 2024-11-05 22:37:54

Version 4747657

created: 2024-11-05 22:22:32

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookequipment_guests_on_site/2024-11-05/1730866286
id: 4747657
processed: 1

raw_data:

{
    "equipment_id": 4,
    "id": 2,
    "newbook_region": 0,
    "occupied": 5,
    "site_id": 3,
    "tenant": 1,
    "timestamp": 6
}

schema_attributes:

{
    "equipment_id": "string",
    "id": "string",
    "newbook_region": "string",
    "occupied": "string",
    "site_id": "string",
    "tenant": "string",
    "timestamp": "string"
}

schema_name_id: 2683
schema_scan_id: 6673689
updated: 2024-11-05 22:22:43

Version 4747081

created: 2024-11-05 04:48:18

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookequipment_guests_on_site/2024-11-04/1730785705
id: 4747081
processed: 1

raw_data:

{
    "equipment_id": 4,
    "id": 2,
    "newbook_region": 0,
    "occupied": 5,
    "site_id": 3,
    "tenant": 1,
    "timestamp": 6
}

schema_attributes:

{
    "equipment_id": "string",
    "id": "string",
    "newbook_region": "string",
    "occupied": "string",
    "site_id": "string",
    "tenant": "string",
    "timestamp": "string"
}

schema_name_id: 2683
schema_scan_id: 6672313
updated: 2024-11-05 04:48:29

Version 4746152

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookequipment_guests_on_site/2024-11-04/1730785116
id: 4746152
processed: 1

raw_data:

{
    "equipment_id": 4,
    "id": 2,
    "newbook_region": 0,
    "occupied": 5,
    "site_id": 3,
    "tenant": 1,
    "timestamp": 6
}

schema_attributes:

{
    "equipment_id": "string",
    "id": "string",
    "newbook_region": "string",
    "occupied": "string",
    "site_id": "string",
    "tenant": "string",
    "timestamp": "string"
}

schema_name_id: 2683
schema_scan_id: 6671373
updated: 2024-11-05 03:51:19

Version 4745353

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookequipment_guests_on_site/2024-11-04/1730784811
id: 4745353
processed: 1

raw_data:

{
    "equipment_id": 4,
    "id": 2,
    "newbook_region": 0,
    "occupied": 5,
    "site_id": 3,
    "tenant": 1,
    "timestamp": 6
}

schema_attributes:

{
    "equipment_id": "string",
    "id": "string",
    "newbook_region": "string",
    "occupied": "string",
    "site_id": "string",
    "tenant": "string",
    "timestamp": "string"
}

schema_name_id: 2683
schema_scan_id: 6670570
updated: 2024-11-05 03:27:24

Version 4744557

created: 2024-11-05 03:06:16

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookequipment_guests_on_site/2024-11-04/1730784207
id: 4744557
processed: 1

raw_data:

{
    "equipment_id": 4,
    "id": 2,
    "newbook_region": 0,
    "occupied": 5,
    "site_id": 3,
    "tenant": 1,
    "timestamp": 6
}

schema_attributes:

{
    "equipment_id": "string",
    "id": "string",
    "newbook_region": "string",
    "occupied": "string",
    "site_id": "string",
    "tenant": "string",
    "timestamp": "string"
}

schema_name_id: 2683
schema_scan_id: 6669775
updated: 2024-11-05 03:06:29

Version 4744214

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookequipment_guests_on_site/2024-11-04/1730784044
id: 4744214
processed: 1

raw_data:

{
    "equipment_id": 4,
    "id": 2,
    "newbook_region": 0,
    "occupied": 5,
    "site_id": 3,
    "tenant": 1,
    "timestamp": 6
}

schema_attributes:

{
    "equipment_id": "string",
    "id": "string",
    "newbook_region": "string",
    "occupied": "string",
    "site_id": "string",
    "tenant": "string",
    "timestamp": "string"
}

schema_name_id: 2683
schema_scan_id: 6669431
updated: 2024-11-05 02:57:10

Version 4743241

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookequipment_guests_on_site/2024-11-04/1730783841
id: 4743241
processed: 1

raw_data:

{
    "equipment_id": 4,
    "id": 2,
    "newbook_region": 0,
    "occupied": 5,
    "site_id": 3,
    "tenant": 1,
    "timestamp": 6
}

schema_attributes:

{
    "equipment_id": "string",
    "id": "string",
    "newbook_region": "string",
    "occupied": "string",
    "site_id": "string",
    "tenant": "string",
    "timestamp": "string"
}

schema_name_id: 2683
schema_scan_id: 6668458
updated: 2024-11-05 02:31:29

Version 4742520

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookequipment_guests_on_site/2024-11-04/1730783758
id: 4742520
processed: 1

raw_data:

{
    "equipment_id": 4,
    "id": 2,
    "newbook_region": 0,
    "occupied": 5,
    "site_id": 3,
    "tenant": 1,
    "timestamp": 6
}

schema_attributes:

{
    "equipment_id": "string",
    "id": "string",
    "newbook_region": "string",
    "occupied": "string",
    "site_id": "string",
    "tenant": "string",
    "timestamp": "string"
}

schema_name_id: 2683
schema_scan_id: 6667737
updated: 2024-11-05 02:12:34

Version 4741961

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookequipment_guests_on_site/2024-11-04/1730783658
id: 4741961
processed: 1

raw_data:

{
    "equipment_id": 4,
    "id": 2,
    "newbook_region": 0,
    "occupied": 5,
    "site_id": 3,
    "tenant": 1,
    "timestamp": 6
}

schema_attributes:

{
    "equipment_id": "string",
    "id": "string",
    "newbook_region": "string",
    "occupied": "string",
    "site_id": "string",
    "tenant": "string",
    "timestamp": "string"
}

schema_name_id: 2683
schema_scan_id: 6667178
updated: 2024-11-05 01:57:30

Version 4740622

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookequipment_guests_on_site/2024-11-04/1730783514
id: 4740622
processed: 1

raw_data:

{
    "equipment_id": 4,
    "id": 2,
    "newbook_region": 0,
    "occupied": 5,
    "site_id": 3,
    "tenant": 1,
    "timestamp": 6
}

schema_attributes:

{
    "equipment_id": "string",
    "id": "string",
    "newbook_region": "string",
    "occupied": "string",
    "site_id": "string",
    "tenant": "string",
    "timestamp": "string"
}

schema_name_id: 2683
schema_scan_id: 6665839
updated: 2024-11-05 01:22:23

Version 4740231

created: 2024-11-05 01:11:53

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookequipment_guests_on_site/2024-11-04/1730783296
id: 4740231
processed: 1

raw_data:

{
    "equipment_id": 4,
    "id": 2,
    "newbook_region": 0,
    "occupied": 5,
    "site_id": 3,
    "tenant": 1,
    "timestamp": 6
}

schema_attributes:

{
    "equipment_id": "string",
    "id": "string",
    "newbook_region": "string",
    "occupied": "string",
    "site_id": "string",
    "tenant": "string",
    "timestamp": "string"
}

schema_name_id: 2683
schema_scan_id: 6665449
updated: 2024-11-05 01:12:07

Version 4739288

created: 2024-11-05 00:46:46

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookequipment_guests_on_site/2024-11-04/1730782897
id: 4739288
processed: 1

raw_data:

{
    "equipment_id": 4,
    "id": 2,
    "newbook_region": 0,
    "occupied": 5,
    "site_id": 3,
    "tenant": 1,
    "timestamp": 6
}

schema_attributes:

{
    "equipment_id": "string",
    "id": "string",
    "newbook_region": "string",
    "occupied": "string",
    "site_id": "string",
    "tenant": "string",
    "timestamp": "string"
}

schema_name_id: 2683
schema_scan_id: 6664503
updated: 2024-11-05 00:46:57

Version 4738609

created: 2024-11-05 00:28:55

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookequipment_guests_on_site/2024-11-04/1730782798
id: 4738609
processed: 1

raw_data:

{
    "equipment_id": 4,
    "id": 2,
    "newbook_region": 0,
    "occupied": 5,
    "site_id": 3,
    "tenant": 1,
    "timestamp": 6
}

schema_attributes:

{
    "equipment_id": "string",
    "id": "string",
    "newbook_region": "string",
    "occupied": "string",
    "site_id": "string",
    "tenant": "string",
    "timestamp": "string"
}

schema_name_id: 2683
schema_scan_id: 6663822
updated: 2024-11-05 00:29:06

Schema Scans: 15

Last at 2024-11-05 22:54:03

Scan 6674660

duration: 0:00:14.082998

exit_message:

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

id: 6674660

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_newbookequipment_guests_on_site/2024-11-05/1730866482",
        "key": "raw/newbookdev_newbookequipment_guests_on_site/2024-11-05/1730866482/equipment_guests_on_site.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookequipment_guests_on_site",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12415778767841037163,
        "service_name": "drive-thru",
        "span_id": 5969051469580126338,
        "trace_id": 2982774442221480544
    }
}

running: False
schema_name_id: 2683
start_time: 2024-11-05 22:54:03
success: True
trace_id: 2982774442221480544

Scan 6674227

duration: 0:00:14.029618

exit_message:

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

id: 6674227

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_newbookequipment_guests_on_site/2024-11-05/1730866396",
        "key": "raw/newbookdev_newbookequipment_guests_on_site/2024-11-05/1730866396/equipment_guests_on_site.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookequipment_guests_on_site",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7364471011234388745,
        "service_name": "drive-thru",
        "span_id": 13816116194267059524,
        "trace_id": 2258726754068758416
    }
}

running: False
schema_name_id: 2683
start_time: 2024-11-05 22:37:40
success: True
trace_id: 2258726754068758416

Scan 6673689

duration: 0:00:11.513649

exit_message:

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

id: 6673689

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_newbookequipment_guests_on_site/2024-11-05/1730866286",
        "key": "raw/newbookdev_newbookequipment_guests_on_site/2024-11-05/1730866286/equipment_guests_on_site.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookequipment_guests_on_site",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1333399909287536860,
        "service_name": "drive-thru",
        "span_id": 14006410548931298069,
        "trace_id": 3752827752885046842
    }
}

running: False
schema_name_id: 2683
start_time: 2024-11-05 22:22:32
success: True
trace_id: 3752827752885046842

Scan 6672313

duration: 0:00:11.464973

exit_message:

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

id: 6672313

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_newbookequipment_guests_on_site/2024-11-04/1730785705",
        "key": "raw/newbookdev_newbookequipment_guests_on_site/2024-11-04/1730785705/equipment_guests_on_site.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookequipment_guests_on_site",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5560842854091582024,
        "service_name": "drive-thru",
        "span_id": 12813621406069880131,
        "trace_id": 11773227998028295287
    }
}

running: False
schema_name_id: 2683
start_time: 2024-11-05 04:48:18
success: True
trace_id: 11773227998028295287

Scan 6671373

duration: 0:00:11.525198

exit_message:

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

id: 6671373

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_newbookequipment_guests_on_site/2024-11-04/1730785116",
        "key": "raw/newbookdev_newbookequipment_guests_on_site/2024-11-04/1730785116/equipment_guests_on_site.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookequipment_guests_on_site",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 697196730410166970,
        "service_name": "drive-thru",
        "span_id": 8324614570758376900,
        "trace_id": 923544749386157299
    }
}

running: False
schema_name_id: 2683
start_time: 2024-11-05 03:51:07
success: True
trace_id: 923544749386157299

Scan 6670570

duration: 0:00:11.320058

exit_message:

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

id: 6670570

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_newbookequipment_guests_on_site/2024-11-04/1730784811",
        "key": "raw/newbookdev_newbookequipment_guests_on_site/2024-11-04/1730784811/equipment_guests_on_site.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookequipment_guests_on_site",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6435285855805830283,
        "service_name": "drive-thru",
        "span_id": 7517992416464846852,
        "trace_id": 6968705354620991123
    }
}

running: False
schema_name_id: 2683
start_time: 2024-11-05 03:27:12
success: True
trace_id: 6968705354620991123

Scan 6669775

duration: 0:00:14.057198

exit_message:

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

id: 6669775

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_newbookequipment_guests_on_site/2024-11-04/1730784207",
        "key": "raw/newbookdev_newbookequipment_guests_on_site/2024-11-04/1730784207/equipment_guests_on_site.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookequipment_guests_on_site",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5371738294197376284,
        "service_name": "drive-thru",
        "span_id": 1213782480260261922,
        "trace_id": 13150240268787171469
    }
}

running: False
schema_name_id: 2683
start_time: 2024-11-05 03:06:15
success: True
trace_id: 13150240268787171469

Scan 6669431

duration: 0:00:11.321915

exit_message:

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

id: 6669431

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_newbookequipment_guests_on_site/2024-11-04/1730784044",
        "key": "raw/newbookdev_newbookequipment_guests_on_site/2024-11-04/1730784044/equipment_guests_on_site.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookequipment_guests_on_site",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2497925212285442351,
        "service_name": "drive-thru",
        "span_id": 7981664613441273349,
        "trace_id": 16863556715599418826
    }
}

running: False
schema_name_id: 2683
start_time: 2024-11-05 02:56:58
success: True
trace_id: 16863556715599418826

Scan 6668458

duration: 0:00:11.236230

exit_message:

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

id: 6668458

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_newbookequipment_guests_on_site/2024-11-04/1730783841",
        "key": "raw/newbookdev_newbookequipment_guests_on_site/2024-11-04/1730783841/equipment_guests_on_site.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookequipment_guests_on_site",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11452671742353853092,
        "service_name": "drive-thru",
        "span_id": 16334634026297635008,
        "trace_id": 5936812558025369547
    }
}

running: False
schema_name_id: 2683
start_time: 2024-11-05 02:31:18
success: True
trace_id: 5936812558025369547

Scan 6667737

duration: 0:00:11.330671

exit_message:

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

id: 6667737

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_newbookequipment_guests_on_site/2024-11-04/1730783758",
        "key": "raw/newbookdev_newbookequipment_guests_on_site/2024-11-04/1730783758/equipment_guests_on_site.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookequipment_guests_on_site",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2720266293883002918,
        "service_name": "drive-thru",
        "span_id": 16693637621356232684,
        "trace_id": 16634726206082560998
    }
}

running: False
schema_name_id: 2683
start_time: 2024-11-05 02:12:22
success: True
trace_id: 16634726206082560998

Scan 6667178

duration: 0:00:11.283588

exit_message:

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

id: 6667178

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_newbookequipment_guests_on_site/2024-11-04/1730783658",
        "key": "raw/newbookdev_newbookequipment_guests_on_site/2024-11-04/1730783658/equipment_guests_on_site.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookequipment_guests_on_site",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2768307169943583979,
        "service_name": "drive-thru",
        "span_id": 419258092813156154,
        "trace_id": 17450618592770773512
    }
}

running: False
schema_name_id: 2683
start_time: 2024-11-05 01:57:19
success: True
trace_id: 17450618592770773512

Scan 6665839

duration: 0:00:13.907943

exit_message:

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

id: 6665839

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_newbookequipment_guests_on_site/2024-11-04/1730783514",
        "key": "raw/newbookdev_newbookequipment_guests_on_site/2024-11-04/1730783514/equipment_guests_on_site.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookequipment_guests_on_site",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13579879962216985863,
        "service_name": "drive-thru",
        "span_id": 15232632074200444763,
        "trace_id": 2370249900820037971
    }
}

running: False
schema_name_id: 2683
start_time: 2024-11-05 01:22:09
success: True
trace_id: 2370249900820037971

Scan 6665449

duration: 0:00:13.863121

exit_message:

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

id: 6665449

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_newbookequipment_guests_on_site/2024-11-04/1730783296",
        "key": "raw/newbookdev_newbookequipment_guests_on_site/2024-11-04/1730783296/equipment_guests_on_site.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookequipment_guests_on_site",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9266038347060044495,
        "service_name": "drive-thru",
        "span_id": 4764597366729378475,
        "trace_id": 3312994797302600997
    }
}

running: False
schema_name_id: 2683
start_time: 2024-11-05 01:11:53
success: True
trace_id: 3312994797302600997

Scan 6664503

duration: 0:00:11.304976

exit_message:

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

id: 6664503

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_newbookequipment_guests_on_site/2024-11-04/1730782897",
        "key": "raw/newbookdev_newbookequipment_guests_on_site/2024-11-04/1730782897/equipment_guests_on_site.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookequipment_guests_on_site",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4970372660071360636,
        "service_name": "drive-thru",
        "span_id": 3432902521898449067,
        "trace_id": 3033638730754464772
    }
}

running: False
schema_name_id: 2683
start_time: 2024-11-05 00:46:46
success: True
trace_id: 3033638730754464772

Scan 6663822

duration: 0:00:11.444472

exit_message:

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

id: 6663822

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_newbookequipment_guests_on_site/2024-11-04/1730782798",
        "key": "raw/newbookdev_newbookequipment_guests_on_site/2024-11-04/1730782798/equipment_guests_on_site.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookequipment_guests_on_site",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9912190384607787754,
        "service_name": "drive-thru",
        "span_id": 12696696084307577186,
        "trace_id": 10143182245572138684
    }
}

running: False
schema_name_id: 2683
start_time: 2024-11-05 00:28:54
success: True
trace_id: 10143182245572138684

Partitions:

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

Schema:

attributes:

{
    "equipment_id": "string",
    "id": "string",
    "newbook_region": "string",
    "occupied": "string",
    "site_id": "string",
    "tenant": "string",
    "timestamp": "string"
}

created: 2024-11-05 22:54: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_newbookequipment_guests_on_site`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `site_id`  string , `equipment_id`  string , `occupied`  string , `timestamp`  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_newbookequipment_guests_on_site/2024-11-05/1730866482'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookequipment_guests_on_site`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookequipment_guests_on_site"
}

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:56:46",
        "disabled": false,
        "format": "raw",
        "id": 2683,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "newbookdev_newbookequipment_guests_on_site"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "equipment_id": "string",
            "id": "string",
            "newbook_region": "string",
            "occupied": "string",
            "site_id": "string",
            "tenant": "string",
            "timestamp": "string"
        },
        "created": "2024-11-05 22:54: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_newbookequipment_guests_on_site`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `site_id`  string , `equipment_id`  string , `occupied`  string , `timestamp`  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_newbookequipment_guests_on_site/2024-11-05/1730866482'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookequipment_guests_on_site`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookequipment_guests_on_site"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}