Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookcorporations_translations

created: 2024-10-08 17:49:25
disabled: False
format: raw
id: 2582
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4748419

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcorporations_translations/2024-11-05/1730866439
id: 4748419
processed: 1

raw_data:

{
    "id": 2,
    "language": 4,
    "newbook_region": 0,
    "tenant": 1,
    "translation": 5,
    "translation_id": 3
}

schema_attributes:

{
    "id": "string",
    "language": "string",
    "newbook_region": "string",
    "tenant": "string",
    "translation": "string",
    "translation_id": "string"
}

schema_name_id: 2582
schema_scan_id: 6674451
updated: 2024-11-05 22:45:49

Version 4748056

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcorporations_translations/2024-11-05/1730866355
id: 4748056
processed: 1

raw_data:

{
    "id": 2,
    "language": 4,
    "newbook_region": 0,
    "tenant": 1,
    "translation": 5,
    "translation_id": 3
}

schema_attributes:

{
    "id": "string",
    "language": "string",
    "newbook_region": "string",
    "tenant": "string",
    "translation": "string",
    "translation_id": "string"
}

schema_name_id: 2582
schema_scan_id: 6674088
updated: 2024-11-05 22:33:43

Version 4747557

created: 2024-11-05 22:20:00

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcorporations_translations/2024-11-05/1730866263
id: 4747557
processed: 1

raw_data:

{
    "id": 2,
    "language": 4,
    "newbook_region": 0,
    "tenant": 1,
    "translation": 5,
    "translation_id": 3
}

schema_attributes:

{
    "id": "string",
    "language": "string",
    "newbook_region": "string",
    "tenant": "string",
    "translation": "string",
    "translation_id": "string"
}

schema_name_id: 2582
schema_scan_id: 6673589
updated: 2024-11-05 22:20:14

Version 4746724

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcorporations_translations/2024-11-04/1730785683
id: 4746724
processed: 1

raw_data:

{
    "id": 2,
    "language": 4,
    "newbook_region": 0,
    "tenant": 1,
    "translation": 5,
    "translation_id": 3
}

schema_attributes:

{
    "id": "string",
    "language": "string",
    "newbook_region": "string",
    "tenant": "string",
    "translation": "string",
    "translation_id": "string"
}

schema_name_id: 2582
schema_scan_id: 6671948
updated: 2024-11-05 04:18:54

Version 4746254

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcorporations_translations/2024-11-04/1730785104
id: 4746254
processed: 1

raw_data:

{
    "id": 2,
    "language": 4,
    "newbook_region": 0,
    "tenant": 1,
    "translation": 5,
    "translation_id": 3
}

schema_attributes:

{
    "id": "string",
    "language": "string",
    "newbook_region": "string",
    "tenant": "string",
    "translation": "string",
    "translation_id": "string"
}

schema_name_id: 2582
schema_scan_id: 6671475
updated: 2024-11-05 03:55:21

Version 4745206

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcorporations_translations/2024-11-04/1730784798
id: 4745206
processed: 1

raw_data:

{
    "id": 2,
    "language": 4,
    "newbook_region": 0,
    "tenant": 1,
    "translation": 5,
    "translation_id": 3
}

schema_attributes:

{
    "id": "string",
    "language": "string",
    "newbook_region": "string",
    "tenant": "string",
    "translation": "string",
    "translation_id": "string"
}

schema_name_id: 2582
schema_scan_id: 6670423
updated: 2024-11-05 03:23:34

Version 4744817

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcorporations_translations/2024-11-04/1730784194
id: 4744817
processed: 1

raw_data:

{
    "id": 2,
    "language": 4,
    "newbook_region": 0,
    "tenant": 1,
    "translation": 5,
    "translation_id": 3
}

schema_attributes:

{
    "id": "string",
    "language": "string",
    "newbook_region": "string",
    "tenant": "string",
    "translation": "string",
    "translation_id": "string"
}

schema_name_id: 2582
schema_scan_id: 6670034
updated: 2024-11-05 03:13:21

Version 4744119

created: 2024-11-05 02:54:28

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcorporations_translations/2024-11-04/1730784031
id: 4744119
processed: 1

raw_data:

{
    "id": 2,
    "language": 4,
    "newbook_region": 0,
    "tenant": 1,
    "translation": 5,
    "translation_id": 3
}

schema_attributes:

{
    "id": "string",
    "language": "string",
    "newbook_region": "string",
    "tenant": "string",
    "translation": "string",
    "translation_id": "string"
}

schema_name_id: 2582
schema_scan_id: 6669336
updated: 2024-11-05 02:54:39

