Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbooklogin_settings

created: 2024-10-08 17:58:44
disabled: False
format: raw
id: 2710
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4749243

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklogin_settings/2024-11-05/1730866546
id: 4749243
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2710
schema_scan_id: 6675275
updated: 2024-11-05 23:30:38

Version 4748753

created: 2024-11-05 22:59:33

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklogin_settings/2024-11-05/1730866487
id: 4748753
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2710
schema_scan_id: 6674785
updated: 2024-11-05 22:59:44

Version 4748002

created: 2024-11-05 22:31:51

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklogin_settings/2024-11-05/1730866352
id: 4748002
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2710
schema_scan_id: 6674034
updated: 2024-11-05 22:32:02

Version 4746867

created: 2024-11-05 04:28:58

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklogin_settings/2024-11-04/1730785752
id: 4746867
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2710
schema_scan_id: 6672097
updated: 2024-11-05 04:29:12

Version 4746266

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

ddl:

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

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

raw_data:

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

schema_attributes:

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

schema_name_id: 2710
schema_scan_id: 6671487
updated: 2024-11-05 03:55:52

Version 4745545

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

ddl:

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

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

raw_data:

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

schema_attributes:

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

schema_name_id: 2710
schema_scan_id: 6670762
updated: 2024-11-05 03:32:27

Version 4744351

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

ddl:

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

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

raw_data:

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

schema_attributes:

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

schema_name_id: 2710
schema_scan_id: 6669568
updated: 2024-11-05 03:00:47

Version 4744201

created: 2024-11-05 02:56:40

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklogin_settings/2024-11-04/1730784233
id: 4744201
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2710
schema_scan_id: 6669418
updated: 2024-11-05 02:56:51

Version 4743343

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

ddl:

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

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

raw_data:

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

schema_attributes:

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

schema_name_id: 2710
schema_scan_id: 6668560
updated: 2024-11-05 02:34:19

Version 4742795

created: 2024-11-05 02:19:39

ddl:

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

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

raw_data:

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

schema_attributes:

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

schema_name_id: 2710
schema_scan_id: 6668012
updated: 2024-11-05 02:19:52

Version 4741502

created: 2024-11-05 01:45:15

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklogin_settings/2024-11-04/1730783678
id: 4741502
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2710
schema_scan_id: 6666719
updated: 2024-11-05 01:45:26

Version 4740770

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklogin_settings/2024-11-04/1730783541
id: 4740770
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2710
schema_scan_id: 6665987
updated: 2024-11-05 01:26:13

Version 4740500

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

ddl:

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

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

raw_data:

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

schema_attributes:

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

schema_name_id: 2710
schema_scan_id: 6665717
updated: 2024-11-05 01:19:09

Version 4739797

created: 2024-11-05 01:00:11

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklogin_settings/2024-11-04/1730782923
id: 4739797
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2710
schema_scan_id: 6665014
updated: 2024-11-05 01:00:24

Version 4738589

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

ddl:

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

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

raw_data:

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

schema_attributes:

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

schema_name_id: 2710
schema_scan_id: 6663802
updated: 2024-11-05 00:28:33

Schema Scans: 15

Last at 2024-11-05 23:30:24

Scan 6675275

duration: 0:00:13.974854

exit_message:

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

id: 6675275

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_newbooklogin_settings/2024-11-05/1730866546",
        "key": "raw/newbookdev_newbooklogin_settings/2024-11-05/1730866546/login_settings.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklogin_settings",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2568906366117630678,
        "service_name": "drive-thru",
        "span_id": 10457686078401775894,
        "trace_id": 11537993154375491126
    }
}

running: False
schema_name_id: 2710
start_time: 2024-11-05 23:30:24
success: True
trace_id: 11537993154375491126

Scan 6674785

duration: 0:00:11.600628

exit_message:

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

