Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookstaff_induction

created: 2024-10-08 18:30:40
disabled: False
format: raw
id: 3014
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4749396

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookstaff_induction/2024-11-05/1730866603
id: 4749396
processed: 1

raw_data:

{
    "active": 6,
    "department_id": 4,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1,
    "test_id": 5
}

schema_attributes:

{
    "active": "string",
    "department_id": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string",
    "test_id": "string"
}

schema_name_id: 3014
schema_scan_id: 6675434
updated: 2024-11-05 23:46:24

Version 4749162

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookstaff_induction/2024-11-05/1730866549
id: 4749162
processed: 1

raw_data:

{
    "active": 6,
    "department_id": 4,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1,
    "test_id": 5
}

schema_attributes:

{
    "active": "string",
    "department_id": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string",
    "test_id": "string"
}

schema_name_id: 3014
schema_scan_id: 6675194
updated: 2024-11-05 23:24:49

Version 4748426

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookstaff_induction/2024-11-05/1730866439
id: 4748426
processed: 1

raw_data:

{
    "active": 6,
    "department_id": 4,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1,
    "test_id": 5
}

schema_attributes:

{
    "active": "string",
    "department_id": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string",
    "test_id": "string"
}

schema_name_id: 3014
schema_scan_id: 6674458
updated: 2024-11-05 22:46:01

Version 4747073

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookstaff_induction/2024-11-04/1730785797
id: 4747073
processed: 1

raw_data:

{
    "active": 6,
    "department_id": 4,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1,
    "test_id": 5
}

schema_attributes:

{
    "active": "string",
    "department_id": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string",
    "test_id": "string"
}

schema_name_id: 3014
schema_scan_id: 6672305
updated: 2024-11-05 04:47:37

Version 4745742

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookstaff_induction/2024-11-04/1730785167
id: 4745742
processed: 1

raw_data:

{
    "active": 6,
    "department_id": 4,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1,
    "test_id": 5
}

schema_attributes:

{
    "active": "string",
    "department_id": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string",
    "test_id": "string"
}

schema_name_id: 3014
schema_scan_id: 6670959
updated: 2024-11-05 03:37:49

Version 4745675

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookstaff_induction/2024-11-04/1730784862
id: 4745675
processed: 1

raw_data:

{
    "active": 6,
    "department_id": 4,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1,
    "test_id": 5
}

schema_attributes:

{
    "active": "string",
    "department_id": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string",
    "test_id": "string"
}

schema_name_id: 3014
schema_scan_id: 6670892
updated: 2024-11-05 03:35:54

Version 4744873

created: 2024-11-05 03:14:39

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookstaff_induction/2024-11-04/1730784258
id: 4744873
processed: 1

raw_data:

{
    "active": 6,
    "department_id": 4,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1,
    "test_id": 5
}

schema_attributes:

{
    "active": "string",
    "department_id": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string",
    "test_id": "string"
}

schema_name_id: 3014
schema_scan_id: 6670090
updated: 2024-11-05 03:14:50

Version 4744317

created: 2024-11-05 02:59:42

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookstaff_induction/2024-11-04/1730784096
id: 4744317
processed: 1

raw_data:

{
    "active": 6,
    "department_id": 4,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1,
    "test_id": 5
}

schema_attributes:

{
    "active": "string",
    "department_id": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string",
    "test_id": "string"
}

schema_name_id: 3014
schema_scan_id: 6669534
updated: 2024-11-05 02:59:53

Version 4743085

created: 2024-11-05 02:27:16

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookstaff_induction/2024-11-04/1730783854
id: 4743085
processed: 1

raw_data:

{
    "active": 6,
    "department_id": 4,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1,
    "test_id": 5
}

schema_attributes:

{
    "active": "string",
    "department_id": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string",
    "test_id": "string"
}

schema_name_id: 3014
schema_scan_id: 6668302
updated: 2024-11-05 02:27:27

Version 4742293

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookstaff_induction/2024-11-04/1730783810
id: 4742293
processed: 1

raw_data:

{
    "active": 6,
    "department_id": 4,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1,
    "test_id": 5
}

schema_attributes:

{
    "active": "string",
    "department_id": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string",
    "test_id": "string"
}

schema_name_id: 3014
schema_scan_id: 6667510
updated: 2024-11-05 02:06:34

Version 4742171

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookstaff_induction/2024-11-04/1730783697
id: 4742171
processed: 1

raw_data:

{
    "active": 6,
    "department_id": 4,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1,
    "test_id": 5
}

schema_attributes:

{
    "active": "string",
    "department_id": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string",
    "test_id": "string"
}

schema_name_id: 3014
schema_scan_id: 6667388
updated: 2024-11-05 02:03:14

Version 4741429

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookstaff_induction/2024-11-04/1730783567
id: 4741429
processed: 1

raw_data:

{
    "active": 6,
    "department_id": 4,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1,
    "test_id": 5
}

schema_attributes:

{
    "active": "string",
    "department_id": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string",
    "test_id": "string"
}

schema_name_id: 3014
schema_scan_id: 6666646
updated: 2024-11-05 01:43:34

