Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookcached_sites_configuration

created: 2024-10-08 17:40:03
disabled: False
format: raw
id: 2452
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4748268

created: 2024-11-05 22:40:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcached_sites_configuration`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcached_sites_configuration`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `instance_id`  string , `site_id`  string , `width`  string , `length`  string , `height`  string , `equipment_type_ids`  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_newbookcached_sites_configuration/2024-11-05/1730866387'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcached_sites_configuration"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcached_sites_configuration/2024-11-05/1730866387
id: 4748268
processed: 1

raw_data:

{
    "equipment_type_ids": 8,
    "height": 7,
    "id": 2,
    "instance_id": 3,
    "length": 6,
    "newbook_region": 0,
    "site_id": 4,
    "tenant": 1,
    "width": 5
}

schema_attributes:

{
    "equipment_type_ids": "string",
    "height": "string",
    "id": "string",
    "instance_id": "string",
    "length": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string",
    "width": "string"
}

schema_name_id: 2452
schema_scan_id: 6674300
updated: 2024-11-05 22:40:29

Version 4747689

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcached_sites_configuration`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcached_sites_configuration`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `instance_id`  string , `site_id`  string , `width`  string , `length`  string , `height`  string , `equipment_type_ids`  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_newbookcached_sites_configuration/2024-11-05/1730866318'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcached_sites_configuration"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcached_sites_configuration/2024-11-05/1730866318
id: 4747689
processed: 1

raw_data:

{
    "equipment_type_ids": 8,
    "height": 7,
    "id": 2,
    "instance_id": 3,
    "length": 6,
    "newbook_region": 0,
    "site_id": 4,
    "tenant": 1,
    "width": 5
}

schema_attributes:

{
    "equipment_type_ids": "string",
    "height": "string",
    "id": "string",
    "instance_id": "string",
    "length": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string",
    "width": "string"
}

schema_name_id: 2452
schema_scan_id: 6673721
updated: 2024-11-05 22:23:35

Version 4747466

created: 2024-11-05 22:17:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcached_sites_configuration`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcached_sites_configuration`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `instance_id`  string , `site_id`  string , `width`  string , `length`  string , `height`  string , `equipment_type_ids`  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_newbookcached_sites_configuration/2024-11-05/1730866241'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcached_sites_configuration"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcached_sites_configuration/2024-11-05/1730866241
id: 4747466
processed: 1

raw_data:

{
    "equipment_type_ids": 8,
    "height": 7,
    "id": 2,
    "instance_id": 3,
    "length": 6,
    "newbook_region": 0,
    "site_id": 4,
    "tenant": 1,
    "width": 5
}

schema_attributes:

{
    "equipment_type_ids": "string",
    "height": "string",
    "id": "string",
    "instance_id": "string",
    "length": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string",
    "width": "string"
}

schema_name_id: 2452
schema_scan_id: 6673498
updated: 2024-11-05 22:17:45

Version 4745972

created: 2024-11-05 03:44:38

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcached_sites_configuration`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcached_sites_configuration`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `instance_id`  string , `site_id`  string , `width`  string , `length`  string , `height`  string , `equipment_type_ids`  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_newbookcached_sites_configuration/2024-11-04/1730785088'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcached_sites_configuration"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcached_sites_configuration/2024-11-04/1730785088
id: 4745972
processed: 1

raw_data:

{
    "equipment_type_ids": 8,
    "height": 7,
    "id": 2,
    "instance_id": 3,
    "length": 6,
    "newbook_region": 0,
    "site_id": 4,
    "tenant": 1,
    "width": 5
}

schema_attributes:

{
    "equipment_type_ids": "string",
    "height": "string",
    "id": "string",
    "instance_id": "string",
    "length": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string",
    "width": "string"
}

schema_name_id: 2452
schema_scan_id: 6671192
updated: 2024-11-05 03:44:49

