Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookfacilities_features

created: 2024-10-08 18:04:54
disabled: False
format: raw
id: 2775
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4748782

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfacilities_features/2024-11-05/1730866495
id: 4748782
processed: 1

raw_data:

{
    "active": 4,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

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

schema_name_id: 2775
schema_scan_id: 6674814
updated: 2024-11-05 23:01:24

Version 4748216

created: 2024-11-05 22:38:25

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfacilities_features/2024-11-05/1730866411
id: 4748216
processed: 1

raw_data:

{
    "active": 4,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

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

schema_name_id: 2775
schema_scan_id: 6674248
updated: 2024-11-05 22:38:39

Version 4747719

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfacilities_features/2024-11-05/1730866297
id: 4747719
processed: 1

raw_data:

{
    "active": 4,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

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

schema_name_id: 2775
schema_scan_id: 6673751
updated: 2024-11-05 22:24:23

Version 4746834

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfacilities_features/2024-11-04/1730785712
id: 4746834
processed: 1

raw_data:

{
    "active": 4,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

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

schema_name_id: 2775
schema_scan_id: 6672064
updated: 2024-11-05 04:26:49

Version 4746094

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfacilities_features/2024-11-04/1730785119
id: 4746094
processed: 1

raw_data:

{
    "active": 4,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

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

schema_name_id: 2775
schema_scan_id: 6671316
updated: 2024-11-05 03:49:17

Version 4745408

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfacilities_features/2024-11-04/1730784814
id: 4745408
processed: 1

raw_data:

{
    "active": 4,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

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

schema_name_id: 2775
schema_scan_id: 6670625
updated: 2024-11-05 03:28:49

Version 4744917

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfacilities_features/2024-11-04/1730784211
id: 4744917
processed: 1

raw_data:

{
    "active": 4,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

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

schema_name_id: 2775
schema_scan_id: 6670134
updated: 2024-11-05 03:16:01

Version 4743916

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfacilities_features/2024-11-04/1730784048
id: 4743916
processed: 1

raw_data:

{
    "active": 4,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

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

schema_name_id: 2775
schema_scan_id: 6669133
updated: 2024-11-05 02:49:24

Version 4743478

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfacilities_features/2024-11-04/1730783895
id: 4743478
processed: 1

raw_data:

{
    "active": 4,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

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

schema_name_id: 2775
schema_scan_id: 6668695
updated: 2024-11-05 02:37:55

Version 4741979

created: 2024-11-05 01:57:51

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfacilities_features/2024-11-04/1730783762
id: 4741979
processed: 1

raw_data:

{
    "active": 4,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

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

schema_name_id: 2775
schema_scan_id: 6667197
updated: 2024-11-05 01:58:05

Version 4741666

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfacilities_features/2024-11-04/1730783608
id: 4741666
processed: 1

raw_data:

{
    "active": 4,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

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

schema_name_id: 2775
schema_scan_id: 6666883
updated: 2024-11-05 01:49:47

Version 4740629

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfacilities_features/2024-11-04/1730783517
id: 4740629
processed: 1

raw_data:

{
    "active": 4,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

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

schema_name_id: 2775
schema_scan_id: 6665846
updated: 2024-11-05 01:22:38

Version 4740415

created: 2024-11-05 01:16:42

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfacilities_features/2024-11-04/1730783300
id: 4740415
processed: 1

raw_data:

{
    "active": 4,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

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

schema_name_id: 2775
schema_scan_id: 6665633
updated: 2024-11-05 01:16:56

Version 4739309

created: 2024-11-05 00:47:20

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfacilities_features/2024-11-04/1730782901
id: 4739309
processed: 1

raw_data:

{
    "active": 4,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

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

schema_name_id: 2775
schema_scan_id: 6664525
updated: 2024-11-05 00:47:31

Version 4739000

created: 2024-11-05 00:39:13

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfacilities_features/2024-11-04/1730782801
id: 4739000
processed: 1

raw_data:

{
    "active": 4,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

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

schema_name_id: 2775
schema_scan_id: 6664215
updated: 2024-11-05 00:39:24

Schema Scans: 15

Last at 2024-11-05 23:01:10

Scan 6674814

duration: 0:00:13.945169

exit_message:

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

id: 6674814

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_newbookfacilities_features/2024-11-05/1730866495",
        "key": "raw/newbookdev_newbookfacilities_features/2024-11-05/1730866495/facilities_features.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookfacilities_features",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15634061643843251789,
        "service_name": "drive-thru",
        "span_id": 10501852965411569253,
        "trace_id": 13961323116618641775
    }
}

running: False
schema_name_id: 2775
start_time: 2024-11-05 23:01:10
success: True
trace_id: 13961323116618641775

Scan 6674248

duration: 0:00:13.980200

exit_message:

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

id: 6674248

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_newbookfacilities_features/2024-11-05/1730866411",
        "key": "raw/newbookdev_newbookfacilities_features/2024-11-05/1730866411/facilities_features.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookfacilities_features",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4164827242875870289,
        "service_name": "drive-thru",
        "span_id": 13315806604256337541,
        "trace_id": 14894205102209497957
    }
}

running: False
schema_name_id: 2775
start_time: 2024-11-05 22:38:25
success: True
trace_id: 14894205102209497957

Scan 6673751

duration: 0:00:11.315006

exit_message:

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

id: 6673751

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_newbookfacilities_features/2024-11-05/1730866297",
        "key": "raw/newbookdev_newbookfacilities_features/2024-11-05/1730866297/facilities_features.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookfacilities_features",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17337540305783375381,
        "service_name": "drive-thru",
        "span_id": 9164076645676649731,
        "trace_id": 8175744944483585570
    }
}

running: False
schema_name_id: 2775
start_time: 2024-11-05 22:24:12
success: True
trace_id: 8175744944483585570

Scan 6672064

duration: 0:00:14.165783

exit_message:

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

id: 6672064

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_newbookfacilities_features/2024-11-04/1730785712",
        "key": "raw/newbookdev_newbookfacilities_features/2024-11-04/1730785712/facilities_features.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookfacilities_features",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9879993624658921001,
        "service_name": "drive-thru",
        "span_id": 15592601867365826132,
        "trace_id": 16818933256711587590
    }
}

running: False
schema_name_id: 2775
start_time: 2024-11-05 04:26:34
success: True
trace_id: 16818933256711587590

Scan 6671316

duration: 0:00:11.425824

exit_message:

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

id: 6671316

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_newbookfacilities_features/2024-11-04/1730785119",
        "key": "raw/newbookdev_newbookfacilities_features/2024-11-04/1730785119/facilities_features.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookfacilities_features",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4914194022173139435,
        "service_name": "drive-thru",
        "span_id": 8329006064349448137,
        "trace_id": 2187036433786243515
    }
}

running: False
schema_name_id: 2775
start_time: 2024-11-05 03:49:06
success: True
trace_id: 2187036433786243515

Scan 6670625

duration: 0:00:11.281734

exit_message:

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

id: 6670625

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_newbookfacilities_features/2024-11-04/1730784814",
        "key": "raw/newbookdev_newbookfacilities_features/2024-11-04/1730784814/facilities_features.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookfacilities_features",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14266478078033350986,
        "service_name": "drive-thru",
        "span_id": 295616429077905664,
        "trace_id": 3839368443948551574
    }
}

running: False
schema_name_id: 2775
start_time: 2024-11-05 03:28:38
success: True
trace_id: 3839368443948551574

Scan 6670134

duration: 0:00:11.405732

exit_message:

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

id: 6670134

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_newbookfacilities_features/2024-11-04/1730784211",
        "key": "raw/newbookdev_newbookfacilities_features/2024-11-04/1730784211/facilities_features.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookfacilities_features",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8075073728117151614,
        "service_name": "drive-thru",
        "span_id": 13874429501814608467,
        "trace_id": 4790951419240360811
    }
}

running: False
schema_name_id: 2775
start_time: 2024-11-05 03:15:50
success: True
trace_id: 4790951419240360811

Scan 6669133

duration: 0:00:11.310353

exit_message:

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

id: 6669133

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_newbookfacilities_features/2024-11-04/1730784048",
        "key": "raw/newbookdev_newbookfacilities_features/2024-11-04/1730784048/facilities_features.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookfacilities_features",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9569701334254477870,
        "service_name": "drive-thru",
        "span_id": 1025129565496520210,
        "trace_id": 13358613520004376913
    }
}

