Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbooklocations_temp

created: 2024-10-08 18:11:27
disabled: False
format: raw
id: 2834
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4748980

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklocations_temp/2024-11-05/1730866545
id: 4748980
processed: 1

raw_data:

{
    "area_code": 5,
    "id": 2,
    "locality": 3,
    "newbook_region": 0,
    "state_id": 4,
    "tenant": 1,
    "timezone": 6
}

schema_attributes:

{
    "area_code": "string",
    "id": "string",
    "locality": "string",
    "newbook_region": "string",
    "state_id": "string",
    "tenant": "string",
    "timezone": "string"
}

schema_name_id: 2834
schema_scan_id: 6675012
updated: 2024-11-05 23:12:19

Version 4748812

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklocations_temp/2024-11-05/1730866485
id: 4748812
processed: 1

raw_data:

{
    "area_code": 5,
    "id": 2,
    "locality": 3,
    "newbook_region": 0,
    "state_id": 4,
    "tenant": 1,
    "timezone": 6
}

schema_attributes:

{
    "area_code": "string",
    "id": "string",
    "locality": "string",
    "newbook_region": "string",
    "state_id": "string",
    "tenant": "string",
    "timezone": "string"
}

schema_name_id: 2834
schema_scan_id: 6674844
updated: 2024-11-05 23:03:04

Version 4747861

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklocations_temp/2024-11-05/1730866351
id: 4747861
processed: 1

raw_data:

{
    "area_code": 5,
    "id": 2,
    "locality": 3,
    "newbook_region": 0,
    "state_id": 4,
    "tenant": 1,
    "timezone": 6
}

schema_attributes:

{
    "area_code": "string",
    "id": "string",
    "locality": "string",
    "newbook_region": "string",
    "state_id": "string",
    "tenant": "string",
    "timezone": "string"
}

schema_name_id: 2834
schema_scan_id: 6673893
updated: 2024-11-05 22:28:07

Version 4747185

created: 2024-11-05 04:59:26

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklocations_temp/2024-11-04/1730785751
id: 4747185
processed: 1

raw_data:

{
    "area_code": 5,
    "id": 2,
    "locality": 3,
    "newbook_region": 0,
    "state_id": 4,
    "tenant": 1,
    "timezone": 6
}

schema_attributes:

{
    "area_code": "string",
    "id": "string",
    "locality": "string",
    "newbook_region": "string",
    "state_id": "string",
    "tenant": "string",
    "timezone": "string"
}

schema_name_id: 2834
schema_scan_id: 6672417
updated: 2024-11-05 04:59:36

Version 4746246

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklocations_temp/2024-11-04/1730785141
id: 4746246
processed: 1

raw_data:

{
    "area_code": 5,
    "id": 2,
    "locality": 3,
    "newbook_region": 0,
    "state_id": 4,
    "tenant": 1,
    "timezone": 6
}

schema_attributes:

{
    "area_code": "string",
    "id": "string",
    "locality": "string",
    "newbook_region": "string",
    "state_id": "string",
    "tenant": "string",
    "timezone": "string"
}

schema_name_id: 2834
schema_scan_id: 6671467
updated: 2024-11-05 03:54:57

Version 4745542

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklocations_temp/2024-11-04/1730784836
id: 4745542
processed: 1

raw_data:

{
    "area_code": 5,
    "id": 2,
    "locality": 3,
    "newbook_region": 0,
    "state_id": 4,
    "tenant": 1,
    "timezone": 6
}

schema_attributes:

{
    "area_code": "string",
    "id": "string",
    "locality": "string",
    "newbook_region": "string",
    "state_id": "string",
    "tenant": "string",
    "timezone": "string"
}

schema_name_id: 2834
schema_scan_id: 6670759
updated: 2024-11-05 03:32:24

Version 4744699

created: 2024-11-05 03:10:05

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklocations_temp/2024-11-04/1730784232
id: 4744699
processed: 1

raw_data:

{
    "area_code": 5,
    "id": 2,
    "locality": 3,
    "newbook_region": 0,
    "state_id": 4,
    "tenant": 1,
    "timezone": 6
}

schema_attributes:

{
    "area_code": "string",
    "id": "string",
    "locality": "string",
    "newbook_region": "string",
    "state_id": "string",
    "tenant": "string",
    "timezone": "string"
}

schema_name_id: 2834
schema_scan_id: 6669916
updated: 2024-11-05 03:10:18

Version 4744468

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklocations_temp/2024-11-04/1730784070
id: 4744468
processed: 1

