Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookleads_interests

created: 2024-10-08 18:02:03
disabled: False
format: raw
id: 2749
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4748963

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookleads_interests/2024-11-05/1730866536
id: 4748963
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2749
schema_scan_id: 6674995
updated: 2024-11-05 23:11:23

Version 4748678

created: 2024-11-05 22:56:12

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookleads_interests/2024-11-05/1730866473
id: 4748678
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2749
schema_scan_id: 6674710
updated: 2024-11-05 22:56:23

Version 4747950

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookleads_interests/2024-11-05/1730866339
id: 4747950
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2749
schema_scan_id: 6673982
updated: 2024-11-05 22:30:27

Version 4747107

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookleads_interests/2024-11-04/1730785744
id: 4747107
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2749
schema_scan_id: 6672339
updated: 2024-11-05 04:51:14

Version 4746537

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookleads_interests/2024-11-04/1730785137
id: 4746537
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2749
schema_scan_id: 6671760
updated: 2024-11-05 04:08:28

Version 4745528

created: 2024-11-05 03:31:49

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookleads_interests/2024-11-04/1730784832
id: 4745528
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2749
schema_scan_id: 6670745
updated: 2024-11-05 03:32:03

Version 4744441

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookleads_interests/2024-11-04/1730784066
id: 4744441
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2749
schema_scan_id: 6669658
updated: 2024-11-05 03:03:21

Version 4744186

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookleads_interests/2024-11-04/1730784229
id: 4744186
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2749
schema_scan_id: 6669403
updated: 2024-11-05 02:56:28

Version 4743328

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookleads_interests/2024-11-04/1730783909
id: 4743328
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2749
schema_scan_id: 6668546
updated: 2024-11-05 02:33:52

Version 4742750

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookleads_interests/2024-11-04/1730783780
id: 4742750
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2749
schema_scan_id: 6667967
updated: 2024-11-05 02:18:39

Version 4742081

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookleads_interests/2024-11-04/1730783674
id: 4742081
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2749
schema_scan_id: 6667298
updated: 2024-11-05 02:00:45

Version 4741219

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookleads_interests/2024-11-04/1730783537
id: 4741219
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2749
schema_scan_id: 6666436
updated: 2024-11-05 01:38:07

Version 4740468

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookleads_interests/2024-11-04/1730783318
id: 4740468
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2749
schema_scan_id: 6665685
updated: 2024-11-05 01:18:20

Version 4739577

created: 2024-11-05 00:54:18

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookleads_interests/2024-11-04/1730782918
id: 4739577
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2749
schema_scan_id: 6664793
updated: 2024-11-05 00:54:29

Version 4738563

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookleads_interests/2024-11-04/1730782754
id: 4738563
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2749
schema_scan_id: 6663776
updated: 2024-11-05 00:27:55

Schema Scans: 15

Last at 2024-11-05 23:11:12

Scan 6674995

duration: 0:00:11.530013

exit_message:

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

id: 6674995

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_newbookleads_interests/2024-11-05/1730866536",
        "key": "raw/newbookdev_newbookleads_interests/2024-11-05/1730866536/leads_interests.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookleads_interests",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16657480976015004295,
        "service_name": "drive-thru",
        "span_id": 12574368885977303662,
        "trace_id": 1296029464507003212
    }
}

running: False
schema_name_id: 2749
start_time: 2024-11-05 23:11:12
success: True
trace_id: 1296029464507003212

Scan 6674710

duration: 0:00:11.529934

exit_message:

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

id: 6674710

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_newbookleads_interests/2024-11-05/1730866473",
        "key": "raw/newbookdev_newbookleads_interests/2024-11-05/1730866473/leads_interests.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookleads_interests",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12306100840053102239,
        "service_name": "drive-thru",
        "span_id": 1219202274813067171,
        "trace_id": 11036417182268632973
    }
}

running: False
schema_name_id: 2749
start_time: 2024-11-05 22:56:12
success: True
trace_id: 11036417182268632973

