Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookcrs_availability

created: 2024-10-08 17:50:53
disabled: False
format: raw
id: 2601
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4748442

created: 2024-11-05 22:46:25

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcrs_availability`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcrs_availability`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `date`  string , `instance_id`  string , `category_id`  string , `site_id`  string , `available`  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_newbookcrs_availability/2024-11-05/1730866444'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcrs_availability"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcrs_availability/2024-11-05/1730866444
id: 4748442
processed: 1

raw_data:

{
    "available": 7,
    "category_id": 5,
    "date": 3,
    "id": 2,
    "instance_id": 4,
    "newbook_region": 0,
    "site_id": 6,
    "tenant": 1
}

schema_attributes:

{
    "available": "string",
    "category_id": "string",
    "date": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string"
}

schema_name_id: 2601
schema_scan_id: 6674475
updated: 2024-11-05 22:46:36

Version 4748107

created: 2024-11-05 22:35:03

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcrs_availability`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcrs_availability`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `date`  string , `instance_id`  string , `category_id`  string , `site_id`  string , `available`  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_newbookcrs_availability/2024-11-05/1730866359'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcrs_availability"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcrs_availability/2024-11-05/1730866359
id: 4748107
processed: 1

raw_data:

{
    "available": 7,
    "category_id": 5,
    "date": 3,
    "id": 2,
    "instance_id": 4,
    "newbook_region": 0,
    "site_id": 6,
    "tenant": 1
}

schema_attributes:

{
    "available": "string",
    "category_id": "string",
    "date": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string"
}

schema_name_id: 2601
schema_scan_id: 6674139
updated: 2024-11-05 22:35:14

Version 4747560

created: 2024-11-05 22:20:03

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcrs_availability`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcrs_availability`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `date`  string , `instance_id`  string , `category_id`  string , `site_id`  string , `available`  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_newbookcrs_availability/2024-11-05/1730866265'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcrs_availability"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcrs_availability/2024-11-05/1730866265
id: 4747560
processed: 1

raw_data:

{
    "available": 7,
    "category_id": 5,
    "date": 3,
    "id": 2,
    "instance_id": 4,
    "newbook_region": 0,
    "site_id": 6,
    "tenant": 1
}

schema_attributes:

{
    "available": "string",
    "category_id": "string",
    "date": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string"
}

schema_name_id: 2601
schema_scan_id: 6673592
updated: 2024-11-05 22:20:14

Version 4746760

created: 2024-11-05 04:21:13

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcrs_availability`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcrs_availability`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `date`  string , `instance_id`  string , `category_id`  string , `site_id`  string , `available`  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_newbookcrs_availability/2024-11-04/1730785686'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcrs_availability"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcrs_availability/2024-11-04/1730785686
id: 4746760
processed: 1

raw_data:

{
    "available": 7,
    "category_id": 5,
    "date": 3,
    "id": 2,
    "instance_id": 4,
    "newbook_region": 0,
    "site_id": 6,
    "tenant": 1
}

schema_attributes:

{
    "available": "string",
    "category_id": "string",
    "date": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string"
}

schema_name_id: 2601
schema_scan_id: 6671987
updated: 2024-11-05 04:21:24

Version 4746277

created: 2024-11-05 03:56:08

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcrs_availability`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcrs_availability`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `date`  string , `instance_id`  string , `category_id`  string , `site_id`  string , `available`  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_newbookcrs_availability/2024-11-04/1730785104'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcrs_availability"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcrs_availability/2024-11-04/1730785104
id: 4746277
processed: 1

raw_data:

{
    "available": 7,
    "category_id": 5,
    "date": 3,
    "id": 2,
    "instance_id": 4,
    "newbook_region": 0,
    "site_id": 6,
    "tenant": 1
}

schema_attributes:

{
    "available": "string",
    "category_id": "string",
    "date": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string"
}

schema_name_id: 2601
schema_scan_id: 6671498
updated: 2024-11-05 03:56:19

Version 4744821

created: 2024-11-05 03:13:13

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcrs_availability`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcrs_availability`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `date`  string , `instance_id`  string , `category_id`  string , `site_id`  string , `available`  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_newbookcrs_availability/2024-11-04/1730784195'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcrs_availability"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcrs_availability/2024-11-04/1730784195
id: 4744821
processed: 1

