Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookrelease_notes_groups

created: 2024-10-08 18:13:47
disabled: False
format: raw
id: 2855
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4749431

created: 2024-11-05 23:50:13

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookrelease_notes_groups/2024-11-05/1730866591
id: 4749431
processed: 1

raw_data:

{
    "created_when": 6,
    "id": 2,
    "image_url": 4,
    "name": 3,
    "newbook_region": 0,
    "status": 5,
    "tenant": 1
}

schema_attributes:

{
    "created_when": "string",
    "id": "string",
    "image_url": "string",
    "name": "string",
    "newbook_region": "string",
    "status": "string",
    "tenant": "string"
}

schema_name_id: 2855
schema_scan_id: 6675482
updated: 2024-11-05 23:50:24

Version 4748933

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookrelease_notes_groups/2024-11-05/1730866533
id: 4748933
processed: 1

raw_data:

{
    "created_when": 6,
    "id": 2,
    "image_url": 4,
    "name": 3,
    "newbook_region": 0,
    "status": 5,
    "tenant": 1
}

schema_attributes:

{
    "created_when": "string",
    "id": "string",
    "image_url": "string",
    "name": "string",
    "newbook_region": "string",
    "status": "string",
    "tenant": "string"
}

schema_name_id: 2855
schema_scan_id: 6674965
updated: 2024-11-05 23:09:45

Version 4748437

created: 2024-11-05 22:46:13

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookrelease_notes_groups/2024-11-05/1730866414
id: 4748437
processed: 1

raw_data:

{
    "created_when": 6,
    "id": 2,
    "image_url": 4,
    "name": 3,
    "newbook_region": 0,
    "status": 5,
    "tenant": 1
}

schema_attributes:

{
    "created_when": "string",
    "id": "string",
    "image_url": "string",
    "name": "string",
    "newbook_region": "string",
    "status": "string",
    "tenant": "string"
}

schema_name_id: 2855
schema_scan_id: 6674469
updated: 2024-11-05 22:46:24

Version 4747116

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookrelease_notes_groups/2024-11-04/1730785785
id: 4747116
processed: 1

raw_data:

{
    "created_when": 6,
    "id": 2,
    "image_url": 4,
    "name": 3,
    "newbook_region": 0,
    "status": 5,
    "tenant": 1
}

schema_attributes:

{
    "created_when": "string",
    "id": "string",
    "image_url": "string",
    "name": "string",
    "newbook_region": "string",
    "status": "string",
    "tenant": "string"
}

schema_name_id: 2855
schema_scan_id: 6672348
updated: 2024-11-05 04:52:14

Version 4746614

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookrelease_notes_groups/2024-11-04/1730785160
id: 4746614
processed: 1

raw_data:

{
    "created_when": 6,
    "id": 2,
    "image_url": 4,
    "name": 3,
    "newbook_region": 0,
    "status": 5,
    "tenant": 1
}

schema_attributes:

{
    "created_when": "string",
    "id": "string",
    "image_url": "string",
    "name": "string",
    "newbook_region": "string",
    "status": "string",
    "tenant": "string"
}

schema_name_id: 2855
schema_scan_id: 6671837
updated: 2024-11-05 04:12:42

Version 4745614

created: 2024-11-05 03:34:06

ddl:

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

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

raw_data:

{
    "created_when": 6,
    "id": 2,
    "image_url": 4,
    "name": 3,
    "newbook_region": 0,
    "status": 5,
    "tenant": 1
}

schema_attributes:

{
    "created_when": "string",
    "id": "string",
    "image_url": "string",
    "name": "string",
    "newbook_region": "string",
    "status": "string",
    "tenant": "string"
}

schema_name_id: 2855
schema_scan_id: 6670831
updated: 2024-11-05 03:34:17

Version 4745451

created: 2024-11-05 03:29:46

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookrelease_notes_groups/2024-11-04/1730784252
id: 4745451
processed: 1

raw_data:

{
    "created_when": 6,
    "id": 2,
    "image_url": 4,
    "name": 3,
    "newbook_region": 0,
    "status": 5,
    "tenant": 1
}

schema_attributes:

{
    "created_when": "string",
    "id": "string",
    "image_url": "string",
    "name": "string",
    "newbook_region": "string",
    "status": "string",
    "tenant": "string"
}

schema_name_id: 2855
schema_scan_id: 6670668
updated: 2024-11-05 03:29:57

Version 4744100

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

ddl:

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

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

raw_data:

{
    "created_when": 6,
    "id": 2,
    "image_url": 4,
    "name": 3,
    "newbook_region": 0,
    "status": 5,
    "tenant": 1
}

