Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookcustom_fields_guests_link

created: 2024-10-08 17:48:32
disabled: False
format: raw
id: 2569
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4748519

created: 2024-11-05 22:49:27

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcustom_fields_guests_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcustom_fields_guests_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `for`  string , `for_id`  string , `custom_field_id`  string , `value`  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_guests_link/2024-11-05/1730866453'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcustom_fields_guests_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcustom_fields_guests_link/2024-11-05/1730866453
id: 4748519
processed: 1

raw_data:

{
    "custom_field_id": 5,
    "for": 3,
    "for_id": 4,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "value": 6
}

schema_attributes:

{
    "custom_field_id": "string",
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "value": "string"
}

schema_name_id: 2569
schema_scan_id: 6674551
updated: 2024-11-05 22:49:41

Version 4748102

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcustom_fields_guests_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcustom_fields_guests_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `for`  string , `for_id`  string , `custom_field_id`  string , `value`  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_guests_link/2024-11-05/1730866367'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcustom_fields_guests_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcustom_fields_guests_link/2024-11-05/1730866367
id: 4748102
processed: 1

raw_data:

{
    "custom_field_id": 5,
    "for": 3,
    "for_id": 4,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "value": 6
}

schema_attributes:

{
    "custom_field_id": "string",
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "value": "string"
}

schema_name_id: 2569
schema_scan_id: 6674135
updated: 2024-11-05 22:35:10

Version 4747575

created: 2024-11-05 22:20:27

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcustom_fields_guests_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcustom_fields_guests_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `for`  string , `for_id`  string , `custom_field_id`  string , `value`  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_guests_link/2024-11-05/1730866269'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcustom_fields_guests_link"
]

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

raw_data:

{
    "custom_field_id": 5,
    "for": 3,
    "for_id": 4,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "value": 6
}

schema_attributes:

{
    "custom_field_id": "string",
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "value": "string"
}

schema_name_id: 2569
schema_scan_id: 6673607
updated: 2024-11-05 22:20:38

Version 4746949

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcustom_fields_guests_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcustom_fields_guests_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `for`  string , `for_id`  string , `custom_field_id`  string , `value`  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_guests_link/2024-11-04/1730785690'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcustom_fields_guests_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcustom_fields_guests_link/2024-11-04/1730785690
id: 4746949
processed: 1

raw_data:

{
    "custom_field_id": 5,
    "for": 3,
    "for_id": 4,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "value": 6
}

schema_attributes:

{
    "custom_field_id": "string",
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "value": "string"
}

schema_name_id: 2569
schema_scan_id: 6672180
updated: 2024-11-05 04:35:04

Version 4746040

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcustom_fields_guests_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcustom_fields_guests_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `for`  string , `for_id`  string , `custom_field_id`  string , `value`  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_guests_link/2024-11-04/1730785107'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcustom_fields_guests_link"
]

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

raw_data:

{
    "custom_field_id": 5,
    "for": 3,
    "for_id": 4,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "value": 6
}

schema_attributes:

{
    "custom_field_id": "string",
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "value": "string"
}

schema_name_id: 2569
schema_scan_id: 6671261
updated: 2024-11-05 03:47:23

Version 4745784

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcustom_fields_guests_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcustom_fields_guests_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `for`  string , `for_id`  string , `custom_field_id`  string , `value`  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_guests_link/2024-11-04/1730784802'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcustom_fields_guests_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcustom_fields_guests_link/2024-11-04/1730784802
id: 4745784
processed: 1

raw_data:

{
    "custom_field_id": 5,
    "for": 3,
    "for_id": 4,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "value": 6
}

schema_attributes:

{
    "custom_field_id": "string",
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "value": "string"
}

schema_name_id: 2569
schema_scan_id: 6671001
updated: 2024-11-05 03:39:03

Version 4744845

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcustom_fields_guests_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcustom_fields_guests_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `for`  string , `for_id`  string , `custom_field_id`  string , `value`  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_guests_link/2024-11-04/1730784198'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcustom_fields_guests_link"
]

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

raw_data:

{
    "custom_field_id": 5,
    "for": 3,
    "for_id": 4,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "value": 6
}

schema_attributes:

{
    "custom_field_id": "string",
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "value": "string"
}

schema_name_id: 2569
schema_scan_id: 6670062
updated: 2024-11-05 03:14:06

Version 4743907

created: 2024-11-05 02:49:00

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcustom_fields_guests_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcustom_fields_guests_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `for`  string , `for_id`  string , `custom_field_id`  string , `value`  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_guests_link/2024-11-04/1730784035'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcustom_fields_guests_link"
]

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

raw_data:

{
    "custom_field_id": 5,
    "for": 3,
    "for_id": 4,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "value": 6
}

schema_attributes:

{
    "custom_field_id": "string",
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "value": "string"
}

schema_name_id: 2569
schema_scan_id: 6669126
updated: 2024-11-05 02:49:11

Version 4743423

created: 2024-11-05 02:36:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcustom_fields_guests_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcustom_fields_guests_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `for`  string , `for_id`  string , `custom_field_id`  string , `value`  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_guests_link/2024-11-04/1730783885'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcustom_fields_guests_link"
]

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

raw_data:

{
    "custom_field_id": 5,
    "for": 3,
    "for_id": 4,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "value": 6
}

schema_attributes:

{
    "custom_field_id": "string",
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "value": "string"
}

schema_name_id: 2569
schema_scan_id: 6668640
updated: 2024-11-05 02:36:27

Version 4741938

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcustom_fields_guests_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcustom_fields_guests_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `for`  string , `for_id`  string , `custom_field_id`  string , `value`  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_guests_link/2024-11-04/1730783749'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcustom_fields_guests_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcustom_fields_guests_link/2024-11-04/1730783749
id: 4741938
processed: 1

raw_data:

{
    "custom_field_id": 5,
    "for": 3,
    "for_id": 4,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "value": 6
}

schema_attributes:

{
    "custom_field_id": "string",
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "value": "string"
}

schema_name_id: 2569
schema_scan_id: 6667155
updated: 2024-11-05 01:56:53

Version 4741702

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcustom_fields_guests_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcustom_fields_guests_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `for`  string , `for_id`  string , `custom_field_id`  string , `value`  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_guests_link/2024-11-04/1730783651'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcustom_fields_guests_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcustom_fields_guests_link/2024-11-04/1730783651
id: 4741702
processed: 1

raw_data:

{
    "custom_field_id": 5,
    "for": 3,
    "for_id": 4,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "value": 6
}

schema_attributes:

{
    "custom_field_id": "string",
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "value": "string"
}

schema_name_id: 2569
schema_scan_id: 6666919
updated: 2024-11-05 01:50:44

Version 4740891

created: 2024-11-05 01:29:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcustom_fields_guests_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcustom_fields_guests_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `for`  string , `for_id`  string , `custom_field_id`  string , `value`  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_guests_link/2024-11-04/1730783505'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcustom_fields_guests_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcustom_fields_guests_link/2024-11-04/1730783505
id: 4740891
processed: 1

raw_data:

{
    "custom_field_id": 5,
    "for": 3,
    "for_id": 4,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "value": 6
}

schema_attributes:

{
    "custom_field_id": "string",
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "value": "string"
}

schema_name_id: 2569
schema_scan_id: 6666109
updated: 2024-11-05 01:29:25

Version 4740185

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcustom_fields_guests_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcustom_fields_guests_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `for`  string , `for_id`  string , `custom_field_id`  string , `value`  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_guests_link/2024-11-04/1730783286'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcustom_fields_guests_link"
]

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

raw_data:

{
    "custom_field_id": 5,
    "for": 3,
    "for_id": 4,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "value": 6
}

schema_attributes:

{
    "custom_field_id": "string",
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "value": "string"
}

schema_name_id: 2569
schema_scan_id: 6665402
updated: 2024-11-05 01:10:51

Version 4739328

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcustom_fields_guests_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcustom_fields_guests_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `for`  string , `for_id`  string , `custom_field_id`  string , `value`  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_guests_link/2024-11-04/1730782888'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcustom_fields_guests_link"
]

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

raw_data:

{
    "custom_field_id": 5,
    "for": 3,
    "for_id": 4,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "value": 6
}

schema_attributes:

{
    "custom_field_id": "string",
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "value": "string"
}

schema_name_id: 2569
schema_scan_id: 6664543
updated: 2024-11-05 00:47:59

Version 4738339

created: 2024-11-05 00:21:50

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcustom_fields_guests_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcustom_fields_guests_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `for`  string , `for_id`  string , `custom_field_id`  string , `value`  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_guests_link/2024-11-04/1730782746'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcustom_fields_guests_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcustom_fields_guests_link/2024-11-04/1730782746
id: 4738339
processed: 1

raw_data:

{
    "custom_field_id": 5,
    "for": 3,
    "for_id": 4,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "value": 6
}

schema_attributes:

{
    "custom_field_id": "string",
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "value": "string"
}

schema_name_id: 2569
schema_scan_id: 6663549
updated: 2024-11-05 00:22:04

Schema Scans: 15

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

Scan 6674551

duration: 0:00:14.123403

exit_message:

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

