Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbooknewbie_synonyms

created: 2024-10-08 18:07:17
disabled: False
format: raw
id: 2796
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4749049

created: 2024-11-05 23:16:37

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooknewbie_synonyms/2024-11-05/1730866555
id: 4749049
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: 2796
schema_scan_id: 6675081
updated: 2024-11-05 23:16:51

Version 4748711

created: 2024-11-05 22:57:37

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooknewbie_synonyms/2024-11-05/1730866498
id: 4748711
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: 2796
schema_scan_id: 6674743
updated: 2024-11-05 22:57:48

Version 4748033

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooknewbie_synonyms/2024-11-05/1730866362
id: 4748033
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: 2796
schema_scan_id: 6674065
updated: 2024-11-05 22:32:57

Version 4746900

created: 2024-11-05 04:31:15

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooknewbie_synonyms/2024-11-04/1730785758
id: 4746900
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: 2796
schema_scan_id: 6672131
updated: 2024-11-05 04:31:26

Version 4746369

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooknewbie_synonyms/2024-11-04/1730785145
id: 4746369
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: 2796
schema_scan_id: 6671590
updated: 2024-11-05 04:00:16

Version 4745535

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooknewbie_synonyms/2024-11-04/1730784840
id: 4745535
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: 2796
schema_scan_id: 6670752
updated: 2024-11-05 03:32:13

Version 4745360

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooknewbie_synonyms/2024-11-04/1730784236
id: 4745360
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: 2796
schema_scan_id: 6670577
updated: 2024-11-05 03:27:37

Version 4743554

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooknewbie_synonyms/2024-11-04/1730784074
id: 4743554
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: 2796
schema_scan_id: 6668771
updated: 2024-11-05 02:39:51

Version 4743458

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooknewbie_synonyms/2024-11-04/1730783914
id: 4743458
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: 2796
schema_scan_id: 6668675
updated: 2024-11-05 02:37:21

Version 4742588

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooknewbie_synonyms/2024-11-04/1730783787
id: 4742588
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: 2796
schema_scan_id: 6667805
updated: 2024-11-05 02:14:22

Version 4742015

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooknewbie_synonyms/2024-11-04/1730783680
id: 4742015
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: 2796
schema_scan_id: 6667232
updated: 2024-11-05 01:58:56

Version 4741293

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooknewbie_synonyms/2024-11-04/1730783544
id: 4741293
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: 2796
schema_scan_id: 6666510
updated: 2024-11-05 01:40:01

Version 4740507

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooknewbie_synonyms/2024-11-04/1730783326
id: 4740507
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: 2796
schema_scan_id: 6665725
updated: 2024-11-05 01:19:21

Version 4739775

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooknewbie_synonyms/2024-11-04/1730782926
id: 4739775
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: 2796
schema_scan_id: 6664993
updated: 2024-11-05 00:59:46

Version 4738928

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooknewbie_synonyms/2024-11-04/1730782820
id: 4738928
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: 2796
schema_scan_id: 6664142
updated: 2024-11-05 00:37:31

Schema Scans: 15

Last at 2024-11-05 23:16:37

Scan 6675081

duration: 0:00:14.098996

exit_message:

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

id: 6675081

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_newbooknewbie_synonyms/2024-11-05/1730866555",
        "key": "raw/newbookdev_newbooknewbie_synonyms/2024-11-05/1730866555/newbie_synonyms.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooknewbie_synonyms",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15717138350561578814,
        "service_name": "drive-thru",
        "span_id": 3393769456037536468,
        "trace_id": 5915959415903231760
    }
}

running: False
schema_name_id: 2796
start_time: 2024-11-05 23:16:37
success: True
trace_id: 5915959415903231760

Scan 6674743

duration: 0:00:11.449805

exit_message:

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

id: 6674743

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_newbooknewbie_synonyms/2024-11-05/1730866498",
        "key": "raw/newbookdev_newbooknewbie_synonyms/2024-11-05/1730866498/newbie_synonyms.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooknewbie_synonyms",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1834883204863321097,
        "service_name": "drive-thru",
        "span_id": 4819219967520002488,
        "trace_id": 13510353925287211980
    }
}

