Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbooktariffs_types_profiles

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4749451

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktariffs_types_profiles/2024-11-05/1730866615
id: 4749451
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "profile_id": 4,
    "tenant": 1,
    "type_id": 3
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "profile_id": "string",
    "tenant": "string",
    "type_id": "string"
}

schema_name_id: 3053
schema_scan_id: 6675507
updated: 2024-11-05 23:52:38

Version 4749277

created: 2024-11-05 23:33:33

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktariffs_types_profiles/2024-11-05/1730866569
id: 4749277
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "profile_id": 4,
    "tenant": 1,
    "type_id": 3
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "profile_id": "string",
    "tenant": "string",
    "type_id": "string"
}

schema_name_id: 3053
schema_scan_id: 6675309
updated: 2024-11-05 23:33:44

Version 4748675

created: 2024-11-05 22:56:05

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktariffs_types_profiles/2024-11-05/1730866467
id: 4748675
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "profile_id": 4,
    "tenant": 1,
    "type_id": 3
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "profile_id": "string",
    "tenant": "string",
    "type_id": "string"
}

schema_name_id: 3053
schema_scan_id: 6674707
updated: 2024-11-05 22:56:16

Version 4746520

created: 2024-11-05 04:07:22

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktariffs_types_profiles/2024-11-04/1730785176
id: 4746520
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "profile_id": 4,
    "tenant": 1,
    "type_id": 3
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "profile_id": "string",
    "tenant": "string",
    "type_id": "string"
}

schema_name_id: 3053
schema_scan_id: 6671741
updated: 2024-11-05 04:07:36

Version 4746416

created: 2024-11-05 04:02:07

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktariffs_types_profiles/2024-11-04/1730785812
id: 4746416
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "profile_id": 4,
    "tenant": 1,
    "type_id": 3
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "profile_id": "string",
    "tenant": "string",
    "type_id": "string"
}

schema_name_id: 3053
schema_scan_id: 6671637
updated: 2024-11-05 04:02:21

Version 4745816

created: 2024-11-05 03:39:47

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktariffs_types_profiles/2024-11-04/1730784870
id: 4745816
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "profile_id": 4,
    "tenant": 1,
    "type_id": 3
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "profile_id": "string",
    "tenant": "string",
    "type_id": "string"
}

schema_name_id: 3053
schema_scan_id: 6671033
updated: 2024-11-05 03:39:58

Version 4744939

created: 2024-11-05 03:16:25

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktariffs_types_profiles/2024-11-04/1730784267
id: 4744939
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "profile_id": 4,
    "tenant": 1,
    "type_id": 3
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "profile_id": "string",
    "tenant": "string",
    "type_id": "string"
}

schema_name_id: 3053
schema_scan_id: 6670156
updated: 2024-11-05 03:16:38

Version 4744161

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktariffs_types_profiles/2024-11-04/1730784105
id: 4744161
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "profile_id": 4,
    "tenant": 1,
    "type_id": 3
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "profile_id": "string",
    "tenant": "string",
    "type_id": "string"
}

schema_name_id: 3053
schema_scan_id: 6669379
updated: 2024-11-05 02:55:48

Version 4743040

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktariffs_types_profiles/2024-11-04/1730783818
id: 4743040
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "profile_id": 4,
    "tenant": 1,
    "type_id": 3
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "profile_id": "string",
    "tenant": "string",
    "type_id": "string"
}

schema_name_id: 3053
schema_scan_id: 6668258
updated: 2024-11-05 02:26:14

Version 4742962

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktariffs_types_profiles/2024-11-04/1730783937
id: 4742962
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "profile_id": 4,
    "tenant": 1,
    "type_id": 3
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "profile_id": "string",
    "tenant": "string",
    "type_id": "string"
}

schema_name_id: 3053
schema_scan_id: 6668179
updated: 2024-11-05 02:24:13

Version 4742232

created: 2024-11-05 02:04:41

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktariffs_types_profiles/2024-11-04/1730783703
id: 4742232
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "profile_id": 4,
    "tenant": 1,
    "type_id": 3
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "profile_id": "string",
    "tenant": "string",
    "type_id": "string"
}

schema_name_id: 3053
schema_scan_id: 6667449
updated: 2024-11-05 02:04:54

Version 4741258

created: 2024-11-05 01:38:58

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktariffs_types_profiles/2024-11-04/1730783575
id: 4741258
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "profile_id": 4,
    "tenant": 1,
    "type_id": 3
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "profile_id": "string",
    "tenant": "string",
    "type_id": "string"
}

schema_name_id: 3053
schema_scan_id: 6666475
updated: 2024-11-05 01:39:09

Version 4740641

created: 2024-11-05 01:22:41

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktariffs_types_profiles/2024-11-04/1730783357
id: 4740641
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "profile_id": 4,
    "tenant": 1,
    "type_id": 3
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "profile_id": "string",
    "tenant": "string",
    "type_id": "string"
}