Version 4745970

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcached_sites_configuration`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcached_sites_configuration`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `instance_id`  string , `site_id`  string , `width`  string , `length`  string , `height`  string , `equipment_type_ids`  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_newbookcached_sites_configuration/2024-11-04/1730785660'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcached_sites_configuration"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcached_sites_configuration/2024-11-04/1730785660
id: 4745970
processed: 1

raw_data:

{
    "equipment_type_ids": 8,
    "height": 7,
    "id": 2,
    "instance_id": 3,
    "length": 6,
    "newbook_region": 0,
    "site_id": 4,
    "tenant": 1,
    "width": 5
}

schema_attributes:

{
    "equipment_type_ids": "string",
    "height": "string",
    "id": "string",
    "instance_id": "string",
    "length": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string",
    "width": "string"
}

schema_name_id: 2452
schema_scan_id: 6671190
updated: 2024-11-05 03:44:48

Version 4745382

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcached_sites_configuration`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcached_sites_configuration`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `instance_id`  string , `site_id`  string , `width`  string , `length`  string , `height`  string , `equipment_type_ids`  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_newbookcached_sites_configuration/2024-11-04/1730784783'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcached_sites_configuration"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcached_sites_configuration/2024-11-04/1730784783
id: 4745382
processed: 1

raw_data:

{
    "equipment_type_ids": 8,
    "height": 7,
    "id": 2,
    "instance_id": 3,
    "length": 6,
    "newbook_region": 0,
    "site_id": 4,
    "tenant": 1,
    "width": 5
}

schema_attributes:

{
    "equipment_type_ids": "string",
    "height": "string",
    "id": "string",
    "instance_id": "string",
    "length": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string",
    "width": "string"
}

schema_name_id: 2452
schema_scan_id: 6670599
updated: 2024-11-05 03:28:11

Version 4744334

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcached_sites_configuration`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcached_sites_configuration`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `instance_id`  string , `site_id`  string , `width`  string , `length`  string , `height`  string , `equipment_type_ids`  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_newbookcached_sites_configuration/2024-11-04/1730784180'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcached_sites_configuration"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcached_sites_configuration/2024-11-04/1730784180
id: 4744334
processed: 1

raw_data:

{
    "equipment_type_ids": 8,
    "height": 7,
    "id": 2,
    "instance_id": 3,
    "length": 6,
    "newbook_region": 0,
    "site_id": 4,
    "tenant": 1,
    "width": 5
}

schema_attributes:

{
    "equipment_type_ids": "string",
    "height": "string",
    "id": "string",
    "instance_id": "string",
    "length": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string",
    "width": "string"
}

schema_name_id: 2452
schema_scan_id: 6669551
updated: 2024-11-05 03:00:22

Version 4743665

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcached_sites_configuration`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcached_sites_configuration`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `instance_id`  string , `site_id`  string , `width`  string , `length`  string , `height`  string , `equipment_type_ids`  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_newbookcached_sites_configuration/2024-11-04/1730784017'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcached_sites_configuration"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcached_sites_configuration/2024-11-04/1730784017
id: 4743665
processed: 1

raw_data:

{
    "equipment_type_ids": 8,
    "height": 7,
    "id": 2,
    "instance_id": 3,
    "length": 6,
    "newbook_region": 0,
    "site_id": 4,
    "tenant": 1,
    "width": 5
}

schema_attributes:

{
    "equipment_type_ids": "string",
    "height": "string",
    "id": "string",
    "instance_id": "string",
    "length": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string",
    "width": "string"
}

schema_name_id: 2452
schema_scan_id: 6668882
updated: 2024-11-05 02:42:48

Version 4743201

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcached_sites_configuration`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcached_sites_configuration`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `instance_id`  string , `site_id`  string , `width`  string , `length`  string , `height`  string , `equipment_type_ids`  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_newbookcached_sites_configuration/2024-11-04/1730783871'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcached_sites_configuration"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcached_sites_configuration/2024-11-04/1730783871
id: 4743201
processed: 1

raw_data:

{
    "equipment_type_ids": 8,
    "height": 7,
    "id": 2,
    "instance_id": 3,
    "length": 6,
    "newbook_region": 0,
    "site_id": 4,
    "tenant": 1,
    "width": 5
}

