Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookdiscounts_restrictions_backup

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4748762

created: 2024-11-05 23:00:01

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookdiscounts_restrictions_backup/2024-11-05/1730866475
id: 4748762
processed: 1

raw_data:

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

schema_attributes:

{
    "discount_id": "string",
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2762
schema_scan_id: 6674794
updated: 2024-11-05 23:00:14

Version 4748159

created: 2024-11-05 22:36:38

ddl:

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

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

raw_data:

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

schema_attributes:

{
    "discount_id": "string",
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2762
schema_scan_id: 6674191
updated: 2024-11-05 22:36:49

Version 4747636

created: 2024-11-05 22:22:03

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookdiscounts_restrictions_backup/2024-11-05/1730866280
id: 4747636
processed: 1

raw_data:

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

schema_attributes:

{
    "discount_id": "string",
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2762
schema_scan_id: 6673668
updated: 2024-11-05 22:22:16

Version 4746804

created: 2024-11-05 04:24:27

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookdiscounts_restrictions_backup/2024-11-04/1730785701
id: 4746804
processed: 1

raw_data:

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

schema_attributes:

{
    "discount_id": "string",
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2762
schema_scan_id: 6672034
updated: 2024-11-05 04:24:38

Version 4746136

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookdiscounts_restrictions_backup/2024-11-04/1730785113
id: 4746136
processed: 1

raw_data:

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

schema_attributes:

{
    "discount_id": "string",
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2762
schema_scan_id: 6671356
updated: 2024-11-05 03:50:43

Version 4745298

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookdiscounts_restrictions_backup/2024-11-04/1730784808
id: 4745298
processed: 1

raw_data:

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

schema_attributes:

{
    "discount_id": "string",
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2762
schema_scan_id: 6670515
updated: 2024-11-05 03:25:58

Version 4744536

created: 2024-11-05 03:05:41

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookdiscounts_restrictions_backup/2024-11-04/1730784205
id: 4744536
processed: 1

raw_data:

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

schema_attributes:

{
    "discount_id": "string",
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2762
schema_scan_id: 6669753
updated: 2024-11-05 03:05:54

Version 4743819

created: 2024-11-05 02:46:44

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookdiscounts_restrictions_backup/2024-11-04/1730784042
id: 4743819
processed: 1

raw_data:

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

schema_attributes:

{
    "discount_id": "string",
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2762
schema_scan_id: 6669036
updated: 2024-11-05 02:46:57

Version 4743367

created: 2024-11-05 02:34:44

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookdiscounts_restrictions_backup/2024-11-04/1730783890
id: 4743367
processed: 1

raw_data:

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

schema_attributes:

{
    "discount_id": "string",
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2762
schema_scan_id: 6668584
updated: 2024-11-05 02:34:57

Version 4742512

created: 2024-11-05 02:12:09

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookdiscounts_restrictions_backup/2024-11-04/1730783755
id: 4742512
processed: 1

raw_data:

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

schema_attributes:

{
    "discount_id": "string",
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2762
schema_scan_id: 6667729
updated: 2024-11-05 02:12:22

Version 4741869

created: 2024-11-05 01:54:57

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookdiscounts_restrictions_backup/2024-11-04/1730783656
id: 4741869
processed: 1

raw_data:

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

schema_attributes:

{
    "discount_id": "string",
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2762
schema_scan_id: 6667086
updated: 2024-11-05 01:55:08

Version 4741060

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookdiscounts_restrictions_backup/2024-11-04/1730783511
id: 4741060
processed: 1

raw_data:

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

schema_attributes:

{
    "discount_id": "string",
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2762
schema_scan_id: 6666277
updated: 2024-11-05 01:33:59

Version 4740182

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookdiscounts_restrictions_backup/2024-11-04/1730783293
id: 4740182
processed: 1

raw_data:

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

schema_attributes:

{
    "discount_id": "string",
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2762
schema_scan_id: 6665399
updated: 2024-11-05 01:10:48

Version 4739525

created: 2024-11-05 00:52:57

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookdiscounts_restrictions_backup/2024-11-04/1730782895
id: 4739525
processed: 1

raw_data:

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

schema_attributes:

{
    "discount_id": "string",
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2762
schema_scan_id: 6664740
updated: 2024-11-05 00:53:08

Version 4738785

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookdiscounts_restrictions_backup/2024-11-04/1730782796
id: 4738785
processed: 1

raw_data:

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

schema_attributes:

{
    "discount_id": "string",
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2762
schema_scan_id: 6663999
updated: 2024-11-05 00:33:45

Schema Scans: 15

Last at 2024-11-05 22:59:59

Scan 6674794

duration: 0:00:15.056585

exit_message:

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

id: 6674794

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_newbookdiscounts_restrictions_backup/2024-11-05/1730866475",
        "key": "raw/newbookdev_newbookdiscounts_restrictions_backup/2024-11-05/1730866475/discounts_restrictions_backup.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookdiscounts_restrictions_backup",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7739466757730849966,
        "service_name": "drive-thru",
        "span_id": 163549554613744604,
        "trace_id": 7317189457409382143
    }
}

running: False
schema_name_id: 2762
start_time: 2024-11-05 22:59:59
success: True
trace_id: 7317189457409382143

Scan 6674191

duration: 0:00:11.386231

exit_message:

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

id: 6674191

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_newbookdiscounts_restrictions_backup/2024-11-05/1730866388",
        "key": "raw/newbookdev_newbookdiscounts_restrictions_backup/2024-11-05/1730866388/discounts_restrictions_backup.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookdiscounts_restrictions_backup",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9094691231432070999,
        "service_name": "drive-thru",
        "span_id": 4919884276619954861,
        "trace_id": 1495830414799336165
    }
}

running: False
schema_name_id: 2762
start_time: 2024-11-05 22:36:38
success: True
trace_id: 1495830414799336165

Scan 6673668

duration: 0:00:13.911468

exit_message:

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

id: 6673668

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_newbookdiscounts_restrictions_backup/2024-11-05/1730866280",
        "key": "raw/newbookdev_newbookdiscounts_restrictions_backup/2024-11-05/1730866280/discounts_restrictions_backup.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookdiscounts_restrictions_backup",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10316269118641607790,
        "service_name": "drive-thru",
        "span_id": 12243815767112714026,
        "trace_id": 6885720047372753897
    }
}

running: False
schema_name_id: 2762
start_time: 2024-11-05 22:22:03
success: True
trace_id: 6885720047372753897

Scan 6672034

duration: 0:00:11.530891

exit_message:

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

id: 6672034

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_newbookdiscounts_restrictions_backup/2024-11-04/1730785701",
        "key": "raw/newbookdev_newbookdiscounts_restrictions_backup/2024-11-04/1730785701/discounts_restrictions_backup.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookdiscounts_restrictions_backup",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12609370276403897630,
        "service_name": "drive-thru",
        "span_id": 2628444163585031530,
        "trace_id": 2999595002496835999
    }
}

running: False
schema_name_id: 2762
start_time: 2024-11-05 04:24:27
success: True
trace_id: 2999595002496835999

Scan 6671356

duration: 0:00:11.705879

exit_message:

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

id: 6671356

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_newbookdiscounts_restrictions_backup/2024-11-04/1730785113",
        "key": "raw/newbookdev_newbookdiscounts_restrictions_backup/2024-11-04/1730785113/discounts_restrictions_backup.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookdiscounts_restrictions_backup",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 518496928113005511,
        "service_name": "drive-thru",
        "span_id": 16955929433566496898,
        "trace_id": 15447693875782548468
    }
}

running: False
schema_name_id: 2762
start_time: 2024-11-05 03:50:32
success: True
trace_id: 15447693875782548468

Scan 6670515

duration: 0:00:11.525691

exit_message:

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

id: 6670515

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_newbookdiscounts_restrictions_backup/2024-11-04/1730784808",
        "key": "raw/newbookdev_newbookdiscounts_restrictions_backup/2024-11-04/1730784808/discounts_restrictions_backup.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookdiscounts_restrictions_backup",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15103797612878594549,
        "service_name": "drive-thru",
        "span_id": 8038826505874366535,
        "trace_id": 18401443935682214319
    }
}

running: False
schema_name_id: 2762
start_time: 2024-11-05 03:25:47
success: True
trace_id: 18401443935682214319

Scan 6669753

duration: 0:00:13.891014

exit_message:

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

id: 6669753

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_newbookdiscounts_restrictions_backup/2024-11-04/1730784205",
        "key": "raw/newbookdev_newbookdiscounts_restrictions_backup/2024-11-04/1730784205/discounts_restrictions_backup.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookdiscounts_restrictions_backup",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 140546217241266593,
        "service_name": "drive-thru",
        "span_id": 6485188436068770099,
        "trace_id": 6754660809871057845
    }
}

running: False
schema_name_id: 2762
start_time: 2024-11-05 03:05:40
success: True
trace_id: 6754660809871057845

Scan 6669036

duration: 0:00:13.927629

exit_message:

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

id: 6669036

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_newbookdiscounts_restrictions_backup/2024-11-04/1730784042",
        "key": "raw/newbookdev_newbookdiscounts_restrictions_backup/2024-11-04/1730784042/discounts_restrictions_backup.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookdiscounts_restrictions_backup",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16164977912914289240,
        "service_name": "drive-thru",
        "span_id": 3663351912614767261,
        "trace_id": 14167369917594385492
    }
}

