Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookreceipts_link

created: 2024-10-08 18:12:10
disabled: False
format: raw
id: 2840
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4749164

created: 2024-11-05 23:24:51

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookreceipts_link/2024-11-05/1730866531
id: 4749164
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "payment_id": 4,
    "receipt_id": 3,
    "refund_id": 5,
    "tenant": 1,
    "timestamp": 6
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "payment_id": "string",
    "receipt_id": "string",
    "refund_id": "string",
    "tenant": "string",
    "timestamp": "string"
}

schema_name_id: 2840
schema_scan_id: 6675196
updated: 2024-11-05 23:25:04

Version 4749149

created: 2024-11-05 23:23:46

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookreceipts_link/2024-11-05/1730866590
id: 4749149
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "payment_id": 4,
    "receipt_id": 3,
    "refund_id": 5,
    "tenant": 1,
    "timestamp": 6
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "payment_id": "string",
    "receipt_id": "string",
    "refund_id": "string",
    "tenant": "string",
    "timestamp": "string"
}

schema_name_id: 2840
schema_scan_id: 6675181
updated: 2024-11-05 23:23:57

Version 4748198

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookreceipts_link/2024-11-05/1730866411
id: 4748198
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "payment_id": 4,
    "receipt_id": 3,
    "refund_id": 5,
    "tenant": 1,
    "timestamp": 6
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "payment_id": "string",
    "receipt_id": "string",
    "refund_id": "string",
    "tenant": "string",
    "timestamp": "string"
}

schema_name_id: 2840
schema_scan_id: 6674230
updated: 2024-11-05 22:37:58

Version 4746972

created: 2024-11-05 04:36:32

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookreceipts_link/2024-11-04/1730785784
id: 4746972
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "payment_id": 4,
    "receipt_id": 3,
    "refund_id": 5,
    "tenant": 1,
    "timestamp": 6
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "payment_id": "string",
    "receipt_id": "string",
    "refund_id": "string",
    "tenant": "string",
    "timestamp": "string"
}

schema_name_id: 2840
schema_scan_id: 6672203
updated: 2024-11-05 04:36:46

Version 4746413

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookreceipts_link/2024-11-04/1730785161
id: 4746413
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "payment_id": 4,
    "receipt_id": 3,
    "refund_id": 5,
    "tenant": 1,
    "timestamp": 6
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "payment_id": "string",
    "receipt_id": "string",
    "refund_id": "string",
    "tenant": "string",
    "timestamp": "string"
}

schema_name_id: 2840
schema_scan_id: 6671634
updated: 2024-11-05 04:02:10

Version 4745824

created: 2024-11-05 03:40:03

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookreceipts_link/2024-11-04/1730784855
id: 4745824
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "payment_id": 4,
    "receipt_id": 3,
    "refund_id": 5,
    "tenant": 1,
    "timestamp": 6
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "payment_id": "string",
    "receipt_id": "string",
    "refund_id": "string",
    "tenant": "string",
    "timestamp": "string"
}

schema_name_id: 2840
schema_scan_id: 6671041
updated: 2024-11-05 03:40:16

Version 4744838

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookreceipts_link/2024-11-04/1730784251
id: 4744838
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "payment_id": 4,
    "receipt_id": 3,
    "refund_id": 5,
    "tenant": 1,
    "timestamp": 6
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "payment_id": "string",
    "receipt_id": "string",
    "refund_id": "string",
    "tenant": "string",
    "timestamp": "string"
}

schema_name_id: 2840
schema_scan_id: 6670055
updated: 2024-11-05 03:13:53

Version 4743746

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookreceipts_link/2024-11-04/1730783926
id: 4743746
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "payment_id": 4,
    "receipt_id": 3,
    "refund_id": 5,
    "tenant": 1,
    "timestamp": 6
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "payment_id": "string",
    "receipt_id": "string",
    "refund_id": "string",
    "tenant": "string",
    "timestamp": "string"
}

schema_name_id: 2840
schema_scan_id: 6668963
updated: 2024-11-05 02:44:56

