Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbooklogin_default_settings

created: 2024-10-08 18:10:15
disabled: False
format: raw
id: 2823
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4749030

created: 2024-11-05 23:15:16

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooklogin_default_settings`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooklogin_default_settings`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `description`  string , `tooltip`  string , `group`  string , `default_value`  string , `setting_type`  string , `autoload`  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_default_settings/2024-11-05/1730866546'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooklogin_default_settings"
]

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

raw_data:

{
    "autoload": 9,
    "default_value": 7,
    "description": 4,
    "group": 6,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "setting_type": 8,
    "tenant": 1,
    "tooltip": 5
}

schema_attributes:

{
    "autoload": "string",
    "default_value": "string",
    "description": "string",
    "group": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "setting_type": "string",
    "tenant": "string",
    "tooltip": "string"
}

schema_name_id: 2823
schema_scan_id: 6675062
updated: 2024-11-05 23:15:30

Version 4748827

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooklogin_default_settings`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooklogin_default_settings`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `description`  string , `tooltip`  string , `group`  string , `default_value`  string , `setting_type`  string , `autoload`  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_default_settings/2024-11-05/1730866486'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooklogin_default_settings"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklogin_default_settings/2024-11-05/1730866486
id: 4748827
processed: 1

raw_data:

{
    "autoload": 9,
    "default_value": 7,
    "description": 4,
    "group": 6,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "setting_type": 8,
    "tenant": 1,
    "tooltip": 5
}

schema_attributes:

{
    "autoload": "string",
    "default_value": "string",
    "description": "string",
    "group": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "setting_type": "string",
    "tenant": "string",
    "tooltip": "string"
}

schema_name_id: 2823
schema_scan_id: 6674859
updated: 2024-11-05 23:03:54

Version 4747863

created: 2024-11-05 22:27:57

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooklogin_default_settings`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooklogin_default_settings`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `description`  string , `tooltip`  string , `group`  string , `default_value`  string , `setting_type`  string , `autoload`  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_default_settings/2024-11-05/1730866351'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooklogin_default_settings"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklogin_default_settings/2024-11-05/1730866351
id: 4747863
processed: 1

raw_data:

{
    "autoload": 9,
    "default_value": 7,
    "description": 4,
    "group": 6,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "setting_type": 8,
    "tenant": 1,
    "tooltip": 5
}

schema_attributes:

{
    "autoload": "string",
    "default_value": "string",
    "description": "string",
    "group": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "setting_type": "string",
    "tenant": "string",
    "tooltip": "string"
}

schema_name_id: 2823
schema_scan_id: 6673895
updated: 2024-11-05 22:28:08

Version 4746989

created: 2024-11-05 04:38:27

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooklogin_default_settings`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooklogin_default_settings`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `description`  string , `tooltip`  string , `group`  string , `default_value`  string , `setting_type`  string , `autoload`  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_default_settings/2024-11-04/1730785751'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooklogin_default_settings"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklogin_default_settings/2024-11-04/1730785751
id: 4746989
processed: 1

raw_data:

{
    "autoload": 9,
    "default_value": 7,
    "description": 4,
    "group": 6,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "setting_type": 8,
    "tenant": 1,
    "tooltip": 5
}

schema_attributes:

{
    "autoload": "string",
    "default_value": "string",
    "description": "string",
    "group": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "setting_type": "string",
    "tenant": "string",
    "tooltip": "string"
}

schema_name_id: 2823
schema_scan_id: 6672220
updated: 2024-11-05 04:38:41

Version 4746264

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooklogin_default_settings`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooklogin_default_settings`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `description`  string , `tooltip`  string , `group`  string , `default_value`  string , `setting_type`  string , `autoload`  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_default_settings/2024-11-04/1730785141'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooklogin_default_settings"
]

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

raw_data:

{
    "autoload": 9,
    "default_value": 7,
    "description": 4,
    "group": 6,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "setting_type": 8,
    "tenant": 1,
    "tooltip": 5
}

schema_attributes:

{
    "autoload": "string",
    "default_value": "string",
    "description": "string",
    "group": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "setting_type": "string",
    "tenant": "string",
    "tooltip": "string"
}

schema_name_id: 2823
schema_scan_id: 6671485
updated: 2024-11-05 03:55:44

Version 4745464

