Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookcompendium_synonyms

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4748464

created: 2024-11-05 22:47:13

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcompendium_synonyms/2024-11-05/1730866422
id: 4748464
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "synonyms": 5,
    "tenant": 1,
    "type": 3,
    "type_id": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "synonyms": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2562
schema_scan_id: 6674496
updated: 2024-11-05 22:47:26

Version 4747805

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcompendium_synonyms/2024-11-05/1730866341
id: 4747805
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "synonyms": 5,
    "tenant": 1,
    "type": 3,
    "type_id": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "synonyms": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2562
schema_scan_id: 6673838
updated: 2024-11-05 22:26:40

Version 4747498

created: 2024-11-05 22:18:25

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcompendium_synonyms/2024-11-05/1730866256
id: 4747498
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "synonyms": 5,
    "tenant": 1,
    "type": 3,
    "type_id": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "synonyms": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2562
schema_scan_id: 6673530
updated: 2024-11-05 22:18:39

Version 4746931

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcompendium_synonyms/2024-11-04/1730785676
id: 4746931
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "synonyms": 5,
    "tenant": 1,
    "type": 3,
    "type_id": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "synonyms": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2562
schema_scan_id: 6672162
updated: 2024-11-05 04:33:43

Version 4745934

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcompendium_synonyms/2024-11-04/1730785098
id: 4745934
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "synonyms": 5,
    "tenant": 1,
    "type": 3,
    "type_id": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "synonyms": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2562
schema_scan_id: 6671154
updated: 2024-11-05 03:43:38

Version 4745432

created: 2024-11-05 03:29:15

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcompendium_synonyms/2024-11-04/1730784793
id: 4745432
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "synonyms": 5,
    "tenant": 1,
    "type": 3,
    "type_id": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "synonyms": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2562
schema_scan_id: 6670649
updated: 2024-11-05 03:29:29

Version 4744432

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcompendium_synonyms/2024-11-04/1730784190
id: 4744432
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "synonyms": 5,
    "tenant": 1,
    "type": 3,
    "type_id": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "synonyms": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2562
schema_scan_id: 6669649
updated: 2024-11-05 03:03:03

Version 4744169

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcompendium_synonyms/2024-11-04/1730784027
id: 4744169
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "synonyms": 5,
    "tenant": 1,
    "type": 3,
    "type_id": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "synonyms": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2562
schema_scan_id: 6669386
updated: 2024-11-05 02:55:59

Version 4743389

created: 2024-11-05 02:35:21

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcompendium_synonyms/2024-11-04/1730783878
id: 4743389
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "synonyms": 5,
    "tenant": 1,
    "type": 3,
    "type_id": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "synonyms": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2562
schema_scan_id: 6668606
updated: 2024-11-05 02:35:32

Version 4742423

created: 2024-11-05 02:09:51

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcompendium_synonyms/2024-11-04/1730783740
id: 4742423
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "synonyms": 5,
    "tenant": 1,
    "type": 3,
    "type_id": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "synonyms": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2562
schema_scan_id: 6667640
updated: 2024-11-05 02:10:02

Version 4741639

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcompendium_synonyms/2024-11-04/1730783644
id: 4741639
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "synonyms": 5,
    "tenant": 1,
    "type": 3,
    "type_id": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "synonyms": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2562
schema_scan_id: 6666856
updated: 2024-11-05 01:49:03

Version 4741039

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcompendium_synonyms/2024-11-04/1730783496
id: 4741039
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "synonyms": 5,
    "tenant": 1,
    "type": 3,
    "type_id": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "synonyms": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2562
schema_scan_id: 6666256
updated: 2024-11-05 01:33:25

Version 4740135

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcompendium_synonyms/2024-11-04/1730783277
id: 4740135
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "synonyms": 5,
    "tenant": 1,
    "type": 3,
    "type_id": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "synonyms": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2562
schema_scan_id: 6665352
updated: 2024-11-05 01:09:29

Version 4739499

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcompendium_synonyms/2024-11-04/1730782880
id: 4739499
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "synonyms": 5,
    "tenant": 1,
    "type": 3,
    "type_id": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "synonyms": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2562
schema_scan_id: 6664714
updated: 2024-11-05 00:52:23

Version 4738675

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcompendium_synonyms/2024-11-04/1730782744
id: 4738675
processed: 1

raw_data:

{
    "id": 2,
    "newbook_region": 0,
    "synonyms": 5,
    "tenant": 1,
    "type": 3,
    "type_id": 4
}

schema_attributes:

