Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookcustom_fields_companies_staff_options

created: 2024-10-08 17:51:30
disabled: False
format: raw
id: 2610
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4748582

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcustom_fields_companies_staff_options/2024-11-05/1730866451
id: 4748582
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: 2610
schema_scan_id: 6674614
updated: 2024-11-05 22:52:22

Version 4748044

created: 2024-11-05 22:33:09

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcustom_fields_companies_staff_options/2024-11-05/1730866365
id: 4748044
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: 2610
schema_scan_id: 6674078
updated: 2024-11-05 22:33:20

Version 4747551

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcustom_fields_companies_staff_options/2024-11-05/1730866268
id: 4747551
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: 2610
schema_scan_id: 6673583
updated: 2024-11-05 22:20:02

Version 4746736

created: 2024-11-05 04:19:35

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcustom_fields_companies_staff_options/2024-11-04/1730785689
id: 4746736
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: 2610
schema_scan_id: 6671960
updated: 2024-11-05 04:19:48

Version 4745783

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcustom_fields_companies_staff_options/2024-11-04/1730784801
id: 4745783
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: 2610
schema_scan_id: 6671000
updated: 2024-11-05 03:39:01

Version 4745371

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcustom_fields_companies_staff_options/2024-11-04/1730785106
id: 4745371
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: 2610
schema_scan_id: 6670588
updated: 2024-11-05 03:27:50

Version 4744455

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcustom_fields_companies_staff_options/2024-11-04/1730784198
id: 4744455
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: 2610
schema_scan_id: 6669672
updated: 2024-11-05 03:03:41

Version 4743821

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcustom_fields_companies_staff_options/2024-11-04/1730784035
id: 4743821
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: 2610
schema_scan_id: 6669038
updated: 2024-11-05 02:46:58

Version 4743166

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcustom_fields_companies_staff_options/2024-11-04/1730783885
id: 4743166
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: 2610
schema_scan_id: 6668383
updated: 2024-11-05 02:29:34

Version 4742498

created: 2024-11-05 02:11:47

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcustom_fields_companies_staff_options/2024-11-04/1730783749
id: 4742498
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: 2610
schema_scan_id: 6667715
updated: 2024-11-05 02:11:57

Version 4741670

created: 2024-11-05 01:49:42

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcustom_fields_companies_staff_options/2024-11-04/1730783605
id: 4741670
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: 2610
schema_scan_id: 6666887
updated: 2024-11-05 01:49:53

Version 4740986

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcustom_fields_companies_staff_options/2024-11-04/1730783504
id: 4740986
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: 2610
schema_scan_id: 6666203
updated: 2024-11-05 01:31:54

Version 4740268

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcustom_fields_companies_staff_options/2024-11-04/1730783286
id: 4740268
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: 2610
schema_scan_id: 6665486
updated: 2024-11-05 01:13:06

Version 4739233

created: 2024-11-05 00:45:19

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcustom_fields_companies_staff_options/2024-11-04/1730782889
id: 4739233
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: 2610
schema_scan_id: 6664448
updated: 2024-11-05 00:45:32

Version 4738924

created: 2024-11-05 00:37:13

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcustom_fields_companies_staff_options/2024-11-04/1730782791
id: 4738924
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: 2610
schema_scan_id: 6664138
updated: 2024-11-05 00:37:27

Schema Scans: 15

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

Scan 6674614

duration: 0:00:11.503627

exit_message:

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

id: 6674614

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_companies_staff_options/2024-11-05/1730866451",
        "key": "raw/newbookdev_newbookcustom_fields_companies_staff_options/2024-11-05/1730866451/custom_fields_companies_staff_options.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_companies_staff_options",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13002436451552565369,
        "service_name": "drive-thru",
        "span_id": 5663267159822029549,
        "trace_id": 17788280058833158937
    }
}

running: False
schema_name_id: 2610
start_time: 2024-11-05 22:52:10
success: True
trace_id: 17788280058833158937

Scan 6674078

duration: 0:00:11.415548

exit_message:

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