schema_attributes:

{
    "equipment_type_ids": "string",
    "height": "string",
    "id": "string",
    "instance_id": "string",
    "length": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string",
    "width": "string"
}

schema_name_id: 2452
schema_scan_id: 6668418
updated: 2024-11-05 02:30:25

Version 4742480

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcached_sites_configuration`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcached_sites_configuration`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `instance_id`  string , `site_id`  string , `width`  string , `length`  string , `height`  string , `equipment_type_ids`  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_newbookcached_sites_configuration/2024-11-04/1730783730'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcached_sites_configuration"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcached_sites_configuration/2024-11-04/1730783730
id: 4742480
processed: 1

raw_data:

{
    "equipment_type_ids": 8,
    "height": 7,
    "id": 2,
    "instance_id": 3,
    "length": 6,
    "newbook_region": 0,
    "site_id": 4,
    "tenant": 1,
    "width": 5
}

schema_attributes:

{
    "equipment_type_ids": "string",
    "height": "string",
    "id": "string",
    "instance_id": "string",
    "length": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string",
    "width": "string"
}

schema_name_id: 2452
schema_scan_id: 6667697
updated: 2024-11-05 02:11:34

Version 4741672

created: 2024-11-05 01:49:44

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcached_sites_configuration`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcached_sites_configuration`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `instance_id`  string , `site_id`  string , `width`  string , `length`  string , `height`  string , `equipment_type_ids`  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_newbookcached_sites_configuration/2024-11-04/1730783637'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcached_sites_configuration"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcached_sites_configuration/2024-11-04/1730783637
id: 4741672
processed: 1

raw_data:

{
    "equipment_type_ids": 8,
    "height": 7,
    "id": 2,
    "instance_id": 3,
    "length": 6,
    "newbook_region": 0,
    "site_id": 4,
    "tenant": 1,
    "width": 5
}

schema_attributes:

{
    "equipment_type_ids": "string",
    "height": "string",
    "id": "string",
    "instance_id": "string",
    "length": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string",
    "width": "string"
}

schema_name_id: 2452
schema_scan_id: 6666889
updated: 2024-11-05 01:49:55

Version 4740840

created: 2024-11-05 01:27:52

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcached_sites_configuration`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcached_sites_configuration`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `instance_id`  string , `site_id`  string , `width`  string , `length`  string , `height`  string , `equipment_type_ids`  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_newbookcached_sites_configuration/2024-11-04/1730783486'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcached_sites_configuration"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcached_sites_configuration/2024-11-04/1730783486
id: 4740840
processed: 1

raw_data:

{
    "equipment_type_ids": 8,
    "height": 7,
    "id": 2,
    "instance_id": 3,
    "length": 6,
    "newbook_region": 0,
    "site_id": 4,
    "tenant": 1,
    "width": 5
}

schema_attributes:

{
    "equipment_type_ids": "string",
    "height": "string",
    "id": "string",
    "instance_id": "string",
    "length": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string",
    "width": "string"
}

schema_name_id: 2452
schema_scan_id: 6666057
updated: 2024-11-05 01:28:03

Version 4740159

created: 2024-11-05 01:09:58

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcached_sites_configuration`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcached_sites_configuration`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `instance_id`  string , `site_id`  string , `width`  string , `length`  string , `height`  string , `equipment_type_ids`  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_newbookcached_sites_configuration/2024-11-04/1730783267'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcached_sites_configuration"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcached_sites_configuration/2024-11-04/1730783267
id: 4740159
processed: 1

raw_data:

{
    "equipment_type_ids": 8,
    "height": 7,
    "id": 2,
    "instance_id": 3,
    "length": 6,
    "newbook_region": 0,
    "site_id": 4,
    "tenant": 1,
    "width": 5
}

schema_attributes:

{
    "equipment_type_ids": "string",
    "height": "string",
    "id": "string",
    "instance_id": "string",
    "length": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string",
    "width": "string"
}

