Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookcampaign_tariffs

created: 2024-10-08 17:44:03
disabled: False
format: raw
id: 2507
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4748357

created: 2024-11-05 22:43:25

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcampaign_tariffs/2024-11-05/1730866387
id: 4748357
processed: 1

raw_data:

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

schema_attributes:

{
    "active": "string",
    "added_when": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string",
    "wizard_settings": "string"
}

schema_name_id: 2507
schema_scan_id: 6674389
updated: 2024-11-05 22:43:36

Version 4747804

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcampaign_tariffs/2024-11-05/1730866319
id: 4747804
processed: 1

raw_data:

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

schema_attributes:

{
    "active": "string",
    "added_when": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string",
    "wizard_settings": "string"
}

schema_name_id: 2507
schema_scan_id: 6673837
updated: 2024-11-05 22:26:40

Version 4747417

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcampaign_tariffs/2024-11-05/1730866241
id: 4747417
processed: 1

raw_data:

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

schema_attributes:

{
    "active": "string",
    "added_when": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string",
    "wizard_settings": "string"
}

schema_name_id: 2507
schema_scan_id: 6673449
updated: 2024-11-05 22:16:18

Version 4746605

created: 2024-11-05 04:12:05

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcampaign_tariffs/2024-11-04/1730785660
id: 4746605
processed: 1

raw_data:

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

schema_attributes:

{
    "active": "string",
    "added_when": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string",
    "wizard_settings": "string"
}

schema_name_id: 2507
schema_scan_id: 6671828
updated: 2024-11-05 04:12:19

Version 4745253

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcampaign_tariffs/2024-11-04/1730785089
id: 4745253
processed: 1

raw_data:

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

schema_attributes:

{
    "active": "string",
    "added_when": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string",
    "wizard_settings": "string"
}

schema_name_id: 2507
schema_scan_id: 6670470
updated: 2024-11-05 03:24:50

Version 4744521

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcampaign_tariffs/2024-11-04/1730784783
id: 4744521
processed: 1

raw_data:

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

schema_attributes:

{
    "active": "string",
    "added_when": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string",
    "wizard_settings": "string"
}

schema_name_id: 2507
schema_scan_id: 6669738
updated: 2024-11-05 03:05:27

Version 4744335

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcampaign_tariffs/2024-11-04/1730784180
id: 4744335
processed: 1

raw_data:

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

schema_attributes:

{
    "active": "string",
    "added_when": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string",
    "wizard_settings": "string"
}

schema_name_id: 2507
schema_scan_id: 6669552
updated: 2024-11-05 03:00:22

Version 4743784

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcampaign_tariffs/2024-11-04/1730784017
id: 4743784
processed: 1

raw_data:

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

schema_attributes:

{
    "active": "string",
    "added_when": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string",
    "wizard_settings": "string"
}

schema_name_id: 2507
schema_scan_id: 6669001
updated: 2024-11-05 02:45:58

Version 4743456

created: 2024-11-05 02:37:04

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcampaign_tariffs/2024-11-04/1730783871
id: 4743456
processed: 1

raw_data:

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

schema_attributes:

{
    "active": "string",
    "added_when": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string",
    "wizard_settings": "string"
}

schema_name_id: 2507
schema_scan_id: 6668673
updated: 2024-11-05 02:37:15

Version 4741800

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcampaign_tariffs/2024-11-04/1730783637
id: 4741800
processed: 1

raw_data:

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

schema_attributes:

{
    "active": "string",
    "added_when": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string",
    "wizard_settings": "string"
}

schema_name_id: 2507
schema_scan_id: 6667017
updated: 2024-11-05 01:53:19

Version 4741796

created: 2024-11-05 01:52:59

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcampaign_tariffs/2024-11-04/1730783730
id: 4741796
processed: 1

raw_data:

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

schema_attributes:

{
    "active": "string",
    "added_when": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string",
    "wizard_settings": "string"
}

schema_name_id: 2507
schema_scan_id: 6667013
updated: 2024-11-05 01:53:10

Version 4740471

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcampaign_tariffs/2024-11-04/1730783486
id: 4740471
processed: 1

raw_data:

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

schema_attributes:

{
    "active": "string",
    "added_when": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string",
    "wizard_settings": "string"
}

schema_name_id: 2507
schema_scan_id: 6665688
updated: 2024-11-05 01:18:23

Version 4740101

created: 2024-11-05 01:08:26

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcampaign_tariffs/2024-11-04/1730783268
id: 4740101
processed: 1

raw_data:

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

schema_attributes:

{
    "active": "string",
    "added_when": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string",
    "wizard_settings": "string"
}

schema_name_id: 2507
schema_scan_id: 6665319
updated: 2024-11-05 01:08:39

Version 4739318

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcampaign_tariffs/2024-11-04/1730782870
id: 4739318
processed: 1

raw_data:

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