Version 4740599

created: 2024-11-05 01:21:31

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookstaff_induction/2024-11-04/1730783349
id: 4740599
processed: 1

raw_data:

{
    "active": 6,
    "department_id": 4,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1,
    "test_id": 5
}

schema_attributes:

{
    "active": "string",
    "department_id": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string",
    "test_id": "string"
}

schema_name_id: 3014
schema_scan_id: 6665816
updated: 2024-11-05 01:21:42

Version 4739868

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookstaff_induction/2024-11-04/1730782947
id: 4739868
processed: 1

raw_data:

{
    "active": 6,
    "department_id": 4,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1,
    "test_id": 5
}

schema_attributes:

{
    "active": "string",
    "department_id": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string",
    "test_id": "string"
}

schema_name_id: 3014
schema_scan_id: 6665085
updated: 2024-11-05 01:02:14

Version 4739149

created: 2024-11-05 00:43:05

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookstaff_induction/2024-11-04/1730782837
id: 4739149
processed: 1

raw_data:

{
    "active": 6,
    "department_id": 4,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1,
    "test_id": 5
}

schema_attributes:

{
    "active": "string",
    "department_id": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string",
    "test_id": "string"
}

schema_name_id: 3014
schema_scan_id: 6664364
updated: 2024-11-05 00:43:16

Schema Scans: 15

Last at 2024-11-05 23:46:12

Scan 6675434

duration: 0:00:11.543062

exit_message:

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

id: 6675434

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_newbookstaff_induction/2024-11-05/1730866603",
        "key": "raw/newbookdev_newbookstaff_induction/2024-11-05/1730866603/staff_induction.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookstaff_induction",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10871605060768194199,
        "service_name": "drive-thru",
        "span_id": 2438123746582222134,
        "trace_id": 17453284011074121769
    }
}

running: False
schema_name_id: 3014
start_time: 2024-11-05 23:46:12
success: True
trace_id: 17453284011074121769

Scan 6675194

duration: 0:00:11.568692

exit_message:

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

id: 6675194

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_newbookstaff_induction/2024-11-05/1730866549",
        "key": "raw/newbookdev_newbookstaff_induction/2024-11-05/1730866549/staff_induction.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookstaff_induction",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15509369895274372258,
        "service_name": "drive-thru",
        "span_id": 7413345428495086103,
        "trace_id": 15653266326062915400
    }
}

running: False
schema_name_id: 3014
start_time: 2024-11-05 23:24:37
success: True
trace_id: 15653266326062915400

Scan 6674458

duration: 0:00:11.551380

exit_message:

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

id: 6674458

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_newbookstaff_induction/2024-11-05/1730866439",
        "key": "raw/newbookdev_newbookstaff_induction/2024-11-05/1730866439/staff_induction.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookstaff_induction",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11523828456533241140,
        "service_name": "drive-thru",
        "span_id": 14153325552903289016,
        "trace_id": 18308691658062062131
    }
}

running: False
schema_name_id: 3014
start_time: 2024-11-05 22:45:49
success: True
trace_id: 18308691658062062131

Scan 6672305

duration: 0:00:14.040608

exit_message:

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

id: 6672305

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_newbookstaff_induction/2024-11-04/1730785797",
        "key": "raw/newbookdev_newbookstaff_induction/2024-11-04/1730785797/staff_induction.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookstaff_induction",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16114782558153097602,
        "service_name": "drive-thru",
        "span_id": 2076068229729178351,
        "trace_id": 7053964078848500487
    }
}

running: False
schema_name_id: 3014
start_time: 2024-11-05 04:47:23
success: True
trace_id: 7053964078848500487

Scan 6670959

duration: 0:00:14.113148

exit_message:

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

id: 6670959

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_newbookstaff_induction/2024-11-04/1730785167",
        "key": "raw/newbookdev_newbookstaff_induction/2024-11-04/1730785167/staff_induction.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookstaff_induction",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12165971166041255763,
        "service_name": "drive-thru",
        "span_id": 6695480339835830956,
        "trace_id": 5310795776169988227
    }
}

running: False
schema_name_id: 3014
start_time: 2024-11-05 03:37:35
success: True
trace_id: 5310795776169988227

Scan 6670892

duration: 0:00:11.457634

exit_message:

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

id: 6670892

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_newbookstaff_induction/2024-11-04/1730784862",
        "key": "raw/newbookdev_newbookstaff_induction/2024-11-04/1730784862/staff_induction.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookstaff_induction",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16034129824946770447,
        "service_name": "drive-thru",
        "span_id": 12593106628217927506,
        "trace_id": 5872960217898739233
    }
}

running: False
schema_name_id: 3014
start_time: 2024-11-05 03:35:43
success: True
trace_id: 5872960217898739233

Scan 6670090

duration: 0:00:11.484018

exit_message:

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

id: 6670090

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_newbookstaff_induction/2024-11-04/1730784258",
        "key": "raw/newbookdev_newbookstaff_induction/2024-11-04/1730784258/staff_induction.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookstaff_induction",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10700612522774106277,
        "service_name": "drive-thru",
        "span_id": 12476504595791292535,
        "trace_id": 2069983127153181756
    }
}