Version 4743638

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookreceipts_link/2024-11-04/1730784089
id: 4743638
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "payment_id": 4,
    "receipt_id": 3,
    "refund_id": 5,
    "tenant": 1,
    "timestamp": 6
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "payment_id": "string",
    "receipt_id": "string",
    "refund_id": "string",
    "tenant": "string",
    "timestamp": "string"
}

schema_name_id: 2840
schema_scan_id: 6668856
updated: 2024-11-05 02:42:07

Version 4742775

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookreceipts_link/2024-11-04/1730783802
id: 4742775
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "payment_id": 4,
    "receipt_id": 3,
    "refund_id": 5,
    "tenant": 1,
    "timestamp": 6
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "payment_id": "string",
    "receipt_id": "string",
    "refund_id": "string",
    "tenant": "string",
    "timestamp": "string"
}

schema_name_id: 2840
schema_scan_id: 6667992
updated: 2024-11-05 02:19:16

Version 4742136

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookreceipts_link/2024-11-04/1730783691
id: 4742136
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "payment_id": 4,
    "receipt_id": 3,
    "refund_id": 5,
    "tenant": 1,
    "timestamp": 6
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "payment_id": "string",
    "receipt_id": "string",
    "refund_id": "string",
    "tenant": "string",
    "timestamp": "string"
}

schema_name_id: 2840
schema_scan_id: 6667353
updated: 2024-11-05 02:02:12

Version 4740881

created: 2024-11-05 01:28:58

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookreceipts_link/2024-11-04/1730783560
id: 4740881
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "payment_id": 4,
    "receipt_id": 3,
    "refund_id": 5,
    "tenant": 1,
    "timestamp": 6
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "payment_id": "string",
    "receipt_id": "string",
    "refund_id": "string",
    "tenant": "string",
    "timestamp": "string"
}

schema_name_id: 2840
schema_scan_id: 6666098
updated: 2024-11-05 01:29:09

Version 4740550

created: 2024-11-05 01:20:16

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookreceipts_link/2024-11-04/1730783341
id: 4740550
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "payment_id": 4,
    "receipt_id": 3,
    "refund_id": 5,
    "tenant": 1,
    "timestamp": 6
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "payment_id": "string",
    "receipt_id": "string",
    "refund_id": "string",
    "tenant": "string",
    "timestamp": "string"
}

schema_name_id: 2840
schema_scan_id: 6665767
updated: 2024-11-05 01:20:27

Version 4739710

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookreceipts_link/2024-11-04/1730782940
id: 4739710
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "payment_id": 4,
    "receipt_id": 3,
    "refund_id": 5,
    "tenant": 1,
    "timestamp": 6
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "payment_id": "string",
    "receipt_id": "string",
    "refund_id": "string",
    "tenant": "string",
    "timestamp": "string"
}

schema_name_id: 2840
schema_scan_id: 6664927
updated: 2024-11-05 00:57:59

Version 4738756

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookreceipts_link/2024-11-04/1730782759
id: 4738756
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "payment_id": 4,
    "receipt_id": 3,
    "refund_id": 5,
    "tenant": 1,
    "timestamp": 6
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "payment_id": "string",
    "receipt_id": "string",
    "refund_id": "string",
    "tenant": "string",
    "timestamp": "string"
}

schema_name_id: 2840
schema_scan_id: 6663969
updated: 2024-11-05 00:33:00

Schema Scans: 15

Last at 2024-11-05 23:24:50

Scan 6675196

duration: 0:00:14.262853

exit_message:

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

id: 6675196

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_newbookreceipts_link/2024-11-05/1730866531",
        "key": "raw/newbookdev_newbookreceipts_link/2024-11-05/1730866531/receipts_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookreceipts_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10515378093892091685,
        "service_name": "drive-thru",
        "span_id": 12754581758051732266,
        "trace_id": 14059299284640077469
    }
}

running: False
schema_name_id: 2840
start_time: 2024-11-05 23:24:50
success: True
trace_id: 14059299284640077469

Scan 6675181

duration: 0:00:11.626767

exit_message:

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