schema_name_id: 2452
schema_scan_id: 6665376
updated: 2024-11-05 01:10:09

Version 4739399

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcached_sites_configuration`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcached_sites_configuration`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `instance_id`  string , `site_id`  string , `width`  string , `length`  string , `height`  string , `equipment_type_ids`  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_newbookcached_sites_configuration/2024-11-04/1730782870'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcached_sites_configuration"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcached_sites_configuration/2024-11-04/1730782870
id: 4739399
processed: 1

raw_data:

{
    "equipment_type_ids": 8,
    "height": 7,
    "id": 2,
    "instance_id": 3,
    "length": 6,
    "newbook_region": 0,
    "site_id": 4,
    "tenant": 1,
    "width": 5
}

schema_attributes:

{
    "equipment_type_ids": "string",
    "height": "string",
    "id": "string",
    "instance_id": "string",
    "length": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string",
    "width": "string"
}

schema_name_id: 2452
schema_scan_id: 6664614
updated: 2024-11-05 00:49:49

Version 4738639

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcached_sites_configuration`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcached_sites_configuration`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `instance_id`  string , `site_id`  string , `width`  string , `length`  string , `height`  string , `equipment_type_ids`  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_newbookcached_sites_configuration/2024-11-04/1730782741'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcached_sites_configuration"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcached_sites_configuration/2024-11-04/1730782741
id: 4738639
processed: 1

raw_data:

{
    "equipment_type_ids": 8,
    "height": 7,
    "id": 2,
    "instance_id": 3,
    "length": 6,
    "newbook_region": 0,
    "site_id": 4,
    "tenant": 1,
    "width": 5
}

schema_attributes:

{
    "equipment_type_ids": "string",
    "height": "string",
    "id": "string",
    "instance_id": "string",
    "length": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string",
    "width": "string"
}

schema_name_id: 2452
schema_scan_id: 6663852
updated: 2024-11-05 00:29:49

Schema Scans: 15

Last at 2024-11-05 22:40:18

Scan 6674300

duration: 0:00:11.570834

exit_message:

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

id: 6674300

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_newbookcached_sites_configuration/2024-11-05/1730866387",
        "key": "raw/newbookdev_newbookcached_sites_configuration/2024-11-05/1730866387/cached_sites_configuration.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcached_sites_configuration",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14165300108893450732,
        "service_name": "drive-thru",
        "span_id": 14598905242199055629,
        "trace_id": 13971448124975148325
    }
}

running: False
schema_name_id: 2452
start_time: 2024-11-05 22:40:18
success: True
trace_id: 13971448124975148325

Scan 6673721

duration: 0:00:11.448282

exit_message:

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

id: 6673721

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_newbookcached_sites_configuration/2024-11-05/1730866318",
        "key": "raw/newbookdev_newbookcached_sites_configuration/2024-11-05/1730866318/cached_sites_configuration.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcached_sites_configuration",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1459206664964589978,
        "service_name": "drive-thru",
        "span_id": 16054650138913804288,
        "trace_id": 10548223378784862972
    }
}

running: False
schema_name_id: 2452
start_time: 2024-11-05 22:23:23
success: True
trace_id: 10548223378784862972

Scan 6673498

duration: 0:00:11.558885

exit_message:

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

id: 6673498

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_newbookcached_sites_configuration/2024-11-05/1730866241",
        "key": "raw/newbookdev_newbookcached_sites_configuration/2024-11-05/1730866241/cached_sites_configuration.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcached_sites_configuration",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15190217424488855320,
        "service_name": "drive-thru",
        "span_id": 11777842556281191488,
        "trace_id": 8174293451457231590
    }
}

running: False
schema_name_id: 2452
start_time: 2024-11-05 22:17:33
success: True
trace_id: 8174293451457231590

Scan 6671192

duration: 0:00:11.636075

exit_message:

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

id: 6671192

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_newbookcached_sites_configuration/2024-11-04/1730785088",
        "key": "raw/newbookdev_newbookcached_sites_configuration/2024-11-04/1730785088/cached_sites_configuration.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcached_sites_configuration",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4275351487593254067,
        "service_name": "drive-thru",
        "span_id": 9697812108230133053,
        "trace_id": 10034517404904467355
    }
}