created: 2024-11-05 03:30:07

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooklogin_default_settings`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooklogin_default_settings`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `description`  string , `tooltip`  string , `group`  string , `default_value`  string , `setting_type`  string , `autoload`  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_default_settings/2024-11-04/1730784836'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooklogin_default_settings"
]

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

raw_data:

{
    "autoload": 9,
    "default_value": 7,
    "description": 4,
    "group": 6,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "setting_type": 8,
    "tenant": 1,
    "tooltip": 5
}

schema_attributes:

{
    "autoload": "string",
    "default_value": "string",
    "description": "string",
    "group": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "setting_type": "string",
    "tenant": "string",
    "tooltip": "string"
}

schema_name_id: 2823
schema_scan_id: 6670681
updated: 2024-11-05 03:30:21

Version 4745296

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooklogin_default_settings`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooklogin_default_settings`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `description`  string , `tooltip`  string , `group`  string , `default_value`  string , `setting_type`  string , `autoload`  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_default_settings/2024-11-04/1730784232'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooklogin_default_settings"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklogin_default_settings/2024-11-04/1730784232
id: 4745296
processed: 1

raw_data:

{
    "autoload": 9,
    "default_value": 7,
    "description": 4,
    "group": 6,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "setting_type": 8,
    "tenant": 1,
    "tooltip": 5
}

schema_attributes:

{
    "autoload": "string",
    "default_value": "string",
    "description": "string",
    "group": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "setting_type": "string",
    "tenant": "string",
    "tooltip": "string"
}

schema_name_id: 2823
schema_scan_id: 6670513
updated: 2024-11-05 03:25:56

Version 4743522

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooklogin_default_settings`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooklogin_default_settings`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `description`  string , `tooltip`  string , `group`  string , `default_value`  string , `setting_type`  string , `autoload`  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_default_settings/2024-11-04/1730784070'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooklogin_default_settings"
]

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

raw_data:

{
    "autoload": 9,
    "default_value": 7,
    "description": 4,
    "group": 6,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "setting_type": 8,
    "tenant": 1,
    "tooltip": 5
}

schema_attributes:

{
    "autoload": "string",
    "default_value": "string",
    "description": "string",
    "group": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "setting_type": "string",
    "tenant": "string",
    "tooltip": "string"
}

schema_name_id: 2823
schema_scan_id: 6668739
updated: 2024-11-05 02:38:59

Version 4743336

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooklogin_default_settings`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooklogin_default_settings`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `description`  string , `tooltip`  string , `group`  string , `default_value`  string , `setting_type`  string , `autoload`  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_default_settings/2024-11-04/1730783911'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooklogin_default_settings"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklogin_default_settings/2024-11-04/1730783911
id: 4743336
processed: 1

raw_data:

{
    "autoload": 9,
    "default_value": 7,
    "description": 4,
    "group": 6,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "setting_type": 8,
    "tenant": 1,
    "tooltip": 5
}

schema_attributes:

{
    "autoload": "string",
    "default_value": "string",
    "description": "string",
    "group": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "setting_type": "string",
    "tenant": "string",
    "tooltip": "string"
}

schema_name_id: 2823
schema_scan_id: 6668553
updated: 2024-11-05 02:34:05

Version 4742806

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooklogin_default_settings`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooklogin_default_settings`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `description`  string , `tooltip`  string , `group`  string , `default_value`  string , `setting_type`  string , `autoload`  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_default_settings/2024-11-04/1730783784'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooklogin_default_settings"
]

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

raw_data:

{
    "autoload": 9,
    "default_value": 7,
    "description": 4,
    "group": 6,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "setting_type": 8,
    "tenant": 1,
    "tooltip": 5
}

schema_attributes:

{
    "autoload": "string",
    "default_value": "string",
    "description": "string",
    "group": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "setting_type": "string",
    "tenant": "string",
    "tooltip": "string"
}

schema_name_id: 2823
schema_scan_id: 6668023
updated: 2024-11-05 02:20:08

Version 4741993

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooklogin_default_settings`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooklogin_default_settings`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `description`  string , `tooltip`  string , `group`  string , `default_value`  string , `setting_type`  string , `autoload`  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_default_settings/2024-11-04/1730783677'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooklogin_default_settings"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklogin_default_settings/2024-11-04/1730783677
id: 4741993
processed: 1

raw_data:

{
    "autoload": 9,
    "default_value": 7,
    "description": 4,
    "group": 6,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "setting_type": 8,
    "tenant": 1,
    "tooltip": 5
}