id: 6674785

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_newbooklogin_settings/2024-11-05/1730866487",
        "key": "raw/newbookdev_newbooklogin_settings/2024-11-05/1730866487/login_settings.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklogin_settings",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16374667902926789356,
        "service_name": "drive-thru",
        "span_id": 7410919118872029283,
        "trace_id": 15486981752284061895
    }
}

running: False
schema_name_id: 2710
start_time: 2024-11-05 22:59:33
success: True
trace_id: 15486981752284061895

Scan 6674034

duration: 0:00:11.492329

exit_message:

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

id: 6674034

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_newbooklogin_settings/2024-11-05/1730866352",
        "key": "raw/newbookdev_newbooklogin_settings/2024-11-05/1730866352/login_settings.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklogin_settings",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17778296405453861122,
        "service_name": "drive-thru",
        "span_id": 17249658698982873096,
        "trace_id": 1590242769877751544
    }
}

running: False
schema_name_id: 2710
start_time: 2024-11-05 22:31:50
success: True
trace_id: 1590242769877751544

Scan 6672097

duration: 0:00:14.009282

exit_message:

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

id: 6672097

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_newbooklogin_settings/2024-11-04/1730785752",
        "key": "raw/newbookdev_newbooklogin_settings/2024-11-04/1730785752/login_settings.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklogin_settings",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7072026011531647827,
        "service_name": "drive-thru",
        "span_id": 9834996545062259558,
        "trace_id": 16438949917239280114
    }
}

running: False
schema_name_id: 2710
start_time: 2024-11-05 04:28:58
success: True
trace_id: 16438949917239280114

Scan 6671487

duration: 0:00:13.984661

exit_message:

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

id: 6671487

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_newbooklogin_settings/2024-11-04/1730785141",
        "key": "raw/newbookdev_newbooklogin_settings/2024-11-04/1730785141/login_settings.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklogin_settings",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16272985497067763436,
        "service_name": "drive-thru",
        "span_id": 18164237361836728192,
        "trace_id": 3106057653634428471
    }
}

running: False
schema_name_id: 2710
start_time: 2024-11-05 03:55:38
success: True
trace_id: 3106057653634428471

Scan 6670762

duration: 0:00:11.318442

exit_message:

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

id: 6670762

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_newbooklogin_settings/2024-11-04/1730784836",
        "key": "raw/newbookdev_newbooklogin_settings/2024-11-04/1730784836/login_settings.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklogin_settings",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17494223775498966375,
        "service_name": "drive-thru",
        "span_id": 7080946831753677650,
        "trace_id": 10587246935657672737
    }
}

running: False
schema_name_id: 2710
start_time: 2024-11-05 03:32:15
success: True
trace_id: 10587246935657672737

Scan 6669568

duration: 0:00:11.359066

exit_message:

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

id: 6669568

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_newbooklogin_settings/2024-11-04/1730784070",
        "key": "raw/newbookdev_newbooklogin_settings/2024-11-04/1730784070/login_settings.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklogin_settings",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8295273610534024109,
        "service_name": "drive-thru",
        "span_id": 114670564371109597,
        "trace_id": 17589775963055464035
    }
}

running: False
schema_name_id: 2710
start_time: 2024-11-05 03:00:36
success: True
trace_id: 17589775963055464035

Scan 6669418

duration: 0:00:11.355608

exit_message:

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

id: 6669418

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_newbooklogin_settings/2024-11-04/1730784233",
        "key": "raw/newbookdev_newbooklogin_settings/2024-11-04/1730784233/login_settings.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklogin_settings",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10657695935747999333,
        "service_name": "drive-thru",
        "span_id": 15600178545516118822,
        "trace_id": 7007303782224267452
    }
}

running: False
schema_name_id: 2710
start_time: 2024-11-05 02:56:39
success: True
trace_id: 7007303782224267452

Scan 6668560

duration: 0:00:13.966420

exit_message:

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