Version 4743297

created: 2024-11-05 02:32:50

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcorporations_translations/2024-11-04/1730783882
id: 4743297
processed: 1

raw_data:

{
    "id": 2,
    "language": 4,
    "newbook_region": 0,
    "tenant": 1,
    "translation": 5,
    "translation_id": 3
}

schema_attributes:

{
    "id": "string",
    "language": "string",
    "newbook_region": "string",
    "tenant": "string",
    "translation": "string",
    "translation_id": "string"
}

schema_name_id: 2582
schema_scan_id: 6668514
updated: 2024-11-05 02:33:03

Version 4742439

created: 2024-11-05 02:10:14

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcorporations_translations/2024-11-04/1730783745
id: 4742439
processed: 1

raw_data:

{
    "id": 2,
    "language": 4,
    "newbook_region": 0,
    "tenant": 1,
    "translation": 5,
    "translation_id": 3
}

schema_attributes:

{
    "id": "string",
    "language": "string",
    "newbook_region": "string",
    "tenant": "string",
    "translation": "string",
    "translation_id": "string"
}

schema_name_id: 2582
schema_scan_id: 6667656
updated: 2024-11-05 02:10:25

Version 4741747

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcorporations_translations/2024-11-04/1730783648
id: 4741747
processed: 1

raw_data:

{
    "id": 2,
    "language": 4,
    "newbook_region": 0,
    "tenant": 1,
    "translation": 5,
    "translation_id": 3
}

schema_attributes:

{
    "id": "string",
    "language": "string",
    "newbook_region": "string",
    "tenant": "string",
    "translation": "string",
    "translation_id": "string"
}

schema_name_id: 2582
schema_scan_id: 6666965
updated: 2024-11-05 01:51:58

Version 4740878

created: 2024-11-05 01:28:52

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcorporations_translations/2024-11-04/1730783501
id: 4740878
processed: 1

raw_data:

{
    "id": 2,
    "language": 4,
    "newbook_region": 0,
    "tenant": 1,
    "translation": 5,
    "translation_id": 3
}

schema_attributes:

{
    "id": "string",
    "language": "string",
    "newbook_region": "string",
    "tenant": "string",
    "translation": "string",
    "translation_id": "string"
}

schema_name_id: 2582
schema_scan_id: 6666095
updated: 2024-11-05 01:29:03

Version 4740194

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcorporations_translations/2024-11-04/1730783282
id: 4740194
processed: 1

raw_data:

{
    "id": 2,
    "language": 4,
    "newbook_region": 0,
    "tenant": 1,
    "translation": 5,
    "translation_id": 3
}

schema_attributes:

{
    "id": "string",
    "language": "string",
    "newbook_region": "string",
    "tenant": "string",
    "translation": "string",
    "translation_id": "string"
}

schema_name_id: 2582
schema_scan_id: 6665411
updated: 2024-11-05 01:11:04

Version 4739433

created: 2024-11-05 00:50:30

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcorporations_translations/2024-11-04/1730782884
id: 4739433
processed: 1

raw_data:

{
    "id": 2,
    "language": 4,
    "newbook_region": 0,
    "tenant": 1,
    "translation": 5,
    "translation_id": 3
}

schema_attributes:

{
    "id": "string",
    "language": "string",
    "newbook_region": "string",
    "tenant": "string",
    "translation": "string",
    "translation_id": "string"
}

schema_name_id: 2582
schema_scan_id: 6664648
updated: 2024-11-05 00:50:41

Version 4738929

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcorporations_translations/2024-11-04/1730782788
id: 4738929
processed: 1

raw_data:

{
    "id": 2,
    "language": 4,
    "newbook_region": 0,
    "tenant": 1,
    "translation": 5,
    "translation_id": 3
}

schema_attributes:

{
    "id": "string",
    "language": "string",
    "newbook_region": "string",
    "tenant": "string",
    "translation": "string",
    "translation_id": "string"
}

schema_name_id: 2582
schema_scan_id: 6664143
updated: 2024-11-05 00:37:34

Schema Scans: 15

Last at 2024-11-05 22:45:37

Scan 6674451

duration: 0:00:11.529450

exit_message:

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

id: 6674451

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_newbookcorporations_translations/2024-11-05/1730866439",
        "key": "raw/newbookdev_newbookcorporations_translations/2024-11-05/1730866439/corporations_translations.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcorporations_translations",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1018139017954775235,
        "service_name": "drive-thru",
        "span_id": 2473509750452850580,
        "trace_id": 5409010489082946098
    }
}