schema_attributes:

{
    "created_when": "string",
    "id": "string",
    "image_url": "string",
    "name": "string",
    "newbook_region": "string",
    "status": "string",
    "tenant": "string"
}

schema_name_id: 2855
schema_scan_id: 6669317
updated: 2024-11-05 02:54:15

Version 4743171

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookrelease_notes_groups/2024-11-04/1730783853
id: 4743171
processed: 1

raw_data:

{
    "created_when": 6,
    "id": 2,
    "image_url": 4,
    "name": 3,
    "newbook_region": 0,
    "status": 5,
    "tenant": 1
}

schema_attributes:

{
    "created_when": "string",
    "id": "string",
    "image_url": "string",
    "name": "string",
    "newbook_region": "string",
    "status": "string",
    "tenant": "string"
}

schema_name_id: 2855
schema_scan_id: 6668388
updated: 2024-11-05 02:29:41

Version 4742749

created: 2024-11-05 02:18:24

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookrelease_notes_groups/2024-11-04/1730783803
id: 4742749
processed: 1

raw_data:

{
    "created_when": 6,
    "id": 2,
    "image_url": 4,
    "name": 3,
    "newbook_region": 0,
    "status": 5,
    "tenant": 1
}

schema_attributes:

{
    "created_when": "string",
    "id": "string",
    "image_url": "string",
    "name": "string",
    "newbook_region": "string",
    "status": "string",
    "tenant": "string"
}

schema_name_id: 2855
schema_scan_id: 6667966
updated: 2024-11-05 02:18:38

Version 4742155

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookrelease_notes_groups/2024-11-04/1730783692
id: 4742155
processed: 1

raw_data:

{
    "created_when": 6,
    "id": 2,
    "image_url": 4,
    "name": 3,
    "newbook_region": 0,
    "status": 5,
    "tenant": 1
}

schema_attributes:

{
    "created_when": "string",
    "id": "string",
    "image_url": "string",
    "name": "string",
    "newbook_region": "string",
    "status": "string",
    "tenant": "string"
}

schema_name_id: 2855
schema_scan_id: 6667372
updated: 2024-11-05 02:02:48

Version 4740889

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

ddl:

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

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

raw_data:

{
    "created_when": 6,
    "id": 2,
    "image_url": 4,
    "name": 3,
    "newbook_region": 0,
    "status": 5,
    "tenant": 1
}

schema_attributes:

{
    "created_when": "string",
    "id": "string",
    "image_url": "string",
    "name": "string",
    "newbook_region": "string",
    "status": "string",
    "tenant": "string"
}

schema_name_id: 2855
schema_scan_id: 6666106
updated: 2024-11-05 01:29:21

Version 4740633

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookrelease_notes_groups/2024-11-04/1730783342
id: 4740633
processed: 1

raw_data:

{
    "created_when": 6,
    "id": 2,
    "image_url": 4,
    "name": 3,
    "newbook_region": 0,
    "status": 5,
    "tenant": 1
}

schema_attributes:

{
    "created_when": "string",
    "id": "string",
    "image_url": "string",
    "name": "string",
    "newbook_region": "string",
    "status": "string",
    "tenant": "string"
}

schema_name_id: 2855
schema_scan_id: 6665850
updated: 2024-11-05 01:22:41

Version 4739720

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

ddl:

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

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

raw_data:

{
    "created_when": 6,
    "id": 2,
    "image_url": 4,
    "name": 3,
    "newbook_region": 0,
    "status": 5,
    "tenant": 1
}

schema_attributes:

{
    "created_when": "string",
    "id": "string",
    "image_url": "string",
    "name": "string",
    "newbook_region": "string",
    "status": "string",
    "tenant": "string"
}

schema_name_id: 2855
schema_scan_id: 6664937
updated: 2024-11-05 00:58:16

Version 4739138

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookrelease_notes_groups/2024-11-04/1730782832
id: 4739138
processed: 1

raw_data:

{
    "created_when": 6,
    "id": 2,
    "image_url": 4,
    "name": 3,
    "newbook_region": 0,
    "status": 5,
    "tenant": 1
}

schema_attributes:

{
    "created_when": "string",
    "id": "string",
    "image_url": "string",
    "name": "string",
    "newbook_region": "string",
    "status": "string",
    "tenant": "string"
}

schema_name_id: 2855
schema_scan_id: 6664353
updated: 2024-11-05 00:43:03

Schema Scans: 15

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

Scan 6675482

duration: 0:00:11.577688