schema_attributes:

{
    "active": "string",
    "added_when": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string",
    "wizard_settings": "string"
}

schema_name_id: 2507
schema_scan_id: 6664533
updated: 2024-11-05 00:47:46

Version 4738844

created: 2024-11-05 00:35:07

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcampaign_tariffs/2024-11-04/1730782778
id: 4738844
processed: 1

raw_data:

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

schema_attributes:

{
    "active": "string",
    "added_when": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string",
    "wizard_settings": "string"
}

schema_name_id: 2507
schema_scan_id: 6664057
updated: 2024-11-05 00:35:18

Schema Scans: 15

Last at 2024-11-05 22:43:24

Scan 6674389

duration: 0:00:11.570050

exit_message:

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

id: 6674389

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_newbookcampaign_tariffs/2024-11-05/1730866387",
        "key": "raw/newbookdev_newbookcampaign_tariffs/2024-11-05/1730866387/campaign_tariffs.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcampaign_tariffs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11745567185382372364,
        "service_name": "drive-thru",
        "span_id": 5417539652005116236,
        "trace_id": 11951136311839744095
    }
}

running: False
schema_name_id: 2507
start_time: 2024-11-05 22:43:24
success: True
trace_id: 11951136311839744095

Scan 6673837

duration: 0:00:13.806346

exit_message:

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

id: 6673837

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_newbookcampaign_tariffs/2024-11-05/1730866319",
        "key": "raw/newbookdev_newbookcampaign_tariffs/2024-11-05/1730866319/campaign_tariffs.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcampaign_tariffs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5224092582983568737,
        "service_name": "drive-thru",
        "span_id": 7707410403351349445,
        "trace_id": 7093977197634279397
    }
}

running: False
schema_name_id: 2507
start_time: 2024-11-05 22:26:26
success: True
trace_id: 7093977197634279397

Scan 6673449

duration: 0:00:14.041217

exit_message:

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

id: 6673449

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_newbookcampaign_tariffs/2024-11-05/1730866241",
        "key": "raw/newbookdev_newbookcampaign_tariffs/2024-11-05/1730866241/campaign_tariffs.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcampaign_tariffs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17807316868654844021,
        "service_name": "drive-thru",
        "span_id": 13026229152661504609,
        "trace_id": 5274778745008061875
    }
}

running: False
schema_name_id: 2507
start_time: 2024-11-05 22:16:04
success: True
trace_id: 5274778745008061875

Scan 6671828

duration: 0:00:14.121463

exit_message:

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

id: 6671828

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_newbookcampaign_tariffs/2024-11-04/1730785660",
        "key": "raw/newbookdev_newbookcampaign_tariffs/2024-11-04/1730785660/campaign_tariffs.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcampaign_tariffs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13611916879540882453,
        "service_name": "drive-thru",
        "span_id": 3909201368673461132,
        "trace_id": 8332413815363466045
    }
}

running: False
schema_name_id: 2507
start_time: 2024-11-05 04:12:05
success: True
trace_id: 8332413815363466045

Scan 6670470

duration: 0:00:11.428257

exit_message:

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

id: 6670470

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_newbookcampaign_tariffs/2024-11-04/1730785089",
        "key": "raw/newbookdev_newbookcampaign_tariffs/2024-11-04/1730785089/campaign_tariffs.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcampaign_tariffs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17894176063720430733,
        "service_name": "drive-thru",
        "span_id": 17494576571967655642,
        "trace_id": 7353783812670480780
    }
}

running: False
schema_name_id: 2507
start_time: 2024-11-05 03:24:39
success: True
trace_id: 7353783812670480780

Scan 6669738

duration: 0:00:11.515132

exit_message:

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

id: 6669738

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_newbookcampaign_tariffs/2024-11-04/1730784783",
        "key": "raw/newbookdev_newbookcampaign_tariffs/2024-11-04/1730784783/campaign_tariffs.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcampaign_tariffs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8815535372327223989,
        "service_name": "drive-thru",
        "span_id": 1728451125614953777,
        "trace_id": 13255062203262230311
    }
}

running: False
schema_name_id: 2507
start_time: 2024-11-05 03:05:15
success: True
trace_id: 13255062203262230311

Scan 6669552

duration: 0:00:13.895489

exit_message:

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

id: 6669552

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_newbookcampaign_tariffs/2024-11-04/1730784180",
        "key": "raw/newbookdev_newbookcampaign_tariffs/2024-11-04/1730784180/campaign_tariffs.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcampaign_tariffs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17767425918061032202,
        "service_name": "drive-thru",
        "span_id": 2680485293454170740,
        "trace_id": 1093855946899921440
    }
}

running: False
schema_name_id: 2507
start_time: 2024-11-05 03:00:08
success: True
trace_id: 1093855946899921440

Scan 6669001

duration: 0:00:11.397631