running: False
schema_name_id: 2582
start_time: 2024-11-05 22:45:37
success: True
trace_id: 5409010489082946098

Scan 6674088

duration: 0:00:11.406638

exit_message:

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

id: 6674088

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_newbookcorporations_translations/2024-11-05/1730866355",
        "key": "raw/newbookdev_newbookcorporations_translations/2024-11-05/1730866355/corporations_translations.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcorporations_translations",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7280444835701558475,
        "service_name": "drive-thru",
        "span_id": 15810487820071867426,
        "trace_id": 6795904320410738977
    }
}

running: False
schema_name_id: 2582
start_time: 2024-11-05 22:33:32
success: True
trace_id: 6795904320410738977

Scan 6673589

duration: 0:00:13.841276

exit_message:

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

id: 6673589

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_newbookcorporations_translations/2024-11-05/1730866263",
        "key": "raw/newbookdev_newbookcorporations_translations/2024-11-05/1730866263/corporations_translations.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcorporations_translations",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17687501808213713113,
        "service_name": "drive-thru",
        "span_id": 14150927800558729112,
        "trace_id": 6808812860888736953
    }
}

running: False
schema_name_id: 2582
start_time: 2024-11-05 22:20:00
success: True
trace_id: 6808812860888736953

Scan 6671948

duration: 0:00:14.038074

exit_message:

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

id: 6671948

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_newbookcorporations_translations/2024-11-04/1730785683",
        "key": "raw/newbookdev_newbookcorporations_translations/2024-11-04/1730785683/corporations_translations.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcorporations_translations",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1155246963834798754,
        "service_name": "drive-thru",
        "span_id": 13012592346295959162,
        "trace_id": 5804377626120443802
    }
}

running: False
schema_name_id: 2582
start_time: 2024-11-05 04:18:40
success: True
trace_id: 5804377626120443802

Scan 6671475

duration: 0:00:14.037857

exit_message:

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

id: 6671475

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_newbookcorporations_translations/2024-11-04/1730785104",
        "key": "raw/newbookdev_newbookcorporations_translations/2024-11-04/1730785104/corporations_translations.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcorporations_translations",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6975091013783368058,
        "service_name": "drive-thru",
        "span_id": 17976742256488893329,
        "trace_id": 13975288628985945828
    }
}

running: False
schema_name_id: 2582
start_time: 2024-11-05 03:55:07
success: True
trace_id: 13975288628985945828

Scan 6670423

duration: 0:00:11.313409

exit_message:

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

id: 6670423

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_newbookcorporations_translations/2024-11-04/1730784798",
        "key": "raw/newbookdev_newbookcorporations_translations/2024-11-04/1730784798/corporations_translations.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcorporations_translations",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9952838439201645531,
        "service_name": "drive-thru",
        "span_id": 5524749657242232740,
        "trace_id": 16412465036688216233
    }
}

running: False
schema_name_id: 2582
start_time: 2024-11-05 03:23:23
success: True
trace_id: 16412465036688216233

Scan 6670034

duration: 0:00:13.780338

exit_message:

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

id: 6670034

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_newbookcorporations_translations/2024-11-04/1730784194",
        "key": "raw/newbookdev_newbookcorporations_translations/2024-11-04/1730784194/corporations_translations.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcorporations_translations",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1444098032586101754,
        "service_name": "drive-thru",
        "span_id": 8231168842041558327,
        "trace_id": 8445004960393111210
    }
}

running: False
schema_name_id: 2582
start_time: 2024-11-05 03:13:07
success: True
trace_id: 8445004960393111210

Scan 6669336

duration: 0:00:11.276748

exit_message:

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

id: 6669336

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_newbookcorporations_translations/2024-11-04/1730784031",
        "key": "raw/newbookdev_newbookcorporations_translations/2024-11-04/1730784031/corporations_translations.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcorporations_translations",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9621798248652054068,
        "service_name": "drive-thru",
        "span_id": 551766464307905882,
        "trace_id": 13244038114673487461
    }
}

running: False
schema_name_id: 2582
start_time: 2024-11-05 02:54:28
success: True
trace_id: 13244038114673487461

Scan 6668514

duration: 0:00:13.908729

exit_message:

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

id: 6668514

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_newbookcorporations_translations/2024-11-04/1730783882",
        "key": "raw/newbookdev_newbookcorporations_translations/2024-11-04/1730783882/corporations_translations.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcorporations_translations",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7615934835900545769,
        "service_name": "drive-thru",
        "span_id": 3564473826381394643,
        "trace_id": 16722017698533780839
    }
}

