Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookinstances_settings

created: 2024-10-08 18:08:52
disabled: False
format: raw
id: 2810
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4748847

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_settings/2024-11-05/1730866514
id: 4748847
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "setting_id": 3,
    "tenant": 1,
    "value": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "setting_id": "string",
    "tenant": "string",
    "value": "string"
}

schema_name_id: 2810
schema_scan_id: 6674879
updated: 2024-11-05 23:05:02

Version 4748552

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_settings/2024-11-05/1730866440
id: 4748552
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "setting_id": 3,
    "tenant": 1,
    "value": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "setting_id": "string",
    "tenant": "string",
    "value": "string"
}

schema_name_id: 2810
schema_scan_id: 6674584
updated: 2024-11-05 22:51:03

Version 4747820

created: 2024-11-05 22:26:52

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_settings/2024-11-05/1730866317
id: 4747820
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "setting_id": 3,
    "tenant": 1,
    "value": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "setting_id": "string",
    "tenant": "string",
    "value": "string"
}

schema_name_id: 2810
schema_scan_id: 6673852
updated: 2024-11-05 22:27:05

Version 4746778

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_settings/2024-11-04/1730785726
id: 4746778
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "setting_id": 3,
    "tenant": 1,
    "value": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "setting_id": "string",
    "tenant": "string",
    "value": "string"
}

schema_name_id: 2810
schema_scan_id: 6672006
updated: 2024-11-05 04:22:41

Version 4746170

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_settings/2024-11-04/1730785128
id: 4746170
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "setting_id": 3,
    "tenant": 1,
    "value": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "setting_id": "string",
    "tenant": "string",
    "value": "string"
}

schema_name_id: 2810
schema_scan_id: 6671391
updated: 2024-11-05 03:51:54

Version 4745401

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_settings/2024-11-04/1730784822
id: 4745401
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "setting_id": 3,
    "tenant": 1,
    "value": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "setting_id": "string",
    "tenant": "string",
    "value": "string"
}

schema_name_id: 2810
schema_scan_id: 6670618
updated: 2024-11-05 03:28:38

Version 4744117

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_settings/2024-11-04/1730784218
id: 4744117
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "setting_id": 3,
    "tenant": 1,
    "value": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "setting_id": "string",
    "tenant": "string",
    "value": "string"
}

schema_name_id: 2810
schema_scan_id: 6669335
updated: 2024-11-05 02:54:39

Version 4743977

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_settings/2024-11-04/1730784056
id: 4743977
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "setting_id": 3,
    "tenant": 1,
    "value": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "setting_id": "string",
    "tenant": "string",
    "value": "string"
}

schema_name_id: 2810
schema_scan_id: 6669195
updated: 2024-11-05 02:51:05

Version 4743457

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_settings/2024-11-04/1730783901
id: 4743457
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "setting_id": 3,
    "tenant": 1,
    "value": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "setting_id": "string",
    "tenant": "string",
    "value": "string"
}

schema_name_id: 2810
schema_scan_id: 6668674
updated: 2024-11-05 02:37:17

Version 4742721

created: 2024-11-05 02:17:44

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_settings/2024-11-04/1730783770
id: 4742721
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "setting_id": 3,
    "tenant": 1,
    "value": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "setting_id": "string",
    "tenant": "string",
    "value": "string"
}

schema_name_id: 2810
schema_scan_id: 6667938
updated: 2024-11-05 02:17:55

Version 4742042

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_settings/2024-11-04/1730783667
id: 4742042
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "setting_id": 3,
    "tenant": 1,
    "value": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "setting_id": "string",
    "tenant": "string",
    "value": "string"
}

schema_name_id: 2810
schema_scan_id: 6667259
updated: 2024-11-05 01:59:37

Version 4741123

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_settings/2024-11-04/1730783526
id: 4741123
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "setting_id": 3,
    "tenant": 1,
    "value": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "setting_id": "string",
    "tenant": "string",
    "value": "string"
}

schema_name_id: 2810
schema_scan_id: 6666340
updated: 2024-11-05 01:35:34

Version 4740440

created: 2024-11-05 01:17:24

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_settings/2024-11-04/1730783308
id: 4740440
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "setting_id": 3,
    "tenant": 1,
    "value": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "setting_id": "string",
    "tenant": "string",
    "value": "string"
}

schema_name_id: 2810
schema_scan_id: 6665657
updated: 2024-11-05 01:17:37

Version 4739575

created: 2024-11-05 00:54:17

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_settings/2024-11-04/1730782909
id: 4739575
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "setting_id": 3,
    "tenant": 1,
    "value": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "setting_id": "string",
    "tenant": "string",
    "value": "string"
}

