Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookchannel_managers_connections

created: 2024-10-08 17:43:11
disabled: False
format: raw
id: 2495
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4748225

created: 2024-11-05 22:38:47

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookchannel_managers_connections`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookchannel_managers_connections`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `instance_id`  string , `channel_manager_id`  string , `cm_code`  string , `cm_username`  string , `cm_password`  string , `cm_settings`  string , `cm_oauth`  string , `locked_when`  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_newbookchannel_managers_connections/2024-11-05/1730866401'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookchannel_managers_connections"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookchannel_managers_connections/2024-11-05/1730866401
id: 4748225
processed: 1

raw_data:

{
    "active": 11,
    "channel_manager_id": 4,
    "cm_code": 5,
    "cm_oauth": 9,
    "cm_password": 7,
    "cm_settings": 8,
    "cm_username": 6,
    "id": 2,
    "instance_id": 3,
    "locked_when": 10,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "channel_manager_id": "string",
    "cm_code": "string",
    "cm_oauth": "string",
    "cm_password": "string",
    "cm_settings": "string",
    "cm_username": "string",
    "id": "string",
    "instance_id": "string",
    "locked_when": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2495
schema_scan_id: 6674257
updated: 2024-11-05 22:39:00

Version 4747743

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookchannel_managers_connections`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookchannel_managers_connections`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `instance_id`  string , `channel_manager_id`  string , `cm_code`  string , `cm_username`  string , `cm_password`  string , `cm_settings`  string , `cm_oauth`  string , `locked_when`  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_newbookchannel_managers_connections/2024-11-05/1730866329'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookchannel_managers_connections"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookchannel_managers_connections/2024-11-05/1730866329
id: 4747743
processed: 1

raw_data:

{
    "active": 11,
    "channel_manager_id": 4,
    "cm_code": 5,
    "cm_oauth": 9,
    "cm_password": 7,
    "cm_settings": 8,
    "cm_username": 6,
    "id": 2,
    "instance_id": 3,
    "locked_when": 10,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "channel_manager_id": "string",
    "cm_code": "string",
    "cm_oauth": "string",
    "cm_password": "string",
    "cm_settings": "string",
    "cm_username": "string",
    "id": "string",
    "instance_id": "string",
    "locked_when": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2495
schema_scan_id: 6673774
updated: 2024-11-05 22:24:58

Version 4747447

created: 2024-11-05 22:16:59

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookchannel_managers_connections`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookchannel_managers_connections`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `instance_id`  string , `channel_manager_id`  string , `cm_code`  string , `cm_username`  string , `cm_password`  string , `cm_settings`  string , `cm_oauth`  string , `locked_when`  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_newbookchannel_managers_connections/2024-11-05/1730866247'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookchannel_managers_connections"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookchannel_managers_connections/2024-11-05/1730866247
id: 4747447
processed: 1

raw_data:

{
    "active": 11,
    "channel_manager_id": 4,
    "cm_code": 5,
    "cm_oauth": 9,
    "cm_password": 7,
    "cm_settings": 8,
    "cm_username": 6,
    "id": 2,
    "instance_id": 3,
    "locked_when": 10,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "channel_manager_id": "string",
    "cm_code": "string",
    "cm_oauth": "string",
    "cm_password": "string",
    "cm_settings": "string",
    "cm_username": "string",
    "id": "string",
    "instance_id": "string",
    "locked_when": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2495
schema_scan_id: 6673479
updated: 2024-11-05 22:17:10

Version 4746877

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookchannel_managers_connections`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookchannel_managers_connections`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `instance_id`  string , `channel_manager_id`  string , `cm_code`  string , `cm_username`  string , `cm_password`  string , `cm_settings`  string , `cm_oauth`  string , `locked_when`  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_newbookchannel_managers_connections/2024-11-04/1730785667'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookchannel_managers_connections"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookchannel_managers_connections/2024-11-04/1730785667
id: 4746877
processed: 1

raw_data:

{
    "active": 11,
    "channel_manager_id": 4,
    "cm_code": 5,
    "cm_oauth": 9,
    "cm_password": 7,
    "cm_settings": 8,
    "cm_username": 6,
    "id": 2,
    "instance_id": 3,
    "locked_when": 10,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "channel_manager_id": "string",
    "cm_code": "string",
    "cm_oauth": "string",
    "cm_password": "string",
    "cm_settings": "string",
    "cm_username": "string",
    "id": "string",
    "instance_id": "string",
    "locked_when": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2495
schema_scan_id: 6672107
updated: 2024-11-05 04:29:51

Version 4745900

created: 2024-11-05 03:42:21

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookchannel_managers_connections`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookchannel_managers_connections`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `instance_id`  string , `channel_manager_id`  string , `cm_code`  string , `cm_username`  string , `cm_password`  string , `cm_settings`  string , `cm_oauth`  string , `locked_when`  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_newbookchannel_managers_connections/2024-11-04/1730785092'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookchannel_managers_connections"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookchannel_managers_connections/2024-11-04/1730785092
id: 4745900
processed: 1

raw_data:

{
    "active": 11,
    "channel_manager_id": 4,
    "cm_code": 5,
    "cm_oauth": 9,
    "cm_password": 7,
    "cm_settings": 8,
    "cm_username": 6,
    "id": 2,
    "instance_id": 3,
    "locked_when": 10,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "channel_manager_id": "string",
    "cm_code": "string",
    "cm_oauth": "string",
    "cm_password": "string",
    "cm_settings": "string",
    "cm_username": "string",
    "id": "string",
    "instance_id": "string",
    "locked_when": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2495
schema_scan_id: 6671119
updated: 2024-11-05 03:42:32

Version 4745099

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookchannel_managers_connections`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookchannel_managers_connections`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `instance_id`  string , `channel_manager_id`  string , `cm_code`  string , `cm_username`  string , `cm_password`  string , `cm_settings`  string , `cm_oauth`  string , `locked_when`  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_newbookchannel_managers_connections/2024-11-04/1730784787'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookchannel_managers_connections"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookchannel_managers_connections/2024-11-04/1730784787
id: 4745099
processed: 1

raw_data:

{
    "active": 11,
    "channel_manager_id": 4,
    "cm_code": 5,
    "cm_oauth": 9,
    "cm_password": 7,
    "cm_settings": 8,
    "cm_username": 6,
    "id": 2,
    "instance_id": 3,
    "locked_when": 10,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "channel_manager_id": "string",
    "cm_code": "string",
    "cm_oauth": "string",
    "cm_password": "string",
    "cm_settings": "string",
    "cm_username": "string",
    "id": "string",
    "instance_id": "string",
    "locked_when": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2495
schema_scan_id: 6670316
updated: 2024-11-05 03:20:51

Version 4744585

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookchannel_managers_connections`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookchannel_managers_connections`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `instance_id`  string , `channel_manager_id`  string , `cm_code`  string , `cm_username`  string , `cm_password`  string , `cm_settings`  string , `cm_oauth`  string , `locked_when`  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_newbookchannel_managers_connections/2024-11-04/1730784184'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookchannel_managers_connections"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookchannel_managers_connections/2024-11-04/1730784184
id: 4744585
processed: 1

raw_data:

{
    "active": 11,
    "channel_manager_id": 4,
    "cm_code": 5,
    "cm_oauth": 9,
    "cm_password": 7,
    "cm_settings": 8,
    "cm_username": 6,
    "id": 2,
    "instance_id": 3,
    "locked_when": 10,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "channel_manager_id": "string",
    "cm_code": "string",
    "cm_oauth": "string",
    "cm_password": "string",
    "cm_settings": "string",
    "cm_username": "string",
    "id": "string",
    "instance_id": "string",
    "locked_when": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2495
schema_scan_id: 6669802
updated: 2024-11-05 03:07:14

Version 4744071

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookchannel_managers_connections`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookchannel_managers_connections`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `instance_id`  string , `channel_manager_id`  string , `cm_code`  string , `cm_username`  string , `cm_password`  string , `cm_settings`  string , `cm_oauth`  string , `locked_when`  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_newbookchannel_managers_connections/2024-11-04/1730784022'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookchannel_managers_connections"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookchannel_managers_connections/2024-11-04/1730784022
id: 4744071
processed: 1

raw_data:

{
    "active": 11,
    "channel_manager_id": 4,
    "cm_code": 5,
    "cm_oauth": 9,
    "cm_password": 7,
    "cm_settings": 8,
    "cm_username": 6,
    "id": 2,
    "instance_id": 3,
    "locked_when": 10,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "channel_manager_id": "string",
    "cm_code": "string",
    "cm_oauth": "string",
    "cm_password": "string",
    "cm_settings": "string",
    "cm_username": "string",
    "id": "string",
    "instance_id": "string",
    "locked_when": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2495
schema_scan_id: 6669288
updated: 2024-11-05 02:53:24

Version 4743357

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookchannel_managers_connections`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookchannel_managers_connections`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `instance_id`  string , `channel_manager_id`  string , `cm_code`  string , `cm_username`  string , `cm_password`  string , `cm_settings`  string , `cm_oauth`  string , `locked_when`  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_newbookchannel_managers_connections/2024-11-04/1730783875'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookchannel_managers_connections"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookchannel_managers_connections/2024-11-04/1730783875
id: 4743357
processed: 1

raw_data:

{
    "active": 11,
    "channel_manager_id": 4,
    "cm_code": 5,
    "cm_oauth": 9,
    "cm_password": 7,
    "cm_settings": 8,
    "cm_username": 6,
    "id": 2,
    "instance_id": 3,
    "locked_when": 10,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "channel_manager_id": "string",
    "cm_code": "string",
    "cm_oauth": "string",
    "cm_password": "string",
    "cm_settings": "string",
    "cm_username": "string",
    "id": "string",
    "instance_id": "string",
    "locked_when": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2495
schema_scan_id: 6668574
updated: 2024-11-05 02:34:42

Version 4741865

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookchannel_managers_connections`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookchannel_managers_connections`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `instance_id`  string , `channel_manager_id`  string , `cm_code`  string , `cm_username`  string , `cm_password`  string , `cm_settings`  string , `cm_oauth`  string , `locked_when`  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_newbookchannel_managers_connections/2024-11-04/1730783640'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookchannel_managers_connections"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookchannel_managers_connections/2024-11-04/1730783640
id: 4741865
processed: 1

raw_data:

{
    "active": 11,
    "channel_manager_id": 4,
    "cm_code": 5,
    "cm_oauth": 9,
    "cm_password": 7,
    "cm_settings": 8,
    "cm_username": 6,
    "id": 2,
    "instance_id": 3,
    "locked_when": 10,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "channel_manager_id": "string",
    "cm_code": "string",
    "cm_oauth": "string",
    "cm_password": "string",
    "cm_settings": "string",
    "cm_username": "string",
    "id": "string",
    "instance_id": "string",
    "locked_when": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2495
schema_scan_id: 6667082
updated: 2024-11-05 01:55:00

Version 4741811

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookchannel_managers_connections`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookchannel_managers_connections`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `instance_id`  string , `channel_manager_id`  string , `cm_code`  string , `cm_username`  string , `cm_password`  string , `cm_settings`  string , `cm_oauth`  string , `locked_when`  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_newbookchannel_managers_connections/2024-11-04/1730783734'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookchannel_managers_connections"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookchannel_managers_connections/2024-11-04/1730783734
id: 4741811
processed: 1

raw_data:

{
    "active": 11,
    "channel_manager_id": 4,
    "cm_code": 5,
    "cm_oauth": 9,
    "cm_password": 7,
    "cm_settings": 8,
    "cm_username": 6,
    "id": 2,
    "instance_id": 3,
    "locked_when": 10,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "channel_manager_id": "string",
    "cm_code": "string",
    "cm_oauth": "string",
    "cm_password": "string",
    "cm_settings": "string",
    "cm_username": "string",
    "id": "string",
    "instance_id": "string",
    "locked_when": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2495
schema_scan_id: 6667028
updated: 2024-11-05 01:53:34

Version 4740912

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookchannel_managers_connections`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookchannel_managers_connections`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `instance_id`  string , `channel_manager_id`  string , `cm_code`  string , `cm_username`  string , `cm_password`  string , `cm_settings`  string , `cm_oauth`  string , `locked_when`  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_newbookchannel_managers_connections/2024-11-04/1730783490'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookchannel_managers_connections"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookchannel_managers_connections/2024-11-04/1730783490
id: 4740912
processed: 1

raw_data:

{
    "active": 11,
    "channel_manager_id": 4,
    "cm_code": 5,
    "cm_oauth": 9,
    "cm_password": 7,
    "cm_settings": 8,
    "cm_username": 6,
    "id": 2,
    "instance_id": 3,
    "locked_when": 10,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "channel_manager_id": "string",
    "cm_code": "string",
    "cm_oauth": "string",
    "cm_password": "string",
    "cm_settings": "string",
    "cm_username": "string",
    "id": "string",
    "instance_id": "string",
    "locked_when": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2495
schema_scan_id: 6666129
updated: 2024-11-05 01:29:58

Version 4740211

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookchannel_managers_connections`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookchannel_managers_connections`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `instance_id`  string , `channel_manager_id`  string , `cm_code`  string , `cm_username`  string , `cm_password`  string , `cm_settings`  string , `cm_oauth`  string , `locked_when`  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_newbookchannel_managers_connections/2024-11-04/1730783271'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookchannel_managers_connections"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookchannel_managers_connections/2024-11-04/1730783271
id: 4740211
processed: 1

raw_data:

{
    "active": 11,
    "channel_manager_id": 4,
    "cm_code": 5,
    "cm_oauth": 9,
    "cm_password": 7,
    "cm_settings": 8,
    "cm_username": 6,
    "id": 2,
    "instance_id": 3,
    "locked_when": 10,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "channel_manager_id": "string",
    "cm_code": "string",
    "cm_oauth": "string",
    "cm_password": "string",
    "cm_settings": "string",
    "cm_username": "string",
    "id": "string",
    "instance_id": "string",
    "locked_when": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2495
schema_scan_id: 6665428
updated: 2024-11-05 01:11:34

Version 4739517

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookchannel_managers_connections`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookchannel_managers_connections`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `instance_id`  string , `channel_manager_id`  string , `cm_code`  string , `cm_username`  string , `cm_password`  string , `cm_settings`  string , `cm_oauth`  string , `locked_when`  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_newbookchannel_managers_connections/2024-11-04/1730782874'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookchannel_managers_connections"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookchannel_managers_connections/2024-11-04/1730782874
id: 4739517
processed: 1

raw_data:

{
    "active": 11,
    "channel_manager_id": 4,
    "cm_code": 5,
    "cm_oauth": 9,
    "cm_password": 7,
    "cm_settings": 8,
    "cm_username": 6,
    "id": 2,
    "instance_id": 3,
    "locked_when": 10,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "channel_manager_id": "string",
    "cm_code": "string",
    "cm_oauth": "string",
    "cm_password": "string",
    "cm_settings": "string",
    "cm_username": "string",
    "id": "string",
    "instance_id": "string",
    "locked_when": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2495
schema_scan_id: 6664732
updated: 2024-11-05 00:52:55

Version 4738471

created: 2024-11-05 00:25:19

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookchannel_managers_connections`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookchannel_managers_connections`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `instance_id`  string , `channel_manager_id`  string , `cm_code`  string , `cm_username`  string , `cm_password`  string , `cm_settings`  string , `cm_oauth`  string , `locked_when`  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_newbookchannel_managers_connections/2024-11-04/1730782742'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookchannel_managers_connections"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookchannel_managers_connections/2024-11-04/1730782742
id: 4738471
processed: 1

raw_data:

{
    "active": 11,
    "channel_manager_id": 4,
    "cm_code": 5,
    "cm_oauth": 9,
    "cm_password": 7,
    "cm_settings": 8,
    "cm_username": 6,
    "id": 2,
    "instance_id": 3,
    "locked_when": 10,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "channel_manager_id": "string",
    "cm_code": "string",
    "cm_oauth": "string",
    "cm_password": "string",
    "cm_settings": "string",
    "cm_username": "string",
    "id": "string",
    "instance_id": "string",
    "locked_when": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2495
schema_scan_id: 6663682
updated: 2024-11-05 00:25:32

Schema Scans: 15

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

Scan 6674257

duration: 0:00:14.442472

exit_message:

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

id: 6674257

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_newbookchannel_managers_connections/2024-11-05/1730866401",
        "key": "raw/newbookdev_newbookchannel_managers_connections/2024-11-05/1730866401/channel_managers_connections.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookchannel_managers_connections",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 997295271019462212,
        "service_name": "drive-thru",
        "span_id": 12983231497470781197,
        "trace_id": 4294420440980437503
    }
}

running: False
schema_name_id: 2495
start_time: 2024-11-05 22:38:46
success: True
trace_id: 4294420440980437503

Scan 6673774

duration: 0:00:11.733707

exit_message:

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

id: 6673774

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_newbookchannel_managers_connections/2024-11-05/1730866329",
        "key": "raw/newbookdev_newbookchannel_managers_connections/2024-11-05/1730866329/channel_managers_connections.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookchannel_managers_connections",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13552621781041038030,
        "service_name": "drive-thru",
        "span_id": 16457585741803545673,
        "trace_id": 16285320891594420216
    }
}

running: False
schema_name_id: 2495
start_time: 2024-11-05 22:24:47
success: True
trace_id: 16285320891594420216

Scan 6673479

duration: 0:00:11.915233

exit_message:

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

id: 6673479

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_newbookchannel_managers_connections/2024-11-05/1730866247",
        "key": "raw/newbookdev_newbookchannel_managers_connections/2024-11-05/1730866247/channel_managers_connections.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookchannel_managers_connections",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9576123784810876341,
        "service_name": "drive-thru",
        "span_id": 15015656788801654315,
        "trace_id": 16822349690293899112
    }
}

running: False
schema_name_id: 2495
start_time: 2024-11-05 22:16:58
success: True
trace_id: 16822349690293899112

Scan 6672107

duration: 0:00:11.844146

exit_message:

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

id: 6672107

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_newbookchannel_managers_connections/2024-11-04/1730785667",
        "key": "raw/newbookdev_newbookchannel_managers_connections/2024-11-04/1730785667/channel_managers_connections.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookchannel_managers_connections",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3997440896949263890,
        "service_name": "drive-thru",
        "span_id": 10638322990200447018,
        "trace_id": 14820500935362671697
    }
}

running: False
schema_name_id: 2495
start_time: 2024-11-05 04:29:40
success: True
trace_id: 14820500935362671697

Scan 6671119

duration: 0:00:11.877763

exit_message:

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

id: 6671119

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_newbookchannel_managers_connections/2024-11-04/1730785092",
        "key": "raw/newbookdev_newbookchannel_managers_connections/2024-11-04/1730785092/channel_managers_connections.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookchannel_managers_connections",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10272926988104667529,
        "service_name": "drive-thru",
        "span_id": 835677807511999037,
        "trace_id": 17836798959366553776
    }
}

running: False
schema_name_id: 2495
start_time: 2024-11-05 03:42:21
success: True
trace_id: 17836798959366553776

Scan 6670316

duration: 0:00:14.158178

exit_message:

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

id: 6670316

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_newbookchannel_managers_connections/2024-11-04/1730784787",
        "key": "raw/newbookdev_newbookchannel_managers_connections/2024-11-04/1730784787/channel_managers_connections.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookchannel_managers_connections",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4955762809159253394,
        "service_name": "drive-thru",
        "span_id": 17118396844026597793,
        "trace_id": 4538715981547910529
    }
}

running: False
schema_name_id: 2495
start_time: 2024-11-05 03:20:37
success: True
trace_id: 4538715981547910529

Scan 6669802

duration: 0:00:14.149841

exit_message:

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

id: 6669802

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_newbookchannel_managers_connections/2024-11-04/1730784184",
        "key": "raw/newbookdev_newbookchannel_managers_connections/2024-11-04/1730784184/channel_managers_connections.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookchannel_managers_connections",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8543726706266560416,
        "service_name": "drive-thru",
        "span_id": 7243406601307583893,
        "trace_id": 14689552419758375346
    }
}

running: False
schema_name_id: 2495
start_time: 2024-11-05 03:07:00
success: True
trace_id: 14689552419758375346

Scan 6669288

duration: 0:00:11.562075

exit_message:

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

id: 6669288

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_newbookchannel_managers_connections/2024-11-04/1730784022",
        "key": "raw/newbookdev_newbookchannel_managers_connections/2024-11-04/1730784022/channel_managers_connections.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookchannel_managers_connections",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9757632898766638619,
        "service_name": "drive-thru",
        "span_id": 3276889602458092200,
        "trace_id": 688230540992452523
    }
}

