Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookold_tariffs_types_profiles

created: 2024-10-08 18:20:09
disabled: False
format: raw
id: 2915
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4749108

created: 2024-11-05 23:20:46

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookold_tariffs_types_profiles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookold_tariffs_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_newbookold_tariffs_types_profiles/2024-11-05/1730866570'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookold_tariffs_types_profiles"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookold_tariffs_types_profiles/2024-11-05/1730866570
id: 4749108
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: 2915
schema_scan_id: 6675140
updated: 2024-11-05 23:20:57

Version 4749036

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookold_tariffs_types_profiles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookold_tariffs_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_newbookold_tariffs_types_profiles/2024-11-05/1730866512'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookold_tariffs_types_profiles"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookold_tariffs_types_profiles/2024-11-05/1730866512
id: 4749036
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: 2915
schema_scan_id: 6675068
updated: 2024-11-05 23:15:53

Version 4748253

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookold_tariffs_types_profiles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookold_tariffs_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_newbookold_tariffs_types_profiles/2024-11-05/1730866382'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookold_tariffs_types_profiles"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookold_tariffs_types_profiles/2024-11-05/1730866382
id: 4748253
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: 2915
schema_scan_id: 6674285
updated: 2024-11-05 22:39:57

Version 4747216

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookold_tariffs_types_profiles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookold_tariffs_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_newbookold_tariffs_types_profiles/2024-11-04/1730785769'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookold_tariffs_types_profiles"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookold_tariffs_types_profiles/2024-11-04/1730785769
id: 4747216
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: 2915
schema_scan_id: 6672454
updated: 2024-11-05 05:03:11

Version 4746623

created: 2024-11-05 04:12:59

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookold_tariffs_types_profiles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookold_tariffs_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_newbookold_tariffs_types_profiles/2024-11-04/1730785151'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookold_tariffs_types_profiles"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookold_tariffs_types_profiles/2024-11-04/1730785151
id: 4746623
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: 2915
schema_scan_id: 6671846
updated: 2024-11-05 04:13:10

Version 4745755

created: 2024-11-05 03:37:55

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookold_tariffs_types_profiles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookold_tariffs_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_newbookold_tariffs_types_profiles/2024-11-04/1730784846'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookold_tariffs_types_profiles"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookold_tariffs_types_profiles/2024-11-04/1730784846
id: 4745755
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: 2915
schema_scan_id: 6670972
updated: 2024-11-05 03:38:09

Version 4744781

created: 2024-11-05 03:12:12

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookold_tariffs_types_profiles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookold_tariffs_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_newbookold_tariffs_types_profiles/2024-11-04/1730784243'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookold_tariffs_types_profiles"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookold_tariffs_types_profiles/2024-11-04/1730784243
id: 4744781
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: 2915
schema_scan_id: 6669999
updated: 2024-11-05 03:12:26

Version 4744379

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookold_tariffs_types_profiles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookold_tariffs_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_newbookold_tariffs_types_profiles/2024-11-04/1730784080'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookold_tariffs_types_profiles"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookold_tariffs_types_profiles/2024-11-04/1730784080
id: 4744379
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: 2915
schema_scan_id: 6669596
updated: 2024-11-05 03:01:36

Version 4743660

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookold_tariffs_types_profiles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookold_tariffs_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_newbookold_tariffs_types_profiles/2024-11-04/1730783919'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookold_tariffs_types_profiles"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookold_tariffs_types_profiles/2024-11-04/1730783919
id: 4743660
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: 2915
schema_scan_id: 6668877
updated: 2024-11-05 02:42:41

Version 4742744

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookold_tariffs_types_profiles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookold_tariffs_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_newbookold_tariffs_types_profiles/2024-11-04/1730783794'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookold_tariffs_types_profiles"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookold_tariffs_types_profiles/2024-11-04/1730783794
id: 4742744
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: 2915
schema_scan_id: 6667961
updated: 2024-11-05 02:18:31

Version 4742052

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookold_tariffs_types_profiles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookold_tariffs_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_newbookold_tariffs_types_profiles/2024-11-04/1730783685'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookold_tariffs_types_profiles"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookold_tariffs_types_profiles/2024-11-04/1730783685
id: 4742052
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: 2915
schema_scan_id: 6667269
updated: 2024-11-05 01:59:57

Version 4741294

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookold_tariffs_types_profiles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookold_tariffs_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_newbookold_tariffs_types_profiles/2024-11-04/1730783551'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookold_tariffs_types_profiles"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookold_tariffs_types_profiles/2024-11-04/1730783551
id: 4741294
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: 2915
schema_scan_id: 6666511
updated: 2024-11-05 01:40:01

Version 4740528

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookold_tariffs_types_profiles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookold_tariffs_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_newbookold_tariffs_types_profiles/2024-11-04/1730783332'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookold_tariffs_types_profiles"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookold_tariffs_types_profiles/2024-11-04/1730783332
id: 4740528
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: 2915
schema_scan_id: 6665746
updated: 2024-11-05 01:19:54

