Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbooknewbook_online_translations

created: 2024-10-08 18:24:46
disabled: False
format: raw
id: 2958
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4749075

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooknewbook_online_translations/2024-11-05/1730866563
id: 4749075
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: 2958
schema_scan_id: 6675107
updated: 2024-11-05 23:18:38

Version 4748945

created: 2024-11-05 23:10:12

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooknewbook_online_translations/2024-11-05/1730866506
id: 4748945
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: 2958
schema_scan_id: 6674977
updated: 2024-11-05 23:10:25

Version 4748096

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooknewbook_online_translations/2024-11-05/1730866373
id: 4748096
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: 2958
schema_scan_id: 6674129
updated: 2024-11-05 22:34:56

Version 4747199

created: 2024-11-05 05:00:56

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooknewbook_online_translations/2024-11-04/1730785764
id: 4747199
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: 2958
schema_scan_id: 6672431
updated: 2024-11-05 05:01:08

Version 4746570

created: 2024-11-05 04:10:09

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooknewbook_online_translations/2024-11-04/1730785149
id: 4746570
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: 2958
schema_scan_id: 6671793
updated: 2024-11-05 04:10:22

Version 4745576

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooknewbook_online_translations/2024-11-04/1730784843
id: 4745576
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: 2958
schema_scan_id: 6670793
updated: 2024-11-05 03:33:19

Version 4744228

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooknewbook_online_translations/2024-11-04/1730784240
id: 4744228
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: 2958
schema_scan_id: 6669445
updated: 2024-11-05 02:57:31

Version 4744207

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooknewbook_online_translations/2024-11-04/1730784077
id: 4744207
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: 2958
schema_scan_id: 6669424
updated: 2024-11-05 02:56:57

Version 4743476

created: 2024-11-05 02:37:39

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooknewbook_online_translations/2024-11-04/1730783917
id: 4743476
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: 2958
schema_scan_id: 6668693
updated: 2024-11-05 02:37:50

Version 4742728

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooknewbook_online_translations/2024-11-04/1730783791
id: 4742728
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: 2958
schema_scan_id: 6667945
updated: 2024-11-05 02:18:06

Version 4742109

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooknewbook_online_translations/2024-11-04/1730783683
id: 4742109
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: 2958
schema_scan_id: 6667326
updated: 2024-11-05 02:01:32

Version 4741157

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooknewbook_online_translations/2024-11-04/1730783548
id: 4741157
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: 2958
schema_scan_id: 6666374
updated: 2024-11-05 01:36:29

Version 4740447

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooknewbook_online_translations/2024-11-04/1730783329
id: 4740447
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: 2958
schema_scan_id: 6665664
updated: 2024-11-05 01:17:45

Version 4739798

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooknewbook_online_translations/2024-11-04/1730782929
id: 4739798
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: 2958
schema_scan_id: 6665015
updated: 2024-11-05 01:00:25

Version 4738590

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooknewbook_online_translations/2024-11-04/1730782757
id: 4738590
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: 2958
schema_scan_id: 6663803
updated: 2024-11-05 00:28:36

Schema Scans: 15

Last at 2024-11-05 23:18:26

Scan 6675107

duration: 0:00:11.436673

exit_message:

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

id: 6675107

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_newbooknewbook_online_translations/2024-11-05/1730866563",
        "key": "raw/newbookdev_newbooknewbook_online_translations/2024-11-05/1730866563/newbook_online_translations.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooknewbook_online_translations",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17039896633426994289,
        "service_name": "drive-thru",
        "span_id": 5484163782439009191,
        "trace_id": 16483856817259703670
    }
}

running: False
schema_name_id: 2958
start_time: 2024-11-05 23:18:26
success: True
trace_id: 16483856817259703670

Scan 6674977

duration: 0:00:14.097015

exit_message:

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

id: 6674977

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_newbooknewbook_online_translations/2024-11-05/1730866506",
        "key": "raw/newbookdev_newbooknewbook_online_translations/2024-11-05/1730866506/newbook_online_translations.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooknewbook_online_translations",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17493622500037874830,
        "service_name": "drive-thru",
        "span_id": 18292910360522573023,
        "trace_id": 10183431212921278476
    }
}

