Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookbookings_categories_restrictions_link

created: 2024-10-08 17:39:51
disabled: False
format: raw
id: 2449
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4748101

created: 2024-11-05 22:34:53

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_categories_restrictions_link/2024-11-05/1730866375
id: 4748101
processed: 1

raw_data:

{
    "active": 6,
    "category_id": 3,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "type": 4,
    "type_id": 5
}

schema_attributes:

{
    "active": "string",
    "category_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2449
schema_scan_id: 6674133
updated: 2024-11-05 22:35:06

Version 4747757

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_categories_restrictions_link/2024-11-05/1730866310
id: 4747757
processed: 1

raw_data:

{
    "active": 6,
    "category_id": 3,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "type": 4,
    "type_id": 5
}

schema_attributes:

{
    "active": "string",
    "category_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2449
schema_scan_id: 6673791
updated: 2024-11-05 22:25:25

Version 4747397

created: 2024-11-05 22:15:24

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_categories_restrictions_link/2024-11-05/1730866236
id: 4747397
processed: 1

raw_data:

{
    "active": 6,
    "category_id": 3,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "type": 4,
    "type_id": 5
}

schema_attributes:

{
    "active": "string",
    "category_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2449
schema_scan_id: 6673429
updated: 2024-11-05 22:15:35

Version 4745947

created: 2024-11-05 03:43:49

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_categories_restrictions_link/2024-11-04/1730785085
id: 4745947
processed: 1

raw_data:

{
    "active": 6,
    "category_id": 3,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "type": 4,
    "type_id": 5
}

schema_attributes:

{
    "active": "string",
    "category_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2449
schema_scan_id: 6671167
updated: 2024-11-05 03:43:59

Version 4745943

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_categories_restrictions_link/2024-11-04/1730785654
id: 4745943
processed: 1

raw_data:

{
    "active": 6,
    "category_id": 3,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "type": 4,
    "type_id": 5
}

schema_attributes:

{
    "active": "string",
    "category_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2449
schema_scan_id: 6671163
updated: 2024-11-05 03:43:53

Version 4745677

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_categories_restrictions_link/2024-11-04/1730784779
id: 4745677
processed: 1

raw_data:

{
    "active": 6,
    "category_id": 3,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "type": 4,
    "type_id": 5
}

schema_attributes:

{
    "active": "string",
    "category_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2449
schema_scan_id: 6670894
updated: 2024-11-05 03:35:56

Version 4744324

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_categories_restrictions_link/2024-11-04/1730784176
id: 4744324
processed: 1

raw_data:

{
    "active": 6,
    "category_id": 3,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "type": 4,
    "type_id": 5
}

schema_attributes:

{
    "active": "string",
    "category_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2449
schema_scan_id: 6669542
updated: 2024-11-05 03:00:07

Version 4743742

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_categories_restrictions_link/2024-11-04/1730784014
id: 4743742
processed: 1

raw_data:

{
    "active": 6,
    "category_id": 3,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "type": 4,
    "type_id": 5
}

schema_attributes:

{
    "active": "string",
    "category_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2449
schema_scan_id: 6668959
updated: 2024-11-05 02:44:49

Version 4743033

created: 2024-11-05 02:25:50

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_categories_restrictions_link/2024-11-04/1730783868
id: 4743033
processed: 1

raw_data:

{
    "active": 6,
    "category_id": 3,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "type": 4,
    "type_id": 5
}

schema_attributes:

{
    "active": "string",
    "category_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2449
schema_scan_id: 6668250
updated: 2024-11-05 02:26:01

Version 4741779

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_categories_restrictions_link/2024-11-04/1730783726
id: 4741779
processed: 1

raw_data:

{
    "active": 6,
    "category_id": 3,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "type": 4,
    "type_id": 5
}

schema_attributes:

{
    "active": "string",
    "category_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2449
schema_scan_id: 6666996
updated: 2024-11-05 01:52:45

Version 4741185

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_categories_restrictions_link/2024-11-04/1730783634
id: 4741185
processed: 1

raw_data:

{
    "active": 6,
    "category_id": 3,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "type": 4,
    "type_id": 5
}

schema_attributes:

{
    "active": "string",
    "category_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2449
schema_scan_id: 6666402
updated: 2024-11-05 01:37:13

Version 4740754

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_categories_restrictions_link/2024-11-04/1730783482
id: 4740754
processed: 1

raw_data:

{
    "active": 6,
    "category_id": 3,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "type": 4,
    "type_id": 5
}

schema_attributes:

{
    "active": "string",
    "category_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2449
schema_scan_id: 6665971
updated: 2024-11-05 01:25:50

Version 4740038

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_categories_restrictions_link/2024-11-04/1730783264
id: 4740038
processed: 1

raw_data:

{
    "active": 6,
    "category_id": 3,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "type": 4,
    "type_id": 5
}

schema_attributes:

{
    "active": "string",
    "category_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2449
schema_scan_id: 6665255
updated: 2024-11-05 01:06:55

Version 4739372

created: 2024-11-05 00:48:56

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_categories_restrictions_link/2024-11-04/1730782866
id: 4739372
processed: 1

raw_data:

{
    "active": 6,
    "category_id": 3,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "type": 4,
    "type_id": 5
}

schema_attributes:

{
    "active": "string",
    "category_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2449
schema_scan_id: 6664587
updated: 2024-11-05 00:49:07

Version 4738723

created: 2024-11-05 00:31:56

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_categories_restrictions_link/2024-11-04/1730782775
id: 4738723
processed: 1

raw_data:

{
    "active": 6,
    "category_id": 3,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "type": 4,
    "type_id": 5
}

schema_attributes:

{
    "active": "string",
    "category_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2449
schema_scan_id: 6663936
updated: 2024-11-05 00:32:09

Schema Scans: 15

Last at 2024-11-05 22:34:52

Scan 6674133

duration: 0:00:14.081337

exit_message:

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

id: 6674133

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_newbookbookings_categories_restrictions_link/2024-11-05/1730866375",
        "key": "raw/newbookdev_newbookbookings_categories_restrictions_link/2024-11-05/1730866375/bookings_categories_restrictions_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_categories_restrictions_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16192358425145349099,
        "service_name": "drive-thru",
        "span_id": 13918824811937603873,
        "trace_id": 4947385289247676383
    }
}

running: False
schema_name_id: 2449
start_time: 2024-11-05 22:34:52
success: True
trace_id: 4947385289247676383

Scan 6673791

duration: 0:00:11.492320

exit_message:

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

id: 6673791

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_newbookbookings_categories_restrictions_link/2024-11-05/1730866310",
        "key": "raw/newbookdev_newbookbookings_categories_restrictions_link/2024-11-05/1730866310/bookings_categories_restrictions_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_categories_restrictions_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8397716491697091844,
        "service_name": "drive-thru",
        "span_id": 1052349863912597390,
        "trace_id": 8448815987810183755
    }
}

running: False
schema_name_id: 2449
start_time: 2024-11-05 22:25:13
success: True
trace_id: 8448815987810183755

Scan 6673429

duration: 0:00:11.563731

exit_message:

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

id: 6673429

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_newbookbookings_categories_restrictions_link/2024-11-05/1730866236",
        "key": "raw/newbookdev_newbookbookings_categories_restrictions_link/2024-11-05/1730866236/bookings_categories_restrictions_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_categories_restrictions_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 537262123776108246,
        "service_name": "drive-thru",
        "span_id": 3632468112549595365,
        "trace_id": 12847311647231061574
    }
}

running: False
schema_name_id: 2449
start_time: 2024-11-05 22:15:23
success: True
trace_id: 12847311647231061574

Scan 6671167

duration: 0:00:11.465901

exit_message:

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

id: 6671167

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_newbookbookings_categories_restrictions_link/2024-11-04/1730785085",
        "key": "raw/newbookdev_newbookbookings_categories_restrictions_link/2024-11-04/1730785085/bookings_categories_restrictions_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_categories_restrictions_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8711424607415837099,
        "service_name": "drive-thru",
        "span_id": 3401164461285726835,
        "trace_id": 14825516327048197351
    }
}

running: False
schema_name_id: 2449
start_time: 2024-11-05 03:43:48
success: True
trace_id: 14825516327048197351

Scan 6671163

duration: 0:00:14.091932

exit_message:

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

id: 6671163

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_newbookbookings_categories_restrictions_link/2024-11-04/1730785654",
        "key": "raw/newbookdev_newbookbookings_categories_restrictions_link/2024-11-04/1730785654/bookings_categories_restrictions_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_categories_restrictions_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9539072879450600796,
        "service_name": "drive-thru",
        "span_id": 3260684492695078256,
        "trace_id": 14108909097845428878
    }
}

running: False
schema_name_id: 2449
start_time: 2024-11-05 03:43:39
success: True
trace_id: 14108909097845428878

Scan 6670894

duration: 0:00:11.396585

exit_message:

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

id: 6670894

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_newbookbookings_categories_restrictions_link/2024-11-04/1730784779",
        "key": "raw/newbookdev_newbookbookings_categories_restrictions_link/2024-11-04/1730784779/bookings_categories_restrictions_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_categories_restrictions_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7840426654022633297,
        "service_name": "drive-thru",
        "span_id": 8933725142820016294,
        "trace_id": 15268585593983774262
    }
}

running: False
schema_name_id: 2449
start_time: 2024-11-05 03:35:45
success: True
trace_id: 15268585593983774262

Scan 6669542

duration: 0:00:13.974451

exit_message:

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

id: 6669542

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_newbookbookings_categories_restrictions_link/2024-11-04/1730784176",
        "key": "raw/newbookdev_newbookbookings_categories_restrictions_link/2024-11-04/1730784176/bookings_categories_restrictions_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_categories_restrictions_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3331371224195759043,
        "service_name": "drive-thru",
        "span_id": 14686238999806163503,
        "trace_id": 13628773365407105664
    }
}

running: False
schema_name_id: 2449
start_time: 2024-11-05 02:59:53
success: True
trace_id: 13628773365407105664

Scan 6668959

duration: 0:00:11.330376

exit_message:

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

id: 6668959

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_newbookbookings_categories_restrictions_link/2024-11-04/1730784014",
        "key": "raw/newbookdev_newbookbookings_categories_restrictions_link/2024-11-04/1730784014/bookings_categories_restrictions_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_categories_restrictions_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14142415576740951334,
        "service_name": "drive-thru",
        "span_id": 9084823997711082457,
        "trace_id": 6180768199020163724
    }
}

