Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookusers_shifts_types

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4749514

created: 2024-11-05 23:59:54

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_shifts_types/2024-11-05/1730866631
id: 4749514
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 3028
schema_scan_id: 6675615
updated: 2024-11-06 00:00:06

Version 4749434

created: 2024-11-05 23:50:31

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_shifts_types/2024-11-05/1730866594
id: 4749434
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 3028
schema_scan_id: 6675485
updated: 2024-11-05 23:50:42

Version 4748924

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_shifts_types/2024-11-05/1730866500
id: 4748924
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 3028
schema_scan_id: 6674956
updated: 2024-11-05 23:09:14

Version 4747209

created: 2024-11-05 05:02:04

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_shifts_types/2024-11-04/1730785832
id: 4747209
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 3028
schema_scan_id: 6672443
updated: 2024-11-05 05:02:17

Version 4746741

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_shifts_types/2024-11-04/1730785186
id: 4746741
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 3028
schema_scan_id: 6671965
updated: 2024-11-05 04:20:09

Version 4746082

created: 2024-11-05 03:48:39

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_shifts_types/2024-11-04/1730784881
id: 4746082
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 3028
schema_scan_id: 6671303
updated: 2024-11-05 03:48:53

Version 4745025

created: 2024-11-05 03:18:42

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_shifts_types/2024-11-04/1730784277
id: 4745025
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 3028
schema_scan_id: 6670245
updated: 2024-11-05 03:18:55

Version 4743838

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_shifts_types/2024-11-04/1730784115
id: 4743838
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 3028
schema_scan_id: 6669055
updated: 2024-11-05 02:47:23

Version 4743121

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_shifts_types/2024-11-04/1730783829
id: 4743121
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 3028
schema_scan_id: 6668338
updated: 2024-11-05 02:28:22

Version 4742482

created: 2024-11-05 02:11:23

ddl:

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

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

raw_data:

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

schema_attributes:

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

schema_name_id: 3028
schema_scan_id: 6667699
updated: 2024-11-05 02:11:34

Version 4741713

created: 2024-11-05 01:50:50

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_shifts_types/2024-11-04/1730783712
id: 4741713
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 3028
schema_scan_id: 6666930
updated: 2024-11-05 01:51:01

Version 4741610

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_shifts_types/2024-11-04/1730783587
id: 4741610
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 3028
schema_scan_id: 6666828
updated: 2024-11-05 01:48:17

Version 4740787

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_shifts_types/2024-11-04/1730783368
id: 4740787
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 3028
schema_scan_id: 6666004
updated: 2024-11-05 01:26:42

Version 4740064

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_shifts_types/2024-11-04/1730782965
id: 4740064
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 3028
schema_scan_id: 6665281
updated: 2024-11-05 01:07:34

Version 4739297

created: 2024-11-05 00:46:59

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_shifts_types/2024-11-04/1730782851
id: 4739297
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 3028
schema_scan_id: 6664512
updated: 2024-11-05 00:47:12

Schema Scans: 15

Last at 2024-11-05 23:59:54

Scan 6675615

duration: 0:00:11.510066

exit_message:

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

id: 6675615

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_shifts_types/2024-11-05/1730866631",
        "key": "raw/newbookdev_newbookusers_shifts_types/2024-11-05/1730866631/users_shifts_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_shifts_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7507619007818821600,
        "service_name": "drive-thru",
        "span_id": 16752215359319854366,
        "trace_id": 9228342452394223893
    }
}

running: False
schema_name_id: 3028
start_time: 2024-11-05 23:59:54
success: True
trace_id: 9228342452394223893

Scan 6675485

duration: 0:00:11.477179

exit_message:

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

id: 6675485

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_shifts_types/2024-11-05/1730866594",
        "key": "raw/newbookdev_newbookusers_shifts_types/2024-11-05/1730866594/users_shifts_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_shifts_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17700524113393227508,
        "service_name": "drive-thru",
        "span_id": 13890848899680136753,
        "trace_id": 16907089368681559598
    }
}

running: False
schema_name_id: 3028
start_time: 2024-11-05 23:50:31
success: True
trace_id: 16907089368681559598

Scan 6674956

duration: 0:00:11.577136

exit_message:

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

id: 6674956

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_shifts_types/2024-11-05/1730866500",
        "key": "raw/newbookdev_newbookusers_shifts_types/2024-11-05/1730866500/users_shifts_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_shifts_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7775921838147255837,
        "service_name": "drive-thru",
        "span_id": 13919005880219238662,
        "trace_id": 14853188567013270132
    }
}

running: False
schema_name_id: 3028
start_time: 2024-11-05 23:09:02
success: True
trace_id: 14853188567013270132

Scan 6672443

duration: 0:00:14.140540

exit_message:

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

id: 6672443

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_shifts_types/2024-11-04/1730785832",
        "key": "raw/newbookdev_newbookusers_shifts_types/2024-11-04/1730785832/users_shifts_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_shifts_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 708122091064350727,
        "service_name": "drive-thru",
        "span_id": 1916055396137149351,
        "trace_id": 17005821969013090677
    }
}

running: False
schema_name_id: 3028
start_time: 2024-11-05 05:02:03
success: True
trace_id: 17005821969013090677

Scan 6671965

duration: 0:00:11.527557

exit_message:

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

id: 6671965

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_shifts_types/2024-11-04/1730785186",
        "key": "raw/newbookdev_newbookusers_shifts_types/2024-11-04/1730785186/users_shifts_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_shifts_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15328959703357463205,
        "service_name": "drive-thru",
        "span_id": 16838849763855809350,
        "trace_id": 16226990011490631831
    }
}