id: 6675181

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_newbookreceipts_link/2024-11-05/1730866590",
        "key": "raw/newbookdev_newbookreceipts_link/2024-11-05/1730866590/receipts_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookreceipts_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7960977031130215696,
        "service_name": "drive-thru",
        "span_id": 12345659716826038038,
        "trace_id": 1067060465530095007
    }
}

running: False
schema_name_id: 2840
start_time: 2024-11-05 23:23:45
success: True
trace_id: 1067060465530095007

Scan 6674230

duration: 0:00:11.546952

exit_message:

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

id: 6674230

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_newbookreceipts_link/2024-11-05/1730866411",
        "key": "raw/newbookdev_newbookreceipts_link/2024-11-05/1730866411/receipts_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookreceipts_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6639269519596662098,
        "service_name": "drive-thru",
        "span_id": 16871449780213694351,
        "trace_id": 16993083817225921597
    }
}

running: False
schema_name_id: 2840
start_time: 2024-11-05 22:37:47
success: True
trace_id: 16993083817225921597

Scan 6672203

duration: 0:00:14.206198

exit_message:

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

id: 6672203

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_newbookreceipts_link/2024-11-04/1730785784",
        "key": "raw/newbookdev_newbookreceipts_link/2024-11-04/1730785784/receipts_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookreceipts_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7847609933684441408,
        "service_name": "drive-thru",
        "span_id": 7566603305664800245,
        "trace_id": 9134313781618677678
    }
}

running: False
schema_name_id: 2840
start_time: 2024-11-05 04:36:32
success: True
trace_id: 9134313781618677678

Scan 6671634

duration: 0:00:14.143907

exit_message:

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

id: 6671634

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_newbookreceipts_link/2024-11-04/1730785161",
        "key": "raw/newbookdev_newbookreceipts_link/2024-11-04/1730785161/receipts_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookreceipts_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18138907201304995798,
        "service_name": "drive-thru",
        "span_id": 18413664776333740697,
        "trace_id": 15842308072494027568
    }
}

running: False
schema_name_id: 2840
start_time: 2024-11-05 04:01:56
success: True
trace_id: 15842308072494027568

Scan 6671041

duration: 0:00:13.971735

exit_message:

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

id: 6671041

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_newbookreceipts_link/2024-11-04/1730784855",
        "key": "raw/newbookdev_newbookreceipts_link/2024-11-04/1730784855/receipts_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookreceipts_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12964719963585843074,
        "service_name": "drive-thru",
        "span_id": 8528125326765775571,
        "trace_id": 7102918756802024969
    }
}

running: False
schema_name_id: 2840
start_time: 2024-11-05 03:40:02
success: True
trace_id: 7102918756802024969

Scan 6670055

duration: 0:00:13.867867

exit_message:

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

id: 6670055

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_newbookreceipts_link/2024-11-04/1730784251",
        "key": "raw/newbookdev_newbookreceipts_link/2024-11-04/1730784251/receipts_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookreceipts_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6472770936717288299,
        "service_name": "drive-thru",
        "span_id": 10828097396034042900,
        "trace_id": 16555917104685910474
    }
}

running: False
schema_name_id: 2840
start_time: 2024-11-05 03:13:39
success: True
trace_id: 16555917104685910474

Scan 6668963

duration: 0:00:11.417854

exit_message:

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

id: 6668963

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_newbookreceipts_link/2024-11-04/1730783926",
        "key": "raw/newbookdev_newbookreceipts_link/2024-11-04/1730783926/receipts_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookreceipts_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5222924771074733830,
        "service_name": "drive-thru",
        "span_id": 8026364080596308984,
        "trace_id": 12871222640893010690
    }
}

running: False
schema_name_id: 2840
start_time: 2024-11-05 02:44:45
success: True
trace_id: 12871222640893010690

Scan 6668856

duration: 0:00:11.408126

exit_message:

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

id: 6668856

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_newbookreceipts_link/2024-11-04/1730784089",
        "key": "raw/newbookdev_newbookreceipts_link/2024-11-04/1730784089/receipts_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookreceipts_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8389031197183882536,
        "service_name": "drive-thru",
        "span_id": 13551867292588713047,
        "trace_id": 16187908712763576596
    }
}

