Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookpage_requirements

created: 2024-10-08 18:18:38
disabled: False
format: raw
id: 2901
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4749359

created: 2024-11-05 23:42:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookpage_requirements`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookpage_requirements`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `action_id`  string , `key`  string , `notes`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_requirements/2024-11-05/1730866578'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookpage_requirements"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_requirements/2024-11-05/1730866578
id: 4749359
processed: 1

raw_data:

{
    "action_id": 3,
    "active": 6,
    "id": 2,
    "key": 4,
    "newbook_region": 0,
    "notes": 5,
    "tenant": 1
}

schema_attributes:

{
    "action_id": "string",
    "active": "string",
    "id": "string",
    "key": "string",
    "newbook_region": "string",
    "notes": "string",
    "tenant": "string"
}

schema_name_id: 2901
schema_scan_id: 6675392
updated: 2024-11-05 23:42:27

Version 4748984

created: 2024-11-05 23:12:19

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookpage_requirements`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookpage_requirements`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `action_id`  string , `key`  string , `notes`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_requirements/2024-11-05/1730866520'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookpage_requirements"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_requirements/2024-11-05/1730866520
id: 4748984
processed: 1

raw_data:

{
    "action_id": 3,
    "active": 6,
    "id": 2,
    "key": 4,
    "newbook_region": 0,
    "notes": 5,
    "tenant": 1
}

schema_attributes:

{
    "action_id": "string",
    "active": "string",
    "id": "string",
    "key": "string",
    "newbook_region": "string",
    "notes": "string",
    "tenant": "string"
}

schema_name_id: 2901
schema_scan_id: 6675016
updated: 2024-11-05 23:12:30

Version 4748230

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookpage_requirements`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookpage_requirements`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `action_id`  string , `key`  string , `notes`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_requirements/2024-11-05/1730866393'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookpage_requirements"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_requirements/2024-11-05/1730866393
id: 4748230
processed: 1

raw_data:

{
    "action_id": 3,
    "active": 6,
    "id": 2,
    "key": 4,
    "newbook_region": 0,
    "notes": 5,
    "tenant": 1
}

schema_attributes:

{
    "action_id": "string",
    "active": "string",
    "id": "string",
    "key": "string",
    "newbook_region": "string",
    "notes": "string",
    "tenant": "string"
}

schema_name_id: 2901
schema_scan_id: 6674262
updated: 2024-11-05 22:39:11

Version 4746959

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookpage_requirements`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookpage_requirements`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `action_id`  string , `key`  string , `notes`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_requirements/2024-11-04/1730785775'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookpage_requirements"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_requirements/2024-11-04/1730785775
id: 4746959
processed: 1

raw_data:

{
    "action_id": 3,
    "active": 6,
    "id": 2,
    "key": 4,
    "newbook_region": 0,
    "notes": 5,
    "tenant": 1
}

schema_attributes:

{
    "action_id": "string",
    "active": "string",
    "id": "string",
    "key": "string",
    "newbook_region": "string",
    "notes": "string",
    "tenant": "string"
}

schema_name_id: 2901
schema_scan_id: 6672190
updated: 2024-11-05 04:35:43

Version 4746603

created: 2024-11-05 04:11:54

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookpage_requirements`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookpage_requirements`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `action_id`  string , `key`  string , `notes`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_requirements/2024-11-04/1730785155'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookpage_requirements"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_requirements/2024-11-04/1730785155
id: 4746603
processed: 1

raw_data:

{
    "action_id": 3,
    "active": 6,
    "id": 2,
    "key": 4,
    "newbook_region": 0,
    "notes": 5,
    "tenant": 1
}

schema_attributes:

{
    "action_id": "string",
    "active": "string",
    "id": "string",
    "key": "string",
    "newbook_region": "string",
    "notes": "string",
    "tenant": "string"
}

schema_name_id: 2901
schema_scan_id: 6671826
updated: 2024-11-05 04:12:05

Version 4745566

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookpage_requirements`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookpage_requirements`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `action_id`  string , `key`  string , `notes`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_requirements/2024-11-04/1730784850'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookpage_requirements"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_requirements/2024-11-04/1730784850
id: 4745566
processed: 1

