Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookbackdate_requests_dates

created: 2024-10-08 17:38:20
disabled: False
format: raw
id: 2428
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4748206

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbackdate_requests_dates/2024-11-05/1730866368
id: 4748206
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "request_id": 3,
    "tenant": 1,
    "timestamp": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "request_id": "string",
    "tenant": "string",
    "timestamp": "string"
}

schema_name_id: 2428
schema_scan_id: 6674238
updated: 2024-11-05 22:38:16

Version 4747708

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbackdate_requests_dates/2024-11-05/1730866304
id: 4747708
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "request_id": 3,
    "tenant": 1,
    "timestamp": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "request_id": "string",
    "tenant": "string",
    "timestamp": "string"
}

schema_name_id: 2428
schema_scan_id: 6673740
updated: 2024-11-05 22:24:07

Version 4747377

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbackdate_requests_dates/2024-11-05/1730866232
id: 4747377
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "request_id": 3,
    "tenant": 1,
    "timestamp": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "request_id": "string",
    "tenant": "string",
    "timestamp": "string"
}

schema_name_id: 2428
schema_scan_id: 6673409
updated: 2024-11-05 22:14:43

Version 4746608

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbackdate_requests_dates/2024-11-04/1730785651
id: 4746608
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "request_id": 3,
    "tenant": 1,
    "timestamp": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "request_id": "string",
    "tenant": "string",
    "timestamp": "string"
}

schema_name_id: 2428
schema_scan_id: 6671831
updated: 2024-11-05 04:12:30

Version 4745932

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbackdate_requests_dates/2024-11-04/1730785083
id: 4745932
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "request_id": 3,
    "tenant": 1,
    "timestamp": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "request_id": "string",
    "tenant": "string",
    "timestamp": "string"
}

schema_name_id: 2428
schema_scan_id: 6671152
updated: 2024-11-05 03:43:33

Version 4744504

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbackdate_requests_dates/2024-11-04/1730784174
id: 4744504
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "request_id": 3,
    "tenant": 1,
    "timestamp": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "request_id": "string",
    "tenant": "string",
    "timestamp": "string"
}

schema_name_id: 2428
schema_scan_id: 6669721
updated: 2024-11-05 03:04:58

Version 4744484

created: 2024-11-05 03:04:15

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbackdate_requests_dates/2024-11-04/1730784777
id: 4744484
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "request_id": 3,
    "tenant": 1,
    "timestamp": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "request_id": "string",
    "tenant": "string",
    "timestamp": "string"
}

schema_name_id: 2428
schema_scan_id: 6669701
updated: 2024-11-05 03:04:29

Version 4743695

created: 2024-11-05 02:43:23

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbackdate_requests_dates/2024-11-04/1730784012
id: 4743695
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "request_id": 3,
    "tenant": 1,
    "timestamp": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "request_id": "string",
    "tenant": "string",
    "timestamp": "string"
}

schema_name_id: 2428
schema_scan_id: 6668912
updated: 2024-11-05 02:43:34

Version 4743247

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbackdate_requests_dates/2024-11-04/1730783867
id: 4743247
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "request_id": 3,
    "tenant": 1,
    "timestamp": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "request_id": "string",
    "tenant": "string",
    "timestamp": "string"
}

schema_name_id: 2428
schema_scan_id: 6668464
updated: 2024-11-05 02:31:41

Version 4742287

created: 2024-11-05 02:06:10

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbackdate_requests_dates/2024-11-04/1730783724
id: 4742287
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "request_id": 3,
    "tenant": 1,
    "timestamp": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "request_id": "string",
    "tenant": "string",
    "timestamp": "string"
}

schema_name_id: 2428
schema_scan_id: 6667504
updated: 2024-11-05 02:06:21

Version 4741609

created: 2024-11-05 01:48:05

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbackdate_requests_dates/2024-11-04/1730783599
id: 4741609
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "request_id": 3,
    "tenant": 1,
    "timestamp": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "request_id": "string",
    "tenant": "string",
    "timestamp": "string"
}

schema_name_id: 2428
schema_scan_id: 6666826
updated: 2024-11-05 01:48:16

Version 4740773

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbackdate_requests_dates/2024-11-04/1730783480
id: 4740773
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "request_id": 3,
    "tenant": 1,
    "timestamp": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "request_id": "string",
    "tenant": "string",
    "timestamp": "string"
}

schema_name_id: 2428
schema_scan_id: 6665990
updated: 2024-11-05 01:26:18

Version 4740007

created: 2024-11-05 01:05:50

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbackdate_requests_dates/2024-11-04/1730783261
id: 4740007
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "request_id": 3,
    "tenant": 1,
    "timestamp": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "request_id": "string",
    "tenant": "string",
    "timestamp": "string"
}

schema_name_id: 2428
schema_scan_id: 6665224
updated: 2024-11-05 01:06:03

Version 4739076

