Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookbalance_transfer_reasons

created: 2024-10-08 17:38:18
disabled: False
format: raw
id: 2427
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4747955

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbalance_transfer_reasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbalance_transfer_reasons`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbalance_transfer_reasons/2024-11-05/1730866369'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbalance_transfer_reasons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbalance_transfer_reasons/2024-11-05/1730866369
id: 4747955
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2427
schema_scan_id: 6673987
updated: 2024-11-05 22:30:35

Version 4747742

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbalance_transfer_reasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbalance_transfer_reasons`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbalance_transfer_reasons/2024-11-05/1730866304'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbalance_transfer_reasons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbalance_transfer_reasons/2024-11-05/1730866304
id: 4747742
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2427
schema_scan_id: 6673775
updated: 2024-11-05 22:24:58

Version 4747395

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbalance_transfer_reasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbalance_transfer_reasons`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbalance_transfer_reasons/2024-11-05/1730866233'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbalance_transfer_reasons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbalance_transfer_reasons/2024-11-05/1730866233
id: 4747395
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2427
schema_scan_id: 6673427
updated: 2024-11-05 22:15:28

Version 4746586

created: 2024-11-05 04:11:00

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbalance_transfer_reasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbalance_transfer_reasons`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbalance_transfer_reasons/2024-11-04/1730785651'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbalance_transfer_reasons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbalance_transfer_reasons/2024-11-04/1730785651
id: 4746586
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2427
schema_scan_id: 6671810
updated: 2024-11-05 04:11:11

Version 4745954

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbalance_transfer_reasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbalance_transfer_reasons`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbalance_transfer_reasons/2024-11-04/1730785083'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbalance_transfer_reasons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbalance_transfer_reasons/2024-11-04/1730785083
id: 4745954
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2427
schema_scan_id: 6671174
updated: 2024-11-05 03:44:14

Version 4745655

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbalance_transfer_reasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbalance_transfer_reasons`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbalance_transfer_reasons/2024-11-04/1730784777'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbalance_transfer_reasons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbalance_transfer_reasons/2024-11-04/1730784777
id: 4745655
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2427
schema_scan_id: 6670873
updated: 2024-11-05 03:35:23

Version 4744283

created: 2024-11-05 02:58:43

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbalance_transfer_reasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbalance_transfer_reasons`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbalance_transfer_reasons/2024-11-04/1730784174'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbalance_transfer_reasons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbalance_transfer_reasons/2024-11-04/1730784174
id: 4744283
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2427
schema_scan_id: 6669500
updated: 2024-11-05 02:58:54

Version 4743649

created: 2024-11-05 02:42:11

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbalance_transfer_reasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbalance_transfer_reasons`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbalance_transfer_reasons/2024-11-04/1730784012'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbalance_transfer_reasons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbalance_transfer_reasons/2024-11-04/1730784012
id: 4743649
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2427
schema_scan_id: 6668866
updated: 2024-11-05 02:42:22

Version 4743068

created: 2024-11-05 02:26:46

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbalance_transfer_reasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbalance_transfer_reasons`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbalance_transfer_reasons/2024-11-04/1730783833'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbalance_transfer_reasons"
]

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

raw_data:

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

schema_attributes:

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

schema_name_id: 2427
schema_scan_id: 6668285
updated: 2024-11-05 02:26:59

Version 4742289

created: 2024-11-05 02:06:12

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbalance_transfer_reasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbalance_transfer_reasons`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbalance_transfer_reasons/2024-11-04/1730783724'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbalance_transfer_reasons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbalance_transfer_reasons/2024-11-04/1730783724
id: 4742289
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2427
schema_scan_id: 6667506
updated: 2024-11-05 02:06:26

Version 4741801

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbalance_transfer_reasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbalance_transfer_reasons`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbalance_transfer_reasons/2024-11-04/1730783632'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbalance_transfer_reasons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbalance_transfer_reasons/2024-11-04/1730783632
id: 4741801
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2427
schema_scan_id: 6667018
updated: 2024-11-05 01:53:18

Version 4740899

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbalance_transfer_reasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbalance_transfer_reasons`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbalance_transfer_reasons/2024-11-04/1730783480'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbalance_transfer_reasons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbalance_transfer_reasons/2024-11-04/1730783480
id: 4740899
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2427
schema_scan_id: 6666117
updated: 2024-11-05 01:29:37

Version 4740146

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbalance_transfer_reasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbalance_transfer_reasons`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbalance_transfer_reasons/2024-11-04/1730783261'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbalance_transfer_reasons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbalance_transfer_reasons/2024-11-04/1730783261
id: 4740146
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2427
schema_scan_id: 6665363
updated: 2024-11-05 01:09:49

Version 4739456

created: 2024-11-05 00:51:06

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbalance_transfer_reasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbalance_transfer_reasons`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbalance_transfer_reasons/2024-11-04/1730782864'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbalance_transfer_reasons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbalance_transfer_reasons/2024-11-04/1730782864
id: 4739456
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2427
schema_scan_id: 6664672
updated: 2024-11-05 00:51:17