raw_data:

{
    "action_id": 3,
    "active": 6,
    "id": 2,
    "key": 4,
    "newbook_region": 0,
    "notes": 5,
    "tenant": 1
}

schema_attributes:

{
    "action_id": "string",
    "active": "string",
    "id": "string",
    "key": "string",
    "newbook_region": "string",
    "notes": "string",
    "tenant": "string"
}

schema_name_id: 2901
schema_scan_id: 6670783
updated: 2024-11-05 03:33:01

Version 4744807

created: 2024-11-05 03:12:53

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookpage_requirements`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookpage_requirements`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `action_id`  string , `key`  string , `notes`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_requirements/2024-11-04/1730784246'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookpage_requirements"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_requirements/2024-11-04/1730784246
id: 4744807
processed: 1

raw_data:

{
    "action_id": 3,
    "active": 6,
    "id": 2,
    "key": 4,
    "newbook_region": 0,
    "notes": 5,
    "tenant": 1
}

schema_attributes:

{
    "action_id": "string",
    "active": "string",
    "id": "string",
    "key": "string",
    "newbook_region": "string",
    "notes": "string",
    "tenant": "string"
}

schema_name_id: 2901
schema_scan_id: 6670024
updated: 2024-11-05 03:13:04

Version 4744063

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookpage_requirements`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookpage_requirements`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `action_id`  string , `key`  string , `notes`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_requirements/2024-11-04/1730784084'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookpage_requirements"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_requirements/2024-11-04/1730784084
id: 4744063
processed: 1

raw_data:

{
    "action_id": 3,
    "active": 6,
    "id": 2,
    "key": 4,
    "newbook_region": 0,
    "notes": 5,
    "tenant": 1
}

schema_attributes:

{
    "action_id": "string",
    "active": "string",
    "id": "string",
    "key": "string",
    "newbook_region": "string",
    "notes": "string",
    "tenant": "string"
}

schema_name_id: 2901
schema_scan_id: 6669281
updated: 2024-11-05 02:53:15

Version 4742853

created: 2024-11-05 02:21:08

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookpage_requirements`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookpage_requirements`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `action_id`  string , `key`  string , `notes`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_requirements/2024-11-04/1730783922'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookpage_requirements"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_requirements/2024-11-04/1730783922
id: 4742853
processed: 1

raw_data:

{
    "action_id": 3,
    "active": 6,
    "id": 2,
    "key": 4,
    "newbook_region": 0,
    "notes": 5,
    "tenant": 1
}

schema_attributes:

{
    "action_id": "string",
    "active": "string",
    "id": "string",
    "key": "string",
    "newbook_region": "string",
    "notes": "string",
    "tenant": "string"
}

schema_name_id: 2901
schema_scan_id: 6668070
updated: 2024-11-05 02:21:19

Version 4742647

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookpage_requirements`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookpage_requirements`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `action_id`  string , `key`  string , `notes`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_requirements/2024-11-04/1730783797'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookpage_requirements"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_requirements/2024-11-04/1730783797
id: 4742647
processed: 1

raw_data:

{
    "action_id": 3,
    "active": 6,
    "id": 2,
    "key": 4,
    "newbook_region": 0,
    "notes": 5,
    "tenant": 1
}

schema_attributes:

{
    "action_id": "string",
    "active": "string",
    "id": "string",
    "key": "string",
    "newbook_region": "string",
    "notes": "string",
    "tenant": "string"
}

schema_name_id: 2901
schema_scan_id: 6667864
updated: 2024-11-05 02:15:55

Version 4741900

created: 2024-11-05 01:55:47

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookpage_requirements`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookpage_requirements`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `action_id`  string , `key`  string , `notes`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_requirements/2024-11-04/1730783688'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookpage_requirements"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_requirements/2024-11-04/1730783688
id: 4741900
processed: 1

raw_data:

{
    "action_id": 3,
    "active": 6,
    "id": 2,
    "key": 4,
    "newbook_region": 0,
    "notes": 5,
    "tenant": 1
}

schema_attributes:

{
    "action_id": "string",
    "active": "string",
    "id": "string",
    "key": "string",
    "newbook_region": "string",
    "notes": "string",
    "tenant": "string"
}