running: False
schema_name_id: 3014
start_time: 2024-11-05 03:14:39
success: True
trace_id: 2069983127153181756

Scan 6669534

duration: 0:00:11.337351

exit_message:

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

id: 6669534

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_newbookstaff_induction/2024-11-04/1730784096",
        "key": "raw/newbookdev_newbookstaff_induction/2024-11-04/1730784096/staff_induction.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookstaff_induction",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15418640249058935707,
        "service_name": "drive-thru",
        "span_id": 3056064543128208805,
        "trace_id": 4133560108422617500
    }
}

running: False
schema_name_id: 3014
start_time: 2024-11-05 02:59:42
success: True
trace_id: 4133560108422617500

Scan 6668302

duration: 0:00:11.703355

exit_message:

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

id: 6668302

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_newbookstaff_induction/2024-11-04/1730783854",
        "key": "raw/newbookdev_newbookstaff_induction/2024-11-04/1730783854/staff_induction.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookstaff_induction",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3494591630356788002,
        "service_name": "drive-thru",
        "span_id": 6276670293031483042,
        "trace_id": 5088279188698345250
    }
}

running: False
schema_name_id: 3014
start_time: 2024-11-05 02:27:15
success: True
trace_id: 5088279188698345250

Scan 6667510

duration: 0:00:13.801912

exit_message:

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

id: 6667510

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_newbookstaff_induction/2024-11-04/1730783810",
        "key": "raw/newbookdev_newbookstaff_induction/2024-11-04/1730783810/staff_induction.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookstaff_induction",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16357454069010165298,
        "service_name": "drive-thru",
        "span_id": 14846258659171611107,
        "trace_id": 10998314896494233495
    }
}

running: False
schema_name_id: 3014
start_time: 2024-11-05 02:06:20
success: True
trace_id: 10998314896494233495

Scan 6667388

duration: 0:00:14.254781

exit_message:

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

id: 6667388

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_newbookstaff_induction/2024-11-04/1730783697",
        "key": "raw/newbookdev_newbookstaff_induction/2024-11-04/1730783697/staff_induction.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookstaff_induction",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4625076389730268192,
        "service_name": "drive-thru",
        "span_id": 16975890537204904509,
        "trace_id": 10764955201013589553
    }
}

running: False
schema_name_id: 3014
start_time: 2024-11-05 02:02:59
success: True
trace_id: 10764955201013589553

Scan 6666646

duration: 0:00:13.876046

exit_message:

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

id: 6666646

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_newbookstaff_induction/2024-11-04/1730783567",
        "key": "raw/newbookdev_newbookstaff_induction/2024-11-04/1730783567/staff_induction.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookstaff_induction",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9530784000665275109,
        "service_name": "drive-thru",
        "span_id": 1801868036403721335,
        "trace_id": 7245906520559692725
    }
}

running: False
schema_name_id: 3014
start_time: 2024-11-05 01:43:20
success: True
trace_id: 7245906520559692725

Scan 6665816

duration: 0:00:11.381848

exit_message:

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

id: 6665816

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_newbookstaff_induction/2024-11-04/1730783349",
        "key": "raw/newbookdev_newbookstaff_induction/2024-11-04/1730783349/staff_induction.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookstaff_induction",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15773500254302146610,
        "service_name": "drive-thru",
        "span_id": 2916726497287488263,
        "trace_id": 8608015805466937671
    }
}

running: False
schema_name_id: 3014
start_time: 2024-11-05 01:21:30
success: True
trace_id: 8608015805466937671

Scan 6665085

duration: 0:00:11.514315

exit_message:

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

id: 6665085

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_newbookstaff_induction/2024-11-04/1730782947",
        "key": "raw/newbookdev_newbookstaff_induction/2024-11-04/1730782947/staff_induction.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookstaff_induction",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14295756170569457405,
        "service_name": "drive-thru",
        "span_id": 13712969004899404742,
        "trace_id": 16560959601219615731
    }
}

running: False
schema_name_id: 3014
start_time: 2024-11-05 01:02:03
success: True
trace_id: 16560959601219615731

Scan 6664364

duration: 0:00:11.411803

exit_message:

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

id: 6664364

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_newbookstaff_induction/2024-11-04/1730782837",
        "key": "raw/newbookdev_newbookstaff_induction/2024-11-04/1730782837/staff_induction.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookstaff_induction",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6228254818604627058,
        "service_name": "drive-thru",
        "span_id": 11106121016674727792,
        "trace_id": 13023608319561584043
    }
}

running: False
schema_name_id: 3014
start_time: 2024-11-05 00:43:05
success: True
trace_id: 13023608319561584043

Partitions:

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

Schema:

attributes:

{
    "active": "string",
    "department_id": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string",
    "test_id": "string"
}

created: 2024-11-05 23:46: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_newbookstaff_induction`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `department_id`  string , `test_id`  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_newbookstaff_induction/2024-11-05/1730866603'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookstaff_induction`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookstaff_induction"
}

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