id: 6674551

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_guests_link/2024-11-05/1730866453",
        "key": "raw/newbookdev_newbookcustom_fields_guests_link/2024-11-05/1730866453/custom_fields_guests_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_guests_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5524471879892399019,
        "service_name": "drive-thru",
        "span_id": 520795622216365700,
        "trace_id": 4738779626066341844
    }
}

running: False
schema_name_id: 2569
start_time: 2024-11-05 22:49:27
success: True
trace_id: 4738779626066341844

Scan 6674135

duration: 0:00:14.125169

exit_message:

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

id: 6674135

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_guests_link/2024-11-05/1730866367",
        "key": "raw/newbookdev_newbookcustom_fields_guests_link/2024-11-05/1730866367/custom_fields_guests_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_guests_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10911886566810768775,
        "service_name": "drive-thru",
        "span_id": 7574363734095596676,
        "trace_id": 1624851520285881717
    }
}

running: False
schema_name_id: 2569
start_time: 2024-11-05 22:34:56
success: True
trace_id: 1624851520285881717

Scan 6673607

duration: 0:00:11.431970

exit_message:

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

id: 6673607

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_guests_link/2024-11-05/1730866269",
        "key": "raw/newbookdev_newbookcustom_fields_guests_link/2024-11-05/1730866269/custom_fields_guests_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_guests_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2018791437574471473,
        "service_name": "drive-thru",
        "span_id": 574186440584094817,
        "trace_id": 15381891974049191996
    }
}

running: False
schema_name_id: 2569
start_time: 2024-11-05 22:20:26
success: True
trace_id: 15381891974049191996

Scan 6672180

duration: 0:00:11.598908

exit_message:

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

id: 6672180

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_guests_link/2024-11-04/1730785690",
        "key": "raw/newbookdev_newbookcustom_fields_guests_link/2024-11-04/1730785690/custom_fields_guests_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_guests_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5902060408201990104,
        "service_name": "drive-thru",
        "span_id": 11536444024231841173,
        "trace_id": 10437866896419567838
    }
}

running: False
schema_name_id: 2569
start_time: 2024-11-05 04:34:52
success: True
trace_id: 10437866896419567838

Scan 6671261

duration: 0:00:14.087386

exit_message:

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

id: 6671261

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_guests_link/2024-11-04/1730785107",
        "key": "raw/newbookdev_newbookcustom_fields_guests_link/2024-11-04/1730785107/custom_fields_guests_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_guests_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17846288081915864141,
        "service_name": "drive-thru",
        "span_id": 13814383832643814370,
        "trace_id": 18104583406680873055
    }
}

running: False
schema_name_id: 2569
start_time: 2024-11-05 03:47:09
success: True
trace_id: 18104583406680873055

Scan 6671001

duration: 0:00:13.934252

exit_message:

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

id: 6671001

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_guests_link/2024-11-04/1730784802",
        "key": "raw/newbookdev_newbookcustom_fields_guests_link/2024-11-04/1730784802/custom_fields_guests_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_guests_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4077541673919767535,
        "service_name": "drive-thru",
        "span_id": 11700354101601120794,
        "trace_id": 12506840022376041650
    }
}

running: False
schema_name_id: 2569
start_time: 2024-11-05 03:38:49
success: True
trace_id: 12506840022376041650

Scan 6670062

duration: 0:00:13.828121

exit_message:

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

id: 6670062

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_guests_link/2024-11-04/1730784198",
        "key": "raw/newbookdev_newbookcustom_fields_guests_link/2024-11-04/1730784198/custom_fields_guests_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_guests_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8915398967054671690,
        "service_name": "drive-thru",
        "span_id": 11818789051020848049,
        "trace_id": 6255500496674772919
    }
}

running: False
schema_name_id: 2569
start_time: 2024-11-05 03:13:52
success: True
trace_id: 6255500496674772919

Scan 6669126

duration: 0:00:11.346380

exit_message:

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

id: 6669126

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_guests_link/2024-11-04/1730784035",
        "key": "raw/newbookdev_newbookcustom_fields_guests_link/2024-11-04/1730784035/custom_fields_guests_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_guests_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2071044584994695392,
        "service_name": "drive-thru",
        "span_id": 16542212965680417587,
        "trace_id": 8100084178998195405
    }
}

running: False
schema_name_id: 2569
start_time: 2024-11-05 02:49:00
success: True
trace_id: 8100084178998195405

Scan 6668640

duration: 0:00:13.983831

exit_message:

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