running: False
schema_name_id: 2796
start_time: 2024-11-05 22:57:36
success: True
trace_id: 13510353925287211980

Scan 6674065

duration: 0:00:11.537910

exit_message:

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

id: 6674065

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_newbooknewbie_synonyms/2024-11-05/1730866362",
        "key": "raw/newbookdev_newbooknewbie_synonyms/2024-11-05/1730866362/newbie_synonyms.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooknewbie_synonyms",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3839863231608710386,
        "service_name": "drive-thru",
        "span_id": 1467127510350442772,
        "trace_id": 896221399535595525
    }
}

running: False
schema_name_id: 2796
start_time: 2024-11-05 22:32:45
success: True
trace_id: 896221399535595525

Scan 6672131

duration: 0:00:11.450802

exit_message:

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

id: 6672131

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_newbooknewbie_synonyms/2024-11-04/1730785758",
        "key": "raw/newbookdev_newbooknewbie_synonyms/2024-11-04/1730785758/newbie_synonyms.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooknewbie_synonyms",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2067436467713113114,
        "service_name": "drive-thru",
        "span_id": 7594373653478219059,
        "trace_id": 9325620841458204292
    }
}

running: False
schema_name_id: 2796
start_time: 2024-11-05 04:31:15
success: True
trace_id: 9325620841458204292

Scan 6671590

duration: 0:00:14.077883

exit_message:

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

id: 6671590

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_newbooknewbie_synonyms/2024-11-04/1730785145",
        "key": "raw/newbookdev_newbooknewbie_synonyms/2024-11-04/1730785145/newbie_synonyms.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooknewbie_synonyms",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2867746414714162270,
        "service_name": "drive-thru",
        "span_id": 6466238148139847788,
        "trace_id": 5861603297858227515
    }
}

running: False
schema_name_id: 2796
start_time: 2024-11-05 04:00:02
success: True
trace_id: 5861603297858227515

Scan 6670752

duration: 0:00:13.950915

exit_message:

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

id: 6670752

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_newbooknewbie_synonyms/2024-11-04/1730784840",
        "key": "raw/newbookdev_newbooknewbie_synonyms/2024-11-04/1730784840/newbie_synonyms.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooknewbie_synonyms",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10795983068843001448,
        "service_name": "drive-thru",
        "span_id": 12191824875935830119,
        "trace_id": 11080725998077480851
    }
}

running: False
schema_name_id: 2796
start_time: 2024-11-05 03:31:59
success: True
trace_id: 11080725998077480851

Scan 6670577

duration: 0:00:11.333576

exit_message:

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

id: 6670577

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_newbooknewbie_synonyms/2024-11-04/1730784236",
        "key": "raw/newbookdev_newbooknewbie_synonyms/2024-11-04/1730784236/newbie_synonyms.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooknewbie_synonyms",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6218181114858133787,
        "service_name": "drive-thru",
        "span_id": 17736809436509931644,
        "trace_id": 13443564033512910549
    }
}

running: False
schema_name_id: 2796
start_time: 2024-11-05 03:27:25
success: True
trace_id: 13443564033512910549

Scan 6668771

duration: 0:00:11.516198

exit_message:

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

id: 6668771

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_newbooknewbie_synonyms/2024-11-04/1730784074",
        "key": "raw/newbookdev_newbooknewbie_synonyms/2024-11-04/1730784074/newbie_synonyms.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooknewbie_synonyms",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16591923055000568241,
        "service_name": "drive-thru",
        "span_id": 17102741185669058204,
        "trace_id": 3809657394049631702
    }
}

running: False
schema_name_id: 2796
start_time: 2024-11-05 02:39:39
success: True
trace_id: 3809657394049631702

Scan 6668675

duration: 0:00:11.552767

exit_message:

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