schema_name_id: 2901
schema_scan_id: 6667117
updated: 2024-11-05 01:55:59

Version 4741308

created: 2024-11-05 01:40:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookpage_requirements`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookpage_requirements`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `action_id`  string , `key`  string , `notes`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_requirements/2024-11-04/1730783554'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookpage_requirements"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_requirements/2024-11-04/1730783554
id: 4741308
processed: 1

raw_data:

{
    "action_id": 3,
    "active": 6,
    "id": 2,
    "key": 4,
    "newbook_region": 0,
    "notes": 5,
    "tenant": 1
}

schema_attributes:

{
    "action_id": "string",
    "active": "string",
    "id": "string",
    "key": "string",
    "newbook_region": "string",
    "notes": "string",
    "tenant": "string"
}

schema_name_id: 2901
schema_scan_id: 6666525
updated: 2024-11-05 01:40:24

Version 4740546

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookpage_requirements`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookpage_requirements`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `action_id`  string , `key`  string , `notes`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_requirements/2024-11-04/1730783336'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookpage_requirements"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_requirements/2024-11-04/1730783336
id: 4740546
processed: 1

raw_data:

{
    "action_id": 3,
    "active": 6,
    "id": 2,
    "key": 4,
    "newbook_region": 0,
    "notes": 5,
    "tenant": 1
}

schema_attributes:

{
    "action_id": "string",
    "active": "string",
    "id": "string",
    "key": "string",
    "newbook_region": "string",
    "notes": "string",
    "tenant": "string"
}

schema_name_id: 2901
schema_scan_id: 6665763
updated: 2024-11-05 01:20:21

Version 4739781

created: 2024-11-05 00:59:46

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookpage_requirements`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookpage_requirements`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `action_id`  string , `key`  string , `notes`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_requirements/2024-11-04/1730782935'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookpage_requirements"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_requirements/2024-11-04/1730782935
id: 4739781
processed: 1

raw_data:

{
    "action_id": 3,
    "active": 6,
    "id": 2,
    "key": 4,
    "newbook_region": 0,
    "notes": 5,
    "tenant": 1
}

schema_attributes:

{
    "action_id": "string",
    "active": "string",
    "id": "string",
    "key": "string",
    "newbook_region": "string",
    "notes": "string",
    "tenant": "string"
}

schema_name_id: 2901
schema_scan_id: 6664998
updated: 2024-11-05 01:00:00

Version 4738748

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookpage_requirements`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookpage_requirements`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `action_id`  string , `key`  string , `notes`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_requirements/2024-11-04/1730782758'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookpage_requirements"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_requirements/2024-11-04/1730782758
id: 4738748
processed: 1

raw_data:

{
    "action_id": 3,
    "active": 6,
    "id": 2,
    "key": 4,
    "newbook_region": 0,
    "notes": 5,
    "tenant": 1
}

schema_attributes:

{
    "action_id": "string",
    "active": "string",
    "id": "string",
    "key": "string",
    "newbook_region": "string",
    "notes": "string",
    "tenant": "string"
}

schema_name_id: 2901
schema_scan_id: 6663961
updated: 2024-11-05 00:32:49

Schema Scans: 15

Last at 2024-11-05 23:42:13

Scan 6675392

duration: 0:00:14.072368

exit_message:

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

id: 6675392

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_newbookpage_requirements/2024-11-05/1730866578",
        "key": "raw/newbookdev_newbookpage_requirements/2024-11-05/1730866578/page_requirements.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookpage_requirements",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8151685265493879819,
        "service_name": "drive-thru",
        "span_id": 16100707249281695317,
        "trace_id": 17783994683980048996
    }
}

running: False
schema_name_id: 2901
start_time: 2024-11-05 23:42:13
success: True
trace_id: 17783994683980048996

Scan 6675016

duration: 0:00:11.581781

exit_message:

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

id: 6675016

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_newbookpage_requirements/2024-11-05/1730866520",
        "key": "raw/newbookdev_newbookpage_requirements/2024-11-05/1730866520/page_requirements.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookpage_requirements",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10713507638423011387,
        "service_name": "drive-thru",
        "span_id": 15309643251977448310,
        "trace_id": 2944027476399266741
    }
}

