Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbooktickets_cc

created: 2024-10-08 18:37:50
disabled: False
format: raw
id: 3078
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4749500

created: 2024-11-05 23:58:05

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktickets_cc/2024-11-05/1730866621
id: 4749500
processed: 1

raw_data:

{
    "active": 6,
    "id": 2,
    "newbook_region": 0,
    "recipient": 4,
    "recipient_name": 5,
    "tenant": 1,
    "ticket_id": 3
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "newbook_region": "string",
    "recipient": "string",
    "recipient_name": "string",
    "tenant": "string",
    "ticket_id": "string"
}

schema_name_id: 3078
schema_scan_id: 6675583
updated: 2024-11-05 23:58:19

Version 4749356

created: 2024-11-05 23:41:52

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktickets_cc/2024-11-05/1730866578
id: 4749356
processed: 1

raw_data:

{
    "active": 6,
    "id": 2,
    "newbook_region": 0,
    "recipient": 4,
    "recipient_name": 5,
    "tenant": 1,
    "ticket_id": 3
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "newbook_region": "string",
    "recipient": "string",
    "recipient_name": "string",
    "tenant": "string",
    "ticket_id": "string"
}

schema_name_id: 3078
schema_scan_id: 6675389
updated: 2024-11-05 23:42:06

Version 4748637

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktickets_cc/2024-11-05/1730866478
id: 4748637
processed: 1

raw_data:

{
    "active": 6,
    "id": 2,
    "newbook_region": 0,
    "recipient": 4,
    "recipient_name": 5,
    "tenant": 1,
    "ticket_id": 3
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "newbook_region": "string",
    "recipient": "string",
    "recipient_name": "string",
    "tenant": "string",
    "ticket_id": "string"
}

schema_name_id: 3078
schema_scan_id: 6674669
updated: 2024-11-05 22:54:40

Version 4747153

created: 2024-11-05 04:55:59

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktickets_cc/2024-11-04/1730785819
id: 4747153
processed: 1

raw_data:

{
    "active": 6,
    "id": 2,
    "newbook_region": 0,
    "recipient": 4,
    "recipient_name": 5,
    "tenant": 1,
    "ticket_id": 3
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "newbook_region": "string",
    "recipient": "string",
    "recipient_name": "string",
    "tenant": "string",
    "ticket_id": "string"
}

schema_name_id: 3078
schema_scan_id: 6672385
updated: 2024-11-05 04:56:12

Version 4746773

created: 2024-11-05 04:22:11

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktickets_cc/2024-11-04/1730785179
id: 4746773
processed: 1

raw_data:

{
    "active": 6,
    "id": 2,
    "newbook_region": 0,
    "recipient": 4,
    "recipient_name": 5,
    "tenant": 1,
    "ticket_id": 3
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "newbook_region": "string",
    "recipient": "string",
    "recipient_name": "string",
    "tenant": "string",
    "ticket_id": "string"
}

schema_name_id: 3078
schema_scan_id: 6672001
updated: 2024-11-05 04:22:22

Version 4745838

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktickets_cc/2024-11-04/1730784874
id: 4745838
processed: 1

raw_data:

{
    "active": 6,
    "id": 2,
    "newbook_region": 0,
    "recipient": 4,
    "recipient_name": 5,
    "tenant": 1,
    "ticket_id": 3
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "newbook_region": "string",
    "recipient": "string",
    "recipient_name": "string",
    "tenant": "string",
    "ticket_id": "string"
}

schema_name_id: 3078
schema_scan_id: 6671055
updated: 2024-11-05 03:40:38

Version 4745081

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktickets_cc/2024-11-04/1730784270
id: 4745081
processed: 1

raw_data:

{
    "active": 6,
    "id": 2,
    "newbook_region": 0,
    "recipient": 4,
    "recipient_name": 5,
    "tenant": 1,
    "ticket_id": 3
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "newbook_region": "string",
    "recipient": "string",
    "recipient_name": "string",
    "tenant": "string",
    "ticket_id": "string"
}

schema_name_id: 3078
schema_scan_id: 6670299
updated: 2024-11-05 03:20:21

Version 4744770

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktickets_cc/2024-11-04/1730784109
id: 4744770
processed: 1

raw_data:

{
    "active": 6,
    "id": 2,
    "newbook_region": 0,
    "recipient": 4,
    "recipient_name": 5,
    "tenant": 1,
    "ticket_id": 3
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "newbook_region": "string",
    "recipient": "string",
    "recipient_name": "string",
    "tenant": "string",
    "ticket_id": "string"
}