running: False
schema_name_id: 2840
start_time: 2024-11-05 02:41:56
success: True
trace_id: 16187908712763576596

Scan 6667992

duration: 0:00:11.377204

exit_message:

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

id: 6667992

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_newbookreceipts_link/2024-11-04/1730783802",
        "key": "raw/newbookdev_newbookreceipts_link/2024-11-04/1730783802/receipts_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookreceipts_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12422631409617107509,
        "service_name": "drive-thru",
        "span_id": 1788005713706929287,
        "trace_id": 12616308473715413271
    }
}

running: False
schema_name_id: 2840
start_time: 2024-11-05 02:19:05
success: True
trace_id: 12616308473715413271

Scan 6667353

duration: 0:00:11.362187

exit_message:

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

id: 6667353

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_newbookreceipts_link/2024-11-04/1730783691",
        "key": "raw/newbookdev_newbookreceipts_link/2024-11-04/1730783691/receipts_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookreceipts_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1340018347274507872,
        "service_name": "drive-thru",
        "span_id": 3999667223302334620,
        "trace_id": 10625689738682081939
    }
}

running: False
schema_name_id: 2840
start_time: 2024-11-05 02:02:01
success: True
trace_id: 10625689738682081939

Scan 6666098

duration: 0:00:11.428563

exit_message:

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

id: 6666098

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_newbookreceipts_link/2024-11-04/1730783560",
        "key": "raw/newbookdev_newbookreceipts_link/2024-11-04/1730783560/receipts_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookreceipts_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14307724596450957629,
        "service_name": "drive-thru",
        "span_id": 7618042706587686987,
        "trace_id": 3137716723704457491
    }
}

running: False
schema_name_id: 2840
start_time: 2024-11-05 01:28:57
success: True
trace_id: 3137716723704457491

Scan 6665767

duration: 0:00:11.645229

exit_message:

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

id: 6665767

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_newbookreceipts_link/2024-11-04/1730783341",
        "key": "raw/newbookdev_newbookreceipts_link/2024-11-04/1730783341/receipts_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookreceipts_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10212779444847270352,
        "service_name": "drive-thru",
        "span_id": 15130534674944844863,
        "trace_id": 12352388459631251129
    }
}

running: False
schema_name_id: 2840
start_time: 2024-11-05 01:20:16
success: True
trace_id: 12352388459631251129

Scan 6664927

duration: 0:00:11.309416

exit_message:

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

id: 6664927

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_newbookreceipts_link/2024-11-04/1730782940",
        "key": "raw/newbookdev_newbookreceipts_link/2024-11-04/1730782940/receipts_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookreceipts_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10896427027244936125,
        "service_name": "drive-thru",
        "span_id": 14047375538147846308,
        "trace_id": 5836739463349566635
    }
}

running: False
schema_name_id: 2840
start_time: 2024-11-05 00:57:48
success: True
trace_id: 5836739463349566635

Scan 6663969

duration: 0:00:11.411530

exit_message:

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

id: 6663969

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_newbookreceipts_link/2024-11-04/1730782759",
        "key": "raw/newbookdev_newbookreceipts_link/2024-11-04/1730782759/receipts_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookreceipts_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2369136461689977647,
        "service_name": "drive-thru",
        "span_id": 10507949990318998465,
        "trace_id": 4836807686080592601
    }
}

running: False
schema_name_id: 2840
start_time: 2024-11-05 00:32:49
success: True
trace_id: 4836807686080592601

Partitions:

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

Schema:

attributes:

{
    "id": "string",
    "newbook_region": "string",
    "payment_id": "string",
    "receipt_id": "string",
    "refund_id": "string",
    "tenant": "string",
    "timestamp": "string"
}

created: 2024-11-05 23:24:51

ddl:

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

Server:

hostname: schemamanager-5447774fc6-4w58v
name: schema_manager
process_start: 2026-04-02 21:43:44
sf_env: dev
version: 2427328685

Raw:

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