running: False
schema_name_id: 2762
start_time: 2024-11-05 02:46:43
success: True
trace_id: 14167369917594385492

Scan 6668584

duration: 0:00:13.856468

exit_message:

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

id: 6668584

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_newbookdiscounts_restrictions_backup/2024-11-04/1730783890",
        "key": "raw/newbookdev_newbookdiscounts_restrictions_backup/2024-11-04/1730783890/discounts_restrictions_backup.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookdiscounts_restrictions_backup",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4025903822076806081,
        "service_name": "drive-thru",
        "span_id": 4843313112907774527,
        "trace_id": 8223346479396193233
    }
}

running: False
schema_name_id: 2762
start_time: 2024-11-05 02:34:43
success: True
trace_id: 8223346479396193233

Scan 6667729

duration: 0:00:13.853294

exit_message:

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

id: 6667729

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_newbookdiscounts_restrictions_backup/2024-11-04/1730783755",
        "key": "raw/newbookdev_newbookdiscounts_restrictions_backup/2024-11-04/1730783755/discounts_restrictions_backup.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookdiscounts_restrictions_backup",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4072601397263804746,
        "service_name": "drive-thru",
        "span_id": 10738564254349340001,
        "trace_id": 995720586647429681
    }
}

running: False
schema_name_id: 2762
start_time: 2024-11-05 02:12:08
success: True
trace_id: 995720586647429681