{
    "id": "string",
    "newbook_region": "string",
    "synonyms": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

schema_name_id: 2562
schema_scan_id: 6663888
updated: 2024-11-05 00:30:48

Schema Scans: 15

Last at 2024-11-05 22:47:12

Scan 6674496

duration: 0:00:13.926564

exit_message:

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

id: 6674496

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_newbookcompendium_synonyms/2024-11-05/1730866422",
        "key": "raw/newbookdev_newbookcompendium_synonyms/2024-11-05/1730866422/compendium_synonyms.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcompendium_synonyms",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17758135081232193533,
        "service_name": "drive-thru",
        "span_id": 5525853251030039006,
        "trace_id": 310922998068250228
    }
}

running: False
schema_name_id: 2562
start_time: 2024-11-05 22:47:12
success: True
trace_id: 310922998068250228

Scan 6673838

duration: 0:00:13.894240

exit_message:

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

id: 6673838

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_newbookcompendium_synonyms/2024-11-05/1730866341",
        "key": "raw/newbookdev_newbookcompendium_synonyms/2024-11-05/1730866341/compendium_synonyms.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcompendium_synonyms",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8632170907292272369,
        "service_name": "drive-thru",
        "span_id": 518849325241768343,
        "trace_id": 2567722543622380156
    }
}

running: False
schema_name_id: 2562
start_time: 2024-11-05 22:26:26
success: True
trace_id: 2567722543622380156

Scan 6673530

duration: 0:00:13.946185

exit_message:

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

id: 6673530

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_newbookcompendium_synonyms/2024-11-05/1730866256",
        "key": "raw/newbookdev_newbookcompendium_synonyms/2024-11-05/1730866256/compendium_synonyms.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcompendium_synonyms",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2441979611026844428,
        "service_name": "drive-thru",
        "span_id": 10910459986360914771,
        "trace_id": 3903074635829521099
    }
}

running: False
schema_name_id: 2562
start_time: 2024-11-05 22:18:25
success: True
trace_id: 3903074635829521099

Scan 6672162

duration: 0:00:11.450370

exit_message:

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

id: 6672162

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_newbookcompendium_synonyms/2024-11-04/1730785676",
        "key": "raw/newbookdev_newbookcompendium_synonyms/2024-11-04/1730785676/compendium_synonyms.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcompendium_synonyms",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9916462155553850879,
        "service_name": "drive-thru",
        "span_id": 5982518343743490865,
        "trace_id": 16910984608115887481
    }
}

running: False
schema_name_id: 2562
start_time: 2024-11-05 04:33:32
success: True
trace_id: 16910984608115887481

Scan 6671154

duration: 0:00:13.962898

exit_message:

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

id: 6671154

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_newbookcompendium_synonyms/2024-11-04/1730785098",
        "key": "raw/newbookdev_newbookcompendium_synonyms/2024-11-04/1730785098/compendium_synonyms.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcompendium_synonyms",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13432352782558769015,
        "service_name": "drive-thru",
        "span_id": 12225623844809425212,
        "trace_id": 14733583837181141948
    }
}

running: False
schema_name_id: 2562
start_time: 2024-11-05 03:43:24
success: True
trace_id: 14733583837181141948

Scan 6670649

duration: 0:00:13.911336

exit_message:

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

id: 6670649

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_newbookcompendium_synonyms/2024-11-04/1730784793",
        "key": "raw/newbookdev_newbookcompendium_synonyms/2024-11-04/1730784793/compendium_synonyms.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcompendium_synonyms",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12987231626239213124,
        "service_name": "drive-thru",
        "span_id": 2639597144630992530,
        "trace_id": 17314934660657951186
    }
}

running: False
schema_name_id: 2562
start_time: 2024-11-05 03:29:15
success: True
trace_id: 17314934660657951186

Scan 6669649

duration: 0:00:13.812784

exit_message:

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

id: 6669649

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_newbookcompendium_synonyms/2024-11-04/1730784190",
        "key": "raw/newbookdev_newbookcompendium_synonyms/2024-11-04/1730784190/compendium_synonyms.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcompendium_synonyms",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 564606073321612910,
        "service_name": "drive-thru",
        "span_id": 9878676979637444235,
        "trace_id": 6796117515629991760
    }
}

running: False
schema_name_id: 2562
start_time: 2024-11-05 03:02:50
success: True
trace_id: 6796117515629991760

Scan 6669386

duration: 0:00:11.286928

exit_message:

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

id: 6669386

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_newbookcompendium_synonyms/2024-11-04/1730784027",
        "key": "raw/newbookdev_newbookcompendium_synonyms/2024-11-04/1730784027/compendium_synonyms.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcompendium_synonyms",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16151410760713457939,
        "service_name": "drive-thru",
        "span_id": 11247854899826502263,
        "trace_id": 6687176762192887175
    }
}