id: 6668675

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_newbooknewbie_synonyms/2024-11-04/1730783914",
        "key": "raw/newbookdev_newbooknewbie_synonyms/2024-11-04/1730783914/newbie_synonyms.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooknewbie_synonyms",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3645327919519510026,
        "service_name": "drive-thru",
        "span_id": 1610170423763645312,
        "trace_id": 14282293894610166917
    }
}

running: False
schema_name_id: 2796
start_time: 2024-11-05 02:37:09
success: True
trace_id: 14282293894610166917

Scan 6667805

duration: 0:00:11.394072

exit_message:

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

id: 6667805

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_newbooknewbie_synonyms/2024-11-04/1730783787",
        "key": "raw/newbookdev_newbooknewbie_synonyms/2024-11-04/1730783787/newbie_synonyms.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooknewbie_synonyms",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14685174248895596781,
        "service_name": "drive-thru",
        "span_id": 5673488219884657127,
        "trace_id": 12633764594865837911
    }
}

running: False
schema_name_id: 2796
start_time: 2024-11-05 02:14:11
success: True
trace_id: 12633764594865837911

Scan 6667232

duration: 0:00:11.370743

exit_message:

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

id: 6667232

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_newbooknewbie_synonyms/2024-11-04/1730783680",
        "key": "raw/newbookdev_newbooknewbie_synonyms/2024-11-04/1730783680/newbie_synonyms.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooknewbie_synonyms",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10018332307375991860,
        "service_name": "drive-thru",
        "span_id": 9036052969344491356,
        "trace_id": 17636670581258754179
    }
}

running: False
schema_name_id: 2796
start_time: 2024-11-05 01:58:45
success: True
trace_id: 17636670581258754179

Scan 6666510

duration: 0:00:11.324598

exit_message:

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

id: 6666510

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_newbooknewbie_synonyms/2024-11-04/1730783544",
        "key": "raw/newbookdev_newbooknewbie_synonyms/2024-11-04/1730783544/newbie_synonyms.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooknewbie_synonyms",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11178173302748945353,
        "service_name": "drive-thru",
        "span_id": 2901691021376128215,
        "trace_id": 11448935560483702303
    }
}

running: False
schema_name_id: 2796
start_time: 2024-11-05 01:39:50
success: True
trace_id: 11448935560483702303

Scan 6665725

duration: 0:00:11.499815

exit_message:

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

id: 6665725

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_newbooknewbie_synonyms/2024-11-04/1730783326",
        "key": "raw/newbookdev_newbooknewbie_synonyms/2024-11-04/1730783326/newbie_synonyms.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooknewbie_synonyms",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8852077206748517923,
        "service_name": "drive-thru",
        "span_id": 12069051140650086813,
        "trace_id": 7065172524614790373
    }
}

running: False
schema_name_id: 2796
start_time: 2024-11-05 01:19:09
success: True
trace_id: 7065172524614790373

Scan 6664993

duration: 0:00:11.500983

exit_message:

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

id: 6664993

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_newbooknewbie_synonyms/2024-11-04/1730782926",
        "key": "raw/newbookdev_newbooknewbie_synonyms/2024-11-04/1730782926/newbie_synonyms.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooknewbie_synonyms",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3076677150004390502,
        "service_name": "drive-thru",
        "span_id": 2543162651031397481,
        "trace_id": 7329209521193653982
    }
}

running: False
schema_name_id: 2796
start_time: 2024-11-05 00:59:35
success: True
trace_id: 7329209521193653982

Scan 6664142

duration: 0:00:13.855743

exit_message:

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

id: 6664142

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_newbooknewbie_synonyms/2024-11-04/1730782820",
        "key": "raw/newbookdev_newbooknewbie_synonyms/2024-11-04/1730782820/newbie_synonyms.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooknewbie_synonyms",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7878427794290399281,
        "service_name": "drive-thru",
        "span_id": 17493461366471334841,
        "trace_id": 13265004920979796715
    }
}

running: False
schema_name_id: 2796
start_time: 2024-11-05 00:37:17
success: True
trace_id: 13265004920979796715

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 23:16:37

ddl:

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