raw_data:

{
    "available": 7,
    "category_id": 5,
    "date": 3,
    "id": 2,
    "instance_id": 4,
    "newbook_region": 0,
    "site_id": 6,
    "tenant": 1
}

schema_attributes:

{
    "available": "string",
    "category_id": "string",
    "date": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string"
}

schema_name_id: 2601
schema_scan_id: 6670038
updated: 2024-11-05 03:13:24

Version 4744570

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcrs_availability`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcrs_availability`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `date`  string , `instance_id`  string , `category_id`  string , `site_id`  string , `available`  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_newbookcrs_availability/2024-11-04/1730784799'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcrs_availability"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcrs_availability/2024-11-04/1730784799
id: 4744570
processed: 1

raw_data:

{
    "available": 7,
    "category_id": 5,
    "date": 3,
    "id": 2,
    "instance_id": 4,
    "newbook_region": 0,
    "site_id": 6,
    "tenant": 1
}

schema_attributes:

{
    "available": "string",
    "category_id": "string",
    "date": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string"
}

schema_name_id: 2601
schema_scan_id: 6669787
updated: 2024-11-05 03:06:49

Version 4744192

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcrs_availability`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcrs_availability`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `date`  string , `instance_id`  string , `category_id`  string , `site_id`  string , `available`  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_newbookcrs_availability/2024-11-04/1730784033'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcrs_availability"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcrs_availability/2024-11-04/1730784033
id: 4744192
processed: 1

raw_data:

{
    "available": 7,
    "category_id": 5,
    "date": 3,
    "id": 2,
    "instance_id": 4,
    "newbook_region": 0,
    "site_id": 6,
    "tenant": 1
}

schema_attributes:

{
    "available": "string",
    "category_id": "string",
    "date": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string"
}

schema_name_id: 2601
schema_scan_id: 6669408
updated: 2024-11-05 02:56:33

Version 4743155

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcrs_availability`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcrs_availability`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `date`  string , `instance_id`  string , `category_id`  string , `site_id`  string , `available`  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_newbookcrs_availability/2024-11-04/1730783883'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcrs_availability"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcrs_availability/2024-11-04/1730783883
id: 4743155
processed: 1

raw_data:

{
    "available": 7,
    "category_id": 5,
    "date": 3,
    "id": 2,
    "instance_id": 4,
    "newbook_region": 0,
    "site_id": 6,
    "tenant": 1
}

schema_attributes:

{
    "available": "string",
    "category_id": "string",
    "date": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string"
}

schema_name_id: 2601
schema_scan_id: 6668372
updated: 2024-11-05 02:29:18

Version 4742425

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcrs_availability`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcrs_availability`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `date`  string , `instance_id`  string , `category_id`  string , `site_id`  string , `available`  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_newbookcrs_availability/2024-11-04/1730783746'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcrs_availability"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcrs_availability/2024-11-04/1730783746
id: 4742425
processed: 1

raw_data:

{
    "available": 7,
    "category_id": 5,
    "date": 3,
    "id": 2,
    "instance_id": 4,
    "newbook_region": 0,
    "site_id": 6,
    "tenant": 1
}

schema_attributes:

{
    "available": "string",
    "category_id": "string",
    "date": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string"
}

schema_name_id: 2601
schema_scan_id: 6667643
updated: 2024-11-05 02:10:05

Version 4741933

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcrs_availability`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcrs_availability`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `date`  string , `instance_id`  string , `category_id`  string , `site_id`  string , `available`  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_newbookcrs_availability/2024-11-04/1730783649'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcrs_availability"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcrs_availability/2024-11-04/1730783649
id: 4741933
processed: 1

raw_data:

{
    "available": 7,
    "category_id": 5,
    "date": 3,
    "id": 2,
    "instance_id": 4,
    "newbook_region": 0,
    "site_id": 6,
    "tenant": 1
}

schema_attributes:

{
    "available": "string",
    "category_id": "string",
    "date": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string"
}

schema_name_id: 2601
schema_scan_id: 6667150
updated: 2024-11-05 01:56:52