created: 2024-11-05 00:41:13

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbackdate_requests_dates/2024-11-04/1730782864
id: 4739076
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "request_id": 3,
    "tenant": 1,
    "timestamp": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "request_id": "string",
    "tenant": "string",
    "timestamp": "string"
}

schema_name_id: 2428
schema_scan_id: 6664291
updated: 2024-11-05 00:41:26

Version 4738817

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbackdate_requests_dates/2024-11-04/1730782773
id: 4738817
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "request_id": 3,
    "tenant": 1,
    "timestamp": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "request_id": "string",
    "tenant": "string",
    "timestamp": "string"
}

schema_name_id: 2428
schema_scan_id: 6664030
updated: 2024-11-05 00:34:37

Schema Scans: 15

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

Scan 6674238

duration: 0:00:11.486368

exit_message:

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

id: 6674238

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_newbookbackdate_requests_dates/2024-11-05/1730866368",
        "key": "raw/newbookdev_newbookbackdate_requests_dates/2024-11-05/1730866368/backdate_requests_dates.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbackdate_requests_dates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16379458718464528876,
        "service_name": "drive-thru",
        "span_id": 17950780182420895598,
        "trace_id": 2856594830134492744
    }
}

running: False
schema_name_id: 2428
start_time: 2024-11-05 22:38:05
success: True
trace_id: 2856594830134492744

Scan 6673740

duration: 0:00:11.351692

exit_message:

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

id: 6673740

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_newbookbackdate_requests_dates/2024-11-05/1730866304",
        "key": "raw/newbookdev_newbookbackdate_requests_dates/2024-11-05/1730866304/backdate_requests_dates.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbackdate_requests_dates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7994626704455913836,
        "service_name": "drive-thru",
        "span_id": 1476137315563527241,
        "trace_id": 4280884564870272619
    }
}

running: False
schema_name_id: 2428
start_time: 2024-11-05 22:23:56
success: True
trace_id: 4280884564870272619

Scan 6673409

duration: 0:00:14.067331

exit_message:

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

id: 6673409

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_newbookbackdate_requests_dates/2024-11-05/1730866232",
        "key": "raw/newbookdev_newbookbackdate_requests_dates/2024-11-05/1730866232/backdate_requests_dates.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbackdate_requests_dates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13816972905558016449,
        "service_name": "drive-thru",
        "span_id": 14175748983354697443,
        "trace_id": 15403303116877832699
    }
}

running: False
schema_name_id: 2428
start_time: 2024-11-05 22:14:29
success: True
trace_id: 15403303116877832699

Scan 6671831

duration: 0:00:13.972906

exit_message:

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

id: 6671831

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_newbookbackdate_requests_dates/2024-11-04/1730785651",
        "key": "raw/newbookdev_newbookbackdate_requests_dates/2024-11-04/1730785651/backdate_requests_dates.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbackdate_requests_dates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13524390068478784017,
        "service_name": "drive-thru",
        "span_id": 6469560304426030864,
        "trace_id": 17071652875023939257
    }
}

running: False
schema_name_id: 2428
start_time: 2024-11-05 04:12:16
success: True
trace_id: 17071652875023939257

Scan 6671152

duration: 0:00:11.382201

exit_message:

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

id: 6671152

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_newbookbackdate_requests_dates/2024-11-04/1730785083",
        "key": "raw/newbookdev_newbookbackdate_requests_dates/2024-11-04/1730785083/backdate_requests_dates.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbackdate_requests_dates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3282926141361169106,
        "service_name": "drive-thru",
        "span_id": 12130997275315677418,
        "trace_id": 167899902921149114
    }
}

running: False
schema_name_id: 2428
start_time: 2024-11-05 03:43:22
success: True
trace_id: 167899902921149114

Scan 6669721

duration: 0:00:11.367703

exit_message:

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

id: 6669721

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_newbookbackdate_requests_dates/2024-11-04/1730784174",
        "key": "raw/newbookdev_newbookbackdate_requests_dates/2024-11-04/1730784174/backdate_requests_dates.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbackdate_requests_dates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7761059967357769161,
        "service_name": "drive-thru",
        "span_id": 12556698355617905709,
        "trace_id": 12651767289333707997
    }
}

running: False
schema_name_id: 2428
start_time: 2024-11-05 03:04:47
success: True
trace_id: 12651767289333707997

Scan 6669701

duration: 0:00:13.889785

exit_message:

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

id: 6669701

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_newbookbackdate_requests_dates/2024-11-04/1730784777",
        "key": "raw/newbookdev_newbookbackdate_requests_dates/2024-11-04/1730784777/backdate_requests_dates.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbackdate_requests_dates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7398057016625085948,
        "service_name": "drive-thru",
        "span_id": 5203635863817559300,
        "trace_id": 6557554337989234505
    }
}

running: False
schema_name_id: 2428
start_time: 2024-11-05 03:04:15
success: True
trace_id: 6557554337989234505

Scan 6668912

duration: 0:00:11.449640

exit_message:

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