raw_data:

{
    "area_code": 5,
    "id": 2,
    "locality": 3,
    "newbook_region": 0,
    "state_id": 4,
    "tenant": 1,
    "timezone": 6
}

schema_attributes:

{
    "area_code": "string",
    "id": "string",
    "locality": "string",
    "newbook_region": "string",
    "state_id": "string",
    "tenant": "string",
    "timezone": "string"
}

schema_name_id: 2834
schema_scan_id: 6669685
updated: 2024-11-05 03:04:01

Version 4742763

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklocations_temp/2024-11-04/1730783912
id: 4742763
processed: 1

raw_data:

{
    "area_code": 5,
    "id": 2,
    "locality": 3,
    "newbook_region": 0,
    "state_id": 4,
    "tenant": 1,
    "timezone": 6
}

schema_attributes:

{
    "area_code": "string",
    "id": "string",
    "locality": "string",
    "newbook_region": "string",
    "state_id": "string",
    "tenant": "string",
    "timezone": "string"
}

schema_name_id: 2834
schema_scan_id: 6667980
updated: 2024-11-05 02:19:01

Version 4742651

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklocations_temp/2024-11-04/1730783784
id: 4742651
processed: 1

raw_data:

{
    "area_code": 5,
    "id": 2,
    "locality": 3,
    "newbook_region": 0,
    "state_id": 4,
    "tenant": 1,
    "timezone": 6
}

schema_attributes:

{
    "area_code": "string",
    "id": "string",
    "locality": "string",
    "newbook_region": "string",
    "state_id": "string",
    "tenant": "string",
    "timezone": "string"
}

schema_name_id: 2834
schema_scan_id: 6667868
updated: 2024-11-05 02:16:01

Version 4742118

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklocations_temp/2024-11-04/1730783677
id: 4742118
processed: 1

raw_data:

{
    "area_code": 5,
    "id": 2,
    "locality": 3,
    "newbook_region": 0,
    "state_id": 4,
    "tenant": 1,
    "timezone": 6
}

schema_attributes:

{
    "area_code": "string",
    "id": "string",
    "locality": "string",
    "newbook_region": "string",
    "state_id": "string",
    "tenant": "string",
    "timezone": "string"
}

schema_name_id: 2834
schema_scan_id: 6667335
updated: 2024-11-05 02:01:45

Version 4741234

created: 2024-11-05 01:38:18

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklocations_temp/2024-11-04/1730783540
id: 4741234
processed: 1

raw_data:

{
    "area_code": 5,
    "id": 2,
    "locality": 3,
    "newbook_region": 0,
    "state_id": 4,
    "tenant": 1,
    "timezone": 6
}

schema_attributes:

{
    "area_code": "string",
    "id": "string",
    "locality": "string",
    "newbook_region": "string",
    "state_id": "string",
    "tenant": "string",
    "timezone": "string"
}

schema_name_id: 2834
schema_scan_id: 6666451
updated: 2024-11-05 01:38:32

Version 4740484

created: 2024-11-05 01:18:33

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklocations_temp/2024-11-04/1730783322
id: 4740484
processed: 1

raw_data:

{
    "area_code": 5,
    "id": 2,
    "locality": 3,
    "newbook_region": 0,
    "state_id": 4,
    "tenant": 1,
    "timezone": 6
}

schema_attributes:

{
    "area_code": "string",
    "id": "string",
    "locality": "string",
    "newbook_region": "string",
    "state_id": "string",
    "tenant": "string",
    "timezone": "string"
}

schema_name_id: 2834
schema_scan_id: 6665701
updated: 2024-11-05 01:18:44

Version 4739687

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklocations_temp/2024-11-04/1730782922
id: 4739687
processed: 1

raw_data:

{
    "area_code": 5,
    "id": 2,
    "locality": 3,
    "newbook_region": 0,
    "state_id": 4,
    "tenant": 1,
    "timezone": 6
}

schema_attributes:

{
    "area_code": "string",
    "id": "string",
    "locality": "string",
    "newbook_region": "string",
    "state_id": "string",
    "tenant": "string",
    "timezone": "string"
}

schema_name_id: 2834
schema_scan_id: 6664904
updated: 2024-11-05 00:57:22

Version 4738396

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklocations_temp/2024-11-04/1730782755
id: 4738396
processed: 1

raw_data:

{
    "area_code": 5,
    "id": 2,
    "locality": 3,
    "newbook_region": 0,
    "state_id": 4,
    "tenant": 1,
    "timezone": 6
}