Scan 6673982

duration: 0:00:11.442435

exit_message:

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

id: 6673982

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_newbookleads_interests/2024-11-05/1730866339",
        "key": "raw/newbookdev_newbookleads_interests/2024-11-05/1730866339/leads_interests.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookleads_interests",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12682908844881956498,
        "service_name": "drive-thru",
        "span_id": 14334850446419471946,
        "trace_id": 9925011706949136840
    }
}

running: False
schema_name_id: 2749
start_time: 2024-11-05 22:30:15
success: True
trace_id: 9925011706949136840

Scan 6672339

duration: 0:00:14.091474

exit_message:

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

id: 6672339

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_newbookleads_interests/2024-11-04/1730785744",
        "key": "raw/newbookdev_newbookleads_interests/2024-11-04/1730785744/leads_interests.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookleads_interests",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2180289527694116294,
        "service_name": "drive-thru",
        "span_id": 8466894521648371972,
        "trace_id": 8137977445468612976
    }
}

running: False
schema_name_id: 2749
start_time: 2024-11-05 04:51:00
success: True
trace_id: 8137977445468612976

Scan 6671760

duration: 0:00:11.737728

exit_message:

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

id: 6671760

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_newbookleads_interests/2024-11-04/1730785137",
        "key": "raw/newbookdev_newbookleads_interests/2024-11-04/1730785137/leads_interests.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookleads_interests",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7908062598198276080,
        "service_name": "drive-thru",
        "span_id": 15227447905460333982,
        "trace_id": 11694548296803415350
    }
}

running: False
schema_name_id: 2749
start_time: 2024-11-05 04:08:16
success: True
trace_id: 11694548296803415350

Scan 6670745

duration: 0:00:13.859394

exit_message:

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

id: 6670745

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_newbookleads_interests/2024-11-04/1730784832",
        "key": "raw/newbookdev_newbookleads_interests/2024-11-04/1730784832/leads_interests.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookleads_interests",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17203721167203245859,
        "service_name": "drive-thru",
        "span_id": 3076417315651142856,
        "trace_id": 7512024963680291193
    }
}

running: False
schema_name_id: 2749
start_time: 2024-11-05 03:31:49
success: True
trace_id: 7512024963680291193

Scan 6669658

duration: 0:00:14.036224

exit_message:

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

id: 6669658

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_newbookleads_interests/2024-11-04/1730784066",
        "key": "raw/newbookdev_newbookleads_interests/2024-11-04/1730784066/leads_interests.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookleads_interests",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14489179564203248017,
        "service_name": "drive-thru",
        "span_id": 16150916796724103666,
        "trace_id": 7399657800456774739
    }
}

running: False
schema_name_id: 2749
start_time: 2024-11-05 03:03:07
success: True
trace_id: 7399657800456774739

Scan 6669403

duration: 0:00:13.883580

exit_message:

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

id: 6669403

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_newbookleads_interests/2024-11-04/1730784229",
        "key": "raw/newbookdev_newbookleads_interests/2024-11-04/1730784229/leads_interests.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookleads_interests",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 729176471011861928,
        "service_name": "drive-thru",
        "span_id": 1794243116537157117,
        "trace_id": 2305257597290080944
    }
}

running: False
schema_name_id: 2749
start_time: 2024-11-05 02:56:14
success: True
trace_id: 2305257597290080944

Scan 6668546

duration: 0:00:11.454804

exit_message:

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

id: 6668546

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_newbookleads_interests/2024-11-04/1730783909",
        "key": "raw/newbookdev_newbookleads_interests/2024-11-04/1730783909/leads_interests.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookleads_interests",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9650202280429041039,
        "service_name": "drive-thru",
        "span_id": 8843588966895285067,
        "trace_id": 3304815738394140257
    }
}

running: False
schema_name_id: 2749
start_time: 2024-11-05 02:33:41
success: True
trace_id: 3304815738394140257

Scan 6667967

duration: 0:00:11.532976