schema_name_id: 3078
schema_scan_id: 6669987
updated: 2024-11-05 03:12:06

Version 4743199

created: 2024-11-05 02:30:13

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktickets_cc/2024-11-04/1730783857
id: 4743199
processed: 1

raw_data:

{
    "active": 6,
    "id": 2,
    "newbook_region": 0,
    "recipient": 4,
    "recipient_name": 5,
    "tenant": 1,
    "ticket_id": 3
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "newbook_region": "string",
    "recipient": "string",
    "recipient_name": "string",
    "tenant": "string",
    "ticket_id": "string"
}

schema_name_id: 3078
schema_scan_id: 6668416
updated: 2024-11-05 02:30:26

Version 4743002

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktickets_cc/2024-11-04/1730783822
id: 4743002
processed: 1

raw_data:

{
    "active": 6,
    "id": 2,
    "newbook_region": 0,
    "recipient": 4,
    "recipient_name": 5,
    "tenant": 1,
    "ticket_id": 3
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "newbook_region": "string",
    "recipient": "string",
    "recipient_name": "string",
    "tenant": "string",
    "ticket_id": "string"
}

schema_name_id: 3078
schema_scan_id: 6668219
updated: 2024-11-05 02:25:16

Version 4741669

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktickets_cc/2024-11-04/1730783706
id: 4741669
processed: 1

raw_data:

{
    "active": 6,
    "id": 2,
    "newbook_region": 0,
    "recipient": 4,
    "recipient_name": 5,
    "tenant": 1,
    "ticket_id": 3
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "newbook_region": "string",
    "recipient": "string",
    "recipient_name": "string",
    "tenant": "string",
    "ticket_id": "string"
}

schema_name_id: 3078
schema_scan_id: 6666886
updated: 2024-11-05 01:49:51

Version 4741563

created: 2024-11-05 01:46:51

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktickets_cc/2024-11-04/1730783579
id: 4741563
processed: 1

raw_data:

{
    "active": 6,
    "id": 2,
    "newbook_region": 0,
    "recipient": 4,
    "recipient_name": 5,
    "tenant": 1,
    "ticket_id": 3
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "newbook_region": "string",
    "recipient": "string",
    "recipient_name": "string",
    "tenant": "string",
    "ticket_id": "string"
}

schema_name_id: 3078
schema_scan_id: 6666780
updated: 2024-11-05 01:47:01

Version 4740593

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktickets_cc/2024-11-04/1730783361
id: 4740593
processed: 1

raw_data:

{
    "active": 6,
    "id": 2,
    "newbook_region": 0,
    "recipient": 4,
    "recipient_name": 5,
    "tenant": 1,
    "ticket_id": 3
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "newbook_region": "string",
    "recipient": "string",
    "recipient_name": "string",
    "tenant": "string",
    "ticket_id": "string"
}

schema_name_id: 3078
schema_scan_id: 6665810
updated: 2024-11-05 01:21:33

Version 4739883

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktickets_cc/2024-11-04/1730782958
id: 4739883
processed: 1

raw_data:

{
    "active": 6,
    "id": 2,
    "newbook_region": 0,
    "recipient": 4,
    "recipient_name": 5,
    "tenant": 1,
    "ticket_id": 3
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "newbook_region": "string",
    "recipient": "string",
    "recipient_name": "string",
    "tenant": "string",
    "ticket_id": "string"
}

schema_name_id: 3078
schema_scan_id: 6665100
updated: 2024-11-05 01:02:42

Version 4739187

created: 2024-11-05 00:44:03

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktickets_cc/2024-11-04/1730782846
id: 4739187
processed: 1

raw_data:

{
    "active": 6,
    "id": 2,
    "newbook_region": 0,
    "recipient": 4,
    "recipient_name": 5,
    "tenant": 1,
    "ticket_id": 3
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "newbook_region": "string",
    "recipient": "string",
    "recipient_name": "string",
    "tenant": "string",
    "ticket_id": "string"
}

schema_name_id: 3078
schema_scan_id: 6664402
updated: 2024-11-05 00:44:16

Schema Scans: 15

Last at 2024-11-05 23:58:05

Scan 6675583

duration: 0:00:14.058743

exit_message:

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

id: 6675583

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_newbooktickets_cc/2024-11-05/1730866621",
        "key": "raw/newbookdev_newbooktickets_cc/2024-11-05/1730866621/tickets_cc.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktickets_cc",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14647776780108853050,
        "service_name": "drive-thru",
        "span_id": 1276373944600754427,
        "trace_id": 3932879844801209834
    }
}