running: False
schema_name_id: 2775
start_time: 2024-11-05 02:49:12
success: True
trace_id: 13358613520004376913

Scan 6668695

duration: 0:00:13.946517

exit_message:

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

id: 6668695

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_newbookfacilities_features/2024-11-04/1730783895",
        "key": "raw/newbookdev_newbookfacilities_features/2024-11-04/1730783895/facilities_features.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookfacilities_features",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17000682885161184752,
        "service_name": "drive-thru",
        "span_id": 10468706240696134813,
        "trace_id": 10748500531680080019
    }
}

running: False
schema_name_id: 2775
start_time: 2024-11-05 02:37:41
success: True
trace_id: 10748500531680080019

Scan 6667197

duration: 0:00:13.875808

exit_message:

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

id: 6667197

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_newbookfacilities_features/2024-11-04/1730783762",
        "key": "raw/newbookdev_newbookfacilities_features/2024-11-04/1730783762/facilities_features.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookfacilities_features",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15509834528462302770,
        "service_name": "drive-thru",
        "span_id": 3557219456890553918,
        "trace_id": 6084155844982413731
    }
}

running: False
schema_name_id: 2775
start_time: 2024-11-05 01:57:51
success: True
trace_id: 6084155844982413731

Scan 6666883

duration: 0:00:13.863239

