Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookusers_default_settings_software_types

created: 2024-10-08 18:38:50
disabled: False
format: raw
id: 3087
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4749526

created: 2024-11-06 00:01:32

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_default_settings_software_types/2024-11-05/1730866628
id: 4749526
processed: 1

raw_data:

{
    "active": 5,
    "id": 2,
    "newbook_region": 0,
    "setting_id": 3,
    "software_type": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "newbook_region": "string",
    "setting_id": "string",
    "software_type": "string",
    "tenant": "string"
}

schema_name_id: 3087
schema_scan_id: 6675648
updated: 2024-11-06 00:01:43

Version 4749412

created: 2024-11-05 23:47:56

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_default_settings_software_types/2024-11-05/1730866590
id: 4749412
processed: 1

raw_data:

{
    "active": 5,
    "id": 2,
    "newbook_region": 0,
    "setting_id": 3,
    "software_type": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "newbook_region": "string",
    "setting_id": "string",
    "software_type": "string",
    "tenant": "string"
}

schema_name_id: 3087
schema_scan_id: 6675451
updated: 2024-11-05 23:48:09

Version 4748864

created: 2024-11-05 23:05:45

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_default_settings_software_types/2024-11-05/1730866494
id: 4748864
processed: 1

raw_data:

{
    "active": 5,
    "id": 2,
    "newbook_region": 0,
    "setting_id": 3,
    "software_type": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "newbook_region": "string",
    "setting_id": "string",
    "software_type": "string",
    "tenant": "string"
}

schema_name_id: 3087
schema_scan_id: 6674896
updated: 2024-11-05 23:05:59

Version 4747193

created: 2024-11-05 05:00:19

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_default_settings_software_types/2024-11-04/1730785828
id: 4747193
processed: 1

raw_data:

{
    "active": 5,
    "id": 2,
    "newbook_region": 0,
    "setting_id": 3,
    "software_type": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "newbook_region": "string",
    "setting_id": "string",
    "software_type": "string",
    "tenant": "string"
}

schema_name_id: 3087
schema_scan_id: 6672425
updated: 2024-11-05 05:00:30

Version 4745861

created: 2024-11-05 03:41:14

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_default_settings_software_types/2024-11-04/1730785184
id: 4745861
processed: 1

raw_data:

{
    "active": 5,
    "id": 2,
    "newbook_region": 0,
    "setting_id": 3,
    "software_type": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "newbook_region": "string",
    "setting_id": "string",
    "software_type": "string",
    "tenant": "string"
}

schema_name_id: 3087
schema_scan_id: 6671078
updated: 2024-11-05 03:41:28

Version 4745853

created: 2024-11-05 03:40:58

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_default_settings_software_types/2024-11-04/1730784880
id: 4745853
processed: 1

raw_data:

{
    "active": 5,
    "id": 2,
    "newbook_region": 0,
    "setting_id": 3,
    "software_type": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "newbook_region": "string",
    "setting_id": "string",
    "software_type": "string",
    "tenant": "string"
}

schema_name_id: 3087
schema_scan_id: 6671070
updated: 2024-11-05 03:41:09

Version 4745305

created: 2024-11-05 03:25:59

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_default_settings_software_types/2024-11-04/1730784275
id: 4745305
processed: 1

raw_data:

{
    "active": 5,
    "id": 2,
    "newbook_region": 0,
    "setting_id": 3,
    "software_type": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "newbook_region": "string",
    "setting_id": "string",
    "software_type": "string",
    "tenant": "string"
}

schema_name_id: 3087
schema_scan_id: 6670522
updated: 2024-11-05 03:26:12

Version 4743837

created: 2024-11-05 02:47:09

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_default_settings_software_types/2024-11-04/1730784114
id: 4743837
processed: 1

raw_data:

{
    "active": 5,
    "id": 2,
    "newbook_region": 0,
    "setting_id": 3,
    "software_type": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "newbook_region": "string",
    "setting_id": "string",
    "software_type": "string",
    "tenant": "string"
}

schema_name_id: 3087
schema_scan_id: 6669054
updated: 2024-11-05 02:47:20

