Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookewn_alerts_instances

created: 2024-10-08 17:56:22
disabled: False
format: raw
id: 2678
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4748858

created: 2024-11-05 23:05:29

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookewn_alerts_instances/2024-11-05/1730866491
id: 4748858
processed: 1

raw_data:

{
    "alert_id": 3,
    "id": 2,
    "instance_id": 4,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "alert_id": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2678
schema_scan_id: 6674890
updated: 2024-11-05 23:05:40

Version 4748429

created: 2024-11-05 22:45:58

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookewn_alerts_instances/2024-11-05/1730866407
id: 4748429
processed: 1

raw_data:

{
    "alert_id": 3,
    "id": 2,
    "instance_id": 4,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "alert_id": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2678
schema_scan_id: 6674461
updated: 2024-11-05 22:46:12

Version 4747601

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookewn_alerts_instances/2024-11-05/1730866293
id: 4747601
processed: 1

raw_data:

{
    "alert_id": 3,
    "id": 2,
    "instance_id": 4,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "alert_id": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2678
schema_scan_id: 6673634
updated: 2024-11-05 22:21:20

Version 4746189

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookewn_alerts_instances/2024-11-04/1730785119
id: 4746189
processed: 1

raw_data:

{
    "alert_id": 3,
    "id": 2,
    "instance_id": 4,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "alert_id": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2678
schema_scan_id: 6671410
updated: 2024-11-05 03:52:38

Version 4746097

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookewn_alerts_instances/2024-11-04/1730785710
id: 4746097
processed: 1

raw_data:

{
    "alert_id": 3,
    "id": 2,
    "instance_id": 4,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "alert_id": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2678
schema_scan_id: 6671318
updated: 2024-11-05 03:49:25

Version 4745396

created: 2024-11-05 03:28:19

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookewn_alerts_instances/2024-11-04/1730784814
id: 4745396
processed: 1

raw_data:

{
    "alert_id": 3,
    "id": 2,
    "instance_id": 4,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "alert_id": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2678
schema_scan_id: 6670613
updated: 2024-11-05 03:28:32

Version 4744516

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookewn_alerts_instances/2024-11-04/1730784210
id: 4744516
processed: 1

raw_data:

{
    "alert_id": 3,
    "id": 2,
    "instance_id": 4,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "alert_id": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2678
schema_scan_id: 6669733
updated: 2024-11-05 03:05:21

Version 4743471

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookewn_alerts_instances/2024-11-04/1730783894
id: 4743471
processed: 1

raw_data:

{
    "alert_id": 3,
    "id": 2,
    "instance_id": 4,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "alert_id": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2678
schema_scan_id: 6668688
updated: 2024-11-05 02:37:40

Version 4743355

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookewn_alerts_instances/2024-11-04/1730784047
id: 4743355
processed: 1

raw_data:

{
    "alert_id": 3,
    "id": 2,
    "instance_id": 4,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "alert_id": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2678
schema_scan_id: 6668572
updated: 2024-11-05 02:34:35

Version 4742438

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookewn_alerts_instances/2024-11-04/1730783761
id: 4742438
processed: 1

raw_data:

{
    "alert_id": 3,
    "id": 2,
    "instance_id": 4,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "alert_id": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2678
schema_scan_id: 6667655
updated: 2024-11-05 02:10:24

Version 4741980

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookewn_alerts_instances/2024-11-04/1730783660
id: 4741980
processed: 1

raw_data:

{
    "alert_id": 3,
    "id": 2,
    "instance_id": 4,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "alert_id": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2678
schema_scan_id: 6667196
updated: 2024-11-05 01:58:05

Version 4741055

created: 2024-11-05 01:33:36

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookewn_alerts_instances/2024-11-04/1730783516
id: 4741055
processed: 1

raw_data:

{
    "alert_id": 3,
    "id": 2,
    "instance_id": 4,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "alert_id": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2678
schema_scan_id: 6666272
updated: 2024-11-05 01:33:47

Version 4740252

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookewn_alerts_instances/2024-11-04/1730783299
id: 4740252
processed: 1

raw_data:

{
    "alert_id": 3,
    "id": 2,
    "instance_id": 4,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "alert_id": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2678
schema_scan_id: 6665469
updated: 2024-11-05 01:12:43

Version 4739554

created: 2024-11-05 00:53:41

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookewn_alerts_instances/2024-11-04/1730782900
id: 4739554
processed: 1

raw_data:

{
    "alert_id": 3,
    "id": 2,
    "instance_id": 4,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "alert_id": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2678
schema_scan_id: 6664769
updated: 2024-11-05 00:53:54

Version 4738532

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookewn_alerts_instances/2024-11-04/1730782749
id: 4738532
processed: 1

raw_data:

{
    "alert_id": 3,
    "id": 2,
    "instance_id": 4,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "alert_id": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2678
schema_scan_id: 6663745
updated: 2024-11-05 00:27:07

Schema Scans: 15

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

Scan 6674890

duration: 0:00:11.634730

exit_message:

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

id: 6674890

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_newbookewn_alerts_instances/2024-11-05/1730866491",
        "key": "raw/newbookdev_newbookewn_alerts_instances/2024-11-05/1730866491/ewn_alerts_instances.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookewn_alerts_instances",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1097917200500748386,
        "service_name": "drive-thru",
        "span_id": 8384974960045551826,
        "trace_id": 17932016959866426228
    }
}

running: False
schema_name_id: 2678
start_time: 2024-11-05 23:05:29
success: True
trace_id: 17932016959866426228

Scan 6674461

duration: 0:00:14.152869

exit_message:

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

id: 6674461

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_newbookewn_alerts_instances/2024-11-05/1730866407",
        "key": "raw/newbookdev_newbookewn_alerts_instances/2024-11-05/1730866407/ewn_alerts_instances.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookewn_alerts_instances",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17147276063780409921,
        "service_name": "drive-thru",
        "span_id": 11325954500293775614,
        "trace_id": 1227138429889764330
    }
}

running: False
schema_name_id: 2678
start_time: 2024-11-05 22:45:57
success: True
trace_id: 1227138429889764330

Scan 6673634

duration: 0:00:13.908215

exit_message:

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

id: 6673634

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_newbookewn_alerts_instances/2024-11-05/1730866293",
        "key": "raw/newbookdev_newbookewn_alerts_instances/2024-11-05/1730866293/ewn_alerts_instances.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookewn_alerts_instances",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13153340284268466228,
        "service_name": "drive-thru",
        "span_id": 12424263585402306813,
        "trace_id": 10193437424346012402
    }
}

running: False
schema_name_id: 2678
start_time: 2024-11-05 22:21:06
success: True
trace_id: 10193437424346012402

Scan 6671410

duration: 0:00:11.499331

exit_message:

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

id: 6671410

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_newbookewn_alerts_instances/2024-11-04/1730785119",
        "key": "raw/newbookdev_newbookewn_alerts_instances/2024-11-04/1730785119/ewn_alerts_instances.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookewn_alerts_instances",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13914175913295776705,
        "service_name": "drive-thru",
        "span_id": 10785421336082133261,
        "trace_id": 16130106913149826575
    }
}

running: False
schema_name_id: 2678
start_time: 2024-11-05 03:52:26
success: True
trace_id: 16130106913149826575

Scan 6671318

duration: 0:00:14.083022

exit_message:

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

id: 6671318

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_newbookewn_alerts_instances/2024-11-04/1730785710",
        "key": "raw/newbookdev_newbookewn_alerts_instances/2024-11-04/1730785710/ewn_alerts_instances.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookewn_alerts_instances",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5382404423073220156,
        "service_name": "drive-thru",
        "span_id": 3399082143371827885,
        "trace_id": 17778256866255480145
    }
}

running: False
schema_name_id: 2678
start_time: 2024-11-05 03:49:11
success: True
trace_id: 17778256866255480145

Scan 6670613

duration: 0:00:13.825763

exit_message:

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

id: 6670613

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_newbookewn_alerts_instances/2024-11-04/1730784814",
        "key": "raw/newbookdev_newbookewn_alerts_instances/2024-11-04/1730784814/ewn_alerts_instances.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookewn_alerts_instances",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7612308363372288239,
        "service_name": "drive-thru",
        "span_id": 3223265014603013179,
        "trace_id": 4292756180873030146
    }
}

running: False
schema_name_id: 2678
start_time: 2024-11-05 03:28:18
success: True
trace_id: 4292756180873030146

Scan 6669733

duration: 0:00:11.501827

exit_message:

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

id: 6669733

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_newbookewn_alerts_instances/2024-11-04/1730784210",
        "key": "raw/newbookdev_newbookewn_alerts_instances/2024-11-04/1730784210/ewn_alerts_instances.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookewn_alerts_instances",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4576801882287386619,
        "service_name": "drive-thru",
        "span_id": 6288606084259950042,
        "trace_id": 7660807659156816110
    }
}

running: False
schema_name_id: 2678
start_time: 2024-11-05 03:05:10
success: True
trace_id: 7660807659156816110

Scan 6668688

duration: 0:00:11.473984

exit_message:

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

id: 6668688

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_newbookewn_alerts_instances/2024-11-04/1730783894",
        "key": "raw/newbookdev_newbookewn_alerts_instances/2024-11-04/1730783894/ewn_alerts_instances.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookewn_alerts_instances",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5879020977875285891,
        "service_name": "drive-thru",
        "span_id": 14268984193314792993,
        "trace_id": 16064834339864982612
    }
}