exit_message:

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

id: 6675482

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_newbookrelease_notes_groups/2024-11-05/1730866591",
        "key": "raw/newbookdev_newbookrelease_notes_groups/2024-11-05/1730866591/release_notes_groups.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookrelease_notes_groups",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7704635810239162145,
        "service_name": "drive-thru",
        "span_id": 165214651562059050,
        "trace_id": 1251919656673092531
    }
}

running: False
schema_name_id: 2855
start_time: 2024-11-05 23:50:13
success: True
trace_id: 1251919656673092531

Scan 6674965

duration: 0:00:14.049009

exit_message:

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

id: 6674965

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_newbookrelease_notes_groups/2024-11-05/1730866533",
        "key": "raw/newbookdev_newbookrelease_notes_groups/2024-11-05/1730866533/release_notes_groups.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookrelease_notes_groups",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9129296388491479089,
        "service_name": "drive-thru",
        "span_id": 18009955926575495624,
        "trace_id": 8434110705653850943
    }
}

running: False
schema_name_id: 2855
start_time: 2024-11-05 23:09:31
success: True
trace_id: 8434110705653850943

Scan 6674469

duration: 0:00:11.532007

exit_message:

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

id: 6674469

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_newbookrelease_notes_groups/2024-11-05/1730866414",
        "key": "raw/newbookdev_newbookrelease_notes_groups/2024-11-05/1730866414/release_notes_groups.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookrelease_notes_groups",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8151782719496327084,
        "service_name": "drive-thru",
        "span_id": 6006173837945773155,
        "trace_id": 6926356568933997873
    }
}

running: False
schema_name_id: 2855
start_time: 2024-11-05 22:46:13
success: True
trace_id: 6926356568933997873

Scan 6672348

duration: 0:00:11.501518

exit_message:

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

id: 6672348

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_newbookrelease_notes_groups/2024-11-04/1730785785",
        "key": "raw/newbookdev_newbookrelease_notes_groups/2024-11-04/1730785785/release_notes_groups.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookrelease_notes_groups",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13322003947339526481,
        "service_name": "drive-thru",
        "span_id": 15109192340792847940,
        "trace_id": 8559366673326950216
    }
}

running: False
schema_name_id: 2855
start_time: 2024-11-05 04:52:03
success: True
trace_id: 8559366673326950216

Scan 6671837

duration: 0:00:11.625914

exit_message:

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

id: 6671837

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_newbookrelease_notes_groups/2024-11-04/1730785160",
        "key": "raw/newbookdev_newbookrelease_notes_groups/2024-11-04/1730785160/release_notes_groups.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookrelease_notes_groups",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13489185388472118005,
        "service_name": "drive-thru",
        "span_id": 14481002337688867394,
        "trace_id": 9968223765452748081
    }
}

running: False
schema_name_id: 2855
start_time: 2024-11-05 04:12:31
success: True
trace_id: 9968223765452748081

Scan 6670831

duration: 0:00:11.393887

exit_message:

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

id: 6670831

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_newbookrelease_notes_groups/2024-11-04/1730784855",
        "key": "raw/newbookdev_newbookrelease_notes_groups/2024-11-04/1730784855/release_notes_groups.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookrelease_notes_groups",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8496214492822913506,
        "service_name": "drive-thru",
        "span_id": 15244925402135107682,
        "trace_id": 6341744260240250791
    }
}

running: False
schema_name_id: 2855
start_time: 2024-11-05 03:34:05
success: True
trace_id: 6341744260240250791

Scan 6670668

duration: 0:00:11.380606

exit_message:

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

id: 6670668

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_newbookrelease_notes_groups/2024-11-04/1730784252",
        "key": "raw/newbookdev_newbookrelease_notes_groups/2024-11-04/1730784252/release_notes_groups.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookrelease_notes_groups",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9338011800776302376,
        "service_name": "drive-thru",
        "span_id": 16713792196482499384,
        "trace_id": 11518804848499082568
    }
}

running: False
schema_name_id: 2855
start_time: 2024-11-05 03:29:45
success: True
trace_id: 11518804848499082568

Scan 6669317

duration: 0:00:13.939205

exit_message:

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

id: 6669317

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_newbookrelease_notes_groups/2024-11-04/1730784089",
        "key": "raw/newbookdev_newbookrelease_notes_groups/2024-11-04/1730784089/release_notes_groups.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookrelease_notes_groups",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17025342439134715087,
        "service_name": "drive-thru",
        "span_id": 14561995256982543827,
        "trace_id": 1018634986928100583
    }
}