running: False
schema_name_id: 2495
start_time: 2024-11-05 02:53:13
success: True
trace_id: 688230540992452523

Scan 6668574

duration: 0:00:14.155571

exit_message:

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

id: 6668574

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_newbookchannel_managers_connections/2024-11-04/1730783875",
        "key": "raw/newbookdev_newbookchannel_managers_connections/2024-11-04/1730783875/channel_managers_connections.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookchannel_managers_connections",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5385006031177250817,
        "service_name": "drive-thru",
        "span_id": 10342947500569770459,
        "trace_id": 17455533350755133534
    }
}

running: False
schema_name_id: 2495
start_time: 2024-11-05 02:34:28
success: True
trace_id: 17455533350755133534

Scan 6667082

duration: 0:00:14.049824

exit_message:

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

id: 6667082

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_newbookchannel_managers_connections/2024-11-04/1730783640",
        "key": "raw/newbookdev_newbookchannel_managers_connections/2024-11-04/1730783640/channel_managers_connections.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookchannel_managers_connections",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10301998074190353966,
        "service_name": "drive-thru",
        "span_id": 8899731537382809164,
        "trace_id": 2266645616221598569
    }
}

running: False
schema_name_id: 2495
start_time: 2024-11-05 01:54:46
success: True
trace_id: 2266645616221598569

