Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookpayments_types_currencies

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4749246

created: 2024-11-05 23:30:38

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpayments_types_currencies/2024-11-05/1730866583
id: 4749246
processed: 1

raw_data:

{
    "active": 5,
    "currency_id": 4,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "type": 3
}

schema_attributes:

{
    "active": "string",
    "currency_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string"
}

schema_name_id: 2887
schema_scan_id: 6675278
updated: 2024-11-05 23:30:52

Version 4748900

created: 2024-11-05 23:07:42

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpayments_types_currencies/2024-11-05/1730866524
id: 4748900
processed: 1

raw_data:

{
    "active": 5,
    "currency_id": 4,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "type": 3
}

schema_attributes:

{
    "active": "string",
    "currency_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string"
}

schema_name_id: 2887
schema_scan_id: 6674932
updated: 2024-11-05 23:07:55

Version 4748414

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpayments_types_currencies/2024-11-05/1730866400
id: 4748414
processed: 1

raw_data:

{
    "active": 5,
    "currency_id": 4,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "type": 3
}

schema_attributes:

{
    "active": "string",
    "currency_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string"
}

schema_name_id: 2887
schema_scan_id: 6674446
updated: 2024-11-05 22:45:37

Version 4746392

created: 2024-11-05 04:01:04

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpayments_types_currencies/2024-11-04/1730785157
id: 4746392
processed: 1

raw_data:

{
    "active": 5,
    "currency_id": 4,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "type": 3
}

schema_attributes:

{
    "active": "string",
    "currency_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string"
}

schema_name_id: 2887
schema_scan_id: 6671613
updated: 2024-11-05 04:01:17

Version 4746286

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpayments_types_currencies/2024-11-04/1730785779
id: 4746286
processed: 1

raw_data:

{
    "active": 5,
    "currency_id": 4,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "type": 3
}

schema_attributes:

{
    "active": "string",
    "currency_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string"
}

schema_name_id: 2887
schema_scan_id: 6671507
updated: 2024-11-05 03:56:46

Version 4745975

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpayments_types_currencies/2024-11-04/1730784851
id: 4745975
processed: 1

raw_data:

{
    "active": 5,
    "currency_id": 4,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "type": 3
}

schema_attributes:

{
    "active": "string",
    "currency_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string"
}

schema_name_id: 2887
schema_scan_id: 6671195
updated: 2024-11-05 03:44:57

Version 4744827

created: 2024-11-05 03:13:24

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpayments_types_currencies/2024-11-04/1730784248
id: 4744827
processed: 1

raw_data:

{
    "active": 5,
    "currency_id": 4,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "type": 3
}

schema_attributes:

{
    "active": "string",
    "currency_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string"
}

schema_name_id: 2887
schema_scan_id: 6670044
updated: 2024-11-05 03:13:34

Version 4744401

created: 2024-11-05 03:02:03

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpayments_types_currencies/2024-11-04/1730784086
id: 4744401
processed: 1

raw_data:

{
    "active": 5,
    "currency_id": 4,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "type": 3
}

schema_attributes:

{
    "active": "string",
    "currency_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string"
}

schema_name_id: 2887
schema_scan_id: 6669618
updated: 2024-11-05 03:02:13

Version 4742957

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpayments_types_currencies/2024-11-04/1730783852
id: 4742957
processed: 1

raw_data:

{
    "active": 5,
    "currency_id": 4,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "type": 3
}

schema_attributes:

{
    "active": "string",
    "currency_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string"
}

schema_name_id: 2887
schema_scan_id: 6668174
updated: 2024-11-05 02:24:06

Version 4742769

created: 2024-11-05 02:18:56

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpayments_types_currencies/2024-11-04/1730783799
id: 4742769
processed: 1

raw_data:

{
    "active": 5,
    "currency_id": 4,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "type": 3
}

schema_attributes:

{
    "active": "string",
    "currency_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string"
}

schema_name_id: 2887
schema_scan_id: 6667986
updated: 2024-11-05 02:19:07

Version 4741909

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpayments_types_currencies/2024-11-04/1730783689
id: 4741909
processed: 1

raw_data:

{
    "active": 5,
    "currency_id": 4,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "type": 3
}

schema_attributes:

{
    "active": "string",
    "currency_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string"
}

schema_name_id: 2887
schema_scan_id: 6667126
updated: 2024-11-05 01:56:13

Version 4741410

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpayments_types_currencies/2024-11-04/1730783556
id: 4741410
processed: 1

raw_data:

{
    "active": 5,
    "currency_id": 4,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "type": 3
}

schema_attributes:

{
    "active": "string",
    "currency_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string"
}

schema_name_id: 2887
schema_scan_id: 6666627
updated: 2024-11-05 01:43:02

Version 4740180

created: 2024-11-05 01:10:30

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpayments_types_currencies/2024-11-04/1730783338
id: 4740180
processed: 1

raw_data:

{
    "active": 5,
    "currency_id": 4,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "type": 3
}

schema_attributes:

{
    "active": "string",
    "currency_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string"
}