id: 6668640

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_guests_link/2024-11-04/1730783885",
        "key": "raw/newbookdev_newbookcustom_fields_guests_link/2024-11-04/1730783885/custom_fields_guests_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_guests_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8367557367892312985,
        "service_name": "drive-thru",
        "span_id": 536948414067679439,
        "trace_id": 10760139410884699432
    }
}

running: False
schema_name_id: 2569
start_time: 2024-11-05 02:36:13
success: True
trace_id: 10760139410884699432

Scan 6667155

duration: 0:00:11.446742

exit_message:

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

id: 6667155

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_guests_link/2024-11-04/1730783749",
        "key": "raw/newbookdev_newbookcustom_fields_guests_link/2024-11-04/1730783749/custom_fields_guests_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_guests_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12725128950205053771,
        "service_name": "drive-thru",
        "span_id": 3630382453179752424,
        "trace_id": 14686303941858783610
    }
}

running: False
schema_name_id: 2569
start_time: 2024-11-05 01:56:42
success: True
trace_id: 14686303941858783610

Scan 6666919

duration: 0:00:13.950619

exit_message:

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

id: 6666919

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_guests_link/2024-11-04/1730783651",
        "key": "raw/newbookdev_newbookcustom_fields_guests_link/2024-11-04/1730783651/custom_fields_guests_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_guests_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 664277056854990017,
        "service_name": "drive-thru",
        "span_id": 14037392217876997634,
        "trace_id": 12717810141867790834
    }
}

running: False
schema_name_id: 2569
start_time: 2024-11-05 01:50:30
success: True
trace_id: 12717810141867790834

Scan 6666109

duration: 0:00:11.456929

exit_message:

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

id: 6666109

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_guests_link/2024-11-04/1730783505",
        "key": "raw/newbookdev_newbookcustom_fields_guests_link/2024-11-04/1730783505/custom_fields_guests_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_guests_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16910313910855101221,
        "service_name": "drive-thru",
        "span_id": 10153250905554689104,
        "trace_id": 9370098505096894307
    }
}

running: False
schema_name_id: 2569
start_time: 2024-11-05 01:29:14
success: True
trace_id: 9370098505096894307

Scan 6665402

duration: 0:00:13.812558

exit_message:

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

id: 6665402

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_guests_link/2024-11-04/1730783286",
        "key": "raw/newbookdev_newbookcustom_fields_guests_link/2024-11-04/1730783286/custom_fields_guests_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_guests_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6440513469410685510,
        "service_name": "drive-thru",
        "span_id": 836046041399430797,
        "trace_id": 12338246315419314783
    }
}

running: False
schema_name_id: 2569
start_time: 2024-11-05 01:10:37
success: True
trace_id: 12338246315419314783

Scan 6664543

duration: 0:00:11.345458

exit_message:

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

id: 6664543

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_guests_link/2024-11-04/1730782888",
        "key": "raw/newbookdev_newbookcustom_fields_guests_link/2024-11-04/1730782888/custom_fields_guests_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_guests_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4160412919732867438,
        "service_name": "drive-thru",
        "span_id": 6691239513895712085,
        "trace_id": 11458613690661132069
    }
}

running: False
schema_name_id: 2569
start_time: 2024-11-05 00:47:47
success: True
trace_id: 11458613690661132069

Scan 6663549

duration: 0:00:13.885039

exit_message:

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

id: 6663549

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_guests_link/2024-11-04/1730782746",
        "key": "raw/newbookdev_newbookcustom_fields_guests_link/2024-11-04/1730782746/custom_fields_guests_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_guests_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13653221059911167525,
        "service_name": "drive-thru",
        "span_id": 818525940083639996,
        "trace_id": 10620886917661136649
    }
}

running: False
schema_name_id: 2569
start_time: 2024-11-05 00:21:50
success: True
trace_id: 10620886917661136649

Partitions:

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

Schema:

attributes:

{
    "custom_field_id": "string",
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "value": "string"
}

created: 2024-11-05 22:49:27

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_guests_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `for`  string , `for_id`  string , `custom_field_id`  string , `value`  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_guests_link/2024-11-05/1730866453'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcustom_fields_guests_link`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcustom_fields_guests_link"
}

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:48:32",
        "disabled": false,
        "format": "raw",
        "id": 2569,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "newbookdev_newbookcustom_fields_guests_link"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "custom_field_id": "string",
            "for": "string",
            "for_id": "string",
            "id": "string",
            "newbook_region": "string",
            "tenant": "string",
            "value": "string"
        },
        "created": "2024-11-05 22:49:27",
        "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_guests_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `for`  string , `for_id`  string , `custom_field_id`  string , `value`  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_guests_link/2024-11-05/1730866453'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcustom_fields_guests_link`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcustom_fields_guests_link"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}