Scan 6667028

duration: 0:00:11.590956

exit_message:

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

id: 6667028

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_newbookchannel_managers_connections/2024-11-04/1730783734",
        "key": "raw/newbookdev_newbookchannel_managers_connections/2024-11-04/1730783734/channel_managers_connections.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookchannel_managers_connections",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2998214742353808270,
        "service_name": "drive-thru",
        "span_id": 16984006082391699823,
        "trace_id": 10454311323551879456
    }
}

running: False
schema_name_id: 2495
start_time: 2024-11-05 01:53:22
success: True
trace_id: 10454311323551879456

Scan 6666129

duration: 0:00:11.570306

exit_message:

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

id: 6666129

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_newbookchannel_managers_connections/2024-11-04/1730783490",
        "key": "raw/newbookdev_newbookchannel_managers_connections/2024-11-04/1730783490/channel_managers_connections.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookchannel_managers_connections",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7117348962371148208,
        "service_name": "drive-thru",
        "span_id": 10992433122127256270,
        "trace_id": 10370568250766479458
    }
}

running: False
schema_name_id: 2495
start_time: 2024-11-05 01:29:46
success: True
trace_id: 10370568250766479458

Scan 6665428

duration: 0:00:14.206284

exit_message:

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

id: 6665428

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_newbookchannel_managers_connections/2024-11-04/1730783271",
        "key": "raw/newbookdev_newbookchannel_managers_connections/2024-11-04/1730783271/channel_managers_connections.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookchannel_managers_connections",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9672036788684583267,
        "service_name": "drive-thru",
        "span_id": 11756457397084789657,
        "trace_id": 14521180102695853249
    }
}