schema_attributes:

{
    "area_code": "string",
    "id": "string",
    "locality": "string",
    "newbook_region": "string",
    "state_id": "string",
    "tenant": "string",
    "timezone": "string"
}

schema_name_id: 2834
schema_scan_id: 6663607
updated: 2024-11-05 00:23:35

Schema Scans: 15

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

Scan 6675012

duration: 0:00:11.620176

exit_message:

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

id: 6675012

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_newbooklocations_temp/2024-11-05/1730866545",
        "key": "raw/newbookdev_newbooklocations_temp/2024-11-05/1730866545/locations_temp.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklocations_temp",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12723787385512775736,
        "service_name": "drive-thru",
        "span_id": 6031268664667727646,
        "trace_id": 11879581199093478695
    }
}

running: False
schema_name_id: 2834
start_time: 2024-11-05 23:12:07
success: True
trace_id: 11879581199093478695

Scan 6674844

duration: 0:00:14.210012

exit_message:

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

id: 6674844

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_newbooklocations_temp/2024-11-05/1730866485",
        "key": "raw/newbookdev_newbooklocations_temp/2024-11-05/1730866485/locations_temp.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklocations_temp",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16179311259217803427,
        "service_name": "drive-thru",
        "span_id": 17875160244150078299,
        "trace_id": 10116860447795017101
    }
}

running: False
schema_name_id: 2834
start_time: 2024-11-05 23:02:49
success: True
trace_id: 10116860447795017101

Scan 6673893

duration: 0:00:11.468097

exit_message:

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

id: 6673893

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_newbooklocations_temp/2024-11-05/1730866351",
        "key": "raw/newbookdev_newbooklocations_temp/2024-11-05/1730866351/locations_temp.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklocations_temp",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11160826403043404364,
        "service_name": "drive-thru",
        "span_id": 8703907551505228044,
        "trace_id": 6749390711019293350
    }
}

running: False
schema_name_id: 2834
start_time: 2024-11-05 22:27:55
success: True
trace_id: 6749390711019293350

Scan 6672417

duration: 0:00:11.475643

exit_message:

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

id: 6672417

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_newbooklocations_temp/2024-11-04/1730785751",
        "key": "raw/newbookdev_newbooklocations_temp/2024-11-04/1730785751/locations_temp.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklocations_temp",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11318873211811834100,
        "service_name": "drive-thru",
        "span_id": 4746006955988595445,
        "trace_id": 2116910561333426308
    }
}

running: False
schema_name_id: 2834
start_time: 2024-11-05 04:59:25
success: True
trace_id: 2116910561333426308

Scan 6671467

duration: 0:00:11.638517

exit_message:

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

id: 6671467

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_newbooklocations_temp/2024-11-04/1730785141",
        "key": "raw/newbookdev_newbooklocations_temp/2024-11-04/1730785141/locations_temp.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklocations_temp",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 427392147288289991,
        "service_name": "drive-thru",
        "span_id": 11148552710742635059,
        "trace_id": 12676804658988509964
    }
}

running: False
schema_name_id: 2834
start_time: 2024-11-05 03:54:46
success: True
trace_id: 12676804658988509964

Scan 6670759

duration: 0:00:11.432392

exit_message:

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

id: 6670759

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_newbooklocations_temp/2024-11-04/1730784836",
        "key": "raw/newbookdev_newbooklocations_temp/2024-11-04/1730784836/locations_temp.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklocations_temp",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9875905727042234741,
        "service_name": "drive-thru",
        "span_id": 4747088704652419912,
        "trace_id": 17815070429213971419
    }
}

running: False
schema_name_id: 2834
start_time: 2024-11-05 03:32:13
success: True
trace_id: 17815070429213971419

Scan 6669916

duration: 0:00:14.060661

exit_message:

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

id: 6669916

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_newbooklocations_temp/2024-11-04/1730784232",
        "key": "raw/newbookdev_newbooklocations_temp/2024-11-04/1730784232/locations_temp.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklocations_temp",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7026808852823759493,
        "service_name": "drive-thru",
        "span_id": 3160309246229085242,
        "trace_id": 17555866256683956002
    }
}

running: False
schema_name_id: 2834
start_time: 2024-11-05 03:10:04
success: True
trace_id: 17555866256683956002

Scan 6669685

duration: 0:00:11.436394

exit_message:

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

