Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookbank_transactions_link

created: 2024-10-08 17:41:54
disabled: False
format: raw
id: 2477
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4748028

created: 2024-11-05 22:32:39

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbank_transactions_link/2024-11-05/1730866371
id: 4748028
processed: 1

raw_data:

{
    "bank_transaction_id": 3,
    "id": 2,
    "newbook_region": 0,
    "payment_id": 4,
    "refund_id": 5,
    "tenant": 1
}

schema_attributes:

{
    "bank_transaction_id": "string",
    "id": "string",
    "newbook_region": "string",
    "payment_id": "string",
    "refund_id": "string",
    "tenant": "string"
}

schema_name_id: 2477
schema_scan_id: 6674060
updated: 2024-11-05 22:32:53

Version 4747679

created: 2024-11-05 22:23:09

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbank_transactions_link/2024-11-05/1730866306
id: 4747679
processed: 1

raw_data:

{
    "bank_transaction_id": 3,
    "id": 2,
    "newbook_region": 0,
    "payment_id": 4,
    "refund_id": 5,
    "tenant": 1
}

schema_attributes:

{
    "bank_transaction_id": "string",
    "id": "string",
    "newbook_region": "string",
    "payment_id": "string",
    "refund_id": "string",
    "tenant": "string"
}

schema_name_id: 2477
schema_scan_id: 6673711
updated: 2024-11-05 22:23:23

Version 4747394

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

ddl:

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

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

raw_data:

{
    "bank_transaction_id": 3,
    "id": 2,
    "newbook_region": 0,
    "payment_id": 4,
    "refund_id": 5,
    "tenant": 1
}

schema_attributes:

{
    "bank_transaction_id": "string",
    "id": "string",
    "newbook_region": "string",
    "payment_id": "string",
    "refund_id": "string",
    "tenant": "string"
}

schema_name_id: 2477
schema_scan_id: 6673426
updated: 2024-11-05 22:15:26

Version 4746827

created: 2024-11-05 04:25:58

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbank_transactions_link/2024-11-04/1730785652
id: 4746827
processed: 1

raw_data:

{
    "bank_transaction_id": 3,
    "id": 2,
    "newbook_region": 0,
    "payment_id": 4,
    "refund_id": 5,
    "tenant": 1
}

schema_attributes:

{
    "bank_transaction_id": "string",
    "id": "string",
    "newbook_region": "string",
    "payment_id": "string",
    "refund_id": "string",
    "tenant": "string"
}

schema_name_id: 2477
schema_scan_id: 6672057
updated: 2024-11-05 04:26:11

Version 4745196

created: 2024-11-05 03:23:09

ddl:

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

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

raw_data:

{
    "bank_transaction_id": 3,
    "id": 2,
    "newbook_region": 0,
    "payment_id": 4,
    "refund_id": 5,
    "tenant": 1
}

schema_attributes:

{
    "bank_transaction_id": "string",
    "id": "string",
    "newbook_region": "string",
    "payment_id": "string",
    "refund_id": "string",
    "tenant": "string"
}

schema_name_id: 2477
schema_scan_id: 6670413
updated: 2024-11-05 03:23:19

Version 4744495

created: 2024-11-05 03:04:32

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbank_transactions_link/2024-11-04/1730784778
id: 4744495
processed: 1

raw_data:

{
    "bank_transaction_id": 3,
    "id": 2,
    "newbook_region": 0,
    "payment_id": 4,
    "refund_id": 5,
    "tenant": 1
}

schema_attributes:

{
    "bank_transaction_id": "string",
    "id": "string",
    "newbook_region": "string",
    "payment_id": "string",
    "refund_id": "string",
    "tenant": "string"
}

schema_name_id: 2477
schema_scan_id: 6669712
updated: 2024-11-05 03:04:46

Version 4744318

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbank_transactions_link/2024-11-04/1730784175
id: 4744318
processed: 1

raw_data:

{
    "bank_transaction_id": 3,
    "id": 2,
    "newbook_region": 0,
    "payment_id": 4,
    "refund_id": 5,
    "tenant": 1
}

schema_attributes:

{
    "bank_transaction_id": "string",
    "id": "string",
    "newbook_region": "string",
    "payment_id": "string",
    "refund_id": "string",
    "tenant": "string"
}

schema_name_id: 2477
schema_scan_id: 6669536
updated: 2024-11-05 02:59:57

Version 4744171

created: 2024-11-05 02:55:51

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbank_transactions_link/2024-11-04/1730784101
id: 4744171
processed: 1

raw_data:

{
    "bank_transaction_id": 3,
    "id": 2,
    "newbook_region": 0,
    "payment_id": 4,
    "refund_id": 5,
    "tenant": 1
}

schema_attributes:

{
    "bank_transaction_id": "string",
    "id": "string",
    "newbook_region": "string",
    "payment_id": "string",
    "refund_id": "string",
    "tenant": "string"
}

schema_name_id: 2477
schema_scan_id: 6669388
updated: 2024-11-05 02:56:02

Version 4743447

created: 2024-11-05 02:36:51

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbank_transactions_link/2024-11-04/1730783867
id: 4743447
processed: 1

raw_data:

{
    "bank_transaction_id": 3,
    "id": 2,
    "newbook_region": 0,
    "payment_id": 4,
    "refund_id": 5,
    "tenant": 1
}

schema_attributes:

{
    "bank_transaction_id": "string",
    "id": "string",
    "newbook_region": "string",
    "payment_id": "string",
    "refund_id": "string",
    "tenant": "string"
}

schema_name_id: 2477
schema_scan_id: 6668664
updated: 2024-11-05 02:37:02

Version 4742313

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbank_transactions_link/2024-11-04/1730783725
id: 4742313
processed: 1

raw_data:

{
    "bank_transaction_id": 3,
    "id": 2,
    "newbook_region": 0,
    "payment_id": 4,
    "refund_id": 5,
    "tenant": 1
}

schema_attributes:

{
    "bank_transaction_id": "string",
    "id": "string",
    "newbook_region": "string",
    "payment_id": "string",
    "refund_id": "string",
    "tenant": "string"
}

schema_name_id: 2477
schema_scan_id: 6667530
updated: 2024-11-05 02:07:06

Version 4741807

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbank_transactions_link/2024-11-04/1730783633
id: 4741807
processed: 1

raw_data:

{
    "bank_transaction_id": 3,
    "id": 2,
    "newbook_region": 0,
    "payment_id": 4,
    "refund_id": 5,
    "tenant": 1
}

schema_attributes:

{
    "bank_transaction_id": "string",
    "id": "string",
    "newbook_region": "string",
    "payment_id": "string",
    "refund_id": "string",
    "tenant": "string"
}

schema_name_id: 2477
schema_scan_id: 6667024
updated: 2024-11-05 01:53:32

Version 4740457

created: 2024-11-05 01:17:48

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbank_transactions_link/2024-11-04/1730783481
id: 4740457
processed: 1

raw_data:

{
    "bank_transaction_id": 3,
    "id": 2,
    "newbook_region": 0,
    "payment_id": 4,
    "refund_id": 5,
    "tenant": 1
}

schema_attributes:

{
    "bank_transaction_id": "string",
    "id": "string",
    "newbook_region": "string",
    "payment_id": "string",
    "refund_id": "string",
    "tenant": "string"
}

schema_name_id: 2477
schema_scan_id: 6665674
updated: 2024-11-05 01:18:01

Version 4740024

created: 2024-11-05 01:06:18

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbank_transactions_link/2024-11-04/1730783262
id: 4740024
processed: 1

raw_data:

{
    "bank_transaction_id": 3,
    "id": 2,
    "newbook_region": 0,
    "payment_id": 4,
    "refund_id": 5,
    "tenant": 1
}

schema_attributes:

{
    "bank_transaction_id": "string",
    "id": "string",
    "newbook_region": "string",
    "payment_id": "string",
    "refund_id": "string",
    "tenant": "string"
}

schema_name_id: 2477
schema_scan_id: 6665241
updated: 2024-11-05 01:06:32

Version 4739338

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbank_transactions_link/2024-11-04/1730782865
id: 4739338
processed: 1

raw_data:

{
    "bank_transaction_id": 3,
    "id": 2,
    "newbook_region": 0,
    "payment_id": 4,
    "refund_id": 5,
    "tenant": 1
}

schema_attributes:

{
    "bank_transaction_id": "string",
    "id": "string",
    "newbook_region": "string",
    "payment_id": "string",
    "refund_id": "string",
    "tenant": "string"
}

schema_name_id: 2477
schema_scan_id: 6664553
updated: 2024-11-05 00:48:14

Version 4738253

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbank_transactions_link/2024-11-04/1730782740
id: 4738253
processed: 1

raw_data:

{
    "bank_transaction_id": 3,
    "id": 2,
    "newbook_region": 0,
    "payment_id": 4,
    "refund_id": 5,
    "tenant": 1
}

schema_attributes:

{
    "bank_transaction_id": "string",
    "id": "string",
    "newbook_region": "string",
    "payment_id": "string",
    "refund_id": "string",
    "tenant": "string"
}