schema_name_id: 2810
schema_scan_id: 6664792
updated: 2024-11-05 00:54:28

Version 4739079

created: 2024-11-05 00:41:15

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_settings/2024-11-04/1730782807
id: 4739079
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "setting_id": 3,
    "tenant": 1,
    "value": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "setting_id": "string",
    "tenant": "string",
    "value": "string"
}

schema_name_id: 2810
schema_scan_id: 6664294
updated: 2024-11-05 00:41:26

Schema Scans: 15

Last at 2024-11-05 23:04:48

Scan 6674879

duration: 0:00:14.065293

exit_message:

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

id: 6674879

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_newbookinstances_settings/2024-11-05/1730866514",
        "key": "raw/newbookdev_newbookinstances_settings/2024-11-05/1730866514/instances_settings.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_settings",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17766348028719103270,
        "service_name": "drive-thru",
        "span_id": 8246883490397934626,
        "trace_id": 4258286422141376545
    }
}

running: False
schema_name_id: 2810
start_time: 2024-11-05 23:04:48
success: True
trace_id: 4258286422141376545

Scan 6674584

duration: 0:00:11.506059

exit_message:

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

id: 6674584

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_newbookinstances_settings/2024-11-05/1730866440",
        "key": "raw/newbookdev_newbookinstances_settings/2024-11-05/1730866440/instances_settings.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_settings",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11446766109209186365,
        "service_name": "drive-thru",
        "span_id": 4195670485808154776,
        "trace_id": 2479660449079042610
    }
}

running: False
schema_name_id: 2810
start_time: 2024-11-05 22:50:52
success: True
trace_id: 2479660449079042610

Scan 6673852

duration: 0:00:13.789602

exit_message:

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

id: 6673852

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_newbookinstances_settings/2024-11-05/1730866317",
        "key": "raw/newbookdev_newbookinstances_settings/2024-11-05/1730866317/instances_settings.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_settings",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16619304728932678341,
        "service_name": "drive-thru",
        "span_id": 16730355414498088099,
        "trace_id": 4372839297686008874
    }
}

running: False
schema_name_id: 2810
start_time: 2024-11-05 22:26:51
success: True
trace_id: 4372839297686008874

Scan 6672006

duration: 0:00:11.655652

exit_message:

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

id: 6672006

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_newbookinstances_settings/2024-11-04/1730785726",
        "key": "raw/newbookdev_newbookinstances_settings/2024-11-04/1730785726/instances_settings.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_settings",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9672343394607099462,
        "service_name": "drive-thru",
        "span_id": 1257235003834288824,
        "trace_id": 8113160531375728161
    }
}

running: False
schema_name_id: 2810
start_time: 2024-11-05 04:22:30
success: True
trace_id: 8113160531375728161

Scan 6671391

duration: 0:00:11.435503

exit_message:

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

id: 6671391

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_newbookinstances_settings/2024-11-04/1730785128",
        "key": "raw/newbookdev_newbookinstances_settings/2024-11-04/1730785128/instances_settings.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_settings",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1348456091074646431,
        "service_name": "drive-thru",
        "span_id": 259553111916067541,
        "trace_id": 13223228179791937893
    }
}

running: False
schema_name_id: 2810
start_time: 2024-11-05 03:51:43
success: True
trace_id: 13223228179791937893

Scan 6670618

duration: 0:00:11.357269

exit_message:

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

id: 6670618

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_newbookinstances_settings/2024-11-04/1730784822",
        "key": "raw/newbookdev_newbookinstances_settings/2024-11-04/1730784822/instances_settings.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_settings",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17709076351861716417,
        "service_name": "drive-thru",
        "span_id": 6582352629471561500,
        "trace_id": 8844935749165531338
    }
}

running: False
schema_name_id: 2810
start_time: 2024-11-05 03:28:26
success: True
trace_id: 8844935749165531338

Scan 6669335

duration: 0:00:11.268662

exit_message:

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

id: 6669335

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_newbookinstances_settings/2024-11-04/1730784218",
        "key": "raw/newbookdev_newbookinstances_settings/2024-11-04/1730784218/instances_settings.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_settings",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5470868209931180744,
        "service_name": "drive-thru",
        "span_id": 10081456879639626330,
        "trace_id": 5832613699586669802
    }
}

running: False
schema_name_id: 2810
start_time: 2024-11-05 02:54:27
success: True
trace_id: 5832613699586669802

Scan 6669195

duration: 0:00:13.817489