running: False
schema_name_id: 2678
start_time: 2024-11-05 02:37:29
success: True
trace_id: 16064834339864982612

Scan 6668572

duration: 0:00:11.352956

exit_message:

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

id: 6668572

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_newbookewn_alerts_instances/2024-11-04/1730784047",
        "key": "raw/newbookdev_newbookewn_alerts_instances/2024-11-04/1730784047/ewn_alerts_instances.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookewn_alerts_instances",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1174235143353924819,
        "service_name": "drive-thru",
        "span_id": 11679464666237493745,
        "trace_id": 5421497757793435907
    }
}

running: False
schema_name_id: 2678
start_time: 2024-11-05 02:34:23
success: True
trace_id: 5421497757793435907

Scan 6667655

duration: 0:00:11.314914

exit_message:

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

id: 6667655

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_newbookewn_alerts_instances/2024-11-04/1730783761",
        "key": "raw/newbookdev_newbookewn_alerts_instances/2024-11-04/1730783761/ewn_alerts_instances.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookewn_alerts_instances",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14361804374135475102,
        "service_name": "drive-thru",
        "span_id": 8341469786780233079,
        "trace_id": 10921726799999101790
    }
}

running: False
schema_name_id: 2678
start_time: 2024-11-05 02:10:13
success: True
trace_id: 10921726799999101790