running: False
schema_name_id: 2901
start_time: 2024-11-05 23:12:19
success: True
trace_id: 2944027476399266741

Scan 6674262

duration: 0:00:14.043543

exit_message:

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

id: 6674262

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_newbookpage_requirements/2024-11-05/1730866393",
        "key": "raw/newbookdev_newbookpage_requirements/2024-11-05/1730866393/page_requirements.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookpage_requirements",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12569054488575928288,
        "service_name": "drive-thru",
        "span_id": 1697540858820348687,
        "trace_id": 1999572598308435517
    }
}

running: False
schema_name_id: 2901
start_time: 2024-11-05 22:38:57
success: True
trace_id: 1999572598308435517

Scan 6672190

duration: 0:00:11.616020

exit_message:

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

id: 6672190

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_newbookpage_requirements/2024-11-04/1730785775",
        "key": "raw/newbookdev_newbookpage_requirements/2024-11-04/1730785775/page_requirements.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookpage_requirements",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5905564056791311116,
        "service_name": "drive-thru",
        "span_id": 16823765985460905309,
        "trace_id": 8061610033750838079
    }
}

running: False
schema_name_id: 2901
start_time: 2024-11-05 04:35:31
success: True
trace_id: 8061610033750838079

Scan 6671826

duration: 0:00:11.499013

exit_message:

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

id: 6671826

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_newbookpage_requirements/2024-11-04/1730785155",
        "key": "raw/newbookdev_newbookpage_requirements/2024-11-04/1730785155/page_requirements.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookpage_requirements",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11623804799608490761,
        "service_name": "drive-thru",
        "span_id": 10529482390604169858,
        "trace_id": 3392738840828423400
    }
}

running: False
schema_name_id: 2901
start_time: 2024-11-05 04:11:53
success: True
trace_id: 3392738840828423400

Scan 6670783

duration: 0:00:11.434626

exit_message:

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

id: 6670783

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_newbookpage_requirements/2024-11-04/1730784850",
        "key": "raw/newbookdev_newbookpage_requirements/2024-11-04/1730784850/page_requirements.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookpage_requirements",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15128701174163556233,
        "service_name": "drive-thru",
        "span_id": 374803791126641466,
        "trace_id": 1288484668741597670
    }
}

running: False
schema_name_id: 2901
start_time: 2024-11-05 03:32:49
success: True
trace_id: 1288484668741597670

Scan 6670024

duration: 0:00:11.369633

exit_message:

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

id: 6670024

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_newbookpage_requirements/2024-11-04/1730784246",
        "key": "raw/newbookdev_newbookpage_requirements/2024-11-04/1730784246/page_requirements.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookpage_requirements",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10495373242761325294,
        "service_name": "drive-thru",
        "span_id": 10333849081843308229,
        "trace_id": 7813957326151425655
    }
}

running: False
schema_name_id: 2901
start_time: 2024-11-05 03:12:52
success: True
trace_id: 7813957326151425655

Scan 6669281

duration: 0:00:13.909402

exit_message:

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

id: 6669281

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_newbookpage_requirements/2024-11-04/1730784084",
        "key": "raw/newbookdev_newbookpage_requirements/2024-11-04/1730784084/page_requirements.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookpage_requirements",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12367443796564380767,
        "service_name": "drive-thru",
        "span_id": 9684893889196006196,
        "trace_id": 14398488333126621181
    }
}

running: False
schema_name_id: 2901
start_time: 2024-11-05 02:53:01
success: True
trace_id: 14398488333126621181

Scan 6668070

duration: 0:00:11.393910

exit_message:

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

id: 6668070

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_newbookpage_requirements/2024-11-04/1730783922",
        "key": "raw/newbookdev_newbookpage_requirements/2024-11-04/1730783922/page_requirements.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookpage_requirements",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1982486933883873961,
        "service_name": "drive-thru",
        "span_id": 3435352184807484385,
        "trace_id": 970281962391644508
    }
}

running: False
schema_name_id: 2901
start_time: 2024-11-05 02:21:08
success: True
trace_id: 970281962391644508

Scan 6667864

duration: 0:00:11.367919

exit_message:

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

