Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookbookings_cancellation_reasons

created: 2024-10-08 17:37:57
disabled: False
format: raw
id: 2423
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4747984

created: 2024-11-05 22:31:19

ddl:

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

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

raw_data:

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

schema_attributes:

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

schema_name_id: 2423
schema_scan_id: 6674016
updated: 2024-11-05 22:31:30

Version 4747753

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_cancellation_reasons/2024-11-05/1730866309
id: 4747753
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2423
schema_scan_id: 6673785
updated: 2024-11-05 22:25:13

Version 4747360

created: 2024-11-05 22:13:29

ddl:

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

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

raw_data:

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

schema_attributes:

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

schema_name_id: 2423
schema_scan_id: 6673392
updated: 2024-11-05 22:13:40

Version 4746835

created: 2024-11-05 04:26:35

ddl:

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

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

raw_data:

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

schema_attributes:

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

schema_name_id: 2423
schema_scan_id: 6672065
updated: 2024-11-05 04:26:49

Version 4746159

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

ddl:

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

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

raw_data:

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

schema_attributes:

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

schema_name_id: 2423
schema_scan_id: 6671380
updated: 2024-11-05 03:51:34

Version 4744517

created: 2024-11-05 03:05:10

ddl:

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

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

raw_data:

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

schema_attributes:

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

schema_name_id: 2423
schema_scan_id: 6669734
updated: 2024-11-05 03:05:24

Version 4744513

created: 2024-11-05 03:05:02

ddl:

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

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

raw_data:

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

schema_attributes:

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

schema_name_id: 2423
schema_scan_id: 6669730
updated: 2024-11-05 03:05:15

Version 4743098

created: 2024-11-05 02:27:34

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_cancellation_reasons/2024-11-04/1730784013
id: 4743098
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2423
schema_scan_id: 6668315
updated: 2024-11-05 02:27:48

Version 4742434

created: 2024-11-05 02:10:07

ddl:

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

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

raw_data:

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

schema_attributes:

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

schema_name_id: 2423
schema_scan_id: 6667651
updated: 2024-11-05 02:10:18

Version 4742422

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_cancellation_reasons/2024-11-04/1730783833
id: 4742422
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2423
schema_scan_id: 6667639
updated: 2024-11-05 02:10:01

Version 4741593

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

ddl:

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

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

raw_data:

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

schema_attributes:

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

schema_name_id: 2423
schema_scan_id: 6666810
updated: 2024-11-05 01:47:53

Version 4740917

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

ddl:

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

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

raw_data:

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

schema_attributes:

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

schema_name_id: 2423
schema_scan_id: 6666134
updated: 2024-11-05 01:30:04

Version 4740055

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_cancellation_reasons/2024-11-04/1730783263
id: 4740055
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2423
schema_scan_id: 6665272
updated: 2024-11-05 01:07:19

Version 4739347

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

ddl:

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

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

raw_data:

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

schema_attributes:

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

schema_name_id: 2423
schema_scan_id: 6664562
updated: 2024-11-05 00:48:29

Version 4738833

created: 2024-11-05 00:34:49

ddl:

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

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

raw_data:

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

schema_attributes:

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

schema_name_id: 2423
schema_scan_id: 6664046
updated: 2024-11-05 00:35:00

Schema Scans: 15

Last at 2024-11-05 22:31:18

Scan 6674016

duration: 0:00:11.503893

exit_message:

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

id: 6674016

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_cancellation_reasons/2024-11-05/1730866375",
        "key": "raw/newbookdev_newbookbookings_cancellation_reasons/2024-11-05/1730866375/bookings_cancellation_reasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_cancellation_reasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 842298228997510563,
        "service_name": "drive-thru",
        "span_id": 3278207664787194459,
        "trace_id": 13023684371764851373
    }
}

running: False
schema_name_id: 2423
start_time: 2024-11-05 22:31:18
success: True
trace_id: 13023684371764851373

Scan 6673785

duration: 0:00:11.315669

exit_message:

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