Scan 6667196

duration: 0:00:13.901492

exit_message:

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

id: 6667196

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_newbookewn_alerts_instances/2024-11-04/1730783660",
        "key": "raw/newbookdev_newbookewn_alerts_instances/2024-11-04/1730783660/ewn_alerts_instances.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookewn_alerts_instances",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13092128194144409357,
        "service_name": "drive-thru",
        "span_id": 7165847890683669193,
        "trace_id": 3694077297898680897
    }
}

running: False
schema_name_id: 2678
start_time: 2024-11-05 01:57:51
success: True
trace_id: 3694077297898680897

Scan 6666272

duration: 0:00:11.325371

exit_message:

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

id: 6666272

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_newbookewn_alerts_instances/2024-11-04/1730783516",
        "key": "raw/newbookdev_newbookewn_alerts_instances/2024-11-04/1730783516/ewn_alerts_instances.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookewn_alerts_instances",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6322917662623706615,
        "service_name": "drive-thru",
        "span_id": 547813352689600219,
        "trace_id": 6347123355826576088
    }
}

running: False
schema_name_id: 2678
start_time: 2024-11-05 01:33:35
success: True
trace_id: 6347123355826576088

Scan 6665469

duration: 0:00:13.956727

exit_message:

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

id: 6665469

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_newbookewn_alerts_instances/2024-11-04/1730783299",
        "key": "raw/newbookdev_newbookewn_alerts_instances/2024-11-04/1730783299/ewn_alerts_instances.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookewn_alerts_instances",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15369427582067246060,
        "service_name": "drive-thru",
        "span_id": 7298526548777640954,
        "trace_id": 10349810582730683058
    }
}

running: False
schema_name_id: 2678
start_time: 2024-11-05 01:12:29
success: True
trace_id: 10349810582730683058

Scan 6664769

duration: 0:00:13.880757

exit_message:

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

id: 6664769

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_newbookewn_alerts_instances/2024-11-04/1730782900",
        "key": "raw/newbookdev_newbookewn_alerts_instances/2024-11-04/1730782900/ewn_alerts_instances.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookewn_alerts_instances",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15842475097062613341,
        "service_name": "drive-thru",
        "span_id": 16419036681869416221,
        "trace_id": 16913215474634809651
    }
}

running: False
schema_name_id: 2678
start_time: 2024-11-05 00:53:40
success: True
trace_id: 16913215474634809651

Scan 6663745

duration: 0:00:11.458547

exit_message:

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

id: 6663745

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_newbookewn_alerts_instances/2024-11-04/1730782749",
        "key": "raw/newbookdev_newbookewn_alerts_instances/2024-11-04/1730782749/ewn_alerts_instances.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookewn_alerts_instances",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4869853969498338278,
        "service_name": "drive-thru",
        "span_id": 12541075401623105688,
        "trace_id": 7736914086899740737
    }
}

running: False
schema_name_id: 2678
start_time: 2024-11-05 00:26:55
success: True
trace_id: 7736914086899740737

Partitions:

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

Schema:

attributes:

{
    "alert_id": "string",
    "id": "string",
    "instance_id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

created: 2024-11-05 23:05:29

ddl:

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

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