Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookcampaign_tariffs_links

created: 2024-10-08 17:42:24
disabled: False
format: raw
id: 2485
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4748350

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcampaign_tariffs_links/2024-11-05/1730866388
id: 4748350
processed: 1

raw_data:

{
    "campaign_id": 3,
    "id": 2,
    "instance_id": 4,
    "newbook_region": 0,
    "tariff_id": 5,
    "tenant": 1
}

schema_attributes:

{
    "campaign_id": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "tariff_id": "string",
    "tenant": "string"
}

schema_name_id: 2485
schema_scan_id: 6674382
updated: 2024-11-05 22:43:23

Version 4747815

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

ddl:

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

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

raw_data:

{
    "campaign_id": 3,
    "id": 2,
    "instance_id": 4,
    "newbook_region": 0,
    "tariff_id": 5,
    "tenant": 1
}

schema_attributes:

{
    "campaign_id": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "tariff_id": "string",
    "tenant": "string"
}

schema_name_id: 2485
schema_scan_id: 6673847
updated: 2024-11-05 22:26:52

Version 4747431

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcampaign_tariffs_links/2024-11-05/1730866242
id: 4747431
processed: 1

raw_data:

{
    "campaign_id": 3,
    "id": 2,
    "instance_id": 4,
    "newbook_region": 0,
    "tariff_id": 5,
    "tenant": 1
}

schema_attributes:

{
    "campaign_id": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "tariff_id": "string",
    "tenant": "string"
}

schema_name_id: 2485
schema_scan_id: 6673463
updated: 2024-11-05 22:16:43

Version 4746653

created: 2024-11-05 04:14:43

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcampaign_tariffs_links/2024-11-04/1730785661
id: 4746653
processed: 1

raw_data:

{
    "campaign_id": 3,
    "id": 2,
    "instance_id": 4,
    "newbook_region": 0,
    "tariff_id": 5,
    "tenant": 1
}

schema_attributes:

{
    "campaign_id": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "tariff_id": "string",
    "tenant": "string"
}

schema_name_id: 2485
schema_scan_id: 6671876
updated: 2024-11-05 04:14:54

Version 4745974

created: 2024-11-05 03:44:43

ddl:

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

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

raw_data:

{
    "campaign_id": 3,
    "id": 2,
    "instance_id": 4,
    "newbook_region": 0,
    "tariff_id": 5,
    "tenant": 1
}

schema_attributes:

{
    "campaign_id": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "tariff_id": "string",
    "tenant": "string"
}

schema_name_id: 2485
schema_scan_id: 6671194
updated: 2024-11-05 03:44:54

Version 4745241

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

ddl:

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

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

raw_data:

{
    "campaign_id": 3,
    "id": 2,
    "instance_id": 4,
    "newbook_region": 0,
    "tariff_id": 5,
    "tenant": 1
}

schema_attributes:

{
    "campaign_id": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "tariff_id": "string",
    "tenant": "string"
}

schema_name_id: 2485
schema_scan_id: 6670458
updated: 2024-11-05 03:24:27

Version 4744961

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

ddl:

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

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

raw_data:

{
    "campaign_id": 3,
    "id": 2,
    "instance_id": 4,
    "newbook_region": 0,
    "tariff_id": 5,
    "tenant": 1
}

schema_attributes:

{
    "campaign_id": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "tariff_id": "string",
    "tenant": "string"
}

schema_name_id: 2485
schema_scan_id: 6670178
updated: 2024-11-05 03:17:14

Version 4743999

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcampaign_tariffs_links/2024-11-04/1730784018
id: 4743999
processed: 1

raw_data:

{
    "campaign_id": 3,
    "id": 2,
    "instance_id": 4,
    "newbook_region": 0,
    "tariff_id": 5,
    "tenant": 1
}

schema_attributes:

{
    "campaign_id": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "tariff_id": "string",
    "tenant": "string"
}

schema_name_id: 2485
schema_scan_id: 6669216
updated: 2024-11-05 02:51:37

Version 4743283

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

ddl:

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

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

raw_data:

{
    "campaign_id": 3,
    "id": 2,
    "instance_id": 4,
    "newbook_region": 0,
    "tariff_id": 5,
    "tenant": 1
}