id: 6668560

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_newbooklogin_settings/2024-11-04/1730783912",
        "key": "raw/newbookdev_newbooklogin_settings/2024-11-04/1730783912/login_settings.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklogin_settings",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5553297873781863094,
        "service_name": "drive-thru",
        "span_id": 10326321648119737121,
        "trace_id": 6540667136064842428
    }
}

running: False
schema_name_id: 2710
start_time: 2024-11-05 02:34:05
success: True
trace_id: 6540667136064842428

Scan 6668012

duration: 0:00:13.898068

exit_message:

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

id: 6668012

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_newbooklogin_settings/2024-11-04/1730783784",
        "key": "raw/newbookdev_newbooklogin_settings/2024-11-04/1730783784/login_settings.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklogin_settings",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 57316207819938586,
        "service_name": "drive-thru",
        "span_id": 8931429368175731823,
        "trace_id": 1846728834474374060
    }
}

running: False
schema_name_id: 2710
start_time: 2024-11-05 02:19:39
success: True
trace_id: 1846728834474374060

Scan 6666719

duration: 0:00:11.447777

exit_message:

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

id: 6666719

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_newbooklogin_settings/2024-11-04/1730783678",
        "key": "raw/newbookdev_newbooklogin_settings/2024-11-04/1730783678/login_settings.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklogin_settings",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15368113202172522490,
        "service_name": "drive-thru",
        "span_id": 4066410631857165535,
        "trace_id": 3493997774823858559
    }
}

running: False
schema_name_id: 2710
start_time: 2024-11-05 01:45:15
success: True
trace_id: 3493997774823858559

Scan 6665987

duration: 0:00:11.461858

exit_message:

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

id: 6665987

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_newbooklogin_settings/2024-11-04/1730783541",
        "key": "raw/newbookdev_newbooklogin_settings/2024-11-04/1730783541/login_settings.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklogin_settings",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12375341866821909606,
        "service_name": "drive-thru",
        "span_id": 13170492900558646950,
        "trace_id": 559646993365460310
    }
}

running: False
schema_name_id: 2710
start_time: 2024-11-05 01:26:02
success: True
trace_id: 559646993365460310

Scan 6665717

duration: 0:00:13.929828

exit_message:

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

id: 6665717

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_newbooklogin_settings/2024-11-04/1730783322",
        "key": "raw/newbookdev_newbooklogin_settings/2024-11-04/1730783322/login_settings.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklogin_settings",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2339406007270964376,
        "service_name": "drive-thru",
        "span_id": 13923641148307498477,
        "trace_id": 10841055851939893460
    }
}

running: False
schema_name_id: 2710
start_time: 2024-11-05 01:18:55
success: True
trace_id: 10841055851939893460

Scan 6665014

duration: 0:00:13.958367

exit_message:

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

id: 6665014

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_newbooklogin_settings/2024-11-04/1730782923",
        "key": "raw/newbookdev_newbooklogin_settings/2024-11-04/1730782923/login_settings.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklogin_settings",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16044709126026417373,
        "service_name": "drive-thru",
        "span_id": 5217034532491484923,
        "trace_id": 2529642306409522976
    }
}

running: False
schema_name_id: 2710
start_time: 2024-11-05 01:00:10
success: True
trace_id: 2529642306409522976

Scan 6663802

duration: 0:00:11.437236

exit_message:

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

id: 6663802

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_newbooklogin_settings/2024-11-04/1730782755",
        "key": "raw/newbookdev_newbooklogin_settings/2024-11-04/1730782755/login_settings.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklogin_settings",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7488159307276022237,
        "service_name": "drive-thru",
        "span_id": 15128626139640907760,
        "trace_id": 17473152027017043456
    }
}

running: False
schema_name_id: 2710
start_time: 2024-11-05 00:28:21
success: True
trace_id: 17473152027017043456

Partitions:

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

Schema:

attributes:

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

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

ddl:

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