id: 6674078

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_companies_staff_options/2024-11-05/1730866365",
        "key": "raw/newbookdev_newbookcustom_fields_companies_staff_options/2024-11-05/1730866365/custom_fields_companies_staff_options.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_companies_staff_options",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16569918327182235309,
        "service_name": "drive-thru",
        "span_id": 7560041814690471176,
        "trace_id": 11690795401257640024
    }
}

running: False
schema_name_id: 2610
start_time: 2024-11-05 22:33:09
success: True
trace_id: 11690795401257640024

Scan 6673583

duration: 0:00:13.951731

exit_message:

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

id: 6673583

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_companies_staff_options/2024-11-05/1730866268",
        "key": "raw/newbookdev_newbookcustom_fields_companies_staff_options/2024-11-05/1730866268/custom_fields_companies_staff_options.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_companies_staff_options",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5862657159968688482,
        "service_name": "drive-thru",
        "span_id": 12475644874185357364,
        "trace_id": 7613527039575002798
    }
}

running: False
schema_name_id: 2610
start_time: 2024-11-05 22:19:48
success: True
trace_id: 7613527039575002798

Scan 6671960

duration: 0:00:14.142877

exit_message:

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

id: 6671960

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_companies_staff_options/2024-11-04/1730785689",
        "key": "raw/newbookdev_newbookcustom_fields_companies_staff_options/2024-11-04/1730785689/custom_fields_companies_staff_options.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_companies_staff_options",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1425746244801258110,
        "service_name": "drive-thru",
        "span_id": 14410205855372991428,
        "trace_id": 5872088538907268426
    }
}

running: False
schema_name_id: 2610
start_time: 2024-11-05 04:19:34
success: True
trace_id: 5872088538907268426

Scan 6671000

duration: 0:00:14.335428

exit_message:

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

id: 6671000

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_companies_staff_options/2024-11-04/1730784801",
        "key": "raw/newbookdev_newbookcustom_fields_companies_staff_options/2024-11-04/1730784801/custom_fields_companies_staff_options.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_companies_staff_options",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14191423142059272770,
        "service_name": "drive-thru",
        "span_id": 11634579459312208202,
        "trace_id": 17400714773010599649
    }
}

running: False
schema_name_id: 2610
start_time: 2024-11-05 03:38:47
success: True
trace_id: 17400714773010599649

Scan 6670588

duration: 0:00:11.421265

exit_message:

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

id: 6670588

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_companies_staff_options/2024-11-04/1730785106",
        "key": "raw/newbookdev_newbookcustom_fields_companies_staff_options/2024-11-04/1730785106/custom_fields_companies_staff_options.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_companies_staff_options",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8652367991414085332,
        "service_name": "drive-thru",
        "span_id": 16101680184452258366,
        "trace_id": 2216333957440439327
    }
}

running: False
schema_name_id: 2610
start_time: 2024-11-05 03:27:39
success: True
trace_id: 2216333957440439327

Scan 6669672

duration: 0:00:14.023508

exit_message:

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

id: 6669672

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_companies_staff_options/2024-11-04/1730784198",
        "key": "raw/newbookdev_newbookcustom_fields_companies_staff_options/2024-11-04/1730784198/custom_fields_companies_staff_options.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_companies_staff_options",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2305333953170293218,
        "service_name": "drive-thru",
        "span_id": 10059137699223891690,
        "trace_id": 14689758903741636744
    }
}

running: False
schema_name_id: 2610
start_time: 2024-11-05 03:03:27
success: True
trace_id: 14689758903741636744

Scan 6669038

duration: 0:00:13.852583

exit_message:

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

id: 6669038

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_companies_staff_options/2024-11-04/1730784035",
        "key": "raw/newbookdev_newbookcustom_fields_companies_staff_options/2024-11-04/1730784035/custom_fields_companies_staff_options.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_companies_staff_options",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10637573533066405393,
        "service_name": "drive-thru",
        "span_id": 14318920589191592674,
        "trace_id": 6150127836683013440
    }
}

running: False
schema_name_id: 2610
start_time: 2024-11-05 02:46:44
success: True
trace_id: 6150127836683013440

Scan 6668383

duration: 0:00:11.376154

exit_message:

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