running: False
schema_name_id: 3028
start_time: 2024-11-05 04:19:57
success: True
trace_id: 16226990011490631831

Scan 6671303

duration: 0:00:14.032048

exit_message:

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

id: 6671303

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_shifts_types/2024-11-04/1730784881",
        "key": "raw/newbookdev_newbookusers_shifts_types/2024-11-04/1730784881/users_shifts_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_shifts_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14809520818755302918,
        "service_name": "drive-thru",
        "span_id": 6909307928439450052,
        "trace_id": 278038982698235193
    }
}

running: False
schema_name_id: 3028
start_time: 2024-11-05 03:48:39
success: True
trace_id: 278038982698235193

Scan 6670245

duration: 0:00:13.851460

exit_message:

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

id: 6670245

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_shifts_types/2024-11-04/1730784277",
        "key": "raw/newbookdev_newbookusers_shifts_types/2024-11-04/1730784277/users_shifts_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_shifts_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4415131543813413638,
        "service_name": "drive-thru",
        "span_id": 11930172569467574844,
        "trace_id": 2973385189205836660
    }
}

running: False
schema_name_id: 3028
start_time: 2024-11-05 03:18:42
success: True
trace_id: 2973385189205836660

Scan 6669055

duration: 0:00:11.351563

exit_message:

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

id: 6669055

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_shifts_types/2024-11-04/1730784115",
        "key": "raw/newbookdev_newbookusers_shifts_types/2024-11-04/1730784115/users_shifts_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_shifts_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1476213681521006739,
        "service_name": "drive-thru",
        "span_id": 9026705931983662764,
        "trace_id": 18303334388480995236
    }
}

running: False
schema_name_id: 3028
start_time: 2024-11-05 02:47:12
success: True
trace_id: 18303334388480995236

Scan 6668338

duration: 0:00:11.298536

exit_message:

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

id: 6668338

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_shifts_types/2024-11-04/1730783829",
        "key": "raw/newbookdev_newbookusers_shifts_types/2024-11-04/1730783829/users_shifts_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_shifts_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3932055627447952819,
        "service_name": "drive-thru",
        "span_id": 13953187406216153069,
        "trace_id": 9987896247481691166
    }
}

running: False
schema_name_id: 3028
start_time: 2024-11-05 02:28:10
success: True
trace_id: 9987896247481691166

Scan 6667699

duration: 0:00:11.322184

exit_message:

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

id: 6667699

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_shifts_types/2024-11-04/1730783859",
        "key": "raw/newbookdev_newbookusers_shifts_types/2024-11-04/1730783859/users_shifts_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_shifts_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6036510938501219865,
        "service_name": "drive-thru",
        "span_id": 16159825679707093398,
        "trace_id": 317247638801785380
    }
}

running: False
schema_name_id: 3028
start_time: 2024-11-05 02:11:23
success: True
trace_id: 317247638801785380

Scan 6666930

duration: 0:00:11.366717

exit_message:

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

id: 6666930

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_shifts_types/2024-11-04/1730783712",
        "key": "raw/newbookdev_newbookusers_shifts_types/2024-11-04/1730783712/users_shifts_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_shifts_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8250402469160093913,
        "service_name": "drive-thru",
        "span_id": 15639146029737672986,
        "trace_id": 763586934047919784
    }
}

running: False
schema_name_id: 3028
start_time: 2024-11-05 01:50:50
success: True
trace_id: 763586934047919784

Scan 6666828

duration: 0:00:11.481640

exit_message:

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

id: 6666828

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_shifts_types/2024-11-04/1730783587",
        "key": "raw/newbookdev_newbookusers_shifts_types/2024-11-04/1730783587/users_shifts_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_shifts_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17508037351480332770,
        "service_name": "drive-thru",
        "span_id": 6227014625926048104,
        "trace_id": 10090563285775450685
    }
}

running: False
schema_name_id: 3028
start_time: 2024-11-05 01:48:06
success: True
trace_id: 10090563285775450685

Scan 6666004

duration: 0:00:13.852438

exit_message:

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

id: 6666004

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_shifts_types/2024-11-04/1730783368",
        "key": "raw/newbookdev_newbookusers_shifts_types/2024-11-04/1730783368/users_shifts_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_shifts_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4548261472488123175,
        "service_name": "drive-thru",
        "span_id": 13222087368498999089,
        "trace_id": 8741995647890777666
    }
}

running: False
schema_name_id: 3028
start_time: 2024-11-05 01:26:28
success: True
trace_id: 8741995647890777666

Scan 6665281

duration: 0:00:11.267828

exit_message:

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

id: 6665281

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_shifts_types/2024-11-04/1730782965",
        "key": "raw/newbookdev_newbookusers_shifts_types/2024-11-04/1730782965/users_shifts_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_shifts_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6859551883947099591,
        "service_name": "drive-thru",
        "span_id": 17270906281364132821,
        "trace_id": 16477961213758430506
    }
}

running: False
schema_name_id: 3028
start_time: 2024-11-05 01:07:22
success: True
trace_id: 16477961213758430506

Scan 6664512

duration: 0:00:13.923068

exit_message:

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

id: 6664512

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_shifts_types/2024-11-04/1730782851",
        "key": "raw/newbookdev_newbookusers_shifts_types/2024-11-04/1730782851/users_shifts_types.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_shifts_types",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7232971334224252606,
        "service_name": "drive-thru",
        "span_id": 18247481811989178782,
        "trace_id": 8481362506504257886
    }
}

running: False
schema_name_id: 3028
start_time: 2024-11-05 00:46:58
success: True
trace_id: 8481362506504257886

Partitions:

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

Schema:

attributes:

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

created: 2024-11-05 23:59:54

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