Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookprojects_statuses

created: 2024-10-08 18:23:26
disabled: False
format: raw
id: 2946
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4749270

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookprojects_statuses`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookprojects_statuses`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `colour`  string , `display_order`  string , `type`  string , `default`  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_newbookprojects_statuses/2024-11-05/1730866585'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookprojects_statuses"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookprojects_statuses/2024-11-05/1730866585
id: 4749270
processed: 1

raw_data:

{
    "colour": 4,
    "default": 7,
    "display_order": 5,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1,
    "type": 6
}

schema_attributes:

{
    "colour": "string",
    "default": "string",
    "display_order": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string"
}

schema_name_id: 2946
schema_scan_id: 6675302
updated: 2024-11-05 23:33:05

Version 4748899

created: 2024-11-05 23:07:39

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookprojects_statuses`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookprojects_statuses`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `colour`  string , `display_order`  string , `type`  string , `default`  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_newbookprojects_statuses/2024-11-05/1730866527'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookprojects_statuses"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookprojects_statuses/2024-11-05/1730866527
id: 4748899
processed: 1

raw_data:

{
    "colour": 4,
    "default": 7,
    "display_order": 5,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1,
    "type": 6
}

schema_attributes:

{
    "colour": "string",
    "default": "string",
    "display_order": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string"
}

schema_name_id: 2946
schema_scan_id: 6674931
updated: 2024-11-05 23:07:52

Version 4748422

created: 2024-11-05 22:45:45

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookprojects_statuses`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookprojects_statuses`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `colour`  string , `display_order`  string , `type`  string , `default`  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_newbookprojects_statuses/2024-11-05/1730866404'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookprojects_statuses"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookprojects_statuses/2024-11-05/1730866404
id: 4748422
processed: 1

raw_data:

{
    "colour": 4,
    "default": 7,
    "display_order": 5,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1,
    "type": 6
}

schema_attributes:

{
    "colour": "string",
    "default": "string",
    "display_order": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string"
}

schema_name_id: 2946
schema_scan_id: 6674454
updated: 2024-11-05 22:45:56

Version 4747232

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookprojects_statuses`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookprojects_statuses`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `colour`  string , `display_order`  string , `type`  string , `default`  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_newbookprojects_statuses/2024-11-04/1730785781'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookprojects_statuses"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookprojects_statuses/2024-11-04/1730785781
id: 4747232
processed: 1

raw_data:

{
    "colour": 4,
    "default": 7,
    "display_order": 5,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1,
    "type": 6
}

schema_attributes:

{
    "colour": "string",
    "default": "string",
    "display_order": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string"
}

schema_name_id: 2946
schema_scan_id: 6672497
updated: 2024-11-05 05:05:32

Version 4746368

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookprojects_statuses`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookprojects_statuses`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `colour`  string , `display_order`  string , `type`  string , `default`  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_newbookprojects_statuses/2024-11-04/1730785158'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookprojects_statuses"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookprojects_statuses/2024-11-04/1730785158
id: 4746368
processed: 1

raw_data:

{
    "colour": 4,
    "default": 7,
    "display_order": 5,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1,
    "type": 6
}

schema_attributes:

{
    "colour": "string",
    "default": "string",
    "display_order": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string"
}

schema_name_id: 2946
schema_scan_id: 6671589
updated: 2024-11-05 04:00:14

Version 4745679

created: 2024-11-05 03:35:48

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookprojects_statuses`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookprojects_statuses`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `colour`  string , `display_order`  string , `type`  string , `default`  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_newbookprojects_statuses/2024-11-04/1730784853'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookprojects_statuses"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookprojects_statuses/2024-11-04/1730784853
id: 4745679
processed: 1

raw_data:

{
    "colour": 4,
    "default": 7,
    "display_order": 5,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1,
    "type": 6
}

schema_attributes:

{
    "colour": "string",
    "default": "string",
    "display_order": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string"
}

schema_name_id: 2946
schema_scan_id: 6670896
updated: 2024-11-05 03:36:01

Version 4744840

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookprojects_statuses`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookprojects_statuses`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `colour`  string , `display_order`  string , `type`  string , `default`  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_newbookprojects_statuses/2024-11-04/1730784249'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookprojects_statuses"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookprojects_statuses/2024-11-04/1730784249
id: 4744840
processed: 1

raw_data:

{
    "colour": 4,
    "default": 7,
    "display_order": 5,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1,
    "type": 6
}

schema_attributes:

{
    "colour": "string",
    "default": "string",
    "display_order": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string"
}

schema_name_id: 2946
schema_scan_id: 6670057
updated: 2024-11-05 03:13:53