running: False
schema_name_id: 2449
start_time: 2024-11-05 02:44:38
success: True
trace_id: 6180768199020163724

Scan 6668250

duration: 0:00:11.399664

exit_message:

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

id: 6668250

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_newbookbookings_categories_restrictions_link/2024-11-04/1730783868",
        "key": "raw/newbookdev_newbookbookings_categories_restrictions_link/2024-11-04/1730783868/bookings_categories_restrictions_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_categories_restrictions_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1947326410792691211,
        "service_name": "drive-thru",
        "span_id": 7678321225050148831,
        "trace_id": 4310014606694566751
    }
}

running: False
schema_name_id: 2449
start_time: 2024-11-05 02:25:50
success: True
trace_id: 4310014606694566751

Scan 6666996

duration: 0:00:11.421517

exit_message:

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

id: 6666996

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_newbookbookings_categories_restrictions_link/2024-11-04/1730783726",
        "key": "raw/newbookdev_newbookbookings_categories_restrictions_link/2024-11-04/1730783726/bookings_categories_restrictions_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_categories_restrictions_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9007842455901204402,
        "service_name": "drive-thru",
        "span_id": 11589585668265924141,
        "trace_id": 13440761409075636521
    }
}

running: False
schema_name_id: 2449
start_time: 2024-11-05 01:52:33
success: True
trace_id: 13440761409075636521