running: False
schema_name_id: 2495
start_time: 2024-11-05 01:11:20
success: True
trace_id: 14521180102695853249

Scan 6664732

duration: 0:00:11.583975

exit_message:

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

id: 6664732

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_newbookchannel_managers_connections/2024-11-04/1730782874",
        "key": "raw/newbookdev_newbookchannel_managers_connections/2024-11-04/1730782874/channel_managers_connections.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookchannel_managers_connections",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 298445544441431712,
        "service_name": "drive-thru",
        "span_id": 17270157775904918517,
        "trace_id": 12089354182330871184
    }
}

running: False
schema_name_id: 2495
start_time: 2024-11-05 00:52:43
success: True
trace_id: 12089354182330871184

Scan 6663682

duration: 0:00:14.084192

exit_message:

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

id: 6663682

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_newbookchannel_managers_connections/2024-11-04/1730782742",
        "key": "raw/newbookdev_newbookchannel_managers_connections/2024-11-04/1730782742/channel_managers_connections.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookchannel_managers_connections",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15293363593057962834,
        "service_name": "drive-thru",
        "span_id": 3177437887945269978,
        "trace_id": 11353293977992035648
    }
}

running: False
schema_name_id: 2495
start_time: 2024-11-05 00:25:18
success: True
trace_id: 11353293977992035648

Partitions:

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

Schema:

attributes:

{
    "active": "string",
    "channel_manager_id": "string",
    "cm_code": "string",
    "cm_oauth": "string",
    "cm_password": "string",
    "cm_settings": "string",
    "cm_username": "string",
    "id": "string",
    "instance_id": "string",
    "locked_when": "string",
    "newbook_region": "string",
    "tenant": "string"
}

created: 2024-11-05 22:38:47

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookchannel_managers_connections`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `instance_id`  string , `channel_manager_id`  string , `cm_code`  string , `cm_username`  string , `cm_password`  string , `cm_settings`  string , `cm_oauth`  string , `locked_when`  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_newbookchannel_managers_connections/2024-11-05/1730866401'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookchannel_managers_connections`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookchannel_managers_connections"
}

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