Version 4738814

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbalance_transfer_reasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbalance_transfer_reasons`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbalance_transfer_reasons/2024-11-04/1730782773'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbalance_transfer_reasons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbalance_transfer_reasons/2024-11-04/1730782773
id: 4738814
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2427
schema_scan_id: 6664027
updated: 2024-11-05 00:34:31

Schema Scans: 15

Last at 2024-11-05 22:30:24

Scan 6673987

duration: 0:00:11.401706

exit_message:

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

id: 6673987

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_newbookbalance_transfer_reasons/2024-11-05/1730866369",
        "key": "raw/newbookdev_newbookbalance_transfer_reasons/2024-11-05/1730866369/balance_transfer_reasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbalance_transfer_reasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14566934299388255487,
        "service_name": "drive-thru",
        "span_id": 4056314125349798166,
        "trace_id": 4405295830998373610
    }
}

running: False
schema_name_id: 2427
start_time: 2024-11-05 22:30:24
success: True
trace_id: 4405295830998373610

Scan 6673775

duration: 0:00:11.332050

exit_message:

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

id: 6673775

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_newbookbalance_transfer_reasons/2024-11-05/1730866304",
        "key": "raw/newbookdev_newbookbalance_transfer_reasons/2024-11-05/1730866304/balance_transfer_reasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbalance_transfer_reasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6831054416063095826,
        "service_name": "drive-thru",
        "span_id": 17811416533058858128,
        "trace_id": 8684695558820749041
    }
}

running: False
schema_name_id: 2427
start_time: 2024-11-05 22:24:47
success: True
trace_id: 8684695558820749041

Scan 6673427

duration: 0:00:14.097708

exit_message:

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

id: 6673427

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_newbookbalance_transfer_reasons/2024-11-05/1730866233",
        "key": "raw/newbookdev_newbookbalance_transfer_reasons/2024-11-05/1730866233/balance_transfer_reasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbalance_transfer_reasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5931542483142956199,
        "service_name": "drive-thru",
        "span_id": 8132782456618214408,
        "trace_id": 5030299391012154191
    }
}

running: False
schema_name_id: 2427
start_time: 2024-11-05 22:15:14
success: True
trace_id: 5030299391012154191

Scan 6671810

duration: 0:00:11.467828

exit_message:

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

id: 6671810

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_newbookbalance_transfer_reasons/2024-11-04/1730785651",
        "key": "raw/newbookdev_newbookbalance_transfer_reasons/2024-11-04/1730785651/balance_transfer_reasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbalance_transfer_reasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17138245734945959846,
        "service_name": "drive-thru",
        "span_id": 12553181659332028042,
        "trace_id": 14518458854474857843
    }
}

running: False
schema_name_id: 2427
start_time: 2024-11-05 04:11:00
success: True
trace_id: 14518458854474857843

Scan 6671174

duration: 0:00:14.015946

exit_message:

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

id: 6671174

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_newbookbalance_transfer_reasons/2024-11-04/1730785083",
        "key": "raw/newbookdev_newbookbalance_transfer_reasons/2024-11-04/1730785083/balance_transfer_reasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbalance_transfer_reasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15243436161154420346,
        "service_name": "drive-thru",
        "span_id": 10528948587033153441,
        "trace_id": 4492180489228565668
    }
}

running: False
schema_name_id: 2427
start_time: 2024-11-05 03:44:00
success: True
trace_id: 4492180489228565668

Scan 6670873

duration: 0:00:14.003768

exit_message:

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

id: 6670873

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_newbookbalance_transfer_reasons/2024-11-04/1730784777",
        "key": "raw/newbookdev_newbookbalance_transfer_reasons/2024-11-04/1730784777/balance_transfer_reasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbalance_transfer_reasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 504564067013658176,
        "service_name": "drive-thru",
        "span_id": 13108085129977828440,
        "trace_id": 1150807693554775941
    }
}

running: False
schema_name_id: 2427
start_time: 2024-11-05 03:35:09
success: True
trace_id: 1150807693554775941

Scan 6669500

duration: 0:00:11.166842

exit_message:

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

id: 6669500

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_newbookbalance_transfer_reasons/2024-11-04/1730784174",
        "key": "raw/newbookdev_newbookbalance_transfer_reasons/2024-11-04/1730784174/balance_transfer_reasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbalance_transfer_reasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14850657167209894014,
        "service_name": "drive-thru",
        "span_id": 13805470237795272163,
        "trace_id": 1827688038932789693
    }
}

running: False
schema_name_id: 2427
start_time: 2024-11-05 02:58:43
success: True
trace_id: 1827688038932789693

Scan 6668866

duration: 0:00:11.322543

exit_message:

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

id: 6668866

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_newbookbalance_transfer_reasons/2024-11-04/1730784012",
        "key": "raw/newbookdev_newbookbalance_transfer_reasons/2024-11-04/1730784012/balance_transfer_reasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbalance_transfer_reasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16485172465869860202,
        "service_name": "drive-thru",
        "span_id": 7854857053402133523,
        "trace_id": 13545369852853051381
    }
}

running: False
schema_name_id: 2427
start_time: 2024-11-05 02:42:11
success: True
trace_id: 13545369852853051381

Scan 6668285

duration: 0:00:13.752566

exit_message:

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

id: 6668285

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_newbookbalance_transfer_reasons/2024-11-04/1730783833",
        "key": "raw/newbookdev_newbookbalance_transfer_reasons/2024-11-04/1730783833/balance_transfer_reasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbalance_transfer_reasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14213847936022587525,
        "service_name": "drive-thru",
        "span_id": 5897502707396955968,
        "trace_id": 11388247935837429197
    }
}

running: False
schema_name_id: 2427
start_time: 2024-11-05 02:26:46
success: True
trace_id: 11388247935837429197

Scan 6667506

duration: 0:00:13.845452

exit_message:

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

id: 6667506

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_newbookbalance_transfer_reasons/2024-11-04/1730783724",
        "key": "raw/newbookdev_newbookbalance_transfer_reasons/2024-11-04/1730783724/balance_transfer_reasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbalance_transfer_reasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2981379081624887884,
        "service_name": "drive-thru",
        "span_id": 16066545816311447362,
        "trace_id": 8178069742466378787
    }
}

running: False
schema_name_id: 2427
start_time: 2024-11-05 02:06:12
success: True
trace_id: 8178069742466378787

Scan 6667018

duration: 0:00:11.341253

exit_message:

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

id: 6667018

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_newbookbalance_transfer_reasons/2024-11-04/1730783632",
        "key": "raw/newbookdev_newbookbalance_transfer_reasons/2024-11-04/1730783632/balance_transfer_reasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbalance_transfer_reasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1938343756380438109,
        "service_name": "drive-thru",
        "span_id": 1792087290241520036,
        "trace_id": 10838944524944322137
    }
}

running: False
schema_name_id: 2427
start_time: 2024-11-05 01:53:07
success: True
trace_id: 10838944524944322137

Scan 6666117

duration: 0:00:11.379530

exit_message:

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

id: 6666117

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_newbookbalance_transfer_reasons/2024-11-04/1730783480",
        "key": "raw/newbookdev_newbookbalance_transfer_reasons/2024-11-04/1730783480/balance_transfer_reasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbalance_transfer_reasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5809489407776857301,
        "service_name": "drive-thru",
        "span_id": 1016664840284456864,
        "trace_id": 2283393765461731348
    }
}

running: False
schema_name_id: 2427
start_time: 2024-11-05 01:29:26
success: True
trace_id: 2283393765461731348

Scan 6665363

duration: 0:00:13.958920

exit_message:

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

id: 6665363

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_newbookbalance_transfer_reasons/2024-11-04/1730783261",
        "key": "raw/newbookdev_newbookbalance_transfer_reasons/2024-11-04/1730783261/balance_transfer_reasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbalance_transfer_reasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2797478540192129793,
        "service_name": "drive-thru",
        "span_id": 149017146852927768,
        "trace_id": 4514692706535198017
    }
}

running: False
schema_name_id: 2427
start_time: 2024-11-05 01:09:35
success: True
trace_id: 4514692706535198017

Scan 6664672

duration: 0:00:11.239145

exit_message:

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

id: 6664672

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_newbookbalance_transfer_reasons/2024-11-04/1730782864",
        "key": "raw/newbookdev_newbookbalance_transfer_reasons/2024-11-04/1730782864/balance_transfer_reasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbalance_transfer_reasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10916749897585818600,
        "service_name": "drive-thru",
        "span_id": 18364332779695187397,
        "trace_id": 9576404682890398739
    }
}

running: False
schema_name_id: 2427
start_time: 2024-11-05 00:51:06
success: True
trace_id: 9576404682890398739

Scan 6664027

duration: 0:00:13.889498

exit_message:

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

id: 6664027

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_newbookbalance_transfer_reasons/2024-11-04/1730782773",
        "key": "raw/newbookdev_newbookbalance_transfer_reasons/2024-11-04/1730782773/balance_transfer_reasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbalance_transfer_reasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3333604280397152322,
        "service_name": "drive-thru",
        "span_id": 2297311687417150052,
        "trace_id": 419273923363793315
    }
}

running: False
schema_name_id: 2427
start_time: 2024-11-05 00:34:17
success: True
trace_id: 419273923363793315

Partitions:

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

Schema:

attributes:

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

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbalance_transfer_reasons`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbalance_transfer_reasons/2024-11-05/1730866369'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbalance_transfer_reasons`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbalance_transfer_reasons"
}

Server:

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

Raw:

{
    "name": {
        "created": "2024-10-08 17:38:18",
        "disabled": false,
        "format": "raw",
        "id": 2427,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "newbookdev_newbookbalance_transfer_reasons"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "active": "string",
            "id": "string",
            "name": "string",
            "newbook_region": "string",
            "tenant": "string"
        },
        "created": "2024-11-05 22:30:24",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbalance_transfer_reasons`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbalance_transfer_reasons/2024-11-05/1730866369'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbalance_transfer_reasons`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbalance_transfer_reasons"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}