running: False
schema_name_id: 2958
start_time: 2024-11-05 23:10:11
success: True
trace_id: 10183431212921278476

Scan 6674129

duration: 0:00:11.484095

exit_message:

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

id: 6674129

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_newbooknewbook_online_translations/2024-11-05/1730866373",
        "key": "raw/newbookdev_newbooknewbook_online_translations/2024-11-05/1730866373/newbook_online_translations.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooknewbook_online_translations",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18362328632117234798,
        "service_name": "drive-thru",
        "span_id": 1712744764739898195,
        "trace_id": 6460976938176965945
    }
}

running: False
schema_name_id: 2958
start_time: 2024-11-05 22:34:45
success: True
trace_id: 6460976938176965945

Scan 6672431

duration: 0:00:11.536182

exit_message:

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

id: 6672431

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_newbooknewbook_online_translations/2024-11-04/1730785764",
        "key": "raw/newbookdev_newbooknewbook_online_translations/2024-11-04/1730785764/newbook_online_translations.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooknewbook_online_translations",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14829312414909043977,
        "service_name": "drive-thru",
        "span_id": 1890154887252745846,
        "trace_id": 186605024382018628
    }
}

running: False
schema_name_id: 2958
start_time: 2024-11-05 05:00:56
success: True
trace_id: 186605024382018628

Scan 6671793

duration: 0:00:13.967917

exit_message:

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

id: 6671793

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_newbooknewbook_online_translations/2024-11-04/1730785149",
        "key": "raw/newbookdev_newbooknewbook_online_translations/2024-11-04/1730785149/newbook_online_translations.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooknewbook_online_translations",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5415029606680489768,
        "service_name": "drive-thru",
        "span_id": 3406099072974170867,
        "trace_id": 10068673152368032625
    }
}

running: False
schema_name_id: 2958
start_time: 2024-11-05 04:10:08
success: True
trace_id: 10068673152368032625

Scan 6670793

duration: 0:00:11.306941

exit_message:

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

id: 6670793

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_newbooknewbook_online_translations/2024-11-04/1730784843",
        "key": "raw/newbookdev_newbooknewbook_online_translations/2024-11-04/1730784843/newbook_online_translations.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooknewbook_online_translations",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3015365803874329923,
        "service_name": "drive-thru",
        "span_id": 6531329446432884065,
        "trace_id": 4516055092799953815
    }
}

running: False
schema_name_id: 2958
start_time: 2024-11-05 03:33:08
success: True
trace_id: 4516055092799953815

Scan 6669445

duration: 0:00:11.379838

exit_message:

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

id: 6669445

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_newbooknewbook_online_translations/2024-11-04/1730784240",
        "key": "raw/newbookdev_newbooknewbook_online_translations/2024-11-04/1730784240/newbook_online_translations.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooknewbook_online_translations",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2107915609594637637,
        "service_name": "drive-thru",
        "span_id": 5641928706014514461,
        "trace_id": 10078162593753030653
    }
}

running: False
schema_name_id: 2958
start_time: 2024-11-05 02:57:20
success: True
trace_id: 10078162593753030653

Scan 6669424

duration: 0:00:11.348415

exit_message:

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

id: 6669424

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_newbooknewbook_online_translations/2024-11-04/1730784077",
        "key": "raw/newbookdev_newbooknewbook_online_translations/2024-11-04/1730784077/newbook_online_translations.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooknewbook_online_translations",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10328394664098966444,
        "service_name": "drive-thru",
        "span_id": 17061508246666187487,
        "trace_id": 12585455220267997969
    }
}

running: False
schema_name_id: 2958
start_time: 2024-11-05 02:56:46
success: True
trace_id: 12585455220267997969

Scan 6668693

duration: 0:00:11.333018

exit_message:

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

id: 6668693

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_newbooknewbook_online_translations/2024-11-04/1730783917",
        "key": "raw/newbookdev_newbooknewbook_online_translations/2024-11-04/1730783917/newbook_online_translations.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooknewbook_online_translations",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16212533542102905390,
        "service_name": "drive-thru",
        "span_id": 6947402799716252050,
        "trace_id": 9595260301325596158
    }
}