running: False
schema_name_id: 2582
start_time: 2024-11-05 02:32:49
success: True
trace_id: 16722017698533780839

Scan 6667656

duration: 0:00:11.398973

exit_message:

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

id: 6667656

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_newbookcorporations_translations/2024-11-04/1730783745",
        "key": "raw/newbookdev_newbookcorporations_translations/2024-11-04/1730783745/corporations_translations.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcorporations_translations",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17171464336412030108,
        "service_name": "drive-thru",
        "span_id": 18096444926791691270,
        "trace_id": 17102870213242967373
    }
}

running: False
schema_name_id: 2582
start_time: 2024-11-05 02:10:14
success: True
trace_id: 17102870213242967373

Scan 6666965

duration: 0:00:13.927355

exit_message:

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

id: 6666965

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_newbookcorporations_translations/2024-11-04/1730783648",
        "key": "raw/newbookdev_newbookcorporations_translations/2024-11-04/1730783648/corporations_translations.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcorporations_translations",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11688114843739876986,
        "service_name": "drive-thru",
        "span_id": 14096497455994280098,
        "trace_id": 3127216709067544807
    }
}

running: False
schema_name_id: 2582
start_time: 2024-11-05 01:51:44
success: True
trace_id: 3127216709067544807

Scan 6666095

duration: 0:00:11.371994

exit_message:

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

id: 6666095

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_newbookcorporations_translations/2024-11-04/1730783501",
        "key": "raw/newbookdev_newbookcorporations_translations/2024-11-04/1730783501/corporations_translations.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcorporations_translations",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11107242460124333877,
        "service_name": "drive-thru",
        "span_id": 498949430456161350,
        "trace_id": 13952675349052864774
    }
}

running: False
schema_name_id: 2582
start_time: 2024-11-05 01:28:52
success: True
trace_id: 13952675349052864774

Scan 6665411

duration: 0:00:11.392618

exit_message:

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

id: 6665411

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_newbookcorporations_translations/2024-11-04/1730783282",
        "key": "raw/newbookdev_newbookcorporations_translations/2024-11-04/1730783282/corporations_translations.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcorporations_translations",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15429345705480331487,
        "service_name": "drive-thru",
        "span_id": 10628251419579238398,
        "trace_id": 15592041645554244378
    }
}

running: False
schema_name_id: 2582
start_time: 2024-11-05 01:10:52
success: True
trace_id: 15592041645554244378

Scan 6664648

duration: 0:00:11.358524

exit_message:

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

id: 6664648

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_newbookcorporations_translations/2024-11-04/1730782884",
        "key": "raw/newbookdev_newbookcorporations_translations/2024-11-04/1730782884/corporations_translations.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcorporations_translations",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 302928118981302134,
        "service_name": "drive-thru",
        "span_id": 11030294469933236612,
        "trace_id": 12660194452038545643
    }
}

running: False
schema_name_id: 2582
start_time: 2024-11-05 00:50:30
success: True
trace_id: 12660194452038545643

Scan 6664143

duration: 0:00:13.795337

exit_message:

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

id: 6664143

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_newbookcorporations_translations/2024-11-04/1730782788",
        "key": "raw/newbookdev_newbookcorporations_translations/2024-11-04/1730782788/corporations_translations.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcorporations_translations",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5711101404898429292,
        "service_name": "drive-thru",
        "span_id": 55447353673314148,
        "trace_id": 18081203125583438541
    }
}

running: False
schema_name_id: 2582
start_time: 2024-11-05 00:37:20
success: True
trace_id: 18081203125583438541

Partitions:

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

Schema:

attributes:

{
    "id": "string",
    "language": "string",
    "newbook_region": "string",
    "tenant": "string",
    "translation": "string",
    "translation_id": "string"
}

created: 2024-11-05 22:45: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_newbookcorporations_translations`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `translation_id`  string , `language`  string , `translation`  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_newbookcorporations_translations/2024-11-05/1730866439'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcorporations_translations`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcorporations_translations"
}

Server:

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

Raw:

{
    "name": {
        "created": "2024-10-08 17:49:25",
        "disabled": false,
        "format": "raw",
        "id": 2582,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "newbookdev_newbookcorporations_translations"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "id": "string",
            "language": "string",
            "newbook_region": "string",
            "tenant": "string",
            "translation": "string",
            "translation_id": "string"
        },
        "created": "2024-11-05 22:45: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_newbookcorporations_translations`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `translation_id`  string , `language`  string , `translation`  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_newbookcorporations_translations/2024-11-05/1730866439'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcorporations_translations`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcorporations_translations"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}