schema_attributes:

{
    "campaign_id": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "tariff_id": "string",
    "tenant": "string"
}

schema_name_id: 2485
schema_scan_id: 6668500
updated: 2024-11-05 02:32:41

Version 4742348

created: 2024-11-05 02:07:50

ddl:

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

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

raw_data:

{
    "campaign_id": 3,
    "id": 2,
    "instance_id": 4,
    "newbook_region": 0,
    "tariff_id": 5,
    "tenant": 1
}

schema_attributes:

{
    "campaign_id": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "tariff_id": "string",
    "tenant": "string"
}

schema_name_id: 2485
schema_scan_id: 6667565
updated: 2024-11-05 02:08:04

Version 4740996

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcampaign_tariffs_links/2024-11-04/1730783600
id: 4740996
processed: 1

raw_data:

{
    "campaign_id": 3,
    "id": 2,
    "instance_id": 4,
    "newbook_region": 0,
    "tariff_id": 5,
    "tenant": 1
}

schema_attributes:

{
    "campaign_id": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "tariff_id": "string",
    "tenant": "string"
}

schema_name_id: 2485
schema_scan_id: 6666213
updated: 2024-11-05 01:32:12

Version 4740940

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

ddl:

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

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

raw_data:

{
    "campaign_id": 3,
    "id": 2,
    "instance_id": 4,
    "newbook_region": 0,
    "tariff_id": 5,
    "tenant": 1
}

schema_attributes:

{
    "campaign_id": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "tariff_id": "string",
    "tenant": "string"
}

schema_name_id: 2485
schema_scan_id: 6666157
updated: 2024-11-05 01:30:44

Version 4740179

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

ddl:

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

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

raw_data:

{
    "campaign_id": 3,
    "id": 2,
    "instance_id": 4,
    "newbook_region": 0,
    "tariff_id": 5,
    "tenant": 1
}

schema_attributes:

{
    "campaign_id": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "tariff_id": "string",
    "tenant": "string"
}

schema_name_id: 2485
schema_scan_id: 6665396
updated: 2024-11-05 01:10:40

Version 4739405

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

ddl:

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

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

raw_data:

{
    "campaign_id": 3,
    "id": 2,
    "instance_id": 4,
    "newbook_region": 0,
    "tariff_id": 5,
    "tenant": 1
}

schema_attributes:

{
    "campaign_id": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "tariff_id": "string",
    "tenant": "string"
}

schema_name_id: 2485
schema_scan_id: 6664620
updated: 2024-11-05 00:50:00

Version 4738501

created: 2024-11-05 00:26:06

ddl:

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

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

raw_data:

{
    "campaign_id": 3,
    "id": 2,
    "instance_id": 4,
    "newbook_region": 0,
    "tariff_id": 5,
    "tenant": 1
}

schema_attributes:

{
    "campaign_id": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "tariff_id": "string",
    "tenant": "string"
}

schema_name_id: 2485
schema_scan_id: 6663712
updated: 2024-11-05 00:26:20

Schema Scans: 15

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

Scan 6674382

duration: 0:00:13.962767

exit_message:

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

id: 6674382

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_links/2024-11-05/1730866388",
        "key": "raw/newbookdev_newbookcampaign_tariffs_links/2024-11-05/1730866388/campaign_tariffs_links.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcampaign_tariffs_links",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11721939500635159969,
        "service_name": "drive-thru",
        "span_id": 2124047079776042738,
        "trace_id": 10881783667300883968
    }
}

running: False
schema_name_id: 2485
start_time: 2024-11-05 22:43:09
success: True
trace_id: 10881783667300883968

Scan 6673847

duration: 0:00:11.301269

exit_message:

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

id: 6673847

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_links/2024-11-05/1730866319",
        "key": "raw/newbookdev_newbookcampaign_tariffs_links/2024-11-05/1730866319/campaign_tariffs_links.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcampaign_tariffs_links",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14388916441795846590,
        "service_name": "drive-thru",
        "span_id": 2314055216375394597,
        "trace_id": 18229696135849365348
    }
}

running: False
schema_name_id: 2485
start_time: 2024-11-05 22:26:41
success: True
trace_id: 18229696135849365348