exit_message:

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

id: 6666883

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_newbookfacilities_features/2024-11-04/1730783608",
        "key": "raw/newbookdev_newbookfacilities_features/2024-11-04/1730783608/facilities_features.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookfacilities_features",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4015158322478698239,
        "service_name": "drive-thru",
        "span_id": 15798467317219528354,
        "trace_id": 2578311530321604954
    }
}

running: False
schema_name_id: 2775
start_time: 2024-11-05 01:49:33
success: True
trace_id: 2578311530321604954

Scan 6665846

duration: 0:00:16.294215

exit_message:

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

id: 6665846

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_newbookfacilities_features/2024-11-04/1730783517",
        "key": "raw/newbookdev_newbookfacilities_features/2024-11-04/1730783517/facilities_features.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookfacilities_features",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11197312015491156905,
        "service_name": "drive-thru",
        "span_id": 3209783077587391858,
        "trace_id": 1568073331325327153
    }
}

running: False
schema_name_id: 2775
start_time: 2024-11-05 01:22:22
success: True
trace_id: 1568073331325327153

Scan 6665633

duration: 0:00:13.873976

exit_message:

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

id: 6665633

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_newbookfacilities_features/2024-11-04/1730783300",
        "key": "raw/newbookdev_newbookfacilities_features/2024-11-04/1730783300/facilities_features.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookfacilities_features",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1944713869313791726,
        "service_name": "drive-thru",
        "span_id": 431482879999070211,
        "trace_id": 5301153260021279880
    }
}

running: False
schema_name_id: 2775
start_time: 2024-11-05 01:16:42
success: True
trace_id: 5301153260021279880

Scan 6664525

duration: 0:00:11.299831

exit_message:

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

id: 6664525

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_newbookfacilities_features/2024-11-04/1730782901",
        "key": "raw/newbookdev_newbookfacilities_features/2024-11-04/1730782901/facilities_features.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookfacilities_features",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3187375250076612474,
        "service_name": "drive-thru",
        "span_id": 7968930804282701193,
        "trace_id": 16223581958285510705
    }
}

running: False
schema_name_id: 2775
start_time: 2024-11-05 00:47:20
success: True
trace_id: 16223581958285510705

Scan 6664215

duration: 0:00:11.259103

exit_message:

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

id: 6664215

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_newbookfacilities_features/2024-11-04/1730782801",
        "key": "raw/newbookdev_newbookfacilities_features/2024-11-04/1730782801/facilities_features.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookfacilities_features",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6731377457193498343,
        "service_name": "drive-thru",
        "span_id": 2132179426829505377,
        "trace_id": 18442156429008559717
    }
}

running: False
schema_name_id: 2775
start_time: 2024-11-05 00:39:13
success: True
trace_id: 18442156429008559717

Partitions:

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

Schema:

attributes:

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

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

ddl:

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

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