Version 4743200

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_default_settings_software_types/2024-11-04/1730783859
id: 4743200
processed: 1

raw_data:

{
    "active": 5,
    "id": 2,
    "newbook_region": 0,
    "setting_id": 3,
    "software_type": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "newbook_region": "string",
    "setting_id": "string",
    "software_type": "string",
    "tenant": "string"
}

schema_name_id: 3087
schema_scan_id: 6668417
updated: 2024-11-05 02:30:26

Version 4742832

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_default_settings_software_types/2024-11-04/1730783827
id: 4742832
processed: 1

raw_data:

{
    "active": 5,
    "id": 2,
    "newbook_region": 0,
    "setting_id": 3,
    "software_type": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "newbook_region": "string",
    "setting_id": "string",
    "software_type": "string",
    "tenant": "string"
}

schema_name_id: 3087
schema_scan_id: 6668049
updated: 2024-11-05 02:20:49

Version 4742103

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_default_settings_software_types/2024-11-04/1730783710
id: 4742103
processed: 1

raw_data:

{
    "active": 5,
    "id": 2,
    "newbook_region": 0,
    "setting_id": 3,
    "software_type": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "newbook_region": "string",
    "setting_id": "string",
    "software_type": "string",
    "tenant": "string"
}

schema_name_id: 3087
schema_scan_id: 6667320
updated: 2024-11-05 02:01:20

Version 4741590

created: 2024-11-05 01:47:36

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_default_settings_software_types/2024-11-04/1730783585
id: 4741590
processed: 1

raw_data:

{
    "active": 5,
    "id": 2,
    "newbook_region": 0,
    "setting_id": 3,
    "software_type": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "newbook_region": "string",
    "setting_id": "string",
    "software_type": "string",
    "tenant": "string"
}

schema_name_id: 3087
schema_scan_id: 6666807
updated: 2024-11-05 01:47:49

Version 4740356

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_default_settings_software_types/2024-11-04/1730783366
id: 4740356
processed: 1

raw_data:

{
    "active": 5,
    "id": 2,
    "newbook_region": 0,
    "setting_id": 3,
    "software_type": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "newbook_region": "string",
    "setting_id": "string",
    "software_type": "string",
    "tenant": "string"
}

schema_name_id: 3087
schema_scan_id: 6665573
updated: 2024-11-05 01:15:21

Version 4740027

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_default_settings_software_types/2024-11-04/1730782963
id: 4740027
processed: 1

raw_data:

{
    "active": 5,
    "id": 2,
    "newbook_region": 0,
    "setting_id": 3,
    "software_type": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "newbook_region": "string",
    "setting_id": "string",
    "software_type": "string",
    "tenant": "string"
}

schema_name_id: 3087
schema_scan_id: 6665244
updated: 2024-11-05 01:06:35

Version 4739155

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_default_settings_software_types/2024-11-04/1730782849
id: 4739155
processed: 1

raw_data:

{
    "active": 5,
    "id": 2,
    "newbook_region": 0,
    "setting_id": 3,
    "software_type": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "newbook_region": "string",
    "setting_id": "string",
    "software_type": "string",
    "tenant": "string"
}

schema_name_id: 3087
schema_scan_id: 6664371
updated: 2024-11-05 00:43:26

Schema Scans: 15

Last at 2024-11-06 00:01:31

Scan 6675648

duration: 0:00:11.487357

exit_message:

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

id: 6675648

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_newbookusers_default_settings_software_types/2024-11-05/1730866628",
        "key": "raw/newbookdev_newbookusers_default_settings_software_types/2024-11-05/1730866628/users_default_settings_software_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_default_settings_software_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17775948589745687941,
        "service_name": "drive-thru",
        "span_id": 190859876126706046,
        "trace_id": 515492004416270071
    }
}

running: False
schema_name_id: 3087
start_time: 2024-11-06 00:01:31
success: True
trace_id: 515492004416270071

Scan 6675451

duration: 0:00:14.054191

exit_message:

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

id: 6675451

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_newbookusers_default_settings_software_types/2024-11-05/1730866590",
        "key": "raw/newbookdev_newbookusers_default_settings_software_types/2024-11-05/1730866590/users_default_settings_software_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_default_settings_software_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3451704827944195382,
        "service_name": "drive-thru",
        "span_id": 5900831130715294817,
        "trace_id": 1924074729377043169
    }
}