exit_message:

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

id: 6667967

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_newbookleads_interests/2024-11-04/1730783780",
        "key": "raw/newbookdev_newbookleads_interests/2024-11-04/1730783780/leads_interests.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookleads_interests",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7296846895008810577,
        "service_name": "drive-thru",
        "span_id": 13584711823086970845,
        "trace_id": 7848707330941154553
    }
}

running: False
schema_name_id: 2749
start_time: 2024-11-05 02:18:27
success: True
trace_id: 7848707330941154553

Scan 6667298

duration: 0:00:13.914402

exit_message:

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

id: 6667298

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_newbookleads_interests/2024-11-04/1730783674",
        "key": "raw/newbookdev_newbookleads_interests/2024-11-04/1730783674/leads_interests.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookleads_interests",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7820399203525367415,
        "service_name": "drive-thru",
        "span_id": 10592671648163634775,
        "trace_id": 4736278443529861631
    }
}

running: False
schema_name_id: 2749
start_time: 2024-11-05 02:00:31
success: True
trace_id: 4736278443529861631

Scan 6666436

duration: 0:00:13.936193

exit_message:

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

id: 6666436

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_newbookleads_interests/2024-11-04/1730783537",
        "key": "raw/newbookdev_newbookleads_interests/2024-11-04/1730783537/leads_interests.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookleads_interests",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12962094419539073508,
        "service_name": "drive-thru",
        "span_id": 1750096880078654137,
        "trace_id": 11149597064369929508
    }
}

running: False
schema_name_id: 2749
start_time: 2024-11-05 01:37:53
success: True
trace_id: 11149597064369929508

Scan 6665685

duration: 0:00:13.923264

exit_message:

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

id: 6665685

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_newbookleads_interests/2024-11-04/1730783318",
        "key": "raw/newbookdev_newbookleads_interests/2024-11-04/1730783318/leads_interests.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookleads_interests",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3402700756139839904,
        "service_name": "drive-thru",
        "span_id": 12509636197842368646,
        "trace_id": 6625035029107317188
    }
}

running: False
schema_name_id: 2749
start_time: 2024-11-05 01:18:06
success: True
trace_id: 6625035029107317188

Scan 6664793

duration: 0:00:11.539277

exit_message:

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

id: 6664793

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_newbookleads_interests/2024-11-04/1730782918",
        "key": "raw/newbookdev_newbookleads_interests/2024-11-04/1730782918/leads_interests.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookleads_interests",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11985051440406565468,
        "service_name": "drive-thru",
        "span_id": 11044901727724187836,
        "trace_id": 13202206444020543160
    }
}

running: False
schema_name_id: 2749
start_time: 2024-11-05 00:54:17
success: True
trace_id: 13202206444020543160

Scan 6663776

duration: 0:00:11.377944

exit_message:

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

id: 6663776

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_newbookleads_interests/2024-11-04/1730782754",
        "key": "raw/newbookdev_newbookleads_interests/2024-11-04/1730782754/leads_interests.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookleads_interests",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15868643836514582186,
        "service_name": "drive-thru",
        "span_id": 2723107828579982657,
        "trace_id": 4186900358988344919
    }
}

running: False
schema_name_id: 2749
start_time: 2024-11-05 00:27:44
success: True
trace_id: 4186900358988344919

Partitions:

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

Schema:

attributes:

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

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookleads_interests`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `original_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_newbookleads_interests/2024-11-05/1730866536'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookleads_interests`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookleads_interests"
}

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 18:02:03",
        "disabled": false,
        "format": "raw",
        "id": 2749,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "newbookdev_newbookleads_interests"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "active": "string",
            "display_order": "string",
            "id": "string",
            "name": "string",
            "newbook_region": "string",
            "original_id": "string",
            "tenant": "string"
        },
        "created": "2024-11-05 23:11:12",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookleads_interests`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `original_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_newbookleads_interests/2024-11-05/1730866536'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookleads_interests`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookleads_interests"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}