Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookcustom_fields_equipment_guests_options

created: 2024-10-08 17:49:33
disabled: False
format: raw
id: 2583
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4748496

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcustom_fields_equipment_guests_options/2024-11-05/1730866452
id: 4748496
processed: 1

raw_data:

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

schema_attributes:

{
    "active": "string",
    "custom_field_id": "string",
    "display_order": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2583
schema_scan_id: 6674528
updated: 2024-11-05 22:48:39

Version 4747933

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcustom_fields_equipment_guests_options/2024-11-05/1730866366
id: 4747933
processed: 1

raw_data:

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

schema_attributes:

{
    "active": "string",
    "custom_field_id": "string",
    "display_order": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2583
schema_scan_id: 6673965
updated: 2024-11-05 22:30:01

Version 4747554

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcustom_fields_equipment_guests_options/2024-11-05/1730866269
id: 4747554
processed: 1

raw_data:

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

schema_attributes:

{
    "active": "string",
    "custom_field_id": "string",
    "display_order": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2583
schema_scan_id: 6673586
updated: 2024-11-05 22:20:05

Version 4746704

created: 2024-11-05 04:17:25

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcustom_fields_equipment_guests_options/2024-11-04/1730785689
id: 4746704
processed: 1

raw_data:

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

schema_attributes:

{
    "active": "string",
    "custom_field_id": "string",
    "display_order": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2583
schema_scan_id: 6671929
updated: 2024-11-05 04:17:36

Version 4746033

created: 2024-11-05 03:46:53

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcustom_fields_equipment_guests_options/2024-11-04/1730785107
id: 4746033
processed: 1

raw_data:

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

schema_attributes:

{
    "active": "string",
    "custom_field_id": "string",
    "display_order": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2583
schema_scan_id: 6671254
updated: 2024-11-05 03:47:04

Version 4744591

created: 2024-11-05 03:07:09

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcustom_fields_equipment_guests_options/2024-11-04/1730784801
id: 4744591
processed: 1

raw_data:

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

schema_attributes:

{
    "active": "string",
    "custom_field_id": "string",
    "display_order": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2583
schema_scan_id: 6669808
updated: 2024-11-05 03:07:20

Version 4744501

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcustom_fields_equipment_guests_options/2024-11-04/1730784198
id: 4744501
processed: 1

raw_data:

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

schema_attributes:

{
    "active": "string",
    "custom_field_id": "string",
    "display_order": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2583
schema_scan_id: 6669718
updated: 2024-11-05 03:04:58

Version 4743752

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcustom_fields_equipment_guests_options/2024-11-04/1730784035
id: 4743752
processed: 1

raw_data:

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

schema_attributes:

{
    "active": "string",
    "custom_field_id": "string",
    "display_order": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2583
schema_scan_id: 6668969
updated: 2024-11-05 02:45:10

Version 4743507

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcustom_fields_equipment_guests_options/2024-11-04/1730783885
id: 4743507
processed: 1

raw_data:

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

schema_attributes:

{
    "active": "string",
    "custom_field_id": "string",
    "display_order": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2583
schema_scan_id: 6668724
updated: 2024-11-05 02:38:36

Version 4741931

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcustom_fields_equipment_guests_options/2024-11-04/1730783748
id: 4741931
processed: 1

raw_data:

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

schema_attributes:

{
    "active": "string",
    "custom_field_id": "string",
    "display_order": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2583
schema_scan_id: 6667148
updated: 2024-11-05 01:56:41

Version 4741697

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcustom_fields_equipment_guests_options/2024-11-04/1730783650
id: 4741697
processed: 1

raw_data:

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

schema_attributes:

{
    "active": "string",
    "custom_field_id": "string",
    "display_order": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2583
schema_scan_id: 6666914
updated: 2024-11-05 01:50:38

Version 4740999

created: 2024-11-05 01:32:07

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcustom_fields_equipment_guests_options/2024-11-04/1730783504
id: 4740999
processed: 1

raw_data:

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

schema_attributes:

{
    "active": "string",
    "custom_field_id": "string",
    "display_order": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2583
schema_scan_id: 6666216
updated: 2024-11-05 01:32:20

Version 4740271

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcustom_fields_equipment_guests_options/2024-11-04/1730783286
id: 4740271
processed: 1

raw_data:

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

schema_attributes:

{
    "active": "string",
    "custom_field_id": "string",
    "display_order": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2583
schema_scan_id: 6665488
updated: 2024-11-05 01:13:08

Version 4739323

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcustom_fields_equipment_guests_options/2024-11-04/1730782888
id: 4739323
processed: 1

raw_data:

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

schema_attributes:

{
    "active": "string",
    "custom_field_id": "string",
    "display_order": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2583
schema_scan_id: 6664538
updated: 2024-11-05 00:47:53

Version 4738971

created: 2024-11-05 00:38:26

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcustom_fields_equipment_guests_options/2024-11-04/1730782791
id: 4738971
processed: 1

raw_data:

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

schema_attributes:

{
    "active": "string",
    "custom_field_id": "string",
    "display_order": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2583
schema_scan_id: 6664185
updated: 2024-11-05 00:38:37

Schema Scans: 15

Last at 2024-11-05 22:48:27

Scan 6674528

duration: 0:00:11.636233

exit_message:

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

id: 6674528

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_newbookcustom_fields_equipment_guests_options/2024-11-05/1730866452",
        "key": "raw/newbookdev_newbookcustom_fields_equipment_guests_options/2024-11-05/1730866452/custom_fields_equipment_guests_options.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_equipment_guests_options",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12674785392252868583,
        "service_name": "drive-thru",
        "span_id": 2384151233476159367,
        "trace_id": 14567696244122747214
    }
}

running: False
schema_name_id: 2583
start_time: 2024-11-05 22:48:27
success: True
trace_id: 14567696244122747214

Scan 6673965

duration: 0:00:13.993996

exit_message:

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

id: 6673965

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_newbookcustom_fields_equipment_guests_options/2024-11-05/1730866366",
        "key": "raw/newbookdev_newbookcustom_fields_equipment_guests_options/2024-11-05/1730866366/custom_fields_equipment_guests_options.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_equipment_guests_options",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1175202519999248595,
        "service_name": "drive-thru",
        "span_id": 1266111379976324698,
        "trace_id": 16000093414013277008
    }
}

running: False
schema_name_id: 2583
start_time: 2024-11-05 22:29:47
success: True
trace_id: 16000093414013277008

Scan 6673586

duration: 0:00:14.012256

exit_message:

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

id: 6673586

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_newbookcustom_fields_equipment_guests_options/2024-11-05/1730866269",
        "key": "raw/newbookdev_newbookcustom_fields_equipment_guests_options/2024-11-05/1730866269/custom_fields_equipment_guests_options.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_equipment_guests_options",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6413805099860460857,
        "service_name": "drive-thru",
        "span_id": 10283293279560907652,
        "trace_id": 4175313740727674569
    }
}

running: False
schema_name_id: 2583
start_time: 2024-11-05 22:19:51
success: True
trace_id: 4175313740727674569

Scan 6671929

duration: 0:00:11.587421

exit_message:

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

id: 6671929

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_newbookcustom_fields_equipment_guests_options/2024-11-04/1730785689",
        "key": "raw/newbookdev_newbookcustom_fields_equipment_guests_options/2024-11-04/1730785689/custom_fields_equipment_guests_options.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_equipment_guests_options",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16451436888359256617,
        "service_name": "drive-thru",
        "span_id": 14870090739792783933,
        "trace_id": 9706281514225142442
    }
}

running: False
schema_name_id: 2583
start_time: 2024-11-05 04:17:25
success: True
trace_id: 9706281514225142442

Scan 6671254

duration: 0:00:11.605097

exit_message:

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

id: 6671254

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_newbookcustom_fields_equipment_guests_options/2024-11-04/1730785107",
        "key": "raw/newbookdev_newbookcustom_fields_equipment_guests_options/2024-11-04/1730785107/custom_fields_equipment_guests_options.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_equipment_guests_options",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3630762506794906555,
        "service_name": "drive-thru",
        "span_id": 11546121799676513162,
        "trace_id": 7849884638715107727
    }
}

running: False
schema_name_id: 2583
start_time: 2024-11-05 03:46:52
success: True
trace_id: 7849884638715107727

Scan 6669808

duration: 0:00:11.424095

exit_message:

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

id: 6669808

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_newbookcustom_fields_equipment_guests_options/2024-11-04/1730784801",
        "key": "raw/newbookdev_newbookcustom_fields_equipment_guests_options/2024-11-04/1730784801/custom_fields_equipment_guests_options.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_equipment_guests_options",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11091588916879355162,
        "service_name": "drive-thru",
        "span_id": 5492576679566301608,
        "trace_id": 18136349656037007757
    }
}

running: False
schema_name_id: 2583
start_time: 2024-11-05 03:07:09
success: True
trace_id: 18136349656037007757

Scan 6669718

duration: 0:00:13.978642

exit_message:

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

id: 6669718

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_newbookcustom_fields_equipment_guests_options/2024-11-04/1730784198",
        "key": "raw/newbookdev_newbookcustom_fields_equipment_guests_options/2024-11-04/1730784198/custom_fields_equipment_guests_options.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_equipment_guests_options",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16259416837958068293,
        "service_name": "drive-thru",
        "span_id": 9901075392038475023,
        "trace_id": 3076045899208038939
    }
}

running: False
schema_name_id: 2583
start_time: 2024-11-05 03:04:44
success: True
trace_id: 3076045899208038939

Scan 6668969

duration: 0:00:13.829185

exit_message:

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

id: 6668969

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_newbookcustom_fields_equipment_guests_options/2024-11-04/1730784035",
        "key": "raw/newbookdev_newbookcustom_fields_equipment_guests_options/2024-11-04/1730784035/custom_fields_equipment_guests_options.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_equipment_guests_options",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8972763689526400909,
        "service_name": "drive-thru",
        "span_id": 15808022286443954928,
        "trace_id": 9430986531677241099
    }
}