schema_name_id: 3053
schema_scan_id: 6665858
updated: 2024-11-05 01:22:52

Version 4739830

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktariffs_types_profiles/2024-11-04/1730782955
id: 4739830
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "profile_id": 4,
    "tenant": 1,
    "type_id": 3
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "profile_id": "string",
    "tenant": "string",
    "type_id": "string"
}

schema_name_id: 3053
schema_scan_id: 6665048
updated: 2024-11-05 01:01:18

Version 4739238

created: 2024-11-05 00:45:28

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktariffs_types_profiles/2024-11-04/1730782843
id: 4739238
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "profile_id": 4,
    "tenant": 1,
    "type_id": 3
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "profile_id": "string",
    "tenant": "string",
    "type_id": "string"
}

schema_name_id: 3053
schema_scan_id: 6664453
updated: 2024-11-05 00:45:39

Schema Scans: 15

Last at 2024-11-05 23:52:27

Scan 6675507

duration: 0:00:11.440394

exit_message:

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

id: 6675507

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_newbooktariffs_types_profiles/2024-11-05/1730866615",
        "key": "raw/newbookdev_newbooktariffs_types_profiles/2024-11-05/1730866615/tariffs_types_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktariffs_types_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16251086831780696669,
        "service_name": "drive-thru",
        "span_id": 4680111362001826361,
        "trace_id": 188470641867430038
    }
}

running: False
schema_name_id: 3053
start_time: 2024-11-05 23:52:27
success: True
trace_id: 188470641867430038

Scan 6675309

duration: 0:00:11.496553

exit_message:

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

id: 6675309

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_newbooktariffs_types_profiles/2024-11-05/1730866569",
        "key": "raw/newbookdev_newbooktariffs_types_profiles/2024-11-05/1730866569/tariffs_types_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktariffs_types_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6862081531132446149,
        "service_name": "drive-thru",
        "span_id": 5456516434374997848,
        "trace_id": 171632403665426045
    }
}

running: False
schema_name_id: 3053
start_time: 2024-11-05 23:33:32
success: True
trace_id: 171632403665426045

Scan 6674707

duration: 0:00:11.491910

exit_message:

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

id: 6674707

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_newbooktariffs_types_profiles/2024-11-05/1730866467",
        "key": "raw/newbookdev_newbooktariffs_types_profiles/2024-11-05/1730866467/tariffs_types_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktariffs_types_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5384698686383654179,
        "service_name": "drive-thru",
        "span_id": 3597424183092851410,
        "trace_id": 12846498073131513205
    }
}

running: False
schema_name_id: 3053
start_time: 2024-11-05 22:56:04
success: True
trace_id: 12846498073131513205

Scan 6671741

duration: 0:00:13.950763

exit_message:

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

id: 6671741

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_newbooktariffs_types_profiles/2024-11-04/1730785176",
        "key": "raw/newbookdev_newbooktariffs_types_profiles/2024-11-04/1730785176/tariffs_types_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktariffs_types_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2471215415917547942,
        "service_name": "drive-thru",
        "span_id": 15180895419429305839,
        "trace_id": 911602070027497463
    }
}

running: False
schema_name_id: 3053
start_time: 2024-11-05 04:07:22
success: True
trace_id: 911602070027497463

Scan 6671637

duration: 0:00:14.014186

exit_message:

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

id: 6671637

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_newbooktariffs_types_profiles/2024-11-04/1730785812",
        "key": "raw/newbookdev_newbooktariffs_types_profiles/2024-11-04/1730785812/tariffs_types_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktariffs_types_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8730416796042032072,
        "service_name": "drive-thru",
        "span_id": 6387539169142795521,
        "trace_id": 14427853144268073592
    }
}

running: False
schema_name_id: 3053
start_time: 2024-11-05 04:02:07
success: True
trace_id: 14427853144268073592

Scan 6671033

duration: 0:00:11.509766

exit_message:

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

id: 6671033

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_newbooktariffs_types_profiles/2024-11-04/1730784870",
        "key": "raw/newbookdev_newbooktariffs_types_profiles/2024-11-04/1730784870/tariffs_types_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktariffs_types_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17359810419903748594,
        "service_name": "drive-thru",
        "span_id": 3881024708227439657,
        "trace_id": 10128234502985683830
    }
}

running: False
schema_name_id: 3053
start_time: 2024-11-05 03:39:47
success: True
trace_id: 10128234502985683830

Scan 6670156

duration: 0:00:13.916532

exit_message:

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

id: 6670156

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_newbooktariffs_types_profiles/2024-11-04/1730784267",
        "key": "raw/newbookdev_newbooktariffs_types_profiles/2024-11-04/1730784267/tariffs_types_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktariffs_types_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4099595901060211568,
        "service_name": "drive-thru",
        "span_id": 5809868781696987370,
        "trace_id": 11704608902915160248
    }
}

running: False
schema_name_id: 3053
start_time: 2024-11-05 03:16:24
success: True
trace_id: 11704608902915160248

