Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookcustom_fields_restrictions

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4748615

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcustom_fields_restrictions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcustom_fields_restrictions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `custom_field_id`  string , `for`  string , `for_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_newbookcustom_fields_restrictions/2024-11-05/1730866455'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcustom_fields_restrictions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcustom_fields_restrictions/2024-11-05/1730866455
id: 4748615
processed: 1

raw_data:

{
    "custom_field_id": 3,
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "custom_field_id": "string",
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2577
schema_scan_id: 6674647
updated: 2024-11-05 22:53:44

Version 4748106

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcustom_fields_restrictions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcustom_fields_restrictions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `custom_field_id`  string , `for`  string , `for_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_newbookcustom_fields_restrictions/2024-11-05/1730866369'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcustom_fields_restrictions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcustom_fields_restrictions/2024-11-05/1730866369
id: 4748106
processed: 1

raw_data:

{
    "custom_field_id": 3,
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "custom_field_id": "string",
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2577
schema_scan_id: 6674138
updated: 2024-11-05 22:35:13

Version 4747592

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcustom_fields_restrictions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcustom_fields_restrictions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `custom_field_id`  string , `for`  string , `for_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_newbookcustom_fields_restrictions/2024-11-05/1730866270'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcustom_fields_restrictions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcustom_fields_restrictions/2024-11-05/1730866270
id: 4747592
processed: 1

raw_data:

{
    "custom_field_id": 3,
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "custom_field_id": "string",
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2577
schema_scan_id: 6673624
updated: 2024-11-05 22:21:03

Version 4747035

created: 2024-11-05 04:43:22

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcustom_fields_restrictions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcustom_fields_restrictions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `custom_field_id`  string , `for`  string , `for_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_newbookcustom_fields_restrictions/2024-11-04/1730785691'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcustom_fields_restrictions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcustom_fields_restrictions/2024-11-04/1730785691
id: 4747035
processed: 1

raw_data:

{
    "custom_field_id": 3,
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "custom_field_id": "string",
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2577
schema_scan_id: 6672267
updated: 2024-11-05 04:43:33

Version 4745379

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcustom_fields_restrictions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcustom_fields_restrictions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `custom_field_id`  string , `for`  string , `for_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_newbookcustom_fields_restrictions/2024-11-04/1730785107'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcustom_fields_restrictions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcustom_fields_restrictions/2024-11-04/1730785107
id: 4745379
processed: 1

raw_data:

{
    "custom_field_id": 3,
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "custom_field_id": "string",
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2577
schema_scan_id: 6670596
updated: 2024-11-05 03:28:02

Version 4745263

created: 2024-11-05 03:24:54

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcustom_fields_restrictions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcustom_fields_restrictions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `custom_field_id`  string , `for`  string , `for_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_newbookcustom_fields_restrictions/2024-11-04/1730784802'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcustom_fields_restrictions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcustom_fields_restrictions/2024-11-04/1730784802
id: 4745263
processed: 1

raw_data:

{
    "custom_field_id": 3,
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "custom_field_id": "string",
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2577
schema_scan_id: 6670480
updated: 2024-11-05 03:25:05

Version 4744638

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcustom_fields_restrictions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcustom_fields_restrictions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `custom_field_id`  string , `for`  string , `for_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_newbookcustom_fields_restrictions/2024-11-04/1730784199'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcustom_fields_restrictions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcustom_fields_restrictions/2024-11-04/1730784199
id: 4744638
processed: 1

raw_data:

{
    "custom_field_id": 3,
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "custom_field_id": "string",
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2577
schema_scan_id: 6669855
updated: 2024-11-05 03:08:40

Version 4744130

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcustom_fields_restrictions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcustom_fields_restrictions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `custom_field_id`  string , `for`  string , `for_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_newbookcustom_fields_restrictions/2024-11-04/1730784036'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcustom_fields_restrictions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcustom_fields_restrictions/2024-11-04/1730784036
id: 4744130
processed: 1

raw_data:

{
    "custom_field_id": 3,
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "custom_field_id": "string",
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2577
schema_scan_id: 6669347
updated: 2024-11-05 02:54:58

Version 4743433

created: 2024-11-05 02:36:29

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcustom_fields_restrictions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcustom_fields_restrictions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `custom_field_id`  string , `for`  string , `for_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_newbookcustom_fields_restrictions/2024-11-04/1730783886'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcustom_fields_restrictions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcustom_fields_restrictions/2024-11-04/1730783886
id: 4743433
processed: 1

raw_data:

{
    "custom_field_id": 3,
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "custom_field_id": "string",
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2577
schema_scan_id: 6668650
updated: 2024-11-05 02:36:40

Version 4742331

created: 2024-11-05 02:07:25

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcustom_fields_restrictions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcustom_fields_restrictions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `custom_field_id`  string , `for`  string , `for_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_newbookcustom_fields_restrictions/2024-11-04/1730783750'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcustom_fields_restrictions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcustom_fields_restrictions/2024-11-04/1730783750
id: 4742331
processed: 1

raw_data:

{
    "custom_field_id": 3,
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "custom_field_id": "string",
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2577
schema_scan_id: 6667549
updated: 2024-11-05 02:07:38

Version 4741830

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcustom_fields_restrictions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcustom_fields_restrictions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `custom_field_id`  string , `for`  string , `for_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_newbookcustom_fields_restrictions/2024-11-04/1730783651'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcustom_fields_restrictions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcustom_fields_restrictions/2024-11-04/1730783651
id: 4741830
processed: 1

raw_data:

{
    "custom_field_id": 3,
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "custom_field_id": "string",
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2577
schema_scan_id: 6667047
updated: 2024-11-05 01:54:06

Version 4740898

created: 2024-11-05 01:29:24

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcustom_fields_restrictions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcustom_fields_restrictions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `custom_field_id`  string , `for`  string , `for_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_newbookcustom_fields_restrictions/2024-11-04/1730783505'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcustom_fields_restrictions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcustom_fields_restrictions/2024-11-04/1730783505
id: 4740898
processed: 1

raw_data:

{
    "custom_field_id": 3,
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "custom_field_id": "string",
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2577
schema_scan_id: 6666115
updated: 2024-11-05 01:29:35

Version 4740154

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcustom_fields_restrictions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcustom_fields_restrictions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `custom_field_id`  string , `for`  string , `for_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_newbookcustom_fields_restrictions/2024-11-04/1730783287'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcustom_fields_restrictions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcustom_fields_restrictions/2024-11-04/1730783287
id: 4740154
processed: 1

raw_data:

{
    "custom_field_id": 3,
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "custom_field_id": "string",
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2577
schema_scan_id: 6665371
updated: 2024-11-05 01:10:03

Version 4739464

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcustom_fields_restrictions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcustom_fields_restrictions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `custom_field_id`  string , `for`  string , `for_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_newbookcustom_fields_restrictions/2024-11-04/1730782889'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcustom_fields_restrictions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcustom_fields_restrictions/2024-11-04/1730782889
id: 4739464
processed: 1

raw_data:

{
    "custom_field_id": 3,
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "custom_field_id": "string",
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2577
schema_scan_id: 6664679
updated: 2024-11-05 00:51:32

Version 4738496

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcustom_fields_restrictions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcustom_fields_restrictions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `custom_field_id`  string , `for`  string , `for_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_newbookcustom_fields_restrictions/2024-11-04/1730782746'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcustom_fields_restrictions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcustom_fields_restrictions/2024-11-04/1730782746
id: 4738496
processed: 1

raw_data:

{
    "custom_field_id": 3,
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "tenant": 1
}

schema_attributes:

{
    "custom_field_id": "string",
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

schema_name_id: 2577
schema_scan_id: 6663707
updated: 2024-11-05 00:26:07

Schema Scans: 15

Last at 2024-11-05 22:53:33

Scan 6674647

duration: 0:00:11.457720

exit_message:

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

id: 6674647

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_newbookcustom_fields_restrictions/2024-11-05/1730866455",
        "key": "raw/newbookdev_newbookcustom_fields_restrictions/2024-11-05/1730866455/custom_fields_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8748809368188435690,
        "service_name": "drive-thru",
        "span_id": 17068390121074399369,
        "trace_id": 12679666006567022191
    }
}

running: False
schema_name_id: 2577
start_time: 2024-11-05 22:53:33
success: True
trace_id: 12679666006567022191

Scan 6674138

duration: 0:00:11.498407

exit_message:

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

id: 6674138

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_newbookcustom_fields_restrictions/2024-11-05/1730866369",
        "key": "raw/newbookdev_newbookcustom_fields_restrictions/2024-11-05/1730866369/custom_fields_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8366039069830079582,
        "service_name": "drive-thru",
        "span_id": 17799322177375083848,
        "trace_id": 13497814320032712720
    }
}

running: False
schema_name_id: 2577
start_time: 2024-11-05 22:35:02
success: True
trace_id: 13497814320032712720

Scan 6673624

duration: 0:00:11.302656

exit_message:

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

id: 6673624

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_newbookcustom_fields_restrictions/2024-11-05/1730866270",
        "key": "raw/newbookdev_newbookcustom_fields_restrictions/2024-11-05/1730866270/custom_fields_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18187967214353800778,
        "service_name": "drive-thru",
        "span_id": 10327126680723804297,
        "trace_id": 14225575118921357025
    }
}

running: False
schema_name_id: 2577
start_time: 2024-11-05 22:20:52
success: True
trace_id: 14225575118921357025

Scan 6672267

duration: 0:00:11.494490

exit_message:

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

id: 6672267

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_newbookcustom_fields_restrictions/2024-11-04/1730785691",
        "key": "raw/newbookdev_newbookcustom_fields_restrictions/2024-11-04/1730785691/custom_fields_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8795714144594968503,
        "service_name": "drive-thru",
        "span_id": 7855110446011054804,
        "trace_id": 5166665484623289506
    }
}

running: False
schema_name_id: 2577
start_time: 2024-11-05 04:43:21
success: True
trace_id: 5166665484623289506

Scan 6670596

duration: 0:00:11.379467

exit_message:

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

id: 6670596

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_newbookcustom_fields_restrictions/2024-11-04/1730785107",
        "key": "raw/newbookdev_newbookcustom_fields_restrictions/2024-11-04/1730785107/custom_fields_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12672016586816405403,
        "service_name": "drive-thru",
        "span_id": 8918481679406683836,
        "trace_id": 4561443592852176903
    }
}

running: False
schema_name_id: 2577
start_time: 2024-11-05 03:27:50
success: True
trace_id: 4561443592852176903

Scan 6670480

duration: 0:00:11.350524

exit_message:

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

id: 6670480

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_newbookcustom_fields_restrictions/2024-11-04/1730784802",
        "key": "raw/newbookdev_newbookcustom_fields_restrictions/2024-11-04/1730784802/custom_fields_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7544292838650266919,
        "service_name": "drive-thru",
        "span_id": 13346442584241884472,
        "trace_id": 10751651081555314715
    }
}

running: False
schema_name_id: 2577
start_time: 2024-11-05 03:24:54
success: True
trace_id: 10751651081555314715

Scan 6669855

duration: 0:00:13.897224

exit_message:

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

id: 6669855

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_newbookcustom_fields_restrictions/2024-11-04/1730784199",
        "key": "raw/newbookdev_newbookcustom_fields_restrictions/2024-11-04/1730784199/custom_fields_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7880548334464441776,
        "service_name": "drive-thru",
        "span_id": 10746537241221073653,
        "trace_id": 4050991460115097296
    }
}

running: False
schema_name_id: 2577
start_time: 2024-11-05 03:08:26
success: True
trace_id: 4050991460115097296

Scan 6669347

duration: 0:00:11.435119

exit_message:

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

id: 6669347

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_newbookcustom_fields_restrictions/2024-11-04/1730784036",
        "key": "raw/newbookdev_newbookcustom_fields_restrictions/2024-11-04/1730784036/custom_fields_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5194467485733109400,
        "service_name": "drive-thru",
        "span_id": 14600101277973389024,
        "trace_id": 12346928999153708084
    }
}

running: False
schema_name_id: 2577
start_time: 2024-11-05 02:54:47
success: True
trace_id: 12346928999153708084

Scan 6668650

duration: 0:00:11.304477

exit_message:

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

id: 6668650

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_newbookcustom_fields_restrictions/2024-11-04/1730783886",
        "key": "raw/newbookdev_newbookcustom_fields_restrictions/2024-11-04/1730783886/custom_fields_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7942896411190119113,
        "service_name": "drive-thru",
        "span_id": 14309250140360227064,
        "trace_id": 680450989803566110
    }
}

running: False
schema_name_id: 2577
start_time: 2024-11-05 02:36:29
success: True
trace_id: 680450989803566110

Scan 6667549

duration: 0:00:13.937085

exit_message:

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

id: 6667549

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_newbookcustom_fields_restrictions/2024-11-04/1730783750",
        "key": "raw/newbookdev_newbookcustom_fields_restrictions/2024-11-04/1730783750/custom_fields_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14730589413237252601,
        "service_name": "drive-thru",
        "span_id": 11525292266200512147,
        "trace_id": 3414273555352981726
    }
}

running: False
schema_name_id: 2577
start_time: 2024-11-05 02:07:24
success: True
trace_id: 3414273555352981726

Scan 6667047

duration: 0:00:11.459851

exit_message:

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

id: 6667047

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_newbookcustom_fields_restrictions/2024-11-04/1730783651",
        "key": "raw/newbookdev_newbookcustom_fields_restrictions/2024-11-04/1730783651/custom_fields_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11463613062198881938,
        "service_name": "drive-thru",
        "span_id": 2145970150195594844,
        "trace_id": 13362976472171470394
    }
}

running: False
schema_name_id: 2577
start_time: 2024-11-05 01:53:55
success: True
trace_id: 13362976472171470394

Scan 6666115

duration: 0:00:11.365002

exit_message:

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

id: 6666115

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_newbookcustom_fields_restrictions/2024-11-04/1730783505",
        "key": "raw/newbookdev_newbookcustom_fields_restrictions/2024-11-04/1730783505/custom_fields_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14975797782133362957,
        "service_name": "drive-thru",
        "span_id": 3494360612488676955,
        "trace_id": 399855180927355294
    }
}

running: False
schema_name_id: 2577
start_time: 2024-11-05 01:29:23
success: True
trace_id: 399855180927355294

Scan 6665371

duration: 0:00:13.868413

exit_message:

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

id: 6665371

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_newbookcustom_fields_restrictions/2024-11-04/1730783287",
        "key": "raw/newbookdev_newbookcustom_fields_restrictions/2024-11-04/1730783287/custom_fields_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1381112207376773292,
        "service_name": "drive-thru",
        "span_id": 18091322284321670999,
        "trace_id": 11102030117557257793
    }
}

running: False
schema_name_id: 2577
start_time: 2024-11-05 01:09:49
success: True
trace_id: 11102030117557257793

Scan 6664679

duration: 0:00:13.953712

exit_message:

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

id: 6664679

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_newbookcustom_fields_restrictions/2024-11-04/1730782889",
        "key": "raw/newbookdev_newbookcustom_fields_restrictions/2024-11-04/1730782889/custom_fields_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13961784498169058166,
        "service_name": "drive-thru",
        "span_id": 17950135632386273477,
        "trace_id": 6100097398954303860
    }
}

running: False
schema_name_id: 2577
start_time: 2024-11-05 00:51:18
success: True
trace_id: 6100097398954303860

Scan 6663707

duration: 0:00:11.384906

exit_message:

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

id: 6663707

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_newbookcustom_fields_restrictions/2024-11-04/1730782746",
        "key": "raw/newbookdev_newbookcustom_fields_restrictions/2024-11-04/1730782746/custom_fields_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookcustom_fields_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3826582882033528057,
        "service_name": "drive-thru",
        "span_id": 7350153370791686355,
        "trace_id": 10959094241268782424
    }
}

running: False
schema_name_id: 2577
start_time: 2024-11-05 00:25:56
success: True
trace_id: 10959094241268782424

Partitions:

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

Schema:

attributes:

{
    "custom_field_id": "string",
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "tenant": "string"
}

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

ddl:

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

Server:

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

Raw:

{
    "name": {
        "created": "2024-10-08 17:49:07",
        "disabled": false,
        "format": "raw",
        "id": 2577,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "newbookdev_newbookcustom_fields_restrictions"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "custom_field_id": "string",
            "for": "string",
            "for_id": "string",
            "id": "string",
            "newbook_region": "string",
            "tenant": "string"
        },
        "created": "2024-11-05 22:53:33",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcustom_fields_restrictions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `custom_field_id`  string , `for`  string , `for_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_newbookcustom_fields_restrictions/2024-11-05/1730866455'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcustom_fields_restrictions`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcustom_fields_restrictions"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}