Version 4739805

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookold_tariffs_types_profiles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookold_tariffs_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_newbookold_tariffs_types_profiles/2024-11-04/1730782932'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookold_tariffs_types_profiles"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookold_tariffs_types_profiles/2024-11-04/1730782932
id: 4739805
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: 2915
schema_scan_id: 6665022
updated: 2024-11-05 01:00:36

Version 4738862

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookold_tariffs_types_profiles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookold_tariffs_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_newbookold_tariffs_types_profiles/2024-11-04/1730782824'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookold_tariffs_types_profiles"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookold_tariffs_types_profiles/2024-11-04/1730782824
id: 4738862
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: 2915
schema_scan_id: 6664075
updated: 2024-11-05 00:35:46

Schema Scans: 15

Last at 2024-11-05 23:20:46

Scan 6675140

duration: 0:00:11.450953

exit_message:

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

id: 6675140

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_newbookold_tariffs_types_profiles/2024-11-05/1730866570",
        "key": "raw/newbookdev_newbookold_tariffs_types_profiles/2024-11-05/1730866570/old_tariffs_types_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookold_tariffs_types_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15712901724027654386,
        "service_name": "drive-thru",
        "span_id": 64533658025115030,
        "trace_id": 4712937023012958961
    }
}

running: False
schema_name_id: 2915
start_time: 2024-11-05 23:20:46
success: True
trace_id: 4712937023012958961

Scan 6675068

duration: 0:00:11.428608

exit_message:

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

id: 6675068

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_newbookold_tariffs_types_profiles/2024-11-05/1730866512",
        "key": "raw/newbookdev_newbookold_tariffs_types_profiles/2024-11-05/1730866512/old_tariffs_types_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookold_tariffs_types_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15145710797580205877,
        "service_name": "drive-thru",
        "span_id": 7963872694186198311,
        "trace_id": 12760842201804986648
    }
}

running: False
schema_name_id: 2915
start_time: 2024-11-05 23:15:42
success: True
trace_id: 12760842201804986648

Scan 6674285

duration: 0:00:11.660777

exit_message:

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

id: 6674285

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_newbookold_tariffs_types_profiles/2024-11-05/1730866382",
        "key": "raw/newbookdev_newbookold_tariffs_types_profiles/2024-11-05/1730866382/old_tariffs_types_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookold_tariffs_types_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15944904653154011584,
        "service_name": "drive-thru",
        "span_id": 5997867405767274941,
        "trace_id": 11015834059830616131
    }
}

running: False
schema_name_id: 2915
start_time: 2024-11-05 22:39:45
success: True
trace_id: 11015834059830616131

Scan 6672454

duration: 0:00:11.544906

exit_message:

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

id: 6672454

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_newbookold_tariffs_types_profiles/2024-11-04/1730785769",
        "key": "raw/newbookdev_newbookold_tariffs_types_profiles/2024-11-04/1730785769/old_tariffs_types_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookold_tariffs_types_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12121166511395243741,
        "service_name": "drive-thru",
        "span_id": 1088306552809236887,
        "trace_id": 7320412090824054533
    }
}

running: False
schema_name_id: 2915
start_time: 2024-11-05 05:03:00
success: True
trace_id: 7320412090824054533

Scan 6671846

duration: 0:00:11.475119

exit_message:

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

id: 6671846

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_newbookold_tariffs_types_profiles/2024-11-04/1730785151",
        "key": "raw/newbookdev_newbookold_tariffs_types_profiles/2024-11-04/1730785151/old_tariffs_types_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookold_tariffs_types_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8137122844956904927,
        "service_name": "drive-thru",
        "span_id": 5349186486518762408,
        "trace_id": 7521457491155403841
    }
}

running: False
schema_name_id: 2915
start_time: 2024-11-05 04:12:59
success: True
trace_id: 7521457491155403841

Scan 6670972

duration: 0:00:14.071266

exit_message:

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

id: 6670972

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_newbookold_tariffs_types_profiles/2024-11-04/1730784846",
        "key": "raw/newbookdev_newbookold_tariffs_types_profiles/2024-11-04/1730784846/old_tariffs_types_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookold_tariffs_types_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6439073729371067498,
        "service_name": "drive-thru",
        "span_id": 190798720005707966,
        "trace_id": 3678574030827118840
    }
}

running: False
schema_name_id: 2915
start_time: 2024-11-05 03:37:55
success: True
trace_id: 3678574030827118840

Scan 6669999

duration: 0:00:13.885129

exit_message:

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

id: 6669999

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_newbookold_tariffs_types_profiles/2024-11-04/1730784243",
        "key": "raw/newbookdev_newbookold_tariffs_types_profiles/2024-11-04/1730784243/old_tariffs_types_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookold_tariffs_types_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14110001423994345838,
        "service_name": "drive-thru",
        "span_id": 7052164938130513800,
        "trace_id": 16513179682267836640
    }
}

running: False
schema_name_id: 2915
start_time: 2024-11-05 03:12:12
success: True
trace_id: 16513179682267836640

Scan 6669596

duration: 0:00:11.238939

exit_message:

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