Scan 6673463

duration: 0:00:11.505736

exit_message:

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

id: 6673463

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_links/2024-11-05/1730866242",
        "key": "raw/newbookdev_newbookcampaign_tariffs_links/2024-11-05/1730866242/campaign_tariffs_links.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcampaign_tariffs_links",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18081334023549713186,
        "service_name": "drive-thru",
        "span_id": 6617323821305333805,
        "trace_id": 6852440154460202874
    }
}

running: False
schema_name_id: 2485
start_time: 2024-11-05 22:16:31
success: True
trace_id: 6852440154460202874

Scan 6671876

duration: 0:00:11.535138

exit_message:

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

id: 6671876

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_links/2024-11-04/1730785661",
        "key": "raw/newbookdev_newbookcampaign_tariffs_links/2024-11-04/1730785661/campaign_tariffs_links.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcampaign_tariffs_links",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13221587619959207567,
        "service_name": "drive-thru",
        "span_id": 13449109608941838713,
        "trace_id": 17101539100629981356
    }
}

running: False
schema_name_id: 2485
start_time: 2024-11-05 04:14:42
success: True
trace_id: 17101539100629981356

Scan 6671194

duration: 0:00:11.423582

exit_message:

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

id: 6671194

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_links/2024-11-04/1730785089",
        "key": "raw/newbookdev_newbookcampaign_tariffs_links/2024-11-04/1730785089/campaign_tariffs_links.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcampaign_tariffs_links",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16303164200097560660,
        "service_name": "drive-thru",
        "span_id": 10577494899931894258,
        "trace_id": 6898380574400132157
    }
}

running: False
schema_name_id: 2485
start_time: 2024-11-05 03:44:42
success: True
trace_id: 6898380574400132157

Scan 6670458

duration: 0:00:11.415721

exit_message:

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

id: 6670458

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_links/2024-11-04/1730784783",
        "key": "raw/newbookdev_newbookcampaign_tariffs_links/2024-11-04/1730784783/campaign_tariffs_links.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcampaign_tariffs_links",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10983999782232499773,
        "service_name": "drive-thru",
        "span_id": 13632277028004881679,
        "trace_id": 14396542428862625954
    }
}

running: False
schema_name_id: 2485
start_time: 2024-11-05 03:24:16
success: True
trace_id: 14396542428862625954

Scan 6670178

duration: 0:00:13.813305

exit_message:

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

id: 6670178

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_links/2024-11-04/1730784180",
        "key": "raw/newbookdev_newbookcampaign_tariffs_links/2024-11-04/1730784180/campaign_tariffs_links.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcampaign_tariffs_links",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6435853159809092085,
        "service_name": "drive-thru",
        "span_id": 14628126537037371150,
        "trace_id": 13940492681825439659
    }
}

running: False
schema_name_id: 2485
start_time: 2024-11-05 03:17:00
success: True
trace_id: 13940492681825439659

Scan 6669216

duration: 0:00:11.442135

exit_message:

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

id: 6669216

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_links/2024-11-04/1730784018",
        "key": "raw/newbookdev_newbookcampaign_tariffs_links/2024-11-04/1730784018/campaign_tariffs_links.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcampaign_tariffs_links",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10978142300421317543,
        "service_name": "drive-thru",
        "span_id": 8911143211657761860,
        "trace_id": 574653283836324371
    }
}

running: False
schema_name_id: 2485
start_time: 2024-11-05 02:51:26
success: True
trace_id: 574653283836324371

Scan 6668500

duration: 0:00:13.805646

exit_message:

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

id: 6668500

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_links/2024-11-04/1730783871",
        "key": "raw/newbookdev_newbookcampaign_tariffs_links/2024-11-04/1730783871/campaign_tariffs_links.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcampaign_tariffs_links",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13463018177403435291,
        "service_name": "drive-thru",
        "span_id": 7477872511457198009,
        "trace_id": 6274915718290297656
    }
}

running: False
schema_name_id: 2485
start_time: 2024-11-05 02:32:28
success: True
trace_id: 6274915718290297656

Scan 6667565

duration: 0:00:13.858974

exit_message:

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