schema_name_id: 2887
schema_scan_id: 6665397
updated: 2024-11-05 01:10:40

Version 4739550

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpayments_types_currencies/2024-11-04/1730782936
id: 4739550
processed: 1

raw_data:

{
    "active": 5,
    "currency_id": 4,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "type": 3
}

schema_attributes:

{
    "active": "string",
    "currency_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string"
}

schema_name_id: 2887
schema_scan_id: 6664764
updated: 2024-11-05 00:53:48

Version 4739115

created: 2024-11-05 00:42:15

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpayments_types_currencies/2024-11-04/1730782829
id: 4739115
processed: 1

raw_data:

{
    "active": 5,
    "currency_id": 4,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1,
    "type": 3
}

schema_attributes:

{
    "active": "string",
    "currency_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string"
}

schema_name_id: 2887
schema_scan_id: 6664330
updated: 2024-11-05 00:42:26

Schema Scans: 15

Last at 2024-11-05 23:30:38

Scan 6675278

duration: 0:00:14.055104

exit_message:

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

id: 6675278

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_newbookpayments_types_currencies/2024-11-05/1730866583",
        "key": "raw/newbookdev_newbookpayments_types_currencies/2024-11-05/1730866583/payments_types_currencies.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookpayments_types_currencies",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8619092787398265493,
        "service_name": "drive-thru",
        "span_id": 13302355186632845310,
        "trace_id": 12112574522175132398
    }
}

running: False
schema_name_id: 2887
start_time: 2024-11-05 23:30:38
success: True
trace_id: 12112574522175132398

Scan 6674932

duration: 0:00:14.018665

exit_message:

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

id: 6674932

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_newbookpayments_types_currencies/2024-11-05/1730866524",
        "key": "raw/newbookdev_newbookpayments_types_currencies/2024-11-05/1730866524/payments_types_currencies.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookpayments_types_currencies",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7817588982252525499,
        "service_name": "drive-thru",
        "span_id": 8361574779818657032,
        "trace_id": 4806912913118922637
    }
}

running: False
schema_name_id: 2887
start_time: 2024-11-05 23:07:41
success: True
trace_id: 4806912913118922637

Scan 6674446

duration: 0:00:11.477734

exit_message:

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

id: 6674446

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_newbookpayments_types_currencies/2024-11-05/1730866400",
        "key": "raw/newbookdev_newbookpayments_types_currencies/2024-11-05/1730866400/payments_types_currencies.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookpayments_types_currencies",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6977900996513377388,
        "service_name": "drive-thru",
        "span_id": 402467283100321388,
        "trace_id": 11005452520355760850
    }
}

running: False
schema_name_id: 2887
start_time: 2024-11-05 22:45:26
success: True
trace_id: 11005452520355760850

Scan 6671613

duration: 0:00:13.940507

exit_message:

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

id: 6671613

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_newbookpayments_types_currencies/2024-11-04/1730785157",
        "key": "raw/newbookdev_newbookpayments_types_currencies/2024-11-04/1730785157/payments_types_currencies.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookpayments_types_currencies",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6185608203390031324,
        "service_name": "drive-thru",
        "span_id": 6356631968971084417,
        "trace_id": 2641007400343246707
    }
}

running: False
schema_name_id: 2887
start_time: 2024-11-05 04:01:03
success: True
trace_id: 2641007400343246707

Scan 6671507

duration: 0:00:14.008129

exit_message:

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

id: 6671507

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_newbookpayments_types_currencies/2024-11-04/1730785779",
        "key": "raw/newbookdev_newbookpayments_types_currencies/2024-11-04/1730785779/payments_types_currencies.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookpayments_types_currencies",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13876913045698960411,
        "service_name": "drive-thru",
        "span_id": 2338354175966639930,
        "trace_id": 10741511184102259915
    }
}

running: False
schema_name_id: 2887
start_time: 2024-11-05 03:56:32
success: True
trace_id: 10741511184102259915

Scan 6671195

duration: 0:00:14.015239

exit_message:

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

id: 6671195

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_newbookpayments_types_currencies/2024-11-04/1730784851",
        "key": "raw/newbookdev_newbookpayments_types_currencies/2024-11-04/1730784851/payments_types_currencies.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookpayments_types_currencies",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6624757087722054540,
        "service_name": "drive-thru",
        "span_id": 4724950497436740873,
        "trace_id": 16879248135516070998
    }
}

running: False
schema_name_id: 2887
start_time: 2024-11-05 03:44:43
success: True
trace_id: 16879248135516070998

Scan 6670044

duration: 0:00:11.592473

exit_message:

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

id: 6670044

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_newbookpayments_types_currencies/2024-11-04/1730784248",
        "key": "raw/newbookdev_newbookpayments_types_currencies/2024-11-04/1730784248/payments_types_currencies.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookpayments_types_currencies",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9660512102001432040,
        "service_name": "drive-thru",
        "span_id": 2740109153906361580,
        "trace_id": 13477562274709222117
    }
}