running: False
schema_name_id: 3078
start_time: 2024-11-05 23:58:05
success: True
trace_id: 3932879844801209834

Scan 6675389

duration: 0:00:14.179245

exit_message:

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

id: 6675389

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_newbooktickets_cc/2024-11-05/1730866578",
        "key": "raw/newbookdev_newbooktickets_cc/2024-11-05/1730866578/tickets_cc.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktickets_cc",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1001188000811422124,
        "service_name": "drive-thru",
        "span_id": 2600026228610359350,
        "trace_id": 1832099367677599453
    }
}

running: False
schema_name_id: 3078
start_time: 2024-11-05 23:41:51
success: True
trace_id: 1832099367677599453

Scan 6674669

duration: 0:00:11.516847

exit_message:

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

id: 6674669

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_newbooktickets_cc/2024-11-05/1730866478",
        "key": "raw/newbookdev_newbooktickets_cc/2024-11-05/1730866478/tickets_cc.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktickets_cc",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11885123974309715165,
        "service_name": "drive-thru",
        "span_id": 17489212594663265073,
        "trace_id": 6914705697852071367
    }
}

running: False
schema_name_id: 3078
start_time: 2024-11-05 22:54:28
success: True
trace_id: 6914705697852071367

Scan 6672385

duration: 0:00:13.991119

exit_message:

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

id: 6672385

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_newbooktickets_cc/2024-11-04/1730785819",
        "key": "raw/newbookdev_newbooktickets_cc/2024-11-04/1730785819/tickets_cc.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktickets_cc",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17391637878275484527,
        "service_name": "drive-thru",
        "span_id": 13815562723026699911,
        "trace_id": 2309522707193163788
    }
}

running: False
schema_name_id: 3078
start_time: 2024-11-05 04:55:58
success: True
trace_id: 2309522707193163788

Scan 6672001

duration: 0:00:11.478450

exit_message:

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

id: 6672001

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_newbooktickets_cc/2024-11-04/1730785179",
        "key": "raw/newbookdev_newbooktickets_cc/2024-11-04/1730785179/tickets_cc.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktickets_cc",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15287829211853074804,
        "service_name": "drive-thru",
        "span_id": 3206635410398741607,
        "trace_id": 9138481003939276210
    }
}

running: False
schema_name_id: 3078
start_time: 2024-11-05 04:22:10
success: True
trace_id: 9138481003939276210

Scan 6671055

duration: 0:00:11.535047

exit_message:

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

id: 6671055

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_newbooktickets_cc/2024-11-04/1730784874",
        "key": "raw/newbookdev_newbooktickets_cc/2024-11-04/1730784874/tickets_cc.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktickets_cc",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8320415510790801305,
        "service_name": "drive-thru",
        "span_id": 14396817101626424598,
        "trace_id": 17814577366162236120
    }
}

running: False
schema_name_id: 3078
start_time: 2024-11-05 03:40:27
success: True
trace_id: 17814577366162236120

Scan 6670299

duration: 0:00:11.406968

exit_message:

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

id: 6670299

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_newbooktickets_cc/2024-11-04/1730784270",
        "key": "raw/newbookdev_newbooktickets_cc/2024-11-04/1730784270/tickets_cc.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktickets_cc",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18358921278743851671,
        "service_name": "drive-thru",
        "span_id": 6679844056090398981,
        "trace_id": 10693782273916164555
    }
}

running: False
schema_name_id: 3078
start_time: 2024-11-05 03:20:10
success: True
trace_id: 10693782273916164555

Scan 6669987

duration: 0:00:11.405750

exit_message:

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

id: 6669987

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_newbooktickets_cc/2024-11-04/1730784109",
        "key": "raw/newbookdev_newbooktickets_cc/2024-11-04/1730784109/tickets_cc.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktickets_cc",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12105819438358987523,
        "service_name": "drive-thru",
        "span_id": 2860448056692019326,
        "trace_id": 17954206327332863367
    }
}

running: False
schema_name_id: 3078
start_time: 2024-11-05 03:11:54
success: True
trace_id: 17954206327332863367

Scan 6668416

duration: 0:00:13.940971

exit_message:

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

id: 6668416

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_newbooktickets_cc/2024-11-04/1730783857",
        "key": "raw/newbookdev_newbooktickets_cc/2024-11-04/1730783857/tickets_cc.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktickets_cc",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2009365118726899922,
        "service_name": "drive-thru",
        "span_id": 7864613169749061548,
        "trace_id": 11031012563056975488
    }
}