schema_name_id: 2477
schema_scan_id: 6663462
updated: 2024-11-05 00:19:48

Schema Scans: 15

Last at 2024-11-05 22:32:39

Scan 6674060

duration: 0:00:14.074357

exit_message:

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

id: 6674060

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_newbookbank_transactions_link/2024-11-05/1730866371",
        "key": "raw/newbookdev_newbookbank_transactions_link/2024-11-05/1730866371/bank_transactions_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbank_transactions_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2225586665603614761,
        "service_name": "drive-thru",
        "span_id": 7455389914158198142,
        "trace_id": 18291584600341510552
    }
}

running: False
schema_name_id: 2477
start_time: 2024-11-05 22:32:39
success: True
trace_id: 18291584600341510552

Scan 6673711

duration: 0:00:13.961683

exit_message:

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

id: 6673711

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_newbookbank_transactions_link/2024-11-05/1730866306",
        "key": "raw/newbookdev_newbookbank_transactions_link/2024-11-05/1730866306/bank_transactions_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbank_transactions_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1491099929882417059,
        "service_name": "drive-thru",
        "span_id": 1607271453848040735,
        "trace_id": 5774297180498968987
    }
}

running: False
schema_name_id: 2477
start_time: 2024-11-05 22:23:09
success: True
trace_id: 5774297180498968987

Scan 6673426

duration: 0:00:14.004253

exit_message:

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

id: 6673426

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_newbookbank_transactions_link/2024-11-05/1730866233",
        "key": "raw/newbookdev_newbookbank_transactions_link/2024-11-05/1730866233/bank_transactions_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbank_transactions_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14511798276783410897,
        "service_name": "drive-thru",
        "span_id": 5260851012004774347,
        "trace_id": 619008551217338307
    }
}

running: False
schema_name_id: 2477
start_time: 2024-11-05 22:15:12
success: True
trace_id: 619008551217338307

Scan 6672057

duration: 0:00:14.027384

exit_message:

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

id: 6672057

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_newbookbank_transactions_link/2024-11-04/1730785652",
        "key": "raw/newbookdev_newbookbank_transactions_link/2024-11-04/1730785652/bank_transactions_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbank_transactions_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17648913405620515587,
        "service_name": "drive-thru",
        "span_id": 7256513378832232368,
        "trace_id": 73577382209611736
    }
}

running: False
schema_name_id: 2477
start_time: 2024-11-05 04:25:57
success: True
trace_id: 73577382209611736

Scan 6670413

duration: 0:00:11.234573

exit_message:

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

id: 6670413

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_newbookbank_transactions_link/2024-11-04/1730785083",
        "key": "raw/newbookdev_newbookbank_transactions_link/2024-11-04/1730785083/bank_transactions_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbank_transactions_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14943621113022460406,
        "service_name": "drive-thru",
        "span_id": 4167862739055011035,
        "trace_id": 16098888556438485668
    }
}

running: False
schema_name_id: 2477
start_time: 2024-11-05 03:23:08
success: True
trace_id: 16098888556438485668

Scan 6669712

duration: 0:00:13.885826

exit_message:

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

id: 6669712

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_newbookbank_transactions_link/2024-11-04/1730784778",
        "key": "raw/newbookdev_newbookbank_transactions_link/2024-11-04/1730784778/bank_transactions_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbank_transactions_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7065915161262158077,
        "service_name": "drive-thru",
        "span_id": 3296656360435991347,
        "trace_id": 5404723130071394639
    }
}

running: False
schema_name_id: 2477
start_time: 2024-11-05 03:04:32
success: True
trace_id: 5404723130071394639

Scan 6669536

duration: 0:00:13.862422

exit_message:

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

id: 6669536

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_newbookbank_transactions_link/2024-11-04/1730784175",
        "key": "raw/newbookdev_newbookbank_transactions_link/2024-11-04/1730784175/bank_transactions_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbank_transactions_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10450259502968388824,
        "service_name": "drive-thru",
        "span_id": 2827351033026253656,
        "trace_id": 2602283877604155759
    }
}

running: False
schema_name_id: 2477
start_time: 2024-11-05 02:59:43
success: True
trace_id: 2602283877604155759

Scan 6669388

duration: 0:00:11.402282

exit_message:

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

id: 6669388

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_newbookbank_transactions_link/2024-11-04/1730784101",
        "key": "raw/newbookdev_newbookbank_transactions_link/2024-11-04/1730784101/bank_transactions_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbank_transactions_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3111427064013104401,
        "service_name": "drive-thru",
        "span_id": 10372389014245524220,
        "trace_id": 1060753688996036280
    }
}