id: 6667565

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_links/2024-11-04/1730783730",
        "key": "raw/newbookdev_newbookcampaign_tariffs_links/2024-11-04/1730783730/campaign_tariffs_links.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcampaign_tariffs_links",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3549385187457173870,
        "service_name": "drive-thru",
        "span_id": 6668016826392137537,
        "trace_id": 4818409697960029809
    }
}

running: False
schema_name_id: 2485
start_time: 2024-11-05 02:07:50
success: True
trace_id: 4818409697960029809

Scan 6666213

duration: 0:00:13.816134

exit_message:

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

id: 6666213

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_links/2024-11-04/1730783600",
        "key": "raw/newbookdev_newbookcampaign_tariffs_links/2024-11-04/1730783600/campaign_tariffs_links.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcampaign_tariffs_links",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9039542939354135510,
        "service_name": "drive-thru",
        "span_id": 13152384829127941015,
        "trace_id": 1954455979231075979
    }
}

running: False
schema_name_id: 2485
start_time: 2024-11-05 01:31:58
success: True
trace_id: 1954455979231075979

Scan 6666157

duration: 0:00:11.333055

exit_message:

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

id: 6666157

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_links/2024-11-04/1730783486",
        "key": "raw/newbookdev_newbookcampaign_tariffs_links/2024-11-04/1730783486/campaign_tariffs_links.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcampaign_tariffs_links",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6192909217863890760,
        "service_name": "drive-thru",
        "span_id": 3588761290979705053,
        "trace_id": 478096738680134275
    }
}

running: False
schema_name_id: 2485
start_time: 2024-11-05 01:30:33
success: True
trace_id: 478096738680134275

Scan 6665396

duration: 0:00:11.376943

exit_message:

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

id: 6665396

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_links/2024-11-04/1730783268",
        "key": "raw/newbookdev_newbookcampaign_tariffs_links/2024-11-04/1730783268/campaign_tariffs_links.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcampaign_tariffs_links",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15076073896714529120,
        "service_name": "drive-thru",
        "span_id": 901627049658392523,
        "trace_id": 16727619821159093010
    }
}

running: False
schema_name_id: 2485
start_time: 2024-11-05 01:10:29
success: True
trace_id: 16727619821159093010

Scan 6664620

duration: 0:00:13.725295

exit_message:

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

id: 6664620

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_links/2024-11-04/1730782870",
        "key": "raw/newbookdev_newbookcampaign_tariffs_links/2024-11-04/1730782870/campaign_tariffs_links.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcampaign_tariffs_links",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12839426167779772792,
        "service_name": "drive-thru",
        "span_id": 1875443792947499408,
        "trace_id": 11230311563130715383
    }
}

running: False
schema_name_id: 2485
start_time: 2024-11-05 00:49:46
success: True
trace_id: 11230311563130715383

Scan 6663712

duration: 0:00:14.071879

exit_message:

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

id: 6663712

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_links/2024-11-04/1730782778",
        "key": "raw/newbookdev_newbookcampaign_tariffs_links/2024-11-04/1730782778/campaign_tariffs_links.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcampaign_tariffs_links",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16363019000007290639,
        "service_name": "drive-thru",
        "span_id": 9645099574705795311,
        "trace_id": 2511445763533002779
    }
}

running: False
schema_name_id: 2485
start_time: 2024-11-05 00:26:06
success: True
trace_id: 2511445763533002779

Partitions:

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

Schema:

attributes:

{
    "campaign_id": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "tariff_id": "string",
    "tenant": "string"
}

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

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_links`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `campaign_id`  string , `instance_id`  string , `tariff_id`  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_links/2024-11-05/1730866388'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcampaign_tariffs_links`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcampaign_tariffs_links"
}

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:42:24",
        "disabled": false,
        "format": "raw",
        "id": 2485,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "newbookdev_newbookcampaign_tariffs_links"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "campaign_id": "string",
            "id": "string",
            "instance_id": "string",
            "newbook_region": "string",
            "tariff_id": "string",
            "tenant": "string"
        },
        "created": "2024-11-05 22:43:09",
        "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_links`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `campaign_id`  string , `instance_id`  string , `tariff_id`  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_links/2024-11-05/1730866388'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcampaign_tariffs_links`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcampaign_tariffs_links"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}