running: False
schema_name_id: 2855
start_time: 2024-11-05 02:54:01
success: True
trace_id: 1018634986928100583

Scan 6668388

duration: 0:00:11.391759

exit_message:

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

id: 6668388

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_newbookrelease_notes_groups/2024-11-04/1730783853",
        "key": "raw/newbookdev_newbookrelease_notes_groups/2024-11-04/1730783853/release_notes_groups.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookrelease_notes_groups",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16473324802366393871,
        "service_name": "drive-thru",
        "span_id": 15607528498672167776,
        "trace_id": 10711840979733700972
    }
}

running: False
schema_name_id: 2855
start_time: 2024-11-05 02:29:29
success: True
trace_id: 10711840979733700972

Scan 6667966

duration: 0:00:14.082750

exit_message:

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

id: 6667966

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_newbookrelease_notes_groups/2024-11-04/1730783803",
        "key": "raw/newbookdev_newbookrelease_notes_groups/2024-11-04/1730783803/release_notes_groups.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookrelease_notes_groups",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11815770936480946824,
        "service_name": "drive-thru",
        "span_id": 4137230621466455208,
        "trace_id": 11833728760142762896
    }
}

running: False
schema_name_id: 2855
start_time: 2024-11-05 02:18:24
success: True
trace_id: 11833728760142762896

Scan 6667372

duration: 0:00:13.931209

exit_message:

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

id: 6667372

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_newbookrelease_notes_groups/2024-11-04/1730783692",
        "key": "raw/newbookdev_newbookrelease_notes_groups/2024-11-04/1730783692/release_notes_groups.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookrelease_notes_groups",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4989233697150485288,
        "service_name": "drive-thru",
        "span_id": 13665250827582121348,
        "trace_id": 4226341026470236636
    }
}

running: False
schema_name_id: 2855
start_time: 2024-11-05 02:02:34
success: True
trace_id: 4226341026470236636

Scan 6666106

duration: 0:00:11.419758

exit_message:

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

id: 6666106

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_newbookrelease_notes_groups/2024-11-04/1730783560",
        "key": "raw/newbookdev_newbookrelease_notes_groups/2024-11-04/1730783560/release_notes_groups.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookrelease_notes_groups",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2198008699699614234,
        "service_name": "drive-thru",
        "span_id": 4343921260490408051,
        "trace_id": 14598302381596593778
    }
}

running: False
schema_name_id: 2855
start_time: 2024-11-05 01:29:10
success: True
trace_id: 14598302381596593778

Scan 6665850

duration: 0:00:11.474009

exit_message:

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

id: 6665850

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_newbookrelease_notes_groups/2024-11-04/1730783342",
        "key": "raw/newbookdev_newbookrelease_notes_groups/2024-11-04/1730783342/release_notes_groups.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookrelease_notes_groups",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17299915039633766783,
        "service_name": "drive-thru",
        "span_id": 8264279383166901021,
        "trace_id": 8055381668967255589
    }
}

running: False
schema_name_id: 2855
start_time: 2024-11-05 01:22:29
success: True
trace_id: 8055381668967255589

Scan 6664937

duration: 0:00:13.908869

exit_message:

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

id: 6664937

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_newbookrelease_notes_groups/2024-11-04/1730782940",
        "key": "raw/newbookdev_newbookrelease_notes_groups/2024-11-04/1730782940/release_notes_groups.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookrelease_notes_groups",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9722864309289839274,
        "service_name": "drive-thru",
        "span_id": 7926485882182764245,
        "trace_id": 6094586480381962437
    }
}

running: False
schema_name_id: 2855
start_time: 2024-11-05 00:58:02
success: True
trace_id: 6094586480381962437

Scan 6664353

duration: 0:00:14.102515

exit_message:

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

id: 6664353

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_newbookrelease_notes_groups/2024-11-04/1730782832",
        "key": "raw/newbookdev_newbookrelease_notes_groups/2024-11-04/1730782832/release_notes_groups.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookrelease_notes_groups",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10198018022901639758,
        "service_name": "drive-thru",
        "span_id": 15186675833208107864,
        "trace_id": 10266820080047926463
    }
}

running: False
schema_name_id: 2855
start_time: 2024-11-05 00:42:49
success: True
trace_id: 10266820080047926463

Partitions:

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

Schema:

attributes:

{
    "created_when": "string",
    "id": "string",
    "image_url": "string",
    "name": "string",
    "newbook_region": "string",
    "status": "string",
    "tenant": "string"
}

created: 2024-11-05 23:50:13

ddl:

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

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