id: 6667864

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_newbookpage_requirements/2024-11-04/1730783797",
        "key": "raw/newbookdev_newbookpage_requirements/2024-11-04/1730783797/page_requirements.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookpage_requirements",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1970227075770388358,
        "service_name": "drive-thru",
        "span_id": 15366377544833502384,
        "trace_id": 10506818836856908908
    }
}

running: False
schema_name_id: 2901
start_time: 2024-11-05 02:15:44
success: True
trace_id: 10506818836856908908

Scan 6667117

duration: 0:00:12.977433

exit_message:

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

id: 6667117

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_newbookpage_requirements/2024-11-04/1730783688",
        "key": "raw/newbookdev_newbookpage_requirements/2024-11-04/1730783688/page_requirements.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookpage_requirements",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4551868181227835960,
        "service_name": "drive-thru",
        "span_id": 10765073908792011873,
        "trace_id": 9825648974198615346
    }
}

running: False
schema_name_id: 2901
start_time: 2024-11-05 01:55:46
success: True
trace_id: 9825648974198615346

Scan 6666525

duration: 0:00:11.361298

exit_message:

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

id: 6666525

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_newbookpage_requirements/2024-11-04/1730783554",
        "key": "raw/newbookdev_newbookpage_requirements/2024-11-04/1730783554/page_requirements.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookpage_requirements",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5693028439023690720,
        "service_name": "drive-thru",
        "span_id": 18144220904085390053,
        "trace_id": 12665584937975989791
    }
}

running: False
schema_name_id: 2901
start_time: 2024-11-05 01:40:13
success: True
trace_id: 12665584937975989791

Scan 6665763

duration: 0:00:13.850614

exit_message:

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

id: 6665763

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_newbookpage_requirements/2024-11-04/1730783336",
        "key": "raw/newbookdev_newbookpage_requirements/2024-11-04/1730783336/page_requirements.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookpage_requirements",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15293635768316004910,
        "service_name": "drive-thru",
        "span_id": 2396271660967049909,
        "trace_id": 5813324929704501248
    }
}

running: False
schema_name_id: 2901
start_time: 2024-11-05 01:20:07
success: True
trace_id: 5813324929704501248

Scan 6664998

duration: 0:00:14.142433

exit_message:

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

id: 6664998

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_newbookpage_requirements/2024-11-04/1730782935",
        "key": "raw/newbookdev_newbookpage_requirements/2024-11-04/1730782935/page_requirements.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookpage_requirements",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5160448511014733503,
        "service_name": "drive-thru",
        "span_id": 8155276583702170722,
        "trace_id": 17488454273149287757
    }
}

running: False
schema_name_id: 2901
start_time: 2024-11-05 00:59:46
success: True
trace_id: 17488454273149287757

Scan 6663961

duration: 0:00:13.884571

exit_message:

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

id: 6663961

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_newbookpage_requirements/2024-11-04/1730782758",
        "key": "raw/newbookdev_newbookpage_requirements/2024-11-04/1730782758/page_requirements.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookpage_requirements",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17270030222635578520,
        "service_name": "drive-thru",
        "span_id": 10066326958457216415,
        "trace_id": 1892309190380027619
    }
}

running: False
schema_name_id: 2901
start_time: 2024-11-05 00:32:35
success: True
trace_id: 1892309190380027619

Partitions:

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

Schema:

attributes:

{
    "action_id": "string",
    "active": "string",
    "id": "string",
    "key": "string",
    "newbook_region": "string",
    "notes": "string",
    "tenant": "string"
}

created: 2024-11-05 23:42:14

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookpage_requirements`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `action_id`  string , `key`  string , `notes`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_requirements/2024-11-05/1730866578'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookpage_requirements`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookpage_requirements"
}

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:18:38",
        "disabled": false,
        "format": "raw",
        "id": 2901,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "newbookdev_newbookpage_requirements"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "action_id": "string",
            "active": "string",
            "id": "string",
            "key": "string",
            "newbook_region": "string",
            "notes": "string",
            "tenant": "string"
        },
        "created": "2024-11-05 23:42:14",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookpage_requirements`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `action_id`  string , `key`  string , `notes`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_requirements/2024-11-05/1730866578'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookpage_requirements`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookpage_requirements"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}