Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookcustom_fields_companies_link

created: 2024-10-08 17:50:18
disabled: False
format: raw
id: 2594
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4748522

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcustom_fields_companies_link/2024-11-05/1730866448
id: 4748522
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: 2594
schema_scan_id: 6674554
updated: 2024-11-05 22:49:46

Version 4748180

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcustom_fields_companies_link/2024-11-05/1730866363
id: 4748180
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: 2594
schema_scan_id: 6674212
updated: 2024-11-05 22:37:29

Version 4747573

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcustom_fields_companies_link/2024-11-05/1730866267
id: 4747573
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: 2594
schema_scan_id: 6673605
updated: 2024-11-05 22:20:37

Version 4746702

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcustom_fields_companies_link/2024-11-04/1730785687
id: 4746702
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: 2594
schema_scan_id: 6671926
updated: 2024-11-05 04:17:26

Version 4746278

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcustom_fields_companies_link/2024-11-04/1730785105
id: 4746278
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: 2594
schema_scan_id: 6671499
updated: 2024-11-05 03:56:21

Version 4745277

created: 2024-11-05 03:25:15

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcustom_fields_companies_link/2024-11-04/1730784800
id: 4745277
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: 2594
schema_scan_id: 6670494
updated: 2024-11-05 03:25:26

Version 4744823

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcustom_fields_companies_link/2024-11-04/1730784196
id: 4744823
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: 2594
schema_scan_id: 6670040
updated: 2024-11-05 03:13:27

Version 4744209

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcustom_fields_companies_link/2024-11-04/1730784034
id: 4744209
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: 2594
schema_scan_id: 6669426
updated: 2024-11-05 02:57:05

Version 4743332

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcustom_fields_companies_link/2024-11-04/1730783884
id: 4743332
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: 2594
schema_scan_id: 6668549
updated: 2024-11-05 02:34:03

Version 4742470

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcustom_fields_companies_link/2024-11-04/1730783748
id: 4742470
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: 2594
schema_scan_id: 6667687
updated: 2024-11-05 02:11:15

Version 4741912

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcustom_fields_companies_link/2024-11-04/1730783650
id: 4741912
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: 2594
schema_scan_id: 6667129
updated: 2024-11-05 01:56:16

Version 4740984

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcustom_fields_companies_link/2024-11-04/1730783503
id: 4740984
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: 2594
schema_scan_id: 6666201
updated: 2024-11-05 01:31:55

Version 4739913

created: 2024-11-05 01:03:18

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcustom_fields_companies_link/2024-11-04/1730783285
id: 4739913
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: 2594
schema_scan_id: 6665130
updated: 2024-11-05 01:03:29

Version 4739452

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcustom_fields_companies_link/2024-11-04/1730782887
id: 4739452
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: 2594
schema_scan_id: 6664667
updated: 2024-11-05 00:51:17

Version 4738960

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcustom_fields_companies_link/2024-11-04/1730782790
id: 4738960
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: 2594
schema_scan_id: 6664174
updated: 2024-11-05 00:38:22

Schema Scans: 15

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

Scan 6674554

duration: 0:00:14.097888

exit_message:

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

id: 6674554

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_link/2024-11-05/1730866448",
        "key": "raw/newbookdev_newbookcustom_fields_companies_link/2024-11-05/1730866448/custom_fields_companies_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_companies_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13328138148180924864,
        "service_name": "drive-thru",
        "span_id": 16408746659527541982,
        "trace_id": 6520748011668265691
    }
}

running: False
schema_name_id: 2594
start_time: 2024-11-05 22:49:32
success: True
trace_id: 6520748011668265691

Scan 6674212

duration: 0:00:14.061929

exit_message:

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

id: 6674212

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_link/2024-11-05/1730866363",
        "key": "raw/newbookdev_newbookcustom_fields_companies_link/2024-11-05/1730866363/custom_fields_companies_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_companies_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 822870607884819647,
        "service_name": "drive-thru",
        "span_id": 9597373660384762891,
        "trace_id": 15387279181746103004
    }
}

running: False
schema_name_id: 2594
start_time: 2024-11-05 22:37:15
success: True
trace_id: 15387279181746103004

Scan 6673605

duration: 0:00:11.448684

exit_message:

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

id: 6673605

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_link/2024-11-05/1730866267",
        "key": "raw/newbookdev_newbookcustom_fields_companies_link/2024-11-05/1730866267/custom_fields_companies_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_companies_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7895314416195769011,
        "service_name": "drive-thru",
        "span_id": 17509942768606468264,
        "trace_id": 16604791886920108286
    }
}

running: False
schema_name_id: 2594
start_time: 2024-11-05 22:20:26
success: True
trace_id: 16604791886920108286

Scan 6671926

duration: 0:00:11.600756

exit_message:

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

id: 6671926

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_link/2024-11-04/1730785687",
        "key": "raw/newbookdev_newbookcustom_fields_companies_link/2024-11-04/1730785687/custom_fields_companies_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_companies_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3636288142422516637,
        "service_name": "drive-thru",
        "span_id": 454325465365082083,
        "trace_id": 15967716640857932111
    }
}

running: False
schema_name_id: 2594
start_time: 2024-11-05 04:17:14
success: True
trace_id: 15967716640857932111

Scan 6671499

duration: 0:00:11.672864

exit_message:

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

id: 6671499

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_link/2024-11-04/1730785105",
        "key": "raw/newbookdev_newbookcustom_fields_companies_link/2024-11-04/1730785105/custom_fields_companies_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_companies_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12512898013085858045,
        "service_name": "drive-thru",
        "span_id": 10068882682089641917,
        "trace_id": 1370715507290866813
    }
}