exit_message:

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

id: 6669001

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_newbookcampaign_tariffs/2024-11-04/1730784017",
        "key": "raw/newbookdev_newbookcampaign_tariffs/2024-11-04/1730784017/campaign_tariffs.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcampaign_tariffs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18384740345272666837,
        "service_name": "drive-thru",
        "span_id": 2887530140900833070,
        "trace_id": 14158235902760210574
    }
}

running: False
schema_name_id: 2507
start_time: 2024-11-05 02:45:46
success: True
trace_id: 14158235902760210574

Scan 6668673

duration: 0:00:11.482012

exit_message:

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

id: 6668673

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_newbookcampaign_tariffs/2024-11-04/1730783871",
        "key": "raw/newbookdev_newbookcampaign_tariffs/2024-11-04/1730783871/campaign_tariffs.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcampaign_tariffs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15847959020559655492,
        "service_name": "drive-thru",
        "span_id": 16956839744369053397,
        "trace_id": 2234660808799800750
    }
}

running: False
schema_name_id: 2507
start_time: 2024-11-05 02:37:04
success: True
trace_id: 2234660808799800750

Scan 6667017

duration: 0:00:13.965076

exit_message:

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

id: 6667017

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_newbookcampaign_tariffs/2024-11-04/1730783637",
        "key": "raw/newbookdev_newbookcampaign_tariffs/2024-11-04/1730783637/campaign_tariffs.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcampaign_tariffs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7592122557190171900,
        "service_name": "drive-thru",
        "span_id": 11179835889681503179,
        "trace_id": 15106682490513057172
    }
}

running: False
schema_name_id: 2507
start_time: 2024-11-05 01:53:05
success: True
trace_id: 15106682490513057172

Scan 6667013

duration: 0:00:11.400815

exit_message:

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

id: 6667013

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_newbookcampaign_tariffs/2024-11-04/1730783730",
        "key": "raw/newbookdev_newbookcampaign_tariffs/2024-11-04/1730783730/campaign_tariffs.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcampaign_tariffs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 962343079177637465,
        "service_name": "drive-thru",
        "span_id": 8071845347229608153,
        "trace_id": 2273492420223913053
    }
}

running: False
schema_name_id: 2507
start_time: 2024-11-05 01:52:59
success: True
trace_id: 2273492420223913053

Scan 6665688

duration: 0:00:11.373487

exit_message:

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

id: 6665688

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_newbookcampaign_tariffs/2024-11-04/1730783486",
        "key": "raw/newbookdev_newbookcampaign_tariffs/2024-11-04/1730783486/campaign_tariffs.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcampaign_tariffs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2807088183681773892,
        "service_name": "drive-thru",
        "span_id": 11361459270417024984,
        "trace_id": 9832424092817157126
    }
}

running: False
schema_name_id: 2507
start_time: 2024-11-05 01:18:12
success: True
trace_id: 9832424092817157126

Scan 6665319

duration: 0:00:13.896233

exit_message:

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

id: 6665319

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_newbookcampaign_tariffs/2024-11-04/1730783268",
        "key": "raw/newbookdev_newbookcampaign_tariffs/2024-11-04/1730783268/campaign_tariffs.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcampaign_tariffs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16163859602874366327,
        "service_name": "drive-thru",
        "span_id": 16121841545318400377,
        "trace_id": 3591774812274325007
    }
}

running: False
schema_name_id: 2507
start_time: 2024-11-05 01:08:26
success: True
trace_id: 3591774812274325007

Scan 6664533

duration: 0:00:13.894613

exit_message:

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

id: 6664533

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_newbookcampaign_tariffs/2024-11-04/1730782870",
        "key": "raw/newbookdev_newbookcampaign_tariffs/2024-11-04/1730782870/campaign_tariffs.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcampaign_tariffs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16928931056679704151,
        "service_name": "drive-thru",
        "span_id": 5511654707645556523,
        "trace_id": 17668539460029405762
    }
}

running: False
schema_name_id: 2507
start_time: 2024-11-05 00:47:32
success: True
trace_id: 17668539460029405762

Scan 6664057

duration: 0:00:11.486776

exit_message:

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

id: 6664057

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_newbookcampaign_tariffs/2024-11-04/1730782778",
        "key": "raw/newbookdev_newbookcampaign_tariffs/2024-11-04/1730782778/campaign_tariffs.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcampaign_tariffs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14394576158684928474,
        "service_name": "drive-thru",
        "span_id": 5495847177244664304,
        "trace_id": 1173283718721813623
    }
}

running: False
schema_name_id: 2507
start_time: 2024-11-05 00:35:07
success: True
trace_id: 1173283718721813623

Partitions:

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

Schema:

attributes:

{
    "active": "string",
    "added_when": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string",
    "wizard_settings": "string"
}

created: 2024-11-05 22:43:25

ddl:

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

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