running: False
schema_name_id: 2583
start_time: 2024-11-05 02:44:56
success: True
trace_id: 9430986531677241099

Scan 6668724

duration: 0:00:11.448692

exit_message:

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

id: 6668724

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_newbookcustom_fields_equipment_guests_options/2024-11-04/1730783885",
        "key": "raw/newbookdev_newbookcustom_fields_equipment_guests_options/2024-11-04/1730783885/custom_fields_equipment_guests_options.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_equipment_guests_options",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 886099535178165322,
        "service_name": "drive-thru",
        "span_id": 8413269949846687477,
        "trace_id": 15729432168360534636
    }
}

running: False
schema_name_id: 2583
start_time: 2024-11-05 02:38:25
success: True
trace_id: 15729432168360534636

Scan 6667148

duration: 0:00:11.402311

exit_message:

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

id: 6667148

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_newbookcustom_fields_equipment_guests_options/2024-11-04/1730783748",
        "key": "raw/newbookdev_newbookcustom_fields_equipment_guests_options/2024-11-04/1730783748/custom_fields_equipment_guests_options.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_equipment_guests_options",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1669493448709275485,
        "service_name": "drive-thru",
        "span_id": 7884618464020738412,
        "trace_id": 3999147961908664998
    }
}

running: False
schema_name_id: 2583
start_time: 2024-11-05 01:56:30
success: True
trace_id: 3999147961908664998