running: False
schema_name_id: 2594
start_time: 2024-11-05 03:56:09
success: True
trace_id: 1370715507290866813

Scan 6670494

duration: 0:00:11.409383

exit_message:

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

id: 6670494

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_link/2024-11-04/1730784800",
        "key": "raw/newbookdev_newbookcustom_fields_companies_link/2024-11-04/1730784800/custom_fields_companies_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_companies_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9338192075520905684,
        "service_name": "drive-thru",
        "span_id": 8971508561592183072,
        "trace_id": 2592437777284013362
    }
}

running: False
schema_name_id: 2594
start_time: 2024-11-05 03:25:14
success: True
trace_id: 2592437777284013362

Scan 6670040

duration: 0:00:11.678174

exit_message:

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

id: 6670040

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_link/2024-11-04/1730784196",
        "key": "raw/newbookdev_newbookcustom_fields_companies_link/2024-11-04/1730784196/custom_fields_companies_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_companies_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4587931582101156895,
        "service_name": "drive-thru",
        "span_id": 14268976248536984991,
        "trace_id": 3392066102489238082
    }
}

running: False
schema_name_id: 2594
start_time: 2024-11-05 03:13:16
success: True
trace_id: 3392066102489238082

Scan 6669426

duration: 0:00:13.775295

exit_message:

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

id: 6669426

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_link/2024-11-04/1730784034",
        "key": "raw/newbookdev_newbookcustom_fields_companies_link/2024-11-04/1730784034/custom_fields_companies_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_companies_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17202976009577634257,
        "service_name": "drive-thru",
        "span_id": 11830397065496372746,
        "trace_id": 9292928405571311206
    }
}

running: False
schema_name_id: 2594
start_time: 2024-11-05 02:56:51
success: True
trace_id: 9292928405571311206

Scan 6668549

duration: 0:00:13.853915

exit_message:

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

id: 6668549

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_link/2024-11-04/1730783884",
        "key": "raw/newbookdev_newbookcustom_fields_companies_link/2024-11-04/1730783884/custom_fields_companies_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_companies_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10888901327498588054,
        "service_name": "drive-thru",
        "span_id": 7280261612269734642,
        "trace_id": 14275688475157433938
    }
}

running: False
schema_name_id: 2594
start_time: 2024-11-05 02:33:49
success: True
trace_id: 14275688475157433938

Scan 6667687

duration: 0:00:14.179293

exit_message:

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

id: 6667687

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_link/2024-11-04/1730783748",
        "key": "raw/newbookdev_newbookcustom_fields_companies_link/2024-11-04/1730783748/custom_fields_companies_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_companies_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2177622443128411482,
        "service_name": "drive-thru",
        "span_id": 528536027789947217,
        "trace_id": 8807763673957066171
    }
}

running: False
schema_name_id: 2594
start_time: 2024-11-05 02:11:01
success: True
trace_id: 8807763673957066171

Scan 6667129

duration: 0:00:11.463764

exit_message:

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

id: 6667129

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_link/2024-11-04/1730783650",
        "key": "raw/newbookdev_newbookcustom_fields_companies_link/2024-11-04/1730783650/custom_fields_companies_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_companies_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4601600497282936760,
        "service_name": "drive-thru",
        "span_id": 15661738551182872649,
        "trace_id": 2317390469325478896
    }
}

running: False
schema_name_id: 2594
start_time: 2024-11-05 01:56:04
success: True
trace_id: 2317390469325478896

Scan 6666201

duration: 0:00:13.820179

exit_message:

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

id: 6666201

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_link/2024-11-04/1730783503",
        "key": "raw/newbookdev_newbookcustom_fields_companies_link/2024-11-04/1730783503/custom_fields_companies_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_companies_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3553981263180727142,
        "service_name": "drive-thru",
        "span_id": 13003012705320197819,
        "trace_id": 13532964660695921808
    }
}

running: False
schema_name_id: 2594
start_time: 2024-11-05 01:31:41
success: True
trace_id: 13532964660695921808

Scan 6665130

duration: 0:00:11.494687

exit_message:

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

id: 6665130

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_link/2024-11-04/1730783285",
        "key": "raw/newbookdev_newbookcustom_fields_companies_link/2024-11-04/1730783285/custom_fields_companies_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_companies_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 765046980644513032,
        "service_name": "drive-thru",
        "span_id": 8927830962181242801,
        "trace_id": 4170964442339471864
    }
}

running: False
schema_name_id: 2594
start_time: 2024-11-05 01:03:18
success: True
trace_id: 4170964442339471864

Scan 6664667

duration: 0:00:14.017250

exit_message:

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

id: 6664667

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_link/2024-11-04/1730782887",
        "key": "raw/newbookdev_newbookcustom_fields_companies_link/2024-11-04/1730782887/custom_fields_companies_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_companies_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2643460522508893396,
        "service_name": "drive-thru",
        "span_id": 3481954531820988899,
        "trace_id": 3076433778832029252
    }
}

running: False
schema_name_id: 2594
start_time: 2024-11-05 00:51:03
success: True
trace_id: 3076433778832029252

Scan 6664174

duration: 0:00:11.443037

exit_message:

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

id: 6664174

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_link/2024-11-04/1730782790",
        "key": "raw/newbookdev_newbookcustom_fields_companies_link/2024-11-04/1730782790/custom_fields_companies_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_companies_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4666864872774136612,
        "service_name": "drive-thru",
        "span_id": 7977723777145181229,
        "trace_id": 1835758843770989029
    }
}

running: False
schema_name_id: 2594
start_time: 2024-11-05 00:38:11
success: True
trace_id: 1835758843770989029

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:32

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