id: 6669685

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_newbooklocations_temp/2024-11-04/1730784070",
        "key": "raw/newbookdev_newbooklocations_temp/2024-11-04/1730784070/locations_temp.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklocations_temp",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15885227398099871708,
        "service_name": "drive-thru",
        "span_id": 5340549206141761815,
        "trace_id": 12096392088578782658
    }
}

running: False
schema_name_id: 2834
start_time: 2024-11-05 03:03:49
success: True
trace_id: 12096392088578782658

Scan 6667980

duration: 0:00:14.098939

exit_message:

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

id: 6667980

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_newbooklocations_temp/2024-11-04/1730783912",
        "key": "raw/newbookdev_newbooklocations_temp/2024-11-04/1730783912/locations_temp.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklocations_temp",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13173121145700747358,
        "service_name": "drive-thru",
        "span_id": 16521727134307038175,
        "trace_id": 3303229296959622750
    }
}

running: False
schema_name_id: 2834
start_time: 2024-11-05 02:18:47
success: True
trace_id: 3303229296959622750

Scan 6667868

duration: 0:00:11.350556

exit_message:

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

id: 6667868

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_newbooklocations_temp/2024-11-04/1730783784",
        "key": "raw/newbookdev_newbooklocations_temp/2024-11-04/1730783784/locations_temp.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklocations_temp",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9631613205400947533,
        "service_name": "drive-thru",
        "span_id": 10267096614046300945,
        "trace_id": 549022337466183176
    }
}

running: False
schema_name_id: 2834
start_time: 2024-11-05 02:15:49
success: True
trace_id: 549022337466183176

Scan 6667335

duration: 0:00:11.898767

exit_message:

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

id: 6667335

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_newbooklocations_temp/2024-11-04/1730783677",
        "key": "raw/newbookdev_newbooklocations_temp/2024-11-04/1730783677/locations_temp.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklocations_temp",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3706058815402347566,
        "service_name": "drive-thru",
        "span_id": 18441749682955329934,
        "trace_id": 17627901472205860733
    }
}

running: False
schema_name_id: 2834
start_time: 2024-11-05 02:01:33
success: True
trace_id: 17627901472205860733

Scan 6666451

duration: 0:00:13.922105

exit_message:

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

id: 6666451

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_newbooklocations_temp/2024-11-04/1730783540",
        "key": "raw/newbookdev_newbooklocations_temp/2024-11-04/1730783540/locations_temp.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklocations_temp",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13383117599734135635,
        "service_name": "drive-thru",
        "span_id": 6431004303409321905,
        "trace_id": 18217222973251979915
    }
}

running: False
schema_name_id: 2834
start_time: 2024-11-05 01:38:18
success: True
trace_id: 18217222973251979915

Scan 6665701

duration: 0:00:11.385208

exit_message:

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

id: 6665701

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_newbooklocations_temp/2024-11-04/1730783322",
        "key": "raw/newbookdev_newbooklocations_temp/2024-11-04/1730783322/locations_temp.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklocations_temp",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13565010519527852127,
        "service_name": "drive-thru",
        "span_id": 6706275796878582888,
        "trace_id": 1766594590737711530
    }
}

running: False
schema_name_id: 2834
start_time: 2024-11-05 01:18:32
success: True
trace_id: 1766594590737711530

Scan 6664904

duration: 0:00:11.354203

exit_message:

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

id: 6664904

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_newbooklocations_temp/2024-11-04/1730782922",
        "key": "raw/newbookdev_newbooklocations_temp/2024-11-04/1730782922/locations_temp.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklocations_temp",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7943492925062593148,
        "service_name": "drive-thru",
        "span_id": 17931028675119275431,
        "trace_id": 10468429867967307316
    }
}

running: False
schema_name_id: 2834
start_time: 2024-11-05 00:57:11
success: True
trace_id: 10468429867967307316

Scan 6663607

duration: 0:00:11.420321

exit_message:

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

id: 6663607

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_newbooklocations_temp/2024-11-04/1730782755",
        "key": "raw/newbookdev_newbooklocations_temp/2024-11-04/1730782755/locations_temp.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklocations_temp",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15345944984778060151,
        "service_name": "drive-thru",
        "span_id": 11671056675892277069,
        "trace_id": 10243440254286387630
    }
}

running: False
schema_name_id: 2834
start_time: 2024-11-05 00:23:23
success: True
trace_id: 10243440254286387630

Partitions:

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

Schema:

attributes:

{
    "area_code": "string",
    "id": "string",
    "locality": "string",
    "newbook_region": "string",
    "state_id": "string",
    "tenant": "string",
    "timezone": "string"
}

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

ddl:

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

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