running: False
schema_name_id: 3087
start_time: 2024-11-05 23:47:55
success: True
trace_id: 1924074729377043169

Scan 6674896

duration: 0:00:13.997363

exit_message:

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

id: 6674896

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_newbookusers_default_settings_software_types/2024-11-05/1730866494",
        "key": "raw/newbookdev_newbookusers_default_settings_software_types/2024-11-05/1730866494/users_default_settings_software_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_default_settings_software_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 620401447791119,
        "service_name": "drive-thru",
        "span_id": 1057928915201187539,
        "trace_id": 11181673977426598272
    }
}

running: False
schema_name_id: 3087
start_time: 2024-11-05 23:05:45
success: True
trace_id: 11181673977426598272

Scan 6672425

duration: 0:00:11.462218

exit_message:

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

id: 6672425

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_newbookusers_default_settings_software_types/2024-11-04/1730785828",
        "key": "raw/newbookdev_newbookusers_default_settings_software_types/2024-11-04/1730785828/users_default_settings_software_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_default_settings_software_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8726709998293187396,
        "service_name": "drive-thru",
        "span_id": 12566936322661232662,
        "trace_id": 9043667606694517502
    }
}

running: False
schema_name_id: 3087
start_time: 2024-11-05 05:00:18
success: True
trace_id: 9043667606694517502

Scan 6671078

duration: 0:00:13.944431

exit_message:

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

id: 6671078

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_newbookusers_default_settings_software_types/2024-11-04/1730785184",
        "key": "raw/newbookdev_newbookusers_default_settings_software_types/2024-11-04/1730785184/users_default_settings_software_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_default_settings_software_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1513036627864622312,
        "service_name": "drive-thru",
        "span_id": 8712472643111674106,
        "trace_id": 5774622911690395578
    }
}

running: False
schema_name_id: 3087
start_time: 2024-11-05 03:41:14
success: True
trace_id: 5774622911690395578

Scan 6671070

duration: 0:00:11.517027

exit_message:

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

id: 6671070

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_newbookusers_default_settings_software_types/2024-11-04/1730784880",
        "key": "raw/newbookdev_newbookusers_default_settings_software_types/2024-11-04/1730784880/users_default_settings_software_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_default_settings_software_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7242153105152504363,
        "service_name": "drive-thru",
        "span_id": 12307992120879365067,
        "trace_id": 13703846091868192309
    }
}

running: False
schema_name_id: 3087
start_time: 2024-11-05 03:40:57
success: True
trace_id: 13703846091868192309

Scan 6670522

duration: 0:00:13.850633

exit_message:

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

id: 6670522

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_newbookusers_default_settings_software_types/2024-11-04/1730784275",
        "key": "raw/newbookdev_newbookusers_default_settings_software_types/2024-11-04/1730784275/users_default_settings_software_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_default_settings_software_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3549871136939460796,
        "service_name": "drive-thru",
        "span_id": 11966354012818435563,
        "trace_id": 2802289286147430021
    }
}

running: False
schema_name_id: 3087
start_time: 2024-11-05 03:25:58
success: True
trace_id: 2802289286147430021

Scan 6669054

duration: 0:00:11.428924

exit_message:

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

id: 6669054

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_newbookusers_default_settings_software_types/2024-11-04/1730784114",
        "key": "raw/newbookdev_newbookusers_default_settings_software_types/2024-11-04/1730784114/users_default_settings_software_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_default_settings_software_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3018005876897177079,
        "service_name": "drive-thru",
        "span_id": 16760343021696739048,
        "trace_id": 15874008998597407509
    }
}

running: False
schema_name_id: 3087
start_time: 2024-11-05 02:47:09
success: True
trace_id: 15874008998597407509

Scan 6668417

duration: 0:00:13.886203

exit_message:

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

id: 6668417

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_newbookusers_default_settings_software_types/2024-11-04/1730783859",
        "key": "raw/newbookdev_newbookusers_default_settings_software_types/2024-11-04/1730783859/users_default_settings_software_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_default_settings_software_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12140190906173562949,
        "service_name": "drive-thru",
        "span_id": 1848546481812778923,
        "trace_id": 10814030843573827991
    }
}