Version 4741099

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcrs_availability`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcrs_availability`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `date`  string , `instance_id`  string , `category_id`  string , `site_id`  string , `available`  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_newbookcrs_availability/2024-11-04/1730783502'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcrs_availability"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcrs_availability/2024-11-04/1730783502
id: 4741099
processed: 1

raw_data:

{
    "available": 7,
    "category_id": 5,
    "date": 3,
    "id": 2,
    "instance_id": 4,
    "newbook_region": 0,
    "site_id": 6,
    "tenant": 1
}

schema_attributes:

{
    "available": "string",
    "category_id": "string",
    "date": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string"
}

schema_name_id: 2601
schema_scan_id: 6666316
updated: 2024-11-05 01:34:58

Version 4740276

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcrs_availability`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcrs_availability`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `date`  string , `instance_id`  string , `category_id`  string , `site_id`  string , `available`  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_newbookcrs_availability/2024-11-04/1730783284'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcrs_availability"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcrs_availability/2024-11-04/1730783284
id: 4740276
processed: 1

raw_data:

{
    "available": 7,
    "category_id": 5,
    "date": 3,
    "id": 2,
    "instance_id": 4,
    "newbook_region": 0,
    "site_id": 6,
    "tenant": 1
}

schema_attributes:

{
    "available": "string",
    "category_id": "string",
    "date": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string"
}

schema_name_id: 2601
schema_scan_id: 6665493
updated: 2024-11-05 01:13:18

Version 4739440

created: 2024-11-05 00:50:42

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcrs_availability`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcrs_availability`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `date`  string , `instance_id`  string , `category_id`  string , `site_id`  string , `available`  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_newbookcrs_availability/2024-11-04/1730782886'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcrs_availability"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcrs_availability/2024-11-04/1730782886
id: 4739440
processed: 1

raw_data:

{
    "available": 7,
    "category_id": 5,
    "date": 3,
    "id": 2,
    "instance_id": 4,
    "newbook_region": 0,
    "site_id": 6,
    "tenant": 1
}

schema_attributes:

{
    "available": "string",
    "category_id": "string",
    "date": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string"
}

schema_name_id: 2601
schema_scan_id: 6664655
updated: 2024-11-05 00:50:53

Version 4738957

created: 2024-11-05 00:38:06

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcrs_availability`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcrs_availability`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `date`  string , `instance_id`  string , `category_id`  string , `site_id`  string , `available`  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_newbookcrs_availability/2024-11-04/1730782789'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcrs_availability"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcrs_availability/2024-11-04/1730782789
id: 4738957
processed: 1

raw_data:

{
    "available": 7,
    "category_id": 5,
    "date": 3,
    "id": 2,
    "instance_id": 4,
    "newbook_region": 0,
    "site_id": 6,
    "tenant": 1
}

schema_attributes:

{
    "available": "string",
    "category_id": "string",
    "date": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string"
}

schema_name_id: 2601
schema_scan_id: 6664171
updated: 2024-11-05 00:38:18

Schema Scans: 15

Last at 2024-11-05 22:46:24

Scan 6674475

duration: 0:00:11.566571

exit_message:

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

id: 6674475

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_newbookcrs_availability/2024-11-05/1730866444",
        "key": "raw/newbookdev_newbookcrs_availability/2024-11-05/1730866444/crs_availability.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcrs_availability",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 145473186867932350,
        "service_name": "drive-thru",
        "span_id": 12332474153915612339,
        "trace_id": 9185199266587958682
    }
}

running: False
schema_name_id: 2601
start_time: 2024-11-05 22:46:24
success: True
trace_id: 9185199266587958682

Scan 6674139

duration: 0:00:11.432777

exit_message:

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

id: 6674139

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_newbookcrs_availability/2024-11-05/1730866359",
        "key": "raw/newbookdev_newbookcrs_availability/2024-11-05/1730866359/crs_availability.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcrs_availability",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13363998242635477674,
        "service_name": "drive-thru",
        "span_id": 7848645453343793686,
        "trace_id": 5276641040427603550
    }
}

running: False
schema_name_id: 2601
start_time: 2024-11-05 22:35:02
success: True
trace_id: 5276641040427603550

Scan 6673592

duration: 0:00:11.385942

exit_message:

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