running: False
schema_name_id: 2887
start_time: 2024-11-05 03:13:23
success: True
trace_id: 13477562274709222117

Scan 6669618

duration: 0:00:11.356908

exit_message:

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

id: 6669618

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_newbookpayments_types_currencies/2024-11-04/1730784086",
        "key": "raw/newbookdev_newbookpayments_types_currencies/2024-11-04/1730784086/payments_types_currencies.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookpayments_types_currencies",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10001856113271262234,
        "service_name": "drive-thru",
        "span_id": 8427597318622324384,
        "trace_id": 3375441359163733540
    }
}

running: False
schema_name_id: 2887
start_time: 2024-11-05 03:02:02
success: True
trace_id: 3375441359163733540

Scan 6668174

duration: 0:00:11.388867

exit_message:

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

id: 6668174

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_newbookpayments_types_currencies/2024-11-04/1730783852",
        "key": "raw/newbookdev_newbookpayments_types_currencies/2024-11-04/1730783852/payments_types_currencies.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookpayments_types_currencies",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2961702162139415174,
        "service_name": "drive-thru",
        "span_id": 6498571705802588701,
        "trace_id": 6452386193524849280
    }
}

running: False
schema_name_id: 2887
start_time: 2024-11-05 02:23:54
success: True
trace_id: 6452386193524849280

Scan 6667986

duration: 0:00:11.384383

exit_message:

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

id: 6667986

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_newbookpayments_types_currencies/2024-11-04/1730783799",
        "key": "raw/newbookdev_newbookpayments_types_currencies/2024-11-04/1730783799/payments_types_currencies.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookpayments_types_currencies",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10010429533162812393,
        "service_name": "drive-thru",
        "span_id": 11221023997178709023,
        "trace_id": 2867747536091220432
    }
}

running: False
schema_name_id: 2887
start_time: 2024-11-05 02:18:56
success: True
trace_id: 2867747536091220432

Scan 6667126

duration: 0:00:13.899421

exit_message:

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

id: 6667126

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_newbookpayments_types_currencies/2024-11-04/1730783689",
        "key": "raw/newbookdev_newbookpayments_types_currencies/2024-11-04/1730783689/payments_types_currencies.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookpayments_types_currencies",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1688388981079588796,
        "service_name": "drive-thru",
        "span_id": 6455602474755661053,
        "trace_id": 2109932568462080717
    }
}

running: False
schema_name_id: 2887
start_time: 2024-11-05 01:55:59
success: True
trace_id: 2109932568462080717

Scan 6666627

duration: 0:00:11.235941

exit_message:

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

id: 6666627

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_newbookpayments_types_currencies/2024-11-04/1730783556",
        "key": "raw/newbookdev_newbookpayments_types_currencies/2024-11-04/1730783556/payments_types_currencies.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookpayments_types_currencies",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10039657026912157540,
        "service_name": "drive-thru",
        "span_id": 3525375104955033072,
        "trace_id": 5047640605970172435
    }
}

running: False
schema_name_id: 2887
start_time: 2024-11-05 01:42:50
success: True
trace_id: 5047640605970172435

Scan 6665397

duration: 0:00:11.284585

exit_message:

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

id: 6665397

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_newbookpayments_types_currencies/2024-11-04/1730783338",
        "key": "raw/newbookdev_newbookpayments_types_currencies/2024-11-04/1730783338/payments_types_currencies.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookpayments_types_currencies",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 921495452665639101,
        "service_name": "drive-thru",
        "span_id": 13550561755292737201,
        "trace_id": 4932334201079091996
    }
}

running: False
schema_name_id: 2887
start_time: 2024-11-05 01:10:29
success: True
trace_id: 4932334201079091996

Scan 6664764

duration: 0:00:13.887358

exit_message:

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

id: 6664764

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_newbookpayments_types_currencies/2024-11-04/1730782936",
        "key": "raw/newbookdev_newbookpayments_types_currencies/2024-11-04/1730782936/payments_types_currencies.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookpayments_types_currencies",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14429240367495835966,
        "service_name": "drive-thru",
        "span_id": 8466597418798784852,
        "trace_id": 16716163867853915179
    }
}

running: False
schema_name_id: 2887
start_time: 2024-11-05 00:53:34
success: True
trace_id: 16716163867853915179

Scan 6664330

duration: 0:00:11.461925

exit_message:

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

id: 6664330

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_newbookpayments_types_currencies/2024-11-04/1730782829",
        "key": "raw/newbookdev_newbookpayments_types_currencies/2024-11-04/1730782829/payments_types_currencies.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookpayments_types_currencies",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13501345758902252188,
        "service_name": "drive-thru",
        "span_id": 14173599084154153164,
        "trace_id": 4232964123654462320
    }
}

running: False
schema_name_id: 2887
start_time: 2024-11-05 00:42:14
success: True
trace_id: 4232964123654462320

Partitions:

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

Schema:

attributes:

{
    "active": "string",
    "currency_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string"
}

created: 2024-11-05 23:30:38

ddl:

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

Server:

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

Raw:

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