id: 6673785

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_cancellation_reasons/2024-11-05/1730866309",
        "key": "raw/newbookdev_newbookbookings_cancellation_reasons/2024-11-05/1730866309/bookings_cancellation_reasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_cancellation_reasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13633957595845743042,
        "service_name": "drive-thru",
        "span_id": 13769379185297000452,
        "trace_id": 9471006537512738625
    }
}

running: False
schema_name_id: 2423
start_time: 2024-11-05 22:25:02
success: True
trace_id: 9471006537512738625

Scan 6673392

duration: 0:00:11.518246

exit_message:

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

id: 6673392

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_cancellation_reasons/2024-11-05/1730866236",
        "key": "raw/newbookdev_newbookbookings_cancellation_reasons/2024-11-05/1730866236/bookings_cancellation_reasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_cancellation_reasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10887081546793524658,
        "service_name": "drive-thru",
        "span_id": 17469453414753555484,
        "trace_id": 10575615212761899461
    }
}

running: False
schema_name_id: 2423
start_time: 2024-11-05 22:13:29
success: True
trace_id: 10575615212761899461

Scan 6672065

duration: 0:00:14.082999

exit_message:

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

id: 6672065

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_cancellation_reasons/2024-11-04/1730785654",
        "key": "raw/newbookdev_newbookbookings_cancellation_reasons/2024-11-04/1730785654/bookings_cancellation_reasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_cancellation_reasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4445382672169254524,
        "service_name": "drive-thru",
        "span_id": 15640282017119426798,
        "trace_id": 7133344150245286273
    }
}

running: False
schema_name_id: 2423
start_time: 2024-11-05 04:26:35
success: True
trace_id: 7133344150245286273

Scan 6671380

duration: 0:00:14.086119

exit_message:

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

id: 6671380

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_cancellation_reasons/2024-11-04/1730785085",
        "key": "raw/newbookdev_newbookbookings_cancellation_reasons/2024-11-04/1730785085/bookings_cancellation_reasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_cancellation_reasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12249724741462977633,
        "service_name": "drive-thru",
        "span_id": 16924083201782023497,
        "trace_id": 2247958650591875222
    }
}

running: False
schema_name_id: 2423
start_time: 2024-11-05 03:51:20
success: True
trace_id: 2247958650591875222

Scan 6669734

duration: 0:00:13.907241

exit_message:

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

id: 6669734

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_cancellation_reasons/2024-11-04/1730784779",
        "key": "raw/newbookdev_newbookbookings_cancellation_reasons/2024-11-04/1730784779/bookings_cancellation_reasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_cancellation_reasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4856243587753282449,
        "service_name": "drive-thru",
        "span_id": 7190880571738203048,
        "trace_id": 14649471641128318462
    }
}

running: False
schema_name_id: 2423
start_time: 2024-11-05 03:05:10
success: True
trace_id: 14649471641128318462

Scan 6669730

duration: 0:00:14.063547

exit_message:

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

id: 6669730

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_cancellation_reasons/2024-11-04/1730784176",
        "key": "raw/newbookdev_newbookbookings_cancellation_reasons/2024-11-04/1730784176/bookings_cancellation_reasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_cancellation_reasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2092332297750334540,
        "service_name": "drive-thru",
        "span_id": 10227789109113996961,
        "trace_id": 13779083072970447970
    }
}

running: False
schema_name_id: 2423
start_time: 2024-11-05 03:05:01
success: True
trace_id: 13779083072970447970

Scan 6668315

duration: 0:00:14.267589

exit_message:

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

id: 6668315

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_cancellation_reasons/2024-11-04/1730784013",
        "key": "raw/newbookdev_newbookbookings_cancellation_reasons/2024-11-04/1730784013/bookings_cancellation_reasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_cancellation_reasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8480620256263687478,
        "service_name": "drive-thru",
        "span_id": 14396832295923553258,
        "trace_id": 12396292976424055424
    }
}

running: False
schema_name_id: 2423
start_time: 2024-11-05 02:27:34
success: True
trace_id: 12396292976424055424

Scan 6667651

duration: 0:00:11.256910

exit_message:

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