Scan 6669379

duration: 0:00:13.887835

exit_message:

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

id: 6669379

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_newbooktariffs_types_profiles/2024-11-04/1730784105",
        "key": "raw/newbookdev_newbooktariffs_types_profiles/2024-11-04/1730784105/tariffs_types_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktariffs_types_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12252631618022854081,
        "service_name": "drive-thru",
        "span_id": 11462952898254213034,
        "trace_id": 3249945827787850149
    }
}

running: False
schema_name_id: 3053
start_time: 2024-11-05 02:55:34
success: True
trace_id: 3249945827787850149

Scan 6668258

duration: 0:00:11.278119

exit_message:

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

id: 6668258

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_newbooktariffs_types_profiles/2024-11-04/1730783818",
        "key": "raw/newbookdev_newbooktariffs_types_profiles/2024-11-04/1730783818/tariffs_types_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktariffs_types_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12965006205077022871,
        "service_name": "drive-thru",
        "span_id": 13014738066556932124,
        "trace_id": 1443785195412716300
    }
}

running: False
schema_name_id: 3053
start_time: 2024-11-05 02:26:03
success: True
trace_id: 1443785195412716300

Scan 6668179

duration: 0:00:14.037475

exit_message:

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

id: 6668179

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_newbooktariffs_types_profiles/2024-11-04/1730783937",
        "key": "raw/newbookdev_newbooktariffs_types_profiles/2024-11-04/1730783937/tariffs_types_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktariffs_types_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17352458644948685572,
        "service_name": "drive-thru",
        "span_id": 14752650744378590003,
        "trace_id": 8795837109607806615
    }
}

running: False
schema_name_id: 3053
start_time: 2024-11-05 02:23:59
success: True
trace_id: 8795837109607806615

Scan 6667449

duration: 0:00:13.981469

exit_message:

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

id: 6667449

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_newbooktariffs_types_profiles/2024-11-04/1730783703",
        "key": "raw/newbookdev_newbooktariffs_types_profiles/2024-11-04/1730783703/tariffs_types_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktariffs_types_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17634126888916902766,
        "service_name": "drive-thru",
        "span_id": 16943316749611186409,
        "trace_id": 14690206008791595751
    }
}

running: False
schema_name_id: 3053
start_time: 2024-11-05 02:04:40
success: True
trace_id: 14690206008791595751

Scan 6666475

duration: 0:00:11.409891

exit_message:

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

id: 6666475

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_newbooktariffs_types_profiles/2024-11-04/1730783575",
        "key": "raw/newbookdev_newbooktariffs_types_profiles/2024-11-04/1730783575/tariffs_types_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktariffs_types_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2778996973904240196,
        "service_name": "drive-thru",
        "span_id": 9360867619795195411,
        "trace_id": 2679347646365286351
    }
}

running: False
schema_name_id: 3053
start_time: 2024-11-05 01:38:57
success: True
trace_id: 2679347646365286351

Scan 6665858

duration: 0:00:11.446269

exit_message:

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

id: 6665858

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_newbooktariffs_types_profiles/2024-11-04/1730783357",
        "key": "raw/newbookdev_newbooktariffs_types_profiles/2024-11-04/1730783357/tariffs_types_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktariffs_types_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7199386294417181025,
        "service_name": "drive-thru",
        "span_id": 13461120854864495920,
        "trace_id": 16040753155035678255
    }
}

running: False
schema_name_id: 3053
start_time: 2024-11-05 01:22:41
success: True
trace_id: 16040753155035678255

Scan 6665048

duration: 0:00:13.941822

exit_message:

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

id: 6665048

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_newbooktariffs_types_profiles/2024-11-04/1730782955",
        "key": "raw/newbookdev_newbooktariffs_types_profiles/2024-11-04/1730782955/tariffs_types_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktariffs_types_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3523413013941001591,
        "service_name": "drive-thru",
        "span_id": 4201353271972169263,
        "trace_id": 16822490018840927234
    }
}

running: False
schema_name_id: 3053
start_time: 2024-11-05 01:01:04
success: True
trace_id: 16822490018840927234

Scan 6664453

duration: 0:00:11.366312

exit_message:

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

id: 6664453

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_newbooktariffs_types_profiles/2024-11-04/1730782843",
        "key": "raw/newbookdev_newbooktariffs_types_profiles/2024-11-04/1730782843/tariffs_types_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktariffs_types_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7732038499814554401,
        "service_name": "drive-thru",
        "span_id": 16209784417904021754,
        "trace_id": 17853853636923565101
    }
}

running: False
schema_name_id: 3053
start_time: 2024-11-05 00:45:27
success: True
trace_id: 17853853636923565101

Partitions:

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

Schema:

attributes:

{
    "id": "string",
    "newbook_region": "string",
    "profile_id": "string",
    "tenant": "string",
    "type_id": "string"
}

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

ddl:

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

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