running: False
schema_name_id: 2477
start_time: 2024-11-05 02:55:51
success: True
trace_id: 1060753688996036280

Scan 6668664

duration: 0:00:11.478612

exit_message:

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

id: 6668664

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_newbookbank_transactions_link/2024-11-04/1730783867",
        "key": "raw/newbookdev_newbookbank_transactions_link/2024-11-04/1730783867/bank_transactions_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbank_transactions_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13390255582140547403,
        "service_name": "drive-thru",
        "span_id": 10346624959190165739,
        "trace_id": 13762564203190593777
    }
}

running: False
schema_name_id: 2477
start_time: 2024-11-05 02:36:50
success: True
trace_id: 13762564203190593777

Scan 6667530

duration: 0:00:13.908259

exit_message:

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

id: 6667530

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_newbookbank_transactions_link/2024-11-04/1730783725",
        "key": "raw/newbookdev_newbookbank_transactions_link/2024-11-04/1730783725/bank_transactions_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbank_transactions_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15876842793327875359,
        "service_name": "drive-thru",
        "span_id": 8459031901410955329,
        "trace_id": 13639011145826647471
    }
}

running: False
schema_name_id: 2477
start_time: 2024-11-05 02:06:53
success: True
trace_id: 13639011145826647471

Scan 6667024

duration: 0:00:13.798464

exit_message:

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

id: 6667024

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_newbookbank_transactions_link/2024-11-04/1730783633",
        "key": "raw/newbookdev_newbookbank_transactions_link/2024-11-04/1730783633/bank_transactions_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbank_transactions_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13867757177712856822,
        "service_name": "drive-thru",
        "span_id": 192061100240094435,
        "trace_id": 4206593836759857073
    }
}

running: False
schema_name_id: 2477
start_time: 2024-11-05 01:53:18
success: True
trace_id: 4206593836759857073

Scan 6665674

duration: 0:00:13.839029

exit_message:

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

id: 6665674

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_newbookbank_transactions_link/2024-11-04/1730783481",
        "key": "raw/newbookdev_newbookbank_transactions_link/2024-11-04/1730783481/bank_transactions_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbank_transactions_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7096206061041767807,
        "service_name": "drive-thru",
        "span_id": 13714962311820811015,
        "trace_id": 5251039146958564219
    }
}

running: False
schema_name_id: 2477
start_time: 2024-11-05 01:17:47
success: True
trace_id: 5251039146958564219

Scan 6665241

duration: 0:00:13.931263

exit_message:

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

id: 6665241

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_newbookbank_transactions_link/2024-11-04/1730783262",
        "key": "raw/newbookdev_newbookbank_transactions_link/2024-11-04/1730783262/bank_transactions_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbank_transactions_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16296258009188002582,
        "service_name": "drive-thru",
        "span_id": 5988212857298533508,
        "trace_id": 2600984395647682395
    }
}

running: False
schema_name_id: 2477
start_time: 2024-11-05 01:06:18
success: True
trace_id: 2600984395647682395

Scan 6664553

duration: 0:00:11.322337

exit_message:

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

id: 6664553

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_newbookbank_transactions_link/2024-11-04/1730782865",
        "key": "raw/newbookdev_newbookbank_transactions_link/2024-11-04/1730782865/bank_transactions_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbank_transactions_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11175973427950794154,
        "service_name": "drive-thru",
        "span_id": 15712715406112430240,
        "trace_id": 3860401969574050391
    }
}

running: False
schema_name_id: 2477
start_time: 2024-11-05 00:48:02
success: True
trace_id: 3860401969574050391

Scan 6663462

duration: 0:00:11.355101

exit_message:

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

id: 6663462

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_newbookbank_transactions_link/2024-11-04/1730782740",
        "key": "raw/newbookdev_newbookbank_transactions_link/2024-11-04/1730782740/bank_transactions_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbank_transactions_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2369676945855826473,
        "service_name": "drive-thru",
        "span_id": 6316646049611493823,
        "trace_id": 12430100105207123665
    }
}

running: False
schema_name_id: 2477
start_time: 2024-11-05 00:19:37
success: True
trace_id: 12430100105207123665

Partitions:

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

Schema:

attributes:

{
    "bank_transaction_id": "string",
    "id": "string",
    "newbook_region": "string",
    "payment_id": "string",
    "refund_id": "string",
    "tenant": "string"
}

created: 2024-11-05 22:32:39

ddl:

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

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