Version 4744246

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookprojects_statuses`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookprojects_statuses`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `colour`  string , `display_order`  string , `type`  string , `default`  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_newbookprojects_statuses/2024-11-04/1730784087'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookprojects_statuses"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookprojects_statuses/2024-11-04/1730784087
id: 4744246
processed: 1

raw_data:

{
    "colour": 4,
    "default": 7,
    "display_order": 5,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1,
    "type": 6
}

schema_attributes:

{
    "colour": "string",
    "default": "string",
    "display_order": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string"
}

schema_name_id: 2946
schema_scan_id: 6669463
updated: 2024-11-05 02:58:00

Version 4743731

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookprojects_statuses`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookprojects_statuses`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `colour`  string , `display_order`  string , `type`  string , `default`  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_newbookprojects_statuses/2024-11-04/1730783925'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookprojects_statuses"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookprojects_statuses/2024-11-04/1730783925
id: 4743731
processed: 1

raw_data:

{
    "colour": 4,
    "default": 7,
    "display_order": 5,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1,
    "type": 6
}

schema_attributes:

{
    "colour": "string",
    "default": "string",
    "display_order": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string"
}

schema_name_id: 2946
schema_scan_id: 6668948
updated: 2024-11-05 02:44:33

Version 4742242

created: 2024-11-05 02:04:55

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookprojects_statuses`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookprojects_statuses`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `colour`  string , `display_order`  string , `type`  string , `default`  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_newbookprojects_statuses/2024-11-04/1730783801'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookprojects_statuses"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookprojects_statuses/2024-11-04/1730783801
id: 4742242
processed: 1

raw_data:

{
    "colour": 4,
    "default": 7,
    "display_order": 5,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1,
    "type": 6
}

schema_attributes:

{
    "colour": "string",
    "default": "string",
    "display_order": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string"
}

schema_name_id: 2946
schema_scan_id: 6667459
updated: 2024-11-05 02:05:08

Version 4742101

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookprojects_statuses`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookprojects_statuses`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `colour`  string , `display_order`  string , `type`  string , `default`  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_newbookprojects_statuses/2024-11-04/1730783690'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookprojects_statuses"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookprojects_statuses/2024-11-04/1730783690
id: 4742101
processed: 1

raw_data:

{
    "colour": 4,
    "default": 7,
    "display_order": 5,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1,
    "type": 6
}

schema_attributes:

{
    "colour": "string",
    "default": "string",
    "display_order": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string"
}

schema_name_id: 2946
schema_scan_id: 6667318
updated: 2024-11-05 02:01:17

Version 4741419

created: 2024-11-05 01:43:06

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookprojects_statuses`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookprojects_statuses`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `colour`  string , `display_order`  string , `type`  string , `default`  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_newbookprojects_statuses/2024-11-04/1730783558'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookprojects_statuses"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookprojects_statuses/2024-11-04/1730783558
id: 4741419
processed: 1

raw_data:

{
    "colour": 4,
    "default": 7,
    "display_order": 5,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1,
    "type": 6
}

schema_attributes:

{
    "colour": "string",
    "default": "string",
    "display_order": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string"
}

schema_name_id: 2946
schema_scan_id: 6666636
updated: 2024-11-05 01:43:17

Version 4740655

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookprojects_statuses`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookprojects_statuses`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `colour`  string , `display_order`  string , `type`  string , `default`  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_newbookprojects_statuses/2024-11-04/1730783339'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookprojects_statuses"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookprojects_statuses/2024-11-04/1730783339
id: 4740655
processed: 1

raw_data:

{
    "colour": 4,
    "default": 7,
    "display_order": 5,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1,
    "type": 6
}

schema_attributes:

{
    "colour": "string",
    "default": "string",
    "display_order": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string"
}

schema_name_id: 2946
schema_scan_id: 6665872
updated: 2024-11-05 01:23:12

Version 4739701

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookprojects_statuses`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookprojects_statuses`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `colour`  string , `display_order`  string , `type`  string , `default`  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_newbookprojects_statuses/2024-11-04/1730782938'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookprojects_statuses"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookprojects_statuses/2024-11-04/1730782938
id: 4739701
processed: 1

raw_data:

{
    "colour": 4,
    "default": 7,
    "display_order": 5,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1,
    "type": 6
}

schema_attributes:

{
    "colour": "string",
    "default": "string",
    "display_order": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string"
}

schema_name_id: 2946
schema_scan_id: 6664918
updated: 2024-11-05 00:57:48

Version 4738624

created: 2024-11-05 00:29:15

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookprojects_statuses`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookprojects_statuses`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `colour`  string , `display_order`  string , `type`  string , `default`  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_newbookprojects_statuses/2024-11-04/1730782759'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookprojects_statuses"
]

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