running: False
schema_name_id: 3078
start_time: 2024-11-05 02:30:12
success: True
trace_id: 11031012563056975488

Scan 6668219

duration: 0:00:14.087607

exit_message:

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

id: 6668219

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_newbooktickets_cc/2024-11-04/1730783822",
        "key": "raw/newbookdev_newbooktickets_cc/2024-11-04/1730783822/tickets_cc.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktickets_cc",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17677555371833917839,
        "service_name": "drive-thru",
        "span_id": 4206684645474007561,
        "trace_id": 5196770043762139693
    }
}

running: False
schema_name_id: 3078
start_time: 2024-11-05 02:25:02
success: True
trace_id: 5196770043762139693

Scan 6666886

duration: 0:00:11.399962

exit_message:

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

id: 6666886

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_newbooktickets_cc/2024-11-04/1730783706",
        "key": "raw/newbookdev_newbooktickets_cc/2024-11-04/1730783706/tickets_cc.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktickets_cc",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2987186428920991564,
        "service_name": "drive-thru",
        "span_id": 222576329631341930,
        "trace_id": 17295749998901435392
    }
}

running: False
schema_name_id: 3078
start_time: 2024-11-05 01:49:40
success: True
trace_id: 17295749998901435392

Scan 6666780

duration: 0:00:11.450811

exit_message:

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

id: 6666780

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_newbooktickets_cc/2024-11-04/1730783579",
        "key": "raw/newbookdev_newbooktickets_cc/2024-11-04/1730783579/tickets_cc.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktickets_cc",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8703824838905630798,
        "service_name": "drive-thru",
        "span_id": 7030856180744917817,
        "trace_id": 12558242083198371266
    }
}

running: False
schema_name_id: 3078
start_time: 2024-11-05 01:46:50
success: True
trace_id: 12558242083198371266

Scan 6665810

duration: 0:00:11.367581

exit_message:

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

id: 6665810

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_newbooktickets_cc/2024-11-04/1730783361",
        "key": "raw/newbookdev_newbooktickets_cc/2024-11-04/1730783361/tickets_cc.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktickets_cc",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15835569685852185974,
        "service_name": "drive-thru",
        "span_id": 14839895138238906762,
        "trace_id": 2920799977850078042
    }
}

running: False
schema_name_id: 3078
start_time: 2024-11-05 01:21:22
success: True
trace_id: 2920799977850078042

Scan 6665100

duration: 0:00:13.829889

exit_message:

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

id: 6665100

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_newbooktickets_cc/2024-11-04/1730782958",
        "key": "raw/newbookdev_newbooktickets_cc/2024-11-04/1730782958/tickets_cc.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktickets_cc",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15409402590751184455,
        "service_name": "drive-thru",
        "span_id": 17690738814340614703,
        "trace_id": 17743369125365346630
    }
}

running: False
schema_name_id: 3078
start_time: 2024-11-05 01:02:29
success: True
trace_id: 17743369125365346630

Scan 6664402

duration: 0:00:13.968456

exit_message:

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

id: 6664402

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_newbooktickets_cc/2024-11-04/1730782846",
        "key": "raw/newbookdev_newbooktickets_cc/2024-11-04/1730782846/tickets_cc.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktickets_cc",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11939600641384518179,
        "service_name": "drive-thru",
        "span_id": 14417281742738841106,
        "trace_id": 3214988695333067444
    }
}

running: False
schema_name_id: 3078
start_time: 2024-11-05 00:44:02
success: True
trace_id: 3214988695333067444

Partitions:

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

Schema:

attributes:

{
    "active": "string",
    "id": "string",
    "newbook_region": "string",
    "recipient": "string",
    "recipient_name": "string",
    "tenant": "string",
    "ticket_id": "string"
}

created: 2024-11-05 23:58:05

ddl:

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

Server:

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

Raw:

{
    "name": {
        "created": "2024-10-08 18:37:50",
        "disabled": false,
        "format": "raw",
        "id": 3078,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "newbookdev_newbooktickets_cc"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "active": "string",
            "id": "string",
            "newbook_region": "string",
            "recipient": "string",
            "recipient_name": "string",
            "tenant": "string",
            "ticket_id": "string"
        },
        "created": "2024-11-05 23:58:05",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktickets_cc`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `ticket_id`  string , `recipient`  string , `recipient_name`  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_newbooktickets_cc/2024-11-05/1730866621'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktickets_cc`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktickets_cc"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}