id: 6673592

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_newbookcrs_availability/2024-11-05/1730866265",
        "key": "raw/newbookdev_newbookcrs_availability/2024-11-05/1730866265/crs_availability.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcrs_availability",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1288506800524938949,
        "service_name": "drive-thru",
        "span_id": 13917788173714367601,
        "trace_id": 8833603144761202877
    }
}

running: False
schema_name_id: 2601
start_time: 2024-11-05 22:20:03
success: True
trace_id: 8833603144761202877

Scan 6671987

duration: 0:00:11.545733

exit_message:

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

id: 6671987

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_newbookcrs_availability/2024-11-04/1730785686",
        "key": "raw/newbookdev_newbookcrs_availability/2024-11-04/1730785686/crs_availability.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcrs_availability",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17413788485697249339,
        "service_name": "drive-thru",
        "span_id": 1615454744805006011,
        "trace_id": 16799963475377560602
    }
}

running: False
schema_name_id: 2601
start_time: 2024-11-05 04:21:12
success: True
trace_id: 16799963475377560602

Scan 6671498

duration: 0:00:11.617747

exit_message:

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

id: 6671498

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_newbookcrs_availability/2024-11-04/1730785104",
        "key": "raw/newbookdev_newbookcrs_availability/2024-11-04/1730785104/crs_availability.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcrs_availability",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15578491605129451949,
        "service_name": "drive-thru",
        "span_id": 9097804010992998389,
        "trace_id": 10506333857686185240
    }
}

running: False
schema_name_id: 2601
start_time: 2024-11-05 03:56:08
success: True
trace_id: 10506333857686185240

Scan 6670038

duration: 0:00:11.388750

exit_message:

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

id: 6670038

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_newbookcrs_availability/2024-11-04/1730784195",
        "key": "raw/newbookdev_newbookcrs_availability/2024-11-04/1730784195/crs_availability.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcrs_availability",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7911328455956621806,
        "service_name": "drive-thru",
        "span_id": 13864080444235940060,
        "trace_id": 9853180252951177771
    }
}

running: False
schema_name_id: 2601
start_time: 2024-11-05 03:13:12
success: True
trace_id: 9853180252951177771

Scan 6669787

duration: 0:00:11.411747

exit_message:

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

id: 6669787

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_newbookcrs_availability/2024-11-04/1730784799",
        "key": "raw/newbookdev_newbookcrs_availability/2024-11-04/1730784799/crs_availability.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcrs_availability",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5835059495322221668,
        "service_name": "drive-thru",
        "span_id": 15706796046076138055,
        "trace_id": 5429782387723181178
    }
}

running: False
schema_name_id: 2601
start_time: 2024-11-05 03:06:38
success: True
trace_id: 5429782387723181178

Scan 6669408

duration: 0:00:11.326547

exit_message:

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

id: 6669408

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_newbookcrs_availability/2024-11-04/1730784033",
        "key": "raw/newbookdev_newbookcrs_availability/2024-11-04/1730784033/crs_availability.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcrs_availability",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17737078099737511659,
        "service_name": "drive-thru",
        "span_id": 11104021827974737777,
        "trace_id": 16666175797429569415
    }
}

running: False
schema_name_id: 2601
start_time: 2024-11-05 02:56:22
success: True
trace_id: 16666175797429569415

Scan 6668372

duration: 0:00:13.936339

exit_message:

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

id: 6668372

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_newbookcrs_availability/2024-11-04/1730783883",
        "key": "raw/newbookdev_newbookcrs_availability/2024-11-04/1730783883/crs_availability.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcrs_availability",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3566315907081826847,
        "service_name": "drive-thru",
        "span_id": 13021155838579525926,
        "trace_id": 1224668059479692724
    }
}

running: False
schema_name_id: 2601
start_time: 2024-11-05 02:29:04
success: True
trace_id: 1224668059479692724

Scan 6667643

duration: 0:00:11.356464

exit_message:

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

id: 6667643

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_newbookcrs_availability/2024-11-04/1730783746",
        "key": "raw/newbookdev_newbookcrs_availability/2024-11-04/1730783746/crs_availability.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcrs_availability",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3067101117289982283,
        "service_name": "drive-thru",
        "span_id": 14729954321095108515,
        "trace_id": 16468626475931558548
    }
}