raw_data:

{
    "colour": 4,
    "default": 7,
    "display_order": 5,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1,
    "type": 6
}

schema_attributes:

{
    "colour": "string",
    "default": "string",
    "display_order": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string"
}

schema_name_id: 2946
schema_scan_id: 6663837
updated: 2024-11-05 00:29:29

Schema Scans: 15

Last at 2024-11-05 23:32:51

Scan 6675302

duration: 0:00:14.214215

exit_message:

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

id: 6675302

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_newbookprojects_statuses/2024-11-05/1730866585",
        "key": "raw/newbookdev_newbookprojects_statuses/2024-11-05/1730866585/projects_statuses.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookprojects_statuses",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14588234052496643044,
        "service_name": "drive-thru",
        "span_id": 1467984079479530955,
        "trace_id": 6563003693461657477
    }
}

running: False
schema_name_id: 2946
start_time: 2024-11-05 23:32:51
success: True
trace_id: 6563003693461657477

Scan 6674931

duration: 0:00:14.076101

exit_message:

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

id: 6674931

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_newbookprojects_statuses/2024-11-05/1730866527",
        "key": "raw/newbookdev_newbookprojects_statuses/2024-11-05/1730866527/projects_statuses.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookprojects_statuses",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11644024527348846865,
        "service_name": "drive-thru",
        "span_id": 13809028575731444521,
        "trace_id": 545613115444136653
    }
}

running: False
schema_name_id: 2946
start_time: 2024-11-05 23:07:38
success: True
trace_id: 545613115444136653

Scan 6674454

duration: 0:00:11.718081

exit_message:

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

id: 6674454

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_newbookprojects_statuses/2024-11-05/1730866404",
        "key": "raw/newbookdev_newbookprojects_statuses/2024-11-05/1730866404/projects_statuses.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookprojects_statuses",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1435812305548941896,
        "service_name": "drive-thru",
        "span_id": 3606896317582340781,
        "trace_id": 5922692234122634952
    }
}

running: False
schema_name_id: 2946
start_time: 2024-11-05 22:45:44
success: True
trace_id: 5922692234122634952

Scan 6672497

duration: 0:00:14.262473

exit_message:

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

id: 6672497

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_newbookprojects_statuses/2024-11-04/1730785781",
        "key": "raw/newbookdev_newbookprojects_statuses/2024-11-04/1730785781/projects_statuses.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookprojects_statuses",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1278599811182279705,
        "service_name": "drive-thru",
        "span_id": 14301510192223729064,
        "trace_id": 1903950528425094603
    }
}

running: False
schema_name_id: 2946
start_time: 2024-11-05 05:05:18
success: True
trace_id: 1903950528425094603

Scan 6671589

duration: 0:00:11.687373

exit_message:

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

id: 6671589

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_newbookprojects_statuses/2024-11-04/1730785158",
        "key": "raw/newbookdev_newbookprojects_statuses/2024-11-04/1730785158/projects_statuses.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookprojects_statuses",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6719894264541033409,
        "service_name": "drive-thru",
        "span_id": 5189436717719813559,
        "trace_id": 1487558821630430385
    }
}

running: False
schema_name_id: 2946
start_time: 2024-11-05 04:00:02
success: True
trace_id: 1487558821630430385

Scan 6670896

duration: 0:00:13.976309

exit_message:

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

id: 6670896

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_newbookprojects_statuses/2024-11-04/1730784853",
        "key": "raw/newbookdev_newbookprojects_statuses/2024-11-04/1730784853/projects_statuses.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookprojects_statuses",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15506129665429134704,
        "service_name": "drive-thru",
        "span_id": 5593541228734384207,
        "trace_id": 8655891790182612049
    }
}

running: False
schema_name_id: 2946
start_time: 2024-11-05 03:35:47
success: True
trace_id: 8655891790182612049

Scan 6670057

duration: 0:00:11.615065

exit_message:

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

id: 6670057

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_newbookprojects_statuses/2024-11-04/1730784249",
        "key": "raw/newbookdev_newbookprojects_statuses/2024-11-04/1730784249/projects_statuses.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookprojects_statuses",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16596524317021396627,
        "service_name": "drive-thru",
        "span_id": 11843870477283828147,
        "trace_id": 9154327007149513336
    }
}

running: False
schema_name_id: 2946
start_time: 2024-11-05 03:13:42
success: True
trace_id: 9154327007149513336

Scan 6669463

duration: 0:00:11.528121

exit_message:

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

