Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookfacilities_features_link

created: 2024-10-08 18:00:43
disabled: False
format: raw
id: 2737
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4748771

created: 2024-11-05 23:00:38

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookfacilities_features_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookfacilities_features_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type`  string , `type_id`  string , `feature_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfacilities_features_link/2024-11-05/1730866495'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookfacilities_features_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfacilities_features_link/2024-11-05/1730866495
id: 4748771
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2737
schema_scan_id: 6674803
updated: 2024-11-05 23:00:51

Version 4748340

created: 2024-11-05 22:42:48

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookfacilities_features_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookfacilities_features_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type`  string , `type_id`  string , `feature_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfacilities_features_link/2024-11-05/1730866412'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookfacilities_features_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfacilities_features_link/2024-11-05/1730866412
id: 4748340
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2737
schema_scan_id: 6674372
updated: 2024-11-05 22:42:59

Version 4747672

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookfacilities_features_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookfacilities_features_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type`  string , `type_id`  string , `feature_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfacilities_features_link/2024-11-05/1730866297'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookfacilities_features_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfacilities_features_link/2024-11-05/1730866297
id: 4747672
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2737
schema_scan_id: 6673704
updated: 2024-11-05 22:23:08

Version 4746845

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookfacilities_features_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookfacilities_features_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type`  string , `type_id`  string , `feature_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfacilities_features_link/2024-11-04/1730785713'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookfacilities_features_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfacilities_features_link/2024-11-04/1730785713
id: 4746845
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2737
schema_scan_id: 6672075
updated: 2024-11-05 04:27:31

Version 4746397

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookfacilities_features_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookfacilities_features_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type`  string , `type_id`  string , `feature_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfacilities_features_link/2024-11-04/1730785120'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookfacilities_features_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfacilities_features_link/2024-11-04/1730785120
id: 4746397
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2737
schema_scan_id: 6671618
updated: 2024-11-05 04:01:29

Version 4745340

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookfacilities_features_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookfacilities_features_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type`  string , `type_id`  string , `feature_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfacilities_features_link/2024-11-04/1730784815'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookfacilities_features_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfacilities_features_link/2024-11-04/1730784815
id: 4745340
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2737
schema_scan_id: 6670557
updated: 2024-11-05 03:27:03

Version 4744916

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookfacilities_features_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookfacilities_features_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type`  string , `type_id`  string , `feature_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfacilities_features_link/2024-11-04/1730784211'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookfacilities_features_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfacilities_features_link/2024-11-04/1730784211
id: 4744916
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2737
schema_scan_id: 6670133
updated: 2024-11-05 03:16:01

Version 4744257

created: 2024-11-05 02:58:05

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookfacilities_features_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookfacilities_features_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type`  string , `type_id`  string , `feature_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfacilities_features_link/2024-11-04/1730784049'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookfacilities_features_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfacilities_features_link/2024-11-04/1730784049
id: 4744257
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2737
schema_scan_id: 6669474
updated: 2024-11-05 02:58:16

Version 4743482

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookfacilities_features_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookfacilities_features_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type`  string , `type_id`  string , `feature_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfacilities_features_link/2024-11-04/1730783895'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookfacilities_features_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfacilities_features_link/2024-11-04/1730783895
id: 4743482
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2737
schema_scan_id: 6668699
updated: 2024-11-05 02:38:00

Version 4742614

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookfacilities_features_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookfacilities_features_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type`  string , `type_id`  string , `feature_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfacilities_features_link/2024-11-04/1730783762'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookfacilities_features_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfacilities_features_link/2024-11-04/1730783762
id: 4742614
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2737
schema_scan_id: 6667831
updated: 2024-11-05 02:15:02

Version 4741771

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookfacilities_features_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookfacilities_features_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type`  string , `type_id`  string , `feature_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfacilities_features_link/2024-11-04/1730783661'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookfacilities_features_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfacilities_features_link/2024-11-04/1730783661
id: 4741771
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2737
schema_scan_id: 6666989
updated: 2024-11-05 01:52:36

Version 4741079

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookfacilities_features_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookfacilities_features_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type`  string , `type_id`  string , `feature_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfacilities_features_link/2024-11-04/1730783518'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookfacilities_features_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfacilities_features_link/2024-11-04/1730783518
id: 4741079
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2737
schema_scan_id: 6666296
updated: 2024-11-05 01:34:28

Version 4740270

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookfacilities_features_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookfacilities_features_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type`  string , `type_id`  string , `feature_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfacilities_features_link/2024-11-04/1730783300'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookfacilities_features_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfacilities_features_link/2024-11-04/1730783300
id: 4740270
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2737
schema_scan_id: 6665487
updated: 2024-11-05 01:13:07

Version 4739495

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookfacilities_features_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookfacilities_features_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type`  string , `type_id`  string , `feature_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfacilities_features_link/2024-11-04/1730782901'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookfacilities_features_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfacilities_features_link/2024-11-04/1730782901
id: 4739495
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2737
schema_scan_id: 6664710
updated: 2024-11-05 00:52:21