Scan 6666914

duration: 0:00:13.757221

exit_message:

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

id: 6666914

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_newbookcustom_fields_equipment_guests_options/2024-11-04/1730783650",
        "key": "raw/newbookdev_newbookcustom_fields_equipment_guests_options/2024-11-04/1730783650/custom_fields_equipment_guests_options.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_equipment_guests_options",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16731484911560567998,
        "service_name": "drive-thru",
        "span_id": 12604872011151318686,
        "trace_id": 16712825123760946513
    }
}

running: False
schema_name_id: 2583
start_time: 2024-11-05 01:50:24
success: True
trace_id: 16712825123760946513

Scan 6666216

duration: 0:00:13.888645

exit_message:

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

id: 6666216

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_newbookcustom_fields_equipment_guests_options/2024-11-04/1730783504",
        "key": "raw/newbookdev_newbookcustom_fields_equipment_guests_options/2024-11-04/1730783504/custom_fields_equipment_guests_options.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_equipment_guests_options",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12813832581089562780,
        "service_name": "drive-thru",
        "span_id": 13527764183910082987,
        "trace_id": 13988186548297373121
    }
}

running: False
schema_name_id: 2583
start_time: 2024-11-05 01:32:07
success: True
trace_id: 13988186548297373121

Scan 6665488

duration: 0:00:11.452957

exit_message:

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

id: 6665488

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_newbookcustom_fields_equipment_guests_options/2024-11-04/1730783286",
        "key": "raw/newbookdev_newbookcustom_fields_equipment_guests_options/2024-11-04/1730783286/custom_fields_equipment_guests_options.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_equipment_guests_options",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5774421453247943452,
        "service_name": "drive-thru",
        "span_id": 9064168617211363975,
        "trace_id": 14757319363812206982
    }
}

running: False
schema_name_id: 2583
start_time: 2024-11-05 01:12:56
success: True
trace_id: 14757319363812206982

Scan 6664538

duration: 0:00:11.355889

exit_message:

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

id: 6664538

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_newbookcustom_fields_equipment_guests_options/2024-11-04/1730782888",
        "key": "raw/newbookdev_newbookcustom_fields_equipment_guests_options/2024-11-04/1730782888/custom_fields_equipment_guests_options.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_equipment_guests_options",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18038509818696825528,
        "service_name": "drive-thru",
        "span_id": 13840895233911187550,
        "trace_id": 11807454290467878367
    }
}

running: False
schema_name_id: 2583
start_time: 2024-11-05 00:47:42
success: True
trace_id: 11807454290467878367

Scan 6664185

duration: 0:00:11.336523

exit_message:

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

id: 6664185

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_newbookcustom_fields_equipment_guests_options/2024-11-04/1730782791",
        "key": "raw/newbookdev_newbookcustom_fields_equipment_guests_options/2024-11-04/1730782791/custom_fields_equipment_guests_options.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_equipment_guests_options",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12821293490749226178,
        "service_name": "drive-thru",
        "span_id": 14331419292842069524,
        "trace_id": 980073621227212794
    }
}

running: False
schema_name_id: 2583
start_time: 2024-11-05 00:38:26
success: True
trace_id: 980073621227212794

Partitions:

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

Schema:

attributes:

{
    "active": "string",
    "custom_field_id": "string",
    "display_order": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string"
}

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

ddl:

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

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