id: 6669596

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_newbookold_tariffs_types_profiles/2024-11-04/1730784080",
        "key": "raw/newbookdev_newbookold_tariffs_types_profiles/2024-11-04/1730784080/old_tariffs_types_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookold_tariffs_types_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3562032317939973618,
        "service_name": "drive-thru",
        "span_id": 3254747705905845624,
        "trace_id": 5687957913849640584
    }
}

running: False
schema_name_id: 2915
start_time: 2024-11-05 03:01:25
success: True
trace_id: 5687957913849640584

Scan 6668877

duration: 0:00:11.342492

exit_message:

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

id: 6668877

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_newbookold_tariffs_types_profiles/2024-11-04/1730783919",
        "key": "raw/newbookdev_newbookold_tariffs_types_profiles/2024-11-04/1730783919/old_tariffs_types_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookold_tariffs_types_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7771541712821098145,
        "service_name": "drive-thru",
        "span_id": 4462605749314783404,
        "trace_id": 15812284431454327873
    }
}

running: False
schema_name_id: 2915
start_time: 2024-11-05 02:42:30
success: True
trace_id: 15812284431454327873

Scan 6667961

duration: 0:00:11.275480

exit_message:

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

id: 6667961

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_newbookold_tariffs_types_profiles/2024-11-04/1730783794",
        "key": "raw/newbookdev_newbookold_tariffs_types_profiles/2024-11-04/1730783794/old_tariffs_types_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookold_tariffs_types_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7369534263963850627,
        "service_name": "drive-thru",
        "span_id": 7011098433845146879,
        "trace_id": 11592305242473759245
    }
}

running: False
schema_name_id: 2915
start_time: 2024-11-05 02:18:20
success: True
trace_id: 11592305242473759245

Scan 6667269

duration: 0:00:13.711453

exit_message:

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

id: 6667269

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_newbookold_tariffs_types_profiles/2024-11-04/1730783685",
        "key": "raw/newbookdev_newbookold_tariffs_types_profiles/2024-11-04/1730783685/old_tariffs_types_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookold_tariffs_types_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5296380153608652269,
        "service_name": "drive-thru",
        "span_id": 7530988966074345156,
        "trace_id": 7752742516781990170
    }
}

running: False
schema_name_id: 2915
start_time: 2024-11-05 01:59:43
success: True
trace_id: 7752742516781990170

Scan 6666511

duration: 0:00:11.315134

exit_message:

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

id: 6666511

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_newbookold_tariffs_types_profiles/2024-11-04/1730783551",
        "key": "raw/newbookdev_newbookold_tariffs_types_profiles/2024-11-04/1730783551/old_tariffs_types_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookold_tariffs_types_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1052617198166953142,
        "service_name": "drive-thru",
        "span_id": 238369722508297176,
        "trace_id": 6113912386482300931
    }
}

running: False
schema_name_id: 2915
start_time: 2024-11-05 01:39:50
success: True
trace_id: 6113912386482300931

Scan 6665746

duration: 0:00:13.844193

exit_message:

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

id: 6665746

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_newbookold_tariffs_types_profiles/2024-11-04/1730783332",
        "key": "raw/newbookdev_newbookold_tariffs_types_profiles/2024-11-04/1730783332/old_tariffs_types_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookold_tariffs_types_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1587931636538309151,
        "service_name": "drive-thru",
        "span_id": 17653853628809749758,
        "trace_id": 14972553118298702787
    }
}

running: False
schema_name_id: 2915
start_time: 2024-11-05 01:19:41
success: True
trace_id: 14972553118298702787

Scan 6665022

duration: 0:00:11.436013

exit_message:

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

id: 6665022

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_newbookold_tariffs_types_profiles/2024-11-04/1730782932",
        "key": "raw/newbookdev_newbookold_tariffs_types_profiles/2024-11-04/1730782932/old_tariffs_types_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookold_tariffs_types_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15313842385870718420,
        "service_name": "drive-thru",
        "span_id": 10916974853745410281,
        "trace_id": 11320880960035954237
    }
}

running: False
schema_name_id: 2915
start_time: 2024-11-05 01:00:24
success: True
trace_id: 11320880960035954237

Scan 6664075

duration: 0:00:11.348223

exit_message:

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

id: 6664075

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_newbookold_tariffs_types_profiles/2024-11-04/1730782824",
        "key": "raw/newbookdev_newbookold_tariffs_types_profiles/2024-11-04/1730782824/old_tariffs_types_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookold_tariffs_types_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7337399631873668171,
        "service_name": "drive-thru",
        "span_id": 5939744948655523567,
        "trace_id": 11396724219224507621
    }
}

running: False
schema_name_id: 2915
start_time: 2024-11-05 00:35:35
success: True
trace_id: 11396724219224507621

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:20:46

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookold_tariffs_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_newbookold_tariffs_types_profiles/2024-11-05/1730866570'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookold_tariffs_types_profiles`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookold_tariffs_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:20:09",
        "disabled": false,
        "format": "raw",
        "id": 2915,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "newbookdev_newbookold_tariffs_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:20:46",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookold_tariffs_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_newbookold_tariffs_types_profiles/2024-11-05/1730866570'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookold_tariffs_types_profiles`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookold_tariffs_types_profiles"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}