running: False
schema_name_id: 2601
start_time: 2024-11-05 02:09:53
success: True
trace_id: 16468626475931558548

Scan 6667150

duration: 0:00:13.919478

exit_message:

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

id: 6667150

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_newbookcrs_availability/2024-11-04/1730783649",
        "key": "raw/newbookdev_newbookcrs_availability/2024-11-04/1730783649/crs_availability.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcrs_availability",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17664913080836087658,
        "service_name": "drive-thru",
        "span_id": 16964557904053612462,
        "trace_id": 282040437645032800
    }
}

running: False
schema_name_id: 2601
start_time: 2024-11-05 01:56:38
success: True
trace_id: 282040437645032800

Scan 6666316

duration: 0:00:11.389063

exit_message:

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

id: 6666316

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_newbookcrs_availability/2024-11-04/1730783502",
        "key": "raw/newbookdev_newbookcrs_availability/2024-11-04/1730783502/crs_availability.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcrs_availability",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11759537278400663949,
        "service_name": "drive-thru",
        "span_id": 16332903612656265914,
        "trace_id": 5209115099305659330
    }
}

running: False
schema_name_id: 2601
start_time: 2024-11-05 01:34:46
success: True
trace_id: 5209115099305659330

Scan 6665493

duration: 0:00:11.575707

exit_message:

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

id: 6665493

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_newbookcrs_availability/2024-11-04/1730783284",
        "key": "raw/newbookdev_newbookcrs_availability/2024-11-04/1730783284/crs_availability.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcrs_availability",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9225362439339331655,
        "service_name": "drive-thru",
        "span_id": 11184782184442460010,
        "trace_id": 268288054807634668
    }
}

running: False
schema_name_id: 2601
start_time: 2024-11-05 01:13:06
success: True
trace_id: 268288054807634668

Scan 6664655

duration: 0:00:11.396275

exit_message:

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

id: 6664655

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_newbookcrs_availability/2024-11-04/1730782886",
        "key": "raw/newbookdev_newbookcrs_availability/2024-11-04/1730782886/crs_availability.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcrs_availability",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6240347156215887049,
        "service_name": "drive-thru",
        "span_id": 2571453756415890551,
        "trace_id": 15974400590063123032
    }
}

running: False
schema_name_id: 2601
start_time: 2024-11-05 00:50:42
success: True
trace_id: 15974400590063123032

Scan 6664171

duration: 0:00:11.585436

exit_message:

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

id: 6664171

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_newbookcrs_availability/2024-11-04/1730782789",
        "key": "raw/newbookdev_newbookcrs_availability/2024-11-04/1730782789/crs_availability.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcrs_availability",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4174178998616032601,
        "service_name": "drive-thru",
        "span_id": 2874030731638657578,
        "trace_id": 17178873155724534182
    }
}

running: False
schema_name_id: 2601
start_time: 2024-11-05 00:38:06
success: True
trace_id: 17178873155724534182

Partitions:

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

Schema:

attributes:

{
    "available": "string",
    "category_id": "string",
    "date": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string"
}

created: 2024-11-05 22:46:25

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcrs_availability`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `date`  string , `instance_id`  string , `category_id`  string , `site_id`  string , `available`  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_newbookcrs_availability/2024-11-05/1730866444'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcrs_availability`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcrs_availability"
}

Server:

hostname: schemamanager-5447774fc6-4w58v
name: schema_manager
process_start: 2026-04-02 21:43:44
sf_env: dev
version: 2427328685

Raw:

{
    "name": {
        "created": "2024-10-08 17:50:53",
        "disabled": false,
        "format": "raw",
        "id": 2601,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "newbookdev_newbookcrs_availability"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "available": "string",
            "category_id": "string",
            "date": "string",
            "id": "string",
            "instance_id": "string",
            "newbook_region": "string",
            "site_id": "string",
            "tenant": "string"
        },
        "created": "2024-11-05 22:46:25",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcrs_availability`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `date`  string , `instance_id`  string , `category_id`  string , `site_id`  string , `available`  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_newbookcrs_availability/2024-11-05/1730866444'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcrs_availability`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcrs_availability"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}