id: 6667651

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_cancellation_reasons/2024-11-04/1730783726",
        "key": "raw/newbookdev_newbookbookings_cancellation_reasons/2024-11-04/1730783726/bookings_cancellation_reasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_cancellation_reasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14020403504210504631,
        "service_name": "drive-thru",
        "span_id": 8782988552012495545,
        "trace_id": 1155091902047370541
    }
}

running: False
schema_name_id: 2423
start_time: 2024-11-05 02:10:07
success: True
trace_id: 1155091902047370541

Scan 6667639

duration: 0:00:13.877353

exit_message:

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

id: 6667639

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_cancellation_reasons/2024-11-04/1730783833",
        "key": "raw/newbookdev_newbookbookings_cancellation_reasons/2024-11-04/1730783833/bookings_cancellation_reasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_cancellation_reasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3283245854817392491,
        "service_name": "drive-thru",
        "span_id": 15686124995502360407,
        "trace_id": 2045565769992568801
    }
}

running: False
schema_name_id: 2423
start_time: 2024-11-05 02:09:47
success: True
trace_id: 2045565769992568801

Scan 6666810

duration: 0:00:14.053453

exit_message:

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

id: 6666810

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_cancellation_reasons/2024-11-04/1730783634",
        "key": "raw/newbookdev_newbookbookings_cancellation_reasons/2024-11-04/1730783634/bookings_cancellation_reasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_cancellation_reasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18031707169881878837,
        "service_name": "drive-thru",
        "span_id": 15267524727677713354,
        "trace_id": 10315015079668349931
    }
}

running: False
schema_name_id: 2423
start_time: 2024-11-05 01:47:39
success: True
trace_id: 10315015079668349931

Scan 6666134

duration: 0:00:11.513345

exit_message:

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

id: 6666134

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_cancellation_reasons/2024-11-04/1730783482",
        "key": "raw/newbookdev_newbookbookings_cancellation_reasons/2024-11-04/1730783482/bookings_cancellation_reasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_cancellation_reasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7221799274319933908,
        "service_name": "drive-thru",
        "span_id": 11479111590468425417,
        "trace_id": 16800213124634950729
    }
}

running: False
schema_name_id: 2423
start_time: 2024-11-05 01:29:53
success: True
trace_id: 16800213124634950729

Scan 6665272

duration: 0:00:11.205706

exit_message:

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

id: 6665272

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_cancellation_reasons/2024-11-04/1730783263",
        "key": "raw/newbookdev_newbookbookings_cancellation_reasons/2024-11-04/1730783263/bookings_cancellation_reasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_cancellation_reasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11190272134968973023,
        "service_name": "drive-thru",
        "span_id": 15272549826724210679,
        "trace_id": 11423534361619008958
    }
}

running: False
schema_name_id: 2423
start_time: 2024-11-05 01:07:08
success: True
trace_id: 11423534361619008958

Scan 6664562

duration: 0:00:11.262287

exit_message:

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

id: 6664562

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_cancellation_reasons/2024-11-04/1730782866",
        "key": "raw/newbookdev_newbookbookings_cancellation_reasons/2024-11-04/1730782866/bookings_cancellation_reasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_cancellation_reasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1456087749020386838,
        "service_name": "drive-thru",
        "span_id": 11547289818175018418,
        "trace_id": 15170365211855068103
    }
}

running: False
schema_name_id: 2423
start_time: 2024-11-05 00:48:18
success: True
trace_id: 15170365211855068103

Scan 6664046

duration: 0:00:11.498399

exit_message:

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

id: 6664046

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_cancellation_reasons/2024-11-04/1730782775",
        "key": "raw/newbookdev_newbookbookings_cancellation_reasons/2024-11-04/1730782775/bookings_cancellation_reasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_cancellation_reasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13081254191010520627,
        "service_name": "drive-thru",
        "span_id": 9853366320954870783,
        "trace_id": 14697332148394303281
    }
}

running: False
schema_name_id: 2423
start_time: 2024-11-05 00:34:49
success: True
trace_id: 14697332148394303281

Partitions:

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

Schema:

attributes:

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

created: 2024-11-05 22:31:19

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_cancellation_reasons`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `source`  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_cancellation_reasons/2024-11-05/1730866375'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_cancellation_reasons`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_cancellation_reasons"
}

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