exit_message:

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

id: 6669195

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_newbookinstances_settings/2024-11-04/1730784056",
        "key": "raw/newbookdev_newbookinstances_settings/2024-11-04/1730784056/instances_settings.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_settings",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7544216803579563202,
        "service_name": "drive-thru",
        "span_id": 7077249720261515256,
        "trace_id": 14534320840780380059
    }
}

running: False
schema_name_id: 2810
start_time: 2024-11-05 02:50:51
success: True
trace_id: 14534320840780380059

Scan 6668674

duration: 0:00:11.440340

exit_message:

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

id: 6668674

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_newbookinstances_settings/2024-11-04/1730783901",
        "key": "raw/newbookdev_newbookinstances_settings/2024-11-04/1730783901/instances_settings.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_settings",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12833963043949362960,
        "service_name": "drive-thru",
        "span_id": 1161586801791204837,
        "trace_id": 16614374370145011355
    }
}

running: False
schema_name_id: 2810
start_time: 2024-11-05 02:37:06
success: True
trace_id: 16614374370145011355

Scan 6667938

duration: 0:00:11.388055

exit_message:

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

id: 6667938

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_newbookinstances_settings/2024-11-04/1730783770",
        "key": "raw/newbookdev_newbookinstances_settings/2024-11-04/1730783770/instances_settings.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_settings",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2617772859489289912,
        "service_name": "drive-thru",
        "span_id": 10994520095665843004,
        "trace_id": 3833624317252482412
    }
}

running: False
schema_name_id: 2810
start_time: 2024-11-05 02:17:44
success: True
trace_id: 3833624317252482412

Scan 6667259

duration: 0:00:11.242170

exit_message:

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

id: 6667259

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_newbookinstances_settings/2024-11-04/1730783667",
        "key": "raw/newbookdev_newbookinstances_settings/2024-11-04/1730783667/instances_settings.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_settings",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16767311746669100922,
        "service_name": "drive-thru",
        "span_id": 5676996547541135336,
        "trace_id": 8288143168913004527
    }
}

running: False
schema_name_id: 2810
start_time: 2024-11-05 01:59:25
success: True
trace_id: 8288143168913004527

Scan 6666340

duration: 0:00:11.371106

exit_message:

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

id: 6666340

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_newbookinstances_settings/2024-11-04/1730783526",
        "key": "raw/newbookdev_newbookinstances_settings/2024-11-04/1730783526/instances_settings.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_settings",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3847441141256177111,
        "service_name": "drive-thru",
        "span_id": 7709842936683892746,
        "trace_id": 16465026246719340393
    }
}

running: False
schema_name_id: 2810
start_time: 2024-11-05 01:35:23
success: True
trace_id: 16465026246719340393

Scan 6665657

duration: 0:00:13.937841

exit_message:

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

id: 6665657

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_newbookinstances_settings/2024-11-04/1730783308",
        "key": "raw/newbookdev_newbookinstances_settings/2024-11-04/1730783308/instances_settings.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_settings",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12345445785497610007,
        "service_name": "drive-thru",
        "span_id": 13615263910549377281,
        "trace_id": 9628520625704177577
    }
}

running: False
schema_name_id: 2810
start_time: 2024-11-05 01:17:23
success: True
trace_id: 9628520625704177577

Scan 6664792

duration: 0:00:11.393760

exit_message:

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

id: 6664792

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_newbookinstances_settings/2024-11-04/1730782909",
        "key": "raw/newbookdev_newbookinstances_settings/2024-11-04/1730782909/instances_settings.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_settings",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15291765218952459388,
        "service_name": "drive-thru",
        "span_id": 1985348173707405633,
        "trace_id": 6312817470014381664
    }
}

running: False
schema_name_id: 2810
start_time: 2024-11-05 00:54:17
success: True
trace_id: 6312817470014381664

Scan 6664294

duration: 0:00:11.430428

exit_message:

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

id: 6664294

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_newbookinstances_settings/2024-11-04/1730782807",
        "key": "raw/newbookdev_newbookinstances_settings/2024-11-04/1730782807/instances_settings.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_settings",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14276964293369357309,
        "service_name": "drive-thru",
        "span_id": 2568632300422938643,
        "trace_id": 6989777567156948544
    }
}

running: False
schema_name_id: 2810
start_time: 2024-11-05 00:41:15
success: True
trace_id: 6989777567156948544

Partitions:

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

Schema:

attributes:

{
    "id": "string",
    "newbook_region": "string",
    "setting_id": "string",
    "tenant": "string",
    "value": "string"
}

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

ddl:

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

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