Scan 6666402

duration: 0:00:14.189249

exit_message:

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

id: 6666402

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_newbookbookings_categories_restrictions_link/2024-11-04/1730783634",
        "key": "raw/newbookdev_newbookbookings_categories_restrictions_link/2024-11-04/1730783634/bookings_categories_restrictions_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_categories_restrictions_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12159297567563793525,
        "service_name": "drive-thru",
        "span_id": 13107112502076442521,
        "trace_id": 9918777321617433889
    }
}

running: False
schema_name_id: 2449
start_time: 2024-11-05 01:36:59
success: True
trace_id: 9918777321617433889

Scan 6665971

duration: 0:00:11.354882

exit_message:

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

id: 6665971

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_newbookbookings_categories_restrictions_link/2024-11-04/1730783482",
        "key": "raw/newbookdev_newbookbookings_categories_restrictions_link/2024-11-04/1730783482/bookings_categories_restrictions_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_categories_restrictions_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9705167557193695100,
        "service_name": "drive-thru",
        "span_id": 5258188604040603713,
        "trace_id": 3213005961582117866
    }
}

running: False
schema_name_id: 2449
start_time: 2024-11-05 01:25:38
success: True
trace_id: 3213005961582117866

Scan 6665255

duration: 0:00:13.883526

exit_message:

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

id: 6665255

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_newbookbookings_categories_restrictions_link/2024-11-04/1730783264",
        "key": "raw/newbookdev_newbookbookings_categories_restrictions_link/2024-11-04/1730783264/bookings_categories_restrictions_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_categories_restrictions_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16683991679347189767,
        "service_name": "drive-thru",
        "span_id": 4471455030867051294,
        "trace_id": 11961568643100535872
    }
}

running: False
schema_name_id: 2449
start_time: 2024-11-05 01:06:41
success: True
trace_id: 11961568643100535872

Scan 6664587

duration: 0:00:11.347798

exit_message:

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

id: 6664587

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_newbookbookings_categories_restrictions_link/2024-11-04/1730782866",
        "key": "raw/newbookdev_newbookbookings_categories_restrictions_link/2024-11-04/1730782866/bookings_categories_restrictions_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_categories_restrictions_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8314988480721474168,
        "service_name": "drive-thru",
        "span_id": 9101737301021260594,
        "trace_id": 12362152351778043005
    }
}

running: False
schema_name_id: 2449
start_time: 2024-11-05 00:48:56
success: True
trace_id: 12362152351778043005

Scan 6663936

duration: 0:00:13.952182

exit_message:

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

id: 6663936

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_newbookbookings_categories_restrictions_link/2024-11-04/1730782775",
        "key": "raw/newbookdev_newbookbookings_categories_restrictions_link/2024-11-04/1730782775/bookings_categories_restrictions_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_categories_restrictions_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8964210206400116868,
        "service_name": "drive-thru",
        "span_id": 8534211697868097913,
        "trace_id": 5365373851353649697
    }
}

running: False
schema_name_id: 2449
start_time: 2024-11-05 00:31:55
success: True
trace_id: 5365373851353649697

Partitions:

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

Schema:

attributes:

{
    "active": "string",
    "category_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

created: 2024-11-05 22:34:53

ddl:

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

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