running: False
schema_name_id: 2452
start_time: 2024-11-05 03:44:38
success: True
trace_id: 10034517404904467355

Scan 6671190

duration: 0:00:11.591644

exit_message:

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

id: 6671190

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_newbookcached_sites_configuration/2024-11-04/1730785660",
        "key": "raw/newbookdev_newbookcached_sites_configuration/2024-11-04/1730785660/cached_sites_configuration.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcached_sites_configuration",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13887335348702694208,
        "service_name": "drive-thru",
        "span_id": 8292044717687712456,
        "trace_id": 2520248443976762322
    }
}

running: False
schema_name_id: 2452
start_time: 2024-11-05 03:44:36
success: True
trace_id: 2520248443976762322

Scan 6670599

duration: 0:00:11.382426

exit_message:

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

id: 6670599

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_newbookcached_sites_configuration/2024-11-04/1730784783",
        "key": "raw/newbookdev_newbookcached_sites_configuration/2024-11-04/1730784783/cached_sites_configuration.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcached_sites_configuration",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5335389226201273988,
        "service_name": "drive-thru",
        "span_id": 10936919581473621189,
        "trace_id": 4360518898129252919
    }
}

running: False
schema_name_id: 2452
start_time: 2024-11-05 03:28:00
success: True
trace_id: 4360518898129252919

Scan 6669551

duration: 0:00:13.865079

exit_message:

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

id: 6669551

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_newbookcached_sites_configuration/2024-11-04/1730784180",
        "key": "raw/newbookdev_newbookcached_sites_configuration/2024-11-04/1730784180/cached_sites_configuration.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcached_sites_configuration",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14658835966570513035,
        "service_name": "drive-thru",
        "span_id": 1335443954474562776,
        "trace_id": 6646868215549328507
    }
}

running: False
schema_name_id: 2452
start_time: 2024-11-05 03:00:08
success: True
trace_id: 6646868215549328507

Scan 6668882

duration: 0:00:11.392869

exit_message:

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

id: 6668882

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_newbookcached_sites_configuration/2024-11-04/1730784017",
        "key": "raw/newbookdev_newbookcached_sites_configuration/2024-11-04/1730784017/cached_sites_configuration.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcached_sites_configuration",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14843669727198687937,
        "service_name": "drive-thru",
        "span_id": 5769078592655821329,
        "trace_id": 3187688179213026692
    }
}

running: False
schema_name_id: 2452
start_time: 2024-11-05 02:42:37
success: True
trace_id: 3187688179213026692

Scan 6668418

duration: 0:00:11.336417

exit_message:

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

id: 6668418

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_newbookcached_sites_configuration/2024-11-04/1730783871",
        "key": "raw/newbookdev_newbookcached_sites_configuration/2024-11-04/1730783871/cached_sites_configuration.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcached_sites_configuration",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15435531335271520917,
        "service_name": "drive-thru",
        "span_id": 1749768953369582486,
        "trace_id": 9606330234544388818
    }
}

running: False
schema_name_id: 2452
start_time: 2024-11-05 02:30:14
success: True
trace_id: 9606330234544388818

Scan 6667697

duration: 0:00:13.932304

exit_message:

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

id: 6667697

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_newbookcached_sites_configuration/2024-11-04/1730783730",
        "key": "raw/newbookdev_newbookcached_sites_configuration/2024-11-04/1730783730/cached_sites_configuration.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcached_sites_configuration",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10894229378303672358,
        "service_name": "drive-thru",
        "span_id": 12613411997817841602,
        "trace_id": 6126540360388222984
    }
}

running: False
schema_name_id: 2452
start_time: 2024-11-05 02:11:20
success: True
trace_id: 6126540360388222984

Scan 6666889

duration: 0:00:11.392480

exit_message:

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