id: 6668383

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_companies_staff_options/2024-11-04/1730783885",
        "key": "raw/newbookdev_newbookcustom_fields_companies_staff_options/2024-11-04/1730783885/custom_fields_companies_staff_options.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_companies_staff_options",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13103059753967747467,
        "service_name": "drive-thru",
        "span_id": 5244271449808525844,
        "trace_id": 8316472979170087437
    }
}

running: False
schema_name_id: 2610
start_time: 2024-11-05 02:29:23
success: True
trace_id: 8316472979170087437

Scan 6667715

duration: 0:00:11.372703

exit_message:

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

id: 6667715

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_companies_staff_options/2024-11-04/1730783749",
        "key": "raw/newbookdev_newbookcustom_fields_companies_staff_options/2024-11-04/1730783749/custom_fields_companies_staff_options.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_companies_staff_options",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1229333092543405653,
        "service_name": "drive-thru",
        "span_id": 16188117270515162167,
        "trace_id": 18346186852183804832
    }
}

running: False
schema_name_id: 2610
start_time: 2024-11-05 02:11:46
success: True
trace_id: 18346186852183804832

Scan 6666887

duration: 0:00:11.332756

exit_message:

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

id: 6666887

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_companies_staff_options/2024-11-04/1730783605",
        "key": "raw/newbookdev_newbookcustom_fields_companies_staff_options/2024-11-04/1730783605/custom_fields_companies_staff_options.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_companies_staff_options",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7681463611102849680,
        "service_name": "drive-thru",
        "span_id": 16024083669629392108,
        "trace_id": 8998118499112536040
    }
}

running: False
schema_name_id: 2610
start_time: 2024-11-05 01:49:42
success: True
trace_id: 8998118499112536040

Scan 6666203

duration: 0:00:11.354413

exit_message:

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

id: 6666203

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_companies_staff_options/2024-11-04/1730783504",
        "key": "raw/newbookdev_newbookcustom_fields_companies_staff_options/2024-11-04/1730783504/custom_fields_companies_staff_options.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_companies_staff_options",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12744987307213846706,
        "service_name": "drive-thru",
        "span_id": 13588916728506704674,
        "trace_id": 555957090713513416
    }
}

running: False
schema_name_id: 2610
start_time: 2024-11-05 01:31:43
success: True
trace_id: 555957090713513416

Scan 6665486

duration: 0:00:11.378069

exit_message:

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

id: 6665486

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_companies_staff_options/2024-11-04/1730783286",
        "key": "raw/newbookdev_newbookcustom_fields_companies_staff_options/2024-11-04/1730783286/custom_fields_companies_staff_options.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_companies_staff_options",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6149340115676059085,
        "service_name": "drive-thru",
        "span_id": 459121978604023941,
        "trace_id": 9059934412879840321
    }
}

running: False
schema_name_id: 2610
start_time: 2024-11-05 01:12:55
success: True
trace_id: 9059934412879840321

Scan 6664448

duration: 0:00:13.914576

exit_message:

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

id: 6664448

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_companies_staff_options/2024-11-04/1730782889",
        "key": "raw/newbookdev_newbookcustom_fields_companies_staff_options/2024-11-04/1730782889/custom_fields_companies_staff_options.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_companies_staff_options",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14701769073479523231,
        "service_name": "drive-thru",
        "span_id": 10952893857231416789,
        "trace_id": 16226682109328022392
    }
}

running: False
schema_name_id: 2610
start_time: 2024-11-05 00:45:18
success: True
trace_id: 16226682109328022392

Scan 6664138

duration: 0:00:13.940744

exit_message:

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

id: 6664138

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_companies_staff_options/2024-11-04/1730782791",
        "key": "raw/newbookdev_newbookcustom_fields_companies_staff_options/2024-11-04/1730782791/custom_fields_companies_staff_options.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_companies_staff_options",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18258650009636174872,
        "service_name": "drive-thru",
        "span_id": 14679388603391554173,
        "trace_id": 6812215861330408122
    }
}

running: False
schema_name_id: 2610
start_time: 2024-11-05 00:37:13
success: True
trace_id: 6812215861330408122

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