running: False
schema_name_id: 2562
start_time: 2024-11-05 02:55:48
success: True
trace_id: 6687176762192887175

Scan 6668606

duration: 0:00:11.830601

exit_message:

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

id: 6668606

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_newbookcompendium_synonyms/2024-11-04/1730783878",
        "key": "raw/newbookdev_newbookcompendium_synonyms/2024-11-04/1730783878/compendium_synonyms.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcompendium_synonyms",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7573959347850490512,
        "service_name": "drive-thru",
        "span_id": 15871464733034638992,
        "trace_id": 7654039559208919714
    }
}

running: False
schema_name_id: 2562
start_time: 2024-11-05 02:35:20
success: True
trace_id: 7654039559208919714

Scan 6667640

duration: 0:00:11.448888

exit_message:

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

id: 6667640

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_newbookcompendium_synonyms/2024-11-04/1730783740",
        "key": "raw/newbookdev_newbookcompendium_synonyms/2024-11-04/1730783740/compendium_synonyms.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcompendium_synonyms",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11454873955327133115,
        "service_name": "drive-thru",
        "span_id": 9310265344920338807,
        "trace_id": 7120473081650765251
    }
}

running: False
schema_name_id: 2562
start_time: 2024-11-05 02:09:51
success: True
trace_id: 7120473081650765251

Scan 6666856

duration: 0:00:11.320640

exit_message:

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

id: 6666856

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_newbookcompendium_synonyms/2024-11-04/1730783644",
        "key": "raw/newbookdev_newbookcompendium_synonyms/2024-11-04/1730783644/compendium_synonyms.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcompendium_synonyms",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18154522190567652165,
        "service_name": "drive-thru",
        "span_id": 11909717384326697912,
        "trace_id": 14374919651814229580
    }
}

running: False
schema_name_id: 2562
start_time: 2024-11-05 01:48:52
success: True
trace_id: 14374919651814229580

Scan 6666256

duration: 0:00:13.928091

exit_message:

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

id: 6666256

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_newbookcompendium_synonyms/2024-11-04/1730783496",
        "key": "raw/newbookdev_newbookcompendium_synonyms/2024-11-04/1730783496/compendium_synonyms.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcompendium_synonyms",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11990880852508251807,
        "service_name": "drive-thru",
        "span_id": 1289858797991331126,
        "trace_id": 11754479398726372324
    }
}

running: False
schema_name_id: 2562
start_time: 2024-11-05 01:33:11
success: True
trace_id: 11754479398726372324

Scan 6665352

duration: 0:00:11.364178

exit_message:

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

id: 6665352

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_newbookcompendium_synonyms/2024-11-04/1730783277",
        "key": "raw/newbookdev_newbookcompendium_synonyms/2024-11-04/1730783277/compendium_synonyms.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcompendium_synonyms",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17241869529340168940,
        "service_name": "drive-thru",
        "span_id": 10099636202828275349,
        "trace_id": 10491206356179163113
    }
}

running: False
schema_name_id: 2562
start_time: 2024-11-05 01:09:18
success: True
trace_id: 10491206356179163113

Scan 6664714

duration: 0:00:11.194620

exit_message:

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

id: 6664714

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_newbookcompendium_synonyms/2024-11-04/1730782880",
        "key": "raw/newbookdev_newbookcompendium_synonyms/2024-11-04/1730782880/compendium_synonyms.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcompendium_synonyms",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15658497614591573736,
        "service_name": "drive-thru",
        "span_id": 17446169552467189397,
        "trace_id": 2480200451734950256
    }
}

running: False
schema_name_id: 2562
start_time: 2024-11-05 00:52:12
success: True
trace_id: 2480200451734950256

Scan 6663888

duration: 0:00:11.319500

exit_message:

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

id: 6663888

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_newbookcompendium_synonyms/2024-11-04/1730782744",
        "key": "raw/newbookdev_newbookcompendium_synonyms/2024-11-04/1730782744/compendium_synonyms.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcompendium_synonyms",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8309276442698193570,
        "service_name": "drive-thru",
        "span_id": 12204695766719170583,
        "trace_id": 8041507246852950763
    }
}

running: False
schema_name_id: 2562
start_time: 2024-11-05 00:30:37
success: True
trace_id: 8041507246852950763

Partitions:

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

Schema:

attributes:

{
    "id": "string",
    "newbook_region": "string",
    "synonyms": "string",
    "tenant": "string",
    "type": "string",
    "type_id": "string"
}

created: 2024-11-05 22:47:13

ddl:

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

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