schema_attributes:

{
    "autoload": "string",
    "default_value": "string",
    "description": "string",
    "group": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "setting_type": "string",
    "tenant": "string",
    "tooltip": "string"
}

schema_name_id: 2823
schema_scan_id: 6667210
updated: 2024-11-05 01:58:22

Version 4741122

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooklogin_default_settings`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooklogin_default_settings`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `description`  string , `tooltip`  string , `group`  string , `default_value`  string , `setting_type`  string , `autoload`  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_default_settings/2024-11-04/1730783540'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooklogin_default_settings"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklogin_default_settings/2024-11-04/1730783540
id: 4741122
processed: 1

raw_data:

{
    "autoload": 9,
    "default_value": 7,
    "description": 4,
    "group": 6,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "setting_type": 8,
    "tenant": 1,
    "tooltip": 5
}

schema_attributes:

{
    "autoload": "string",
    "default_value": "string",
    "description": "string",
    "group": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "setting_type": "string",
    "tenant": "string",
    "tooltip": "string"
}

schema_name_id: 2823
schema_scan_id: 6666339
updated: 2024-11-05 01:35:35

Version 4740487

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooklogin_default_settings`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooklogin_default_settings`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `description`  string , `tooltip`  string , `group`  string , `default_value`  string , `setting_type`  string , `autoload`  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_default_settings/2024-11-04/1730783322'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooklogin_default_settings"
]

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

raw_data:

{
    "autoload": 9,
    "default_value": 7,
    "description": 4,
    "group": 6,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "setting_type": 8,
    "tenant": 1,
    "tooltip": 5
}

schema_attributes:

{
    "autoload": "string",
    "default_value": "string",
    "description": "string",
    "group": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "setting_type": "string",
    "tenant": "string",
    "tooltip": "string"
}

schema_name_id: 2823
schema_scan_id: 6665704
updated: 2024-11-05 01:18:50

Version 4739706

created: 2024-11-05 00:57:45

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooklogin_default_settings`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooklogin_default_settings`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `description`  string , `tooltip`  string , `group`  string , `default_value`  string , `setting_type`  string , `autoload`  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_default_settings/2024-11-04/1730782966'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooklogin_default_settings"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklogin_default_settings/2024-11-04/1730782966
id: 4739706
processed: 1

raw_data:

{
    "autoload": 9,
    "default_value": 7,
    "description": 4,
    "group": 6,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "setting_type": 8,
    "tenant": 1,
    "tooltip": 5
}

schema_attributes:

{
    "autoload": "string",
    "default_value": "string",
    "description": "string",
    "group": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "setting_type": "string",
    "tenant": "string",
    "tooltip": "string"
}

schema_name_id: 2823
schema_scan_id: 6664923
updated: 2024-11-05 00:57:58

Version 4739056

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooklogin_default_settings`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooklogin_default_settings`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `description`  string , `tooltip`  string , `group`  string , `default_value`  string , `setting_type`  string , `autoload`  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_default_settings/2024-11-04/1730782817'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooklogin_default_settings"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklogin_default_settings/2024-11-04/1730782817
id: 4739056
processed: 1

raw_data:

{
    "autoload": 9,
    "default_value": 7,
    "description": 4,
    "group": 6,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "setting_type": 8,
    "tenant": 1,
    "tooltip": 5
}

schema_attributes:

{
    "autoload": "string",
    "default_value": "string",
    "description": "string",
    "group": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "setting_type": "string",
    "tenant": "string",
    "tooltip": "string"
}

schema_name_id: 2823
schema_scan_id: 6664271
updated: 2024-11-05 00:40:50

Schema Scans: 15

Last at 2024-11-05 23:15:16

Scan 6675062

duration: 0:00:14.072162

exit_message:

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

id: 6675062

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_default_settings/2024-11-05/1730866546",
        "key": "raw/newbookdev_newbooklogin_default_settings/2024-11-05/1730866546/login_default_settings.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklogin_default_settings",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12145474288870989059,
        "service_name": "drive-thru",
        "span_id": 16571136700122783373,
        "trace_id": 434197839117964468
    }
}

running: False
schema_name_id: 2823
start_time: 2024-11-05 23:15:16
success: True
trace_id: 434197839117964468

Scan 6674859

duration: 0:00:14.242927

exit_message:

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