running: False
schema_name_id: 3087
start_time: 2024-11-05 02:30:12
success: True
trace_id: 10814030843573827991

Scan 6668049

duration: 0:00:11.385711

exit_message:

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

id: 6668049

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_newbookusers_default_settings_software_types/2024-11-04/1730783827",
        "key": "raw/newbookdev_newbookusers_default_settings_software_types/2024-11-04/1730783827/users_default_settings_software_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_default_settings_software_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5321870024365053429,
        "service_name": "drive-thru",
        "span_id": 16377829549855631362,
        "trace_id": 14157671960357444665
    }
}

running: False
schema_name_id: 3087
start_time: 2024-11-05 02:20:37
success: True
trace_id: 14157671960357444665

Scan 6667320

duration: 0:00:11.322980

exit_message:

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

id: 6667320

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_newbookusers_default_settings_software_types/2024-11-04/1730783710",
        "key": "raw/newbookdev_newbookusers_default_settings_software_types/2024-11-04/1730783710/users_default_settings_software_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_default_settings_software_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13270330769974261867,
        "service_name": "drive-thru",
        "span_id": 11072819907343153415,
        "trace_id": 17603592086599370037
    }
}

running: False
schema_name_id: 3087
start_time: 2024-11-05 02:01:09
success: True
trace_id: 17603592086599370037

Scan 6666807

duration: 0:00:13.953997

exit_message:

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

id: 6666807

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_newbookusers_default_settings_software_types/2024-11-04/1730783585",
        "key": "raw/newbookdev_newbookusers_default_settings_software_types/2024-11-04/1730783585/users_default_settings_software_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_default_settings_software_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 357637117557283392,
        "service_name": "drive-thru",
        "span_id": 15016433612490053968,
        "trace_id": 24515022870949384
    }
}

running: False
schema_name_id: 3087
start_time: 2024-11-05 01:47:35
success: True
trace_id: 24515022870949384

Scan 6665573

duration: 0:00:11.564803

exit_message:

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

id: 6665573

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_newbookusers_default_settings_software_types/2024-11-04/1730783366",
        "key": "raw/newbookdev_newbookusers_default_settings_software_types/2024-11-04/1730783366/users_default_settings_software_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_default_settings_software_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2270754741452391441,
        "service_name": "drive-thru",
        "span_id": 13803523030897335585,
        "trace_id": 13120327080885678966
    }
}

running: False
schema_name_id: 3087
start_time: 2024-11-05 01:15:09
success: True
trace_id: 13120327080885678966

Scan 6665244

duration: 0:00:11.354518

exit_message:

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

id: 6665244

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_newbookusers_default_settings_software_types/2024-11-04/1730782963",
        "key": "raw/newbookdev_newbookusers_default_settings_software_types/2024-11-04/1730782963/users_default_settings_software_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_default_settings_software_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17583625235943074395,
        "service_name": "drive-thru",
        "span_id": 1246053892430394921,
        "trace_id": 6711309770642587285
    }
}

running: False
schema_name_id: 3087
start_time: 2024-11-05 01:06:24
success: True
trace_id: 6711309770642587285

Scan 6664371

duration: 0:00:11.486418

exit_message:

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

id: 6664371

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_newbookusers_default_settings_software_types/2024-11-04/1730782849",
        "key": "raw/newbookdev_newbookusers_default_settings_software_types/2024-11-04/1730782849/users_default_settings_software_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_default_settings_software_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18333552193870517222,
        "service_name": "drive-thru",
        "span_id": 15468016191347074702,
        "trace_id": 6858306506363298706
    }
}

running: False
schema_name_id: 3087
start_time: 2024-11-05 00:43:15
success: True
trace_id: 6858306506363298706

Partitions:

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

Schema:

attributes:

{
    "active": "string",
    "id": "string",
    "newbook_region": "string",
    "setting_id": "string",
    "software_type": "string",
    "tenant": "string"
}

created: 2024-11-06 00:01:32

ddl:

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

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