Version 4738369

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookfacilities_features_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookfacilities_features_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type`  string , `type_id`  string , `feature_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfacilities_features_link/2024-11-04/1730782749'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookfacilities_features_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfacilities_features_link/2024-11-04/1730782749
id: 4738369
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2737
schema_scan_id: 6663580
updated: 2024-11-05 00:22:53

Schema Scans: 15

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

Scan 6674803

duration: 0:00:14.054719

exit_message:

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

id: 6674803

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_newbookfacilities_features_link/2024-11-05/1730866495",
        "key": "raw/newbookdev_newbookfacilities_features_link/2024-11-05/1730866495/facilities_features_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookfacilities_features_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4987068204897445838,
        "service_name": "drive-thru",
        "span_id": 9830254164217702066,
        "trace_id": 11970559027037088914
    }
}

running: False
schema_name_id: 2737
start_time: 2024-11-05 23:00:37
success: True
trace_id: 11970559027037088914

Scan 6674372

duration: 0:00:11.517260

exit_message:

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

id: 6674372

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_newbookfacilities_features_link/2024-11-05/1730866412",
        "key": "raw/newbookdev_newbookfacilities_features_link/2024-11-05/1730866412/facilities_features_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookfacilities_features_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17372400192476146517,
        "service_name": "drive-thru",
        "span_id": 3146883949915731910,
        "trace_id": 8100702715133386120
    }
}

running: False
schema_name_id: 2737
start_time: 2024-11-05 22:42:48
success: True
trace_id: 8100702715133386120

Scan 6673704

duration: 0:00:11.421044

exit_message:

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

id: 6673704

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_newbookfacilities_features_link/2024-11-05/1730866297",
        "key": "raw/newbookdev_newbookfacilities_features_link/2024-11-05/1730866297/facilities_features_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookfacilities_features_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1863649644430850346,
        "service_name": "drive-thru",
        "span_id": 12099567383026054626,
        "trace_id": 17986663418936854476
    }
}

running: False
schema_name_id: 2737
start_time: 2024-11-05 22:22:57
success: True
trace_id: 17986663418936854476

Scan 6672075

duration: 0:00:13.993293

exit_message:

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

id: 6672075

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_newbookfacilities_features_link/2024-11-04/1730785713",
        "key": "raw/newbookdev_newbookfacilities_features_link/2024-11-04/1730785713/facilities_features_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookfacilities_features_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7104404482623509127,
        "service_name": "drive-thru",
        "span_id": 2389216138886569270,
        "trace_id": 17560489366499499068
    }
}

running: False
schema_name_id: 2737
start_time: 2024-11-05 04:27:18
success: True
trace_id: 17560489366499499068

Scan 6671618

duration: 0:00:11.554053

exit_message:

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

id: 6671618

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_newbookfacilities_features_link/2024-11-04/1730785120",
        "key": "raw/newbookdev_newbookfacilities_features_link/2024-11-04/1730785120/facilities_features_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookfacilities_features_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9406035092597532405,
        "service_name": "drive-thru",
        "span_id": 9365862887994002057,
        "trace_id": 831028562918117515
    }
}

running: False
schema_name_id: 2737
start_time: 2024-11-05 04:01:17
success: True
trace_id: 831028562918117515

Scan 6670557

duration: 0:00:11.369767

exit_message:

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

id: 6670557

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_newbookfacilities_features_link/2024-11-04/1730784815",
        "key": "raw/newbookdev_newbookfacilities_features_link/2024-11-04/1730784815/facilities_features_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookfacilities_features_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15163966957914562894,
        "service_name": "drive-thru",
        "span_id": 17955505558112770941,
        "trace_id": 3047172479787355279
    }
}

running: False
schema_name_id: 2737
start_time: 2024-11-05 03:26:52
success: True
trace_id: 3047172479787355279

Scan 6670133

duration: 0:00:11.475470

exit_message:

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

id: 6670133

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_newbookfacilities_features_link/2024-11-04/1730784211",
        "key": "raw/newbookdev_newbookfacilities_features_link/2024-11-04/1730784211/facilities_features_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookfacilities_features_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6138022410521930744,
        "service_name": "drive-thru",
        "span_id": 13953321646898929244,
        "trace_id": 16890732617990714312
    }
}

running: False
schema_name_id: 2737
start_time: 2024-11-05 03:15:49
success: True
trace_id: 16890732617990714312

Scan 6669474

duration: 0:00:11.365430

exit_message:

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

id: 6669474

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_newbookfacilities_features_link/2024-11-04/1730784049",
        "key": "raw/newbookdev_newbookfacilities_features_link/2024-11-04/1730784049/facilities_features_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookfacilities_features_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2868743147737488260,
        "service_name": "drive-thru",
        "span_id": 18167012061296449908,
        "trace_id": 6239547883039039160
    }
}