id: 6674859

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_default_settings/2024-11-05/1730866486",
        "key": "raw/newbookdev_newbooklogin_default_settings/2024-11-05/1730866486/login_default_settings.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklogin_default_settings",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14880477313694760275,
        "service_name": "drive-thru",
        "span_id": 11055837649515093397,
        "trace_id": 1954377302860369862
    }
}

running: False
schema_name_id: 2823
start_time: 2024-11-05 23:03:40
success: True
trace_id: 1954377302860369862

Scan 6673895

duration: 0:00:11.543647

exit_message:

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

id: 6673895

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_default_settings/2024-11-05/1730866351",
        "key": "raw/newbookdev_newbooklogin_default_settings/2024-11-05/1730866351/login_default_settings.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklogin_default_settings",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14165741311164738006,
        "service_name": "drive-thru",
        "span_id": 10637584840041774824,
        "trace_id": 13364353071158761049
    }
}

running: False
schema_name_id: 2823
start_time: 2024-11-05 22:27:57
success: True
trace_id: 13364353071158761049

Scan 6672220

duration: 0:00:14.221598

exit_message:

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

id: 6672220

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_default_settings/2024-11-04/1730785751",
        "key": "raw/newbookdev_newbooklogin_default_settings/2024-11-04/1730785751/login_default_settings.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklogin_default_settings",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18409941138465225185,
        "service_name": "drive-thru",
        "span_id": 14074643609594443779,
        "trace_id": 5421165928832918798
    }
}

running: False
schema_name_id: 2823
start_time: 2024-11-05 04:38:26
success: True
trace_id: 5421165928832918798

Scan 6671485

duration: 0:00:11.697267

exit_message:

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

id: 6671485

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_default_settings/2024-11-04/1730785141",
        "key": "raw/newbookdev_newbooklogin_default_settings/2024-11-04/1730785141/login_default_settings.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklogin_default_settings",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16442567826579896836,
        "service_name": "drive-thru",
        "span_id": 15070860555387925165,
        "trace_id": 8053825335384925170
    }
}

running: False
schema_name_id: 2823
start_time: 2024-11-05 03:55:32
success: True
trace_id: 8053825335384925170

Scan 6670681

duration: 0:00:13.867771

exit_message:

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

id: 6670681

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_default_settings/2024-11-04/1730784836",
        "key": "raw/newbookdev_newbooklogin_default_settings/2024-11-04/1730784836/login_default_settings.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklogin_default_settings",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5584804536815008696,
        "service_name": "drive-thru",
        "span_id": 7800260083898496837,
        "trace_id": 16221585687889472918
    }
}

running: False
schema_name_id: 2823
start_time: 2024-11-05 03:30:07
success: True
trace_id: 16221585687889472918

Scan 6670513

duration: 0:00:11.606132

exit_message:

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

id: 6670513

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_default_settings/2024-11-04/1730784232",
        "key": "raw/newbookdev_newbooklogin_default_settings/2024-11-04/1730784232/login_default_settings.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklogin_default_settings",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9323989908580421005,
        "service_name": "drive-thru",
        "span_id": 14322877222290244722,
        "trace_id": 8978010192337504271
    }
}

running: False
schema_name_id: 2823
start_time: 2024-11-05 03:25:44
success: True
trace_id: 8978010192337504271

Scan 6668739

duration: 0:00:11.471495

exit_message:

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

id: 6668739

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_default_settings/2024-11-04/1730784070",
        "key": "raw/newbookdev_newbooklogin_default_settings/2024-11-04/1730784070/login_default_settings.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklogin_default_settings",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 499083885379224070,
        "service_name": "drive-thru",
        "span_id": 1605664557652570383,
        "trace_id": 14569000279176795438
    }
}

running: False
schema_name_id: 2823
start_time: 2024-11-05 02:38:48
success: True
trace_id: 14569000279176795438

Scan 6668553

duration: 0:00:11.556843

exit_message:

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

id: 6668553

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_default_settings/2024-11-04/1730783911",
        "key": "raw/newbookdev_newbooklogin_default_settings/2024-11-04/1730783911/login_default_settings.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklogin_default_settings",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5006693104040505733,
        "service_name": "drive-thru",
        "span_id": 9529699668043240905,
        "trace_id": 15870134375245060684
    }
}

running: False
schema_name_id: 2823
start_time: 2024-11-05 02:33:54
success: True
trace_id: 15870134375245060684

Scan 6668023

duration: 0:00:14.091149

exit_message:

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