id: 6668912

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_newbookbackdate_requests_dates/2024-11-04/1730784012",
        "key": "raw/newbookdev_newbookbackdate_requests_dates/2024-11-04/1730784012/backdate_requests_dates.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbackdate_requests_dates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6235514878309594911,
        "service_name": "drive-thru",
        "span_id": 12421113919309591800,
        "trace_id": 10540862186572437930
    }
}

running: False
schema_name_id: 2428
start_time: 2024-11-05 02:43:23
success: True
trace_id: 10540862186572437930

Scan 6668464

duration: 0:00:11.290676

exit_message:

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

id: 6668464

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_newbookbackdate_requests_dates/2024-11-04/1730783867",
        "key": "raw/newbookdev_newbookbackdate_requests_dates/2024-11-04/1730783867/backdate_requests_dates.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbackdate_requests_dates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5641186426953129653,
        "service_name": "drive-thru",
        "span_id": 17639819769969078513,
        "trace_id": 15907519677301030312
    }
}

running: False
schema_name_id: 2428
start_time: 2024-11-05 02:31:30
success: True
trace_id: 15907519677301030312

Scan 6667504

duration: 0:00:11.301769

exit_message:

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

id: 6667504

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_newbookbackdate_requests_dates/2024-11-04/1730783724",
        "key": "raw/newbookdev_newbookbackdate_requests_dates/2024-11-04/1730783724/backdate_requests_dates.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbackdate_requests_dates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8689179419309440397,
        "service_name": "drive-thru",
        "span_id": 6122522041390007926,
        "trace_id": 2936413269668919330
    }
}

running: False
schema_name_id: 2428
start_time: 2024-11-05 02:06:10
success: True
trace_id: 2936413269668919330

Scan 6666826

duration: 0:00:11.297052

exit_message:

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

id: 6666826

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_newbookbackdate_requests_dates/2024-11-04/1730783599",
        "key": "raw/newbookdev_newbookbackdate_requests_dates/2024-11-04/1730783599/backdate_requests_dates.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbackdate_requests_dates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3271215544012452217,
        "service_name": "drive-thru",
        "span_id": 4828084586977009026,
        "trace_id": 3730973396266665933
    }
}

running: False
schema_name_id: 2428
start_time: 2024-11-05 01:48:05
success: True
trace_id: 3730973396266665933

Scan 6665990

duration: 0:00:11.465071

exit_message:

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

id: 6665990

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_newbookbackdate_requests_dates/2024-11-04/1730783480",
        "key": "raw/newbookdev_newbookbackdate_requests_dates/2024-11-04/1730783480/backdate_requests_dates.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbackdate_requests_dates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5932321409125706616,
        "service_name": "drive-thru",
        "span_id": 8969470410906381958,
        "trace_id": 2070203281794731570
    }
}

running: False
schema_name_id: 2428
start_time: 2024-11-05 01:26:06
success: True
trace_id: 2070203281794731570

Scan 6665224

duration: 0:00:13.856956

exit_message:

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

id: 6665224

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_newbookbackdate_requests_dates/2024-11-04/1730783261",
        "key": "raw/newbookdev_newbookbackdate_requests_dates/2024-11-04/1730783261/backdate_requests_dates.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbackdate_requests_dates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14946111107360359829,
        "service_name": "drive-thru",
        "span_id": 1806769246656493553,
        "trace_id": 9298129962815680665
    }
}

running: False
schema_name_id: 2428
start_time: 2024-11-05 01:05:49
success: True
trace_id: 9298129962815680665

Scan 6664291

duration: 0:00:13.978156

exit_message:

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

id: 6664291

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_newbookbackdate_requests_dates/2024-11-04/1730782864",
        "key": "raw/newbookdev_newbookbackdate_requests_dates/2024-11-04/1730782864/backdate_requests_dates.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbackdate_requests_dates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7754178962640136664,
        "service_name": "drive-thru",
        "span_id": 13037661071298285471,
        "trace_id": 14105342133954072311
    }
}

running: False
schema_name_id: 2428
start_time: 2024-11-05 00:41:12
success: True
trace_id: 14105342133954072311

Scan 6664030

duration: 0:00:13.893938

exit_message:

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

id: 6664030

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_newbookbackdate_requests_dates/2024-11-04/1730782773",
        "key": "raw/newbookdev_newbookbackdate_requests_dates/2024-11-04/1730782773/backdate_requests_dates.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbackdate_requests_dates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14209959736890046773,
        "service_name": "drive-thru",
        "span_id": 7717788082110076276,
        "trace_id": 9051517871443654923
    }
}

running: False
schema_name_id: 2428
start_time: 2024-11-05 00:34:23
success: True
trace_id: 9051517871443654923

Partitions:

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

Schema:

attributes:

{
    "id": "string",
    "newbook_region": "string",
    "request_id": "string",
    "tenant": "string",
    "timestamp": "string"
}

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

ddl:

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

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