Scan 6667086

duration: 0:00:11.385962

exit_message:

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

id: 6667086

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_newbookdiscounts_restrictions_backup/2024-11-04/1730783656",
        "key": "raw/newbookdev_newbookdiscounts_restrictions_backup/2024-11-04/1730783656/discounts_restrictions_backup.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookdiscounts_restrictions_backup",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11087025899777872589,
        "service_name": "drive-thru",
        "span_id": 1926702855771472417,
        "trace_id": 14943743670176831591
    }
}

running: False
schema_name_id: 2762
start_time: 2024-11-05 01:54:56
success: True
trace_id: 14943743670176831591

Scan 6666277

duration: 0:00:13.922976

exit_message:

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

id: 6666277

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_newbookdiscounts_restrictions_backup/2024-11-04/1730783511",
        "key": "raw/newbookdev_newbookdiscounts_restrictions_backup/2024-11-04/1730783511/discounts_restrictions_backup.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookdiscounts_restrictions_backup",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9653223882561243423,
        "service_name": "drive-thru",
        "span_id": 10929976377252752267,
        "trace_id": 3879681000018188582
    }
}

running: False
schema_name_id: 2762
start_time: 2024-11-05 01:33:45
success: True
trace_id: 3879681000018188582

Scan 6665399

duration: 0:00:14.001687

exit_message:

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

id: 6665399

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_newbookdiscounts_restrictions_backup/2024-11-04/1730783293",
        "key": "raw/newbookdev_newbookdiscounts_restrictions_backup/2024-11-04/1730783293/discounts_restrictions_backup.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookdiscounts_restrictions_backup",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8763131320021399510,
        "service_name": "drive-thru",
        "span_id": 8458058289802909582,
        "trace_id": 13689602497299834371
    }
}

running: False
schema_name_id: 2762
start_time: 2024-11-05 01:10:34
success: True
trace_id: 13689602497299834371

Scan 6664740

duration: 0:00:11.364458

exit_message:

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

id: 6664740

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_newbookdiscounts_restrictions_backup/2024-11-04/1730782895",
        "key": "raw/newbookdev_newbookdiscounts_restrictions_backup/2024-11-04/1730782895/discounts_restrictions_backup.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookdiscounts_restrictions_backup",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1334860159455831301,
        "service_name": "drive-thru",
        "span_id": 11047616458602137024,
        "trace_id": 10225319705939389366
    }
}

running: False
schema_name_id: 2762
start_time: 2024-11-05 00:52:56
success: True
trace_id: 10225319705939389366

Scan 6663999

duration: 0:00:13.840663

exit_message:

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

id: 6663999

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_newbookdiscounts_restrictions_backup/2024-11-04/1730782796",
        "key": "raw/newbookdev_newbookdiscounts_restrictions_backup/2024-11-04/1730782796/discounts_restrictions_backup.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookdiscounts_restrictions_backup",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2187723812113457851,
        "service_name": "drive-thru",
        "span_id": 16388666342858742793,
        "trace_id": 1239593901075564092
    }
}

running: False
schema_name_id: 2762
start_time: 2024-11-05 00:33:31
success: True
trace_id: 1239593901075564092

Partitions:

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

Schema:

attributes:

{
    "discount_id": "string",
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

created: 2024-11-05 23:00:01

ddl:

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

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