running: False
schema_name_id: 2958
start_time: 2024-11-05 02:37:39
success: True
trace_id: 9595260301325596158

Scan 6667945

duration: 0:00:11.378845

exit_message:

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

id: 6667945

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_newbooknewbook_online_translations/2024-11-04/1730783791",
        "key": "raw/newbookdev_newbooknewbook_online_translations/2024-11-04/1730783791/newbook_online_translations.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooknewbook_online_translations",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1282917075710109510,
        "service_name": "drive-thru",
        "span_id": 17254070202502279596,
        "trace_id": 17585228542667714880
    }
}

running: False
schema_name_id: 2958
start_time: 2024-11-05 02:17:54
success: True
trace_id: 17585228542667714880

Scan 6667326

duration: 0:00:14.073857

exit_message:

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

id: 6667326

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_newbooknewbook_online_translations/2024-11-04/1730783683",
        "key": "raw/newbookdev_newbooknewbook_online_translations/2024-11-04/1730783683/newbook_online_translations.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooknewbook_online_translations",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4633430154732042448,
        "service_name": "drive-thru",
        "span_id": 4188319987676088692,
        "trace_id": 4881238271994600812
    }
}

running: False
schema_name_id: 2958
start_time: 2024-11-05 02:01:18
success: True
trace_id: 4881238271994600812

Scan 6666374

duration: 0:00:11.326047

exit_message:

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

id: 6666374

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_newbooknewbook_online_translations/2024-11-04/1730783548",
        "key": "raw/newbookdev_newbooknewbook_online_translations/2024-11-04/1730783548/newbook_online_translations.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooknewbook_online_translations",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16058906276366085275,
        "service_name": "drive-thru",
        "span_id": 584992806098783994,
        "trace_id": 5055357185609315272
    }
}

running: False
schema_name_id: 2958
start_time: 2024-11-05 01:36:17
success: True
trace_id: 5055357185609315272

Scan 6665664

duration: 0:00:11.321667

exit_message:

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

id: 6665664

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_newbooknewbook_online_translations/2024-11-04/1730783329",
        "key": "raw/newbookdev_newbooknewbook_online_translations/2024-11-04/1730783329/newbook_online_translations.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooknewbook_online_translations",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14298990295114417038,
        "service_name": "drive-thru",
        "span_id": 15914910125899076155,
        "trace_id": 1399223056484938499
    }
}

running: False
schema_name_id: 2958
start_time: 2024-11-05 01:17:34
success: True
trace_id: 1399223056484938499

Scan 6665015

duration: 0:00:13.908315

exit_message:

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

id: 6665015

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_newbooknewbook_online_translations/2024-11-04/1730782929",
        "key": "raw/newbookdev_newbooknewbook_online_translations/2024-11-04/1730782929/newbook_online_translations.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooknewbook_online_translations",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 669811556340985681,
        "service_name": "drive-thru",
        "span_id": 8867326420166777719,
        "trace_id": 6011122764252716945
    }
}

running: False
schema_name_id: 2958
start_time: 2024-11-05 01:00:12
success: True
trace_id: 6011122764252716945

Scan 6663803

duration: 0:00:11.404649

exit_message:

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

id: 6663803

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_newbooknewbook_online_translations/2024-11-04/1730782757",
        "key": "raw/newbookdev_newbooknewbook_online_translations/2024-11-04/1730782757/newbook_online_translations.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooknewbook_online_translations",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7772168932511925483,
        "service_name": "drive-thru",
        "span_id": 1390126417718474127,
        "trace_id": 13915773333424487798
    }
}

running: False
schema_name_id: 2958
start_time: 2024-11-05 00:28:25
success: True
trace_id: 13915773333424487798

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 23:18: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_newbooknewbook_online_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_newbooknewbook_online_translations/2024-11-05/1730866563'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooknewbook_online_translations`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooknewbook_online_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 18:24:46",
        "disabled": false,
        "format": "raw",
        "id": 2958,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "newbookdev_newbooknewbook_online_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 23:18: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_newbooknewbook_online_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_newbooknewbook_online_translations/2024-11-05/1730866563'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooknewbook_online_translations`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooknewbook_online_translations"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}