id: 6669463

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_newbookprojects_statuses/2024-11-04/1730784087",
        "key": "raw/newbookdev_newbookprojects_statuses/2024-11-04/1730784087/projects_statuses.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookprojects_statuses",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6024329365816784846,
        "service_name": "drive-thru",
        "span_id": 17597290653698890907,
        "trace_id": 13195531727136209367
    }
}

running: False
schema_name_id: 2946
start_time: 2024-11-05 02:57:48
success: True
trace_id: 13195531727136209367

Scan 6668948

duration: 0:00:13.787510

exit_message:

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

id: 6668948

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_newbookprojects_statuses/2024-11-04/1730783925",
        "key": "raw/newbookdev_newbookprojects_statuses/2024-11-04/1730783925/projects_statuses.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookprojects_statuses",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6361862052518565559,
        "service_name": "drive-thru",
        "span_id": 14043325443096937672,
        "trace_id": 18288581965823412109
    }
}

running: False
schema_name_id: 2946
start_time: 2024-11-05 02:44:20
success: True
trace_id: 18288581965823412109

Scan 6667459

duration: 0:00:13.943057

exit_message:

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

id: 6667459

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_newbookprojects_statuses/2024-11-04/1730783801",
        "key": "raw/newbookdev_newbookprojects_statuses/2024-11-04/1730783801/projects_statuses.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookprojects_statuses",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17611026814887216432,
        "service_name": "drive-thru",
        "span_id": 12899975161271744552,
        "trace_id": 14740963978358116120
    }
}

running: False
schema_name_id: 2946
start_time: 2024-11-05 02:04:55
success: True
trace_id: 14740963978358116120

Scan 6667318

duration: 0:00:11.461656

exit_message:

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

id: 6667318

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_newbookprojects_statuses/2024-11-04/1730783690",
        "key": "raw/newbookdev_newbookprojects_statuses/2024-11-04/1730783690/projects_statuses.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookprojects_statuses",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 292469777953197865,
        "service_name": "drive-thru",
        "span_id": 4955237512602579728,
        "trace_id": 13910824353275042719
    }
}

running: False
schema_name_id: 2946
start_time: 2024-11-05 02:01:06
success: True
trace_id: 13910824353275042719

Scan 6666636

duration: 0:00:11.458784

exit_message:

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

id: 6666636

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_newbookprojects_statuses/2024-11-04/1730783558",
        "key": "raw/newbookdev_newbookprojects_statuses/2024-11-04/1730783558/projects_statuses.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookprojects_statuses",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2623624695234782390,
        "service_name": "drive-thru",
        "span_id": 18302837228164997625,
        "trace_id": 18311247825231276879
    }
}

running: False
schema_name_id: 2946
start_time: 2024-11-05 01:43:05
success: True
trace_id: 18311247825231276879

Scan 6665872

duration: 0:00:11.504013

exit_message:

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

id: 6665872

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_newbookprojects_statuses/2024-11-04/1730783339",
        "key": "raw/newbookdev_newbookprojects_statuses/2024-11-04/1730783339/projects_statuses.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookprojects_statuses",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17544151249913994289,
        "service_name": "drive-thru",
        "span_id": 16866506448694042852,
        "trace_id": 9162024551510947418
    }
}

running: False
schema_name_id: 2946
start_time: 2024-11-05 01:23:00
success: True
trace_id: 9162024551510947418

Scan 6664918

duration: 0:00:14.007164

exit_message:

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

id: 6664918

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_newbookprojects_statuses/2024-11-04/1730782938",
        "key": "raw/newbookdev_newbookprojects_statuses/2024-11-04/1730782938/projects_statuses.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookprojects_statuses",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14559454886841391494,
        "service_name": "drive-thru",
        "span_id": 2176064579266915819,
        "trace_id": 2725311277211509859
    }
}

running: False
schema_name_id: 2946
start_time: 2024-11-05 00:57:34
success: True
trace_id: 2725311277211509859

Scan 6663837

duration: 0:00:14.089403

exit_message:

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

id: 6663837

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_newbookprojects_statuses/2024-11-04/1730782759",
        "key": "raw/newbookdev_newbookprojects_statuses/2024-11-04/1730782759/projects_statuses.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookprojects_statuses",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11347329020878925516,
        "service_name": "drive-thru",
        "span_id": 3762672285043622417,
        "trace_id": 6815875442299436311
    }
}

running: False
schema_name_id: 2946
start_time: 2024-11-05 00:29:15
success: True
trace_id: 6815875442299436311

Partitions:

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

Schema:

attributes:

{
    "colour": "string",
    "default": "string",
    "display_order": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string"
}

created: 2024-11-05 23:32: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_newbookprojects_statuses`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `colour`  string , `display_order`  string , `type`  string , `default`  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_newbookprojects_statuses/2024-11-05/1730866585'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookprojects_statuses`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookprojects_statuses"
}

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