running: False
schema_name_id: 2737
start_time: 2024-11-05 02:58:04
success: True
trace_id: 6239547883039039160

Scan 6668699

duration: 0:00:11.339929

exit_message:

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

id: 6668699

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_newbookfacilities_features_link/2024-11-04/1730783895",
        "key": "raw/newbookdev_newbookfacilities_features_link/2024-11-04/1730783895/facilities_features_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookfacilities_features_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14674883985587724101,
        "service_name": "drive-thru",
        "span_id": 3340535258757468225,
        "trace_id": 15616330471366660191
    }
}

running: False
schema_name_id: 2737
start_time: 2024-11-05 02:37:49
success: True
trace_id: 15616330471366660191

Scan 6667831

duration: 0:00:11.437299

exit_message:

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

id: 6667831

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_newbookfacilities_features_link/2024-11-04/1730783762",
        "key": "raw/newbookdev_newbookfacilities_features_link/2024-11-04/1730783762/facilities_features_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookfacilities_features_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8071481818330918029,
        "service_name": "drive-thru",
        "span_id": 3130676348744828559,
        "trace_id": 7122416422145514389
    }
}

running: False
schema_name_id: 2737
start_time: 2024-11-05 02:14:51
success: True
trace_id: 7122416422145514389

Scan 6666989

duration: 0:00:13.872593

exit_message:

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

id: 6666989

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_newbookfacilities_features_link/2024-11-04/1730783661",
        "key": "raw/newbookdev_newbookfacilities_features_link/2024-11-04/1730783661/facilities_features_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookfacilities_features_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2516026727938386095,
        "service_name": "drive-thru",
        "span_id": 7443255103721086922,
        "trace_id": 10116942591664622735
    }
}

running: False
schema_name_id: 2737
start_time: 2024-11-05 01:52:22
success: True
trace_id: 10116942591664622735

Scan 6666296

duration: 0:00:13.880976

exit_message:

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

id: 6666296

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_newbookfacilities_features_link/2024-11-04/1730783518",
        "key": "raw/newbookdev_newbookfacilities_features_link/2024-11-04/1730783518/facilities_features_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookfacilities_features_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9319801039042658072,
        "service_name": "drive-thru",
        "span_id": 6750982559201593352,
        "trace_id": 385621457642583400
    }
}

running: False
schema_name_id: 2737
start_time: 2024-11-05 01:34:14
success: True
trace_id: 385621457642583400

Scan 6665487

duration: 0:00:11.304064

exit_message:

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

id: 6665487

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_newbookfacilities_features_link/2024-11-04/1730783300",
        "key": "raw/newbookdev_newbookfacilities_features_link/2024-11-04/1730783300/facilities_features_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookfacilities_features_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10643491764175473867,
        "service_name": "drive-thru",
        "span_id": 7048478147139563325,
        "trace_id": 10394162934900867861
    }
}

running: False
schema_name_id: 2737
start_time: 2024-11-05 01:12:56
success: True
trace_id: 10394162934900867861

Scan 6664710

duration: 0:00:13.896653

exit_message:

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

id: 6664710

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_newbookfacilities_features_link/2024-11-04/1730782901",
        "key": "raw/newbookdev_newbookfacilities_features_link/2024-11-04/1730782901/facilities_features_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookfacilities_features_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15784648075190330939,
        "service_name": "drive-thru",
        "span_id": 8702287098116241542,
        "trace_id": 15464378298974670086
    }
}

running: False
schema_name_id: 2737
start_time: 2024-11-05 00:52:07
success: True
trace_id: 15464378298974670086

Scan 6663580

duration: 0:00:13.857046

exit_message:

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

id: 6663580

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_newbookfacilities_features_link/2024-11-04/1730782749",
        "key": "raw/newbookdev_newbookfacilities_features_link/2024-11-04/1730782749/facilities_features_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookfacilities_features_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17179027646106149407,
        "service_name": "drive-thru",
        "span_id": 9877894808393722819,
        "trace_id": 13616707927400791479
    }
}

running: False
schema_name_id: 2737
start_time: 2024-11-05 00:22:39
success: True
trace_id: 13616707927400791479

Partitions:

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

Schema:

attributes:

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

created: 2024-11-05 23:00:38

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookfacilities_features_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type`  string , `type_id`  string , `feature_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfacilities_features_link/2024-11-05/1730866495'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookfacilities_features_link`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookfacilities_features_link"
}

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:00:43",
        "disabled": false,
        "format": "raw",
        "id": 2737,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "newbookdev_newbookfacilities_features_link"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "feature_id": "string",
            "id": "string",
            "newbook_region": "string",
            "tenant": "string",
            "type": "string",
            "type_id": "string"
        },
        "created": "2024-11-05 23:00:38",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookfacilities_features_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `type`  string , `type_id`  string , `feature_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookfacilities_features_link/2024-11-05/1730866495'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookfacilities_features_link`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookfacilities_features_link"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}