id: 6666889

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_newbookcached_sites_configuration/2024-11-04/1730783637",
        "key": "raw/newbookdev_newbookcached_sites_configuration/2024-11-04/1730783637/cached_sites_configuration.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcached_sites_configuration",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9600922027315982991,
        "service_name": "drive-thru",
        "span_id": 16218742175289176691,
        "trace_id": 11424230570391309378
    }
}

running: False
schema_name_id: 2452
start_time: 2024-11-05 01:49:43
success: True
trace_id: 11424230570391309378

Scan 6666057

duration: 0:00:11.438406

exit_message:

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

id: 6666057

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_newbookcached_sites_configuration/2024-11-04/1730783486",
        "key": "raw/newbookdev_newbookcached_sites_configuration/2024-11-04/1730783486/cached_sites_configuration.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcached_sites_configuration",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2120011234401372915,
        "service_name": "drive-thru",
        "span_id": 1445856534864804671,
        "trace_id": 2335150601538944356
    }
}

running: False
schema_name_id: 2452
start_time: 2024-11-05 01:27:52
success: True
trace_id: 2335150601538944356

Scan 6665376

duration: 0:00:11.445510

exit_message:

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

id: 6665376

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_newbookcached_sites_configuration/2024-11-04/1730783267",
        "key": "raw/newbookdev_newbookcached_sites_configuration/2024-11-04/1730783267/cached_sites_configuration.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcached_sites_configuration",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3591340166015243898,
        "service_name": "drive-thru",
        "span_id": 13028033356195808892,
        "trace_id": 9216588727485499387
    }
}

running: False
schema_name_id: 2452
start_time: 2024-11-05 01:09:57
success: True
trace_id: 9216588727485499387

Scan 6664614

duration: 0:00:11.462618

exit_message:

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

id: 6664614

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_newbookcached_sites_configuration/2024-11-04/1730782870",
        "key": "raw/newbookdev_newbookcached_sites_configuration/2024-11-04/1730782870/cached_sites_configuration.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcached_sites_configuration",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9024379693868292557,
        "service_name": "drive-thru",
        "span_id": 10852675860586066657,
        "trace_id": 7038593678841346748
    }
}

running: False
schema_name_id: 2452
start_time: 2024-11-05 00:49:37
success: True
trace_id: 7038593678841346748

Scan 6663852

duration: 0:00:11.296299

exit_message:

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

id: 6663852

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_newbookcached_sites_configuration/2024-11-04/1730782741",
        "key": "raw/newbookdev_newbookcached_sites_configuration/2024-11-04/1730782741/cached_sites_configuration.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcached_sites_configuration",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6224207367881588970,
        "service_name": "drive-thru",
        "span_id": 16575495330055387494,
        "trace_id": 6232459048427665047
    }
}

running: False
schema_name_id: 2452
start_time: 2024-11-05 00:29:38
success: True
trace_id: 6232459048427665047

Partitions:

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

Schema:

attributes:

{
    "equipment_type_ids": "string",
    "height": "string",
    "id": "string",
    "instance_id": "string",
    "length": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string",
    "width": "string"
}

created: 2024-11-05 22:40:18

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcached_sites_configuration`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `instance_id`  string , `site_id`  string , `width`  string , `length`  string , `height`  string , `equipment_type_ids`  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_newbookcached_sites_configuration/2024-11-05/1730866387'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcached_sites_configuration`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcached_sites_configuration"
}

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 17:40:03",
        "disabled": false,
        "format": "raw",
        "id": 2452,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "newbookdev_newbookcached_sites_configuration"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "equipment_type_ids": "string",
            "height": "string",
            "id": "string",
            "instance_id": "string",
            "length": "string",
            "newbook_region": "string",
            "site_id": "string",
            "tenant": "string",
            "width": "string"
        },
        "created": "2024-11-05 22:40:18",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcached_sites_configuration`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `instance_id`  string , `site_id`  string , `width`  string , `length`  string , `height`  string , `equipment_type_ids`  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_newbookcached_sites_configuration/2024-11-05/1730866387'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcached_sites_configuration`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcached_sites_configuration"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}