id: 6668023

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_default_settings/2024-11-04/1730783784",
        "key": "raw/newbookdev_newbooklogin_default_settings/2024-11-04/1730783784/login_default_settings.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklogin_default_settings",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15765736115498617389,
        "service_name": "drive-thru",
        "span_id": 1618635889566232728,
        "trace_id": 17141017080294586109
    }
}

running: False
schema_name_id: 2823
start_time: 2024-11-05 02:19:54
success: True
trace_id: 17141017080294586109

Scan 6667210

duration: 0:00:13.971828

exit_message:

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

id: 6667210

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_default_settings/2024-11-04/1730783677",
        "key": "raw/newbookdev_newbooklogin_default_settings/2024-11-04/1730783677/login_default_settings.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklogin_default_settings",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2211738170244927086,
        "service_name": "drive-thru",
        "span_id": 3080563097480930200,
        "trace_id": 4752703041545103005
    }
}

running: False
schema_name_id: 2823
start_time: 2024-11-05 01:58:08
success: True
trace_id: 4752703041545103005

Scan 6666339

duration: 0:00:14.088271

exit_message:

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

id: 6666339

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_default_settings/2024-11-04/1730783540",
        "key": "raw/newbookdev_newbooklogin_default_settings/2024-11-04/1730783540/login_default_settings.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklogin_default_settings",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5992731597282478058,
        "service_name": "drive-thru",
        "span_id": 9482621928119236233,
        "trace_id": 2170683249381109213
    }
}

running: False
schema_name_id: 2823
start_time: 2024-11-05 01:35:21
success: True
trace_id: 2170683249381109213

Scan 6665704

duration: 0:00:13.981273

exit_message:

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

id: 6665704

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_default_settings/2024-11-04/1730783322",
        "key": "raw/newbookdev_newbooklogin_default_settings/2024-11-04/1730783322/login_default_settings.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklogin_default_settings",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9504646937792677638,
        "service_name": "drive-thru",
        "span_id": 8805415031059315079,
        "trace_id": 2535743472745029621
    }
}

running: False
schema_name_id: 2823
start_time: 2024-11-05 01:18:36
success: True
trace_id: 2535743472745029621

Scan 6664923

duration: 0:00:13.997835

exit_message:

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

id: 6664923

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_default_settings/2024-11-04/1730782966",
        "key": "raw/newbookdev_newbooklogin_default_settings/2024-11-04/1730782966/login_default_settings.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklogin_default_settings",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 612943444933175852,
        "service_name": "drive-thru",
        "span_id": 14534555104013021589,
        "trace_id": 7019281696953959336
    }
}

running: False
schema_name_id: 2823
start_time: 2024-11-05 00:57:44
success: True
trace_id: 7019281696953959336

Scan 6664271

duration: 0:00:11.415614

exit_message:

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

id: 6664271

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_default_settings/2024-11-04/1730782817",
        "key": "raw/newbookdev_newbooklogin_default_settings/2024-11-04/1730782817/login_default_settings.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklogin_default_settings",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13101115160658652899,
        "service_name": "drive-thru",
        "span_id": 5046155483103755565,
        "trace_id": 10617579590184511381
    }
}

running: False
schema_name_id: 2823
start_time: 2024-11-05 00:40:38
success: True
trace_id: 10617579590184511381

Partitions:

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

Schema:

attributes:

{
    "autoload": "string",
    "default_value": "string",
    "description": "string",
    "group": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "setting_type": "string",
    "tenant": "string",
    "tooltip": "string"
}

created: 2024-11-05 23:15:16

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_default_settings`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `description`  string , `tooltip`  string , `group`  string , `default_value`  string , `setting_type`  string , `autoload`  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_default_settings/2024-11-05/1730866546'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooklogin_default_settings`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooklogin_default_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:10:15",
        "disabled": false,
        "format": "raw",
        "id": 2823,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "newbookdev_newbooklogin_default_settings"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "autoload": "string",
            "default_value": "string",
            "description": "string",
            "group": "string",
            "id": "string",
            "name": "string",
            "newbook_region": "string",
            "setting_type": "string",
            "tenant": "string",
            "tooltip": "string"
        },
        "created": "2024-11-05 23:15:16",
        "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_default_settings`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `description`  string , `tooltip`  string , `group`  string , `default_value`  string , `setting_type`  string , `autoload`  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_default_settings/2024-11-05/1730866546'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooklogin_default_settings`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooklogin_default_settings"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}