Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbooktranslation_templates_instance_type_link

created: 2024-10-08 18:28:55
disabled: False
format: raw
id: 2997
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4749402

created: 2024-11-05 23:46:48

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktranslation_templates_instance_type_link/2024-11-05/1730866584
id: 4749402
processed: 1

raw_data:

{
    "id": 2,
    "instance_type_id": 4,
    "newbook_region": 0,
    "template_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "id": "string",
    "instance_type_id": "string",
    "newbook_region": "string",
    "template_id": "string",
    "tenant": "string"
}

schema_name_id: 2997
schema_scan_id: 6675440
updated: 2024-11-05 23:47:01

Version 4749350

created: 2024-11-05 23:41:14

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktranslation_templates_instance_type_link/2024-11-05/1730866625
id: 4749350
processed: 1

raw_data:

{
    "id": 2,
    "instance_type_id": 4,
    "newbook_region": 0,
    "template_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "id": "string",
    "instance_type_id": "string",
    "newbook_region": "string",
    "template_id": "string",
    "tenant": "string"
}

schema_name_id: 2997
schema_scan_id: 6675383
updated: 2024-11-05 23:41:25

Version 4748653

created: 2024-11-05 22:55:09

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktranslation_templates_instance_type_link/2024-11-05/1730866487
id: 4748653
processed: 1

raw_data:

{
    "id": 2,
    "instance_type_id": 4,
    "newbook_region": 0,
    "template_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "id": "string",
    "instance_type_id": "string",
    "newbook_region": "string",
    "template_id": "string",
    "tenant": "string"
}

schema_name_id: 2997
schema_scan_id: 6674685
updated: 2024-11-05 22:55:22

Version 4747255

created: 2024-11-05 05:07:54

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktranslation_templates_instance_type_link/2024-11-04/1730785824
id: 4747255
processed: 1

raw_data:

{
    "id": 2,
    "instance_type_id": 4,
    "newbook_region": 0,
    "template_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "id": "string",
    "instance_type_id": "string",
    "newbook_region": "string",
    "template_id": "string",
    "tenant": "string"
}

schema_name_id: 2997
schema_scan_id: 6672525
updated: 2024-11-05 05:08:07

Version 4745850

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktranslation_templates_instance_type_link/2024-11-04/1730785182
id: 4745850
processed: 1

raw_data:

{
    "id": 2,
    "instance_type_id": 4,
    "newbook_region": 0,
    "template_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "id": "string",
    "instance_type_id": "string",
    "newbook_region": "string",
    "template_id": "string",
    "tenant": "string"
}

schema_name_id: 2997
schema_scan_id: 6671067
updated: 2024-11-05 03:41:03

Version 4745585

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktranslation_templates_instance_type_link/2024-11-04/1730784273
id: 4745585
processed: 1

raw_data:

{
    "id": 2,
    "instance_type_id": 4,
    "newbook_region": 0,
    "template_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "id": "string",
    "instance_type_id": "string",
    "newbook_region": "string",
    "template_id": "string",
    "tenant": "string"
}

schema_name_id: 2997
schema_scan_id: 6670802
updated: 2024-11-05 03:33:31

Version 4745112

created: 2024-11-05 03:20:59

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktranslation_templates_instance_type_link/2024-11-04/1730784876
id: 4745112
processed: 1

raw_data:

{
    "id": 2,
    "instance_type_id": 4,
    "newbook_region": 0,
    "template_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "id": "string",
    "instance_type_id": "string",
    "newbook_region": "string",
    "template_id": "string",
    "tenant": "string"
}

schema_name_id: 2997
schema_scan_id: 6670330
updated: 2024-11-05 03:21:10

Version 4744794

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktranslation_templates_instance_type_link/2024-11-04/1730784111
id: 4744794
processed: 1

raw_data:

{
    "id": 2,
    "instance_type_id": 4,
    "newbook_region": 0,
    "template_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "id": "string",
    "instance_type_id": "string",
    "newbook_region": "string",
    "template_id": "string",
    "tenant": "string"
}

schema_name_id: 2997
schema_scan_id: 6670011
updated: 2024-11-05 03:12:46

Version 4743834

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktranslation_templates_instance_type_link/2024-11-04/1730783942
id: 4743834
processed: 1

raw_data:

{
    "id": 2,
    "instance_type_id": 4,
    "newbook_region": 0,
    "template_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "id": "string",
    "instance_type_id": "string",
    "newbook_region": "string",
    "template_id": "string",
    "tenant": "string"
}

schema_name_id: 2997
schema_scan_id: 6669051
updated: 2024-11-05 02:47:17

Version 4742901

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktranslation_templates_instance_type_link/2024-11-04/1730783825
id: 4742901
processed: 1

raw_data:

{
    "id": 2,
    "instance_type_id": 4,
    "newbook_region": 0,
    "template_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "id": "string",
    "instance_type_id": "string",
    "newbook_region": "string",
    "template_id": "string",
    "tenant": "string"
}

schema_name_id: 2997
schema_scan_id: 6668119
updated: 2024-11-05 02:22:35

Version 4741704

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktranslation_templates_instance_type_link/2024-11-04/1730783709
id: 4741704
processed: 1

raw_data:

{
    "id": 2,
    "instance_type_id": 4,
    "newbook_region": 0,
    "template_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "id": "string",
    "instance_type_id": "string",
    "newbook_region": "string",
    "template_id": "string",
    "tenant": "string"
}

schema_name_id: 2997
schema_scan_id: 6666921
updated: 2024-11-05 01:50:44

Version 4741572

created: 2024-11-05 01:47:05

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktranslation_templates_instance_type_link/2024-11-04/1730783582
id: 4741572
processed: 1

raw_data:

{
    "id": 2,
    "instance_type_id": 4,
    "newbook_region": 0,
    "template_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "id": "string",
    "instance_type_id": "string",
    "newbook_region": "string",
    "template_id": "string",
    "tenant": "string"
}

schema_name_id: 2997
schema_scan_id: 6666789
updated: 2024-11-05 01:47:16

Version 4740722

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktranslation_templates_instance_type_link/2024-11-04/1730783363
id: 4740722
processed: 1

raw_data:

{
    "id": 2,
    "instance_type_id": 4,
    "newbook_region": 0,
    "template_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "id": "string",
    "instance_type_id": "string",
    "newbook_region": "string",
    "template_id": "string",
    "tenant": "string"
}

schema_name_id: 2997
schema_scan_id: 6665939
updated: 2024-11-05 01:25:01

Version 4739910

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktranslation_templates_instance_type_link/2024-11-04/1730782964
id: 4739910
processed: 1

raw_data:

{
    "id": 2,
    "instance_type_id": 4,
    "newbook_region": 0,
    "template_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "id": "string",
    "instance_type_id": "string",
    "newbook_region": "string",
    "template_id": "string",
    "tenant": "string"
}

schema_name_id: 2997
schema_scan_id: 6665128
updated: 2024-11-05 01:03:28

Version 4739204

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktranslation_templates_instance_type_link/2024-11-04/1730782848
id: 4739204
processed: 1

raw_data:

{
    "id": 2,
    "instance_type_id": 4,
    "newbook_region": 0,
    "template_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "id": "string",
    "instance_type_id": "string",
    "newbook_region": "string",
    "template_id": "string",
    "tenant": "string"
}

schema_name_id: 2997
schema_scan_id: 6664419
updated: 2024-11-05 00:44:44

Schema Scans: 15

Last at 2024-11-05 23:46:47

Scan 6675440

duration: 0:00:13.985753

exit_message:

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

id: 6675440

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_newbooktranslation_templates_instance_type_link/2024-11-05/1730866584",
        "key": "raw/newbookdev_newbooktranslation_templates_instance_type_link/2024-11-05/1730866584/translation_templates_instance_type_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktranslation_templates_instance_type_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17061615904706462384,
        "service_name": "drive-thru",
        "span_id": 89933117406350174,
        "trace_id": 697758619218869032
    }
}

running: False
schema_name_id: 2997
start_time: 2024-11-05 23:46:47
success: True
trace_id: 697758619218869032

Scan 6675383

duration: 0:00:11.469061

exit_message:

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

id: 6675383

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_newbooktranslation_templates_instance_type_link/2024-11-05/1730866625",
        "key": "raw/newbookdev_newbooktranslation_templates_instance_type_link/2024-11-05/1730866625/translation_templates_instance_type_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktranslation_templates_instance_type_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4449357920045449763,
        "service_name": "drive-thru",
        "span_id": 6360070303426421710,
        "trace_id": 4894863261136793740
    }
}

running: False
schema_name_id: 2997
start_time: 2024-11-05 23:41:14
success: True
trace_id: 4894863261136793740

Scan 6674685

duration: 0:00:13.998971

exit_message:

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

id: 6674685

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_newbooktranslation_templates_instance_type_link/2024-11-05/1730866487",
        "key": "raw/newbookdev_newbooktranslation_templates_instance_type_link/2024-11-05/1730866487/translation_templates_instance_type_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktranslation_templates_instance_type_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12243474003169041509,
        "service_name": "drive-thru",
        "span_id": 13938980206396688881,
        "trace_id": 5961172461693345894
    }
}

running: False
schema_name_id: 2997
start_time: 2024-11-05 22:55:08
success: True
trace_id: 5961172461693345894

Scan 6672525

duration: 0:00:14.053302

exit_message:

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

id: 6672525

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_newbooktranslation_templates_instance_type_link/2024-11-04/1730785824",
        "key": "raw/newbookdev_newbooktranslation_templates_instance_type_link/2024-11-04/1730785824/translation_templates_instance_type_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktranslation_templates_instance_type_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 424395638702138045,
        "service_name": "drive-thru",
        "span_id": 9491885336487882902,
        "trace_id": 12871062913270830390
    }
}

running: False
schema_name_id: 2997
start_time: 2024-11-05 05:07:53
success: True
trace_id: 12871062913270830390

Scan 6671067

duration: 0:00:11.604169

exit_message:

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

id: 6671067

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_newbooktranslation_templates_instance_type_link/2024-11-04/1730785182",
        "key": "raw/newbookdev_newbooktranslation_templates_instance_type_link/2024-11-04/1730785182/translation_templates_instance_type_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktranslation_templates_instance_type_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16023351184004031303,
        "service_name": "drive-thru",
        "span_id": 2049945742150621610,
        "trace_id": 6962307370667317063
    }
}

running: False
schema_name_id: 2997
start_time: 2024-11-05 03:40:51
success: True
trace_id: 6962307370667317063

Scan 6670802

duration: 0:00:11.149402

exit_message:

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

id: 6670802

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_newbooktranslation_templates_instance_type_link/2024-11-04/1730784273",
        "key": "raw/newbookdev_newbooktranslation_templates_instance_type_link/2024-11-04/1730784273/translation_templates_instance_type_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktranslation_templates_instance_type_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3172689890650189544,
        "service_name": "drive-thru",
        "span_id": 18344703732898037114,
        "trace_id": 9931709883121127942
    }
}

running: False
schema_name_id: 2997
start_time: 2024-11-05 03:33:20
success: True
trace_id: 9931709883121127942

Scan 6670330

duration: 0:00:11.320562

exit_message:

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

id: 6670330

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_newbooktranslation_templates_instance_type_link/2024-11-04/1730784876",
        "key": "raw/newbookdev_newbooktranslation_templates_instance_type_link/2024-11-04/1730784876/translation_templates_instance_type_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktranslation_templates_instance_type_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1259580268294155191,
        "service_name": "drive-thru",
        "span_id": 4762109180370722402,
        "trace_id": 14843805619424692272
    }
}

running: False
schema_name_id: 2997
start_time: 2024-11-05 03:20:59
success: True
trace_id: 14843805619424692272

Scan 6670011

duration: 0:00:13.873947

exit_message:

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

id: 6670011

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_newbooktranslation_templates_instance_type_link/2024-11-04/1730784111",
        "key": "raw/newbookdev_newbooktranslation_templates_instance_type_link/2024-11-04/1730784111/translation_templates_instance_type_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktranslation_templates_instance_type_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16412026631880070961,
        "service_name": "drive-thru",
        "span_id": 18344665848965577780,
        "trace_id": 4962980931764046378
    }
}

running: False
schema_name_id: 2997
start_time: 2024-11-05 03:12:32
success: True
trace_id: 4962980931764046378

Scan 6669051

duration: 0:00:11.438302

exit_message:

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

id: 6669051

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_newbooktranslation_templates_instance_type_link/2024-11-04/1730783942",
        "key": "raw/newbookdev_newbooktranslation_templates_instance_type_link/2024-11-04/1730783942/translation_templates_instance_type_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktranslation_templates_instance_type_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1773912232906103061,
        "service_name": "drive-thru",
        "span_id": 4114797587747515820,
        "trace_id": 11938478569026310946
    }
}

running: False
schema_name_id: 2997
start_time: 2024-11-05 02:47:05
success: True
trace_id: 11938478569026310946

Scan 6668119

duration: 0:00:11.443732

exit_message:

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

id: 6668119

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_newbooktranslation_templates_instance_type_link/2024-11-04/1730783825",
        "key": "raw/newbookdev_newbooktranslation_templates_instance_type_link/2024-11-04/1730783825/translation_templates_instance_type_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktranslation_templates_instance_type_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7402505410306128489,
        "service_name": "drive-thru",
        "span_id": 182224732789992701,
        "trace_id": 11103488725252157168
    }
}

running: False
schema_name_id: 2997
start_time: 2024-11-05 02:22:24
success: True
trace_id: 11103488725252157168

Scan 6666921

duration: 0:00:11.273737

exit_message:

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

id: 6666921

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_newbooktranslation_templates_instance_type_link/2024-11-04/1730783709",
        "key": "raw/newbookdev_newbooktranslation_templates_instance_type_link/2024-11-04/1730783709/translation_templates_instance_type_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktranslation_templates_instance_type_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13457241520906179728,
        "service_name": "drive-thru",
        "span_id": 1202250178060511526,
        "trace_id": 16051382152698343160
    }
}

running: False
schema_name_id: 2997
start_time: 2024-11-05 01:50:33
success: True
trace_id: 16051382152698343160

Scan 6666789

duration: 0:00:11.321837

exit_message:

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

id: 6666789

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_newbooktranslation_templates_instance_type_link/2024-11-04/1730783582",
        "key": "raw/newbookdev_newbooktranslation_templates_instance_type_link/2024-11-04/1730783582/translation_templates_instance_type_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktranslation_templates_instance_type_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11925044867227859375,
        "service_name": "drive-thru",
        "span_id": 3281606668149611676,
        "trace_id": 875438027188738101
    }
}

running: False
schema_name_id: 2997
start_time: 2024-11-05 01:47:04
success: True
trace_id: 875438027188738101

Scan 6665939

duration: 0:00:13.816645

exit_message:

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

id: 6665939

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_newbooktranslation_templates_instance_type_link/2024-11-04/1730783363",
        "key": "raw/newbookdev_newbooktranslation_templates_instance_type_link/2024-11-04/1730783363/translation_templates_instance_type_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktranslation_templates_instance_type_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14011039045980306136,
        "service_name": "drive-thru",
        "span_id": 13559133728454213279,
        "trace_id": 8847863680520716821
    }
}

running: False
schema_name_id: 2997
start_time: 2024-11-05 01:24:47
success: True
trace_id: 8847863680520716821

Scan 6665128

duration: 0:00:11.308293

exit_message:

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

id: 6665128

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_newbooktranslation_templates_instance_type_link/2024-11-04/1730782964",
        "key": "raw/newbookdev_newbooktranslation_templates_instance_type_link/2024-11-04/1730782964/translation_templates_instance_type_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktranslation_templates_instance_type_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7664583509884028192,
        "service_name": "drive-thru",
        "span_id": 4993383033823708538,
        "trace_id": 16856181321774504946
    }
}

running: False
schema_name_id: 2997
start_time: 2024-11-05 01:03:16
success: True
trace_id: 16856181321774504946

Scan 6664419

duration: 0:00:13.920628

exit_message:

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

id: 6664419

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_newbooktranslation_templates_instance_type_link/2024-11-04/1730782848",
        "key": "raw/newbookdev_newbooktranslation_templates_instance_type_link/2024-11-04/1730782848/translation_templates_instance_type_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktranslation_templates_instance_type_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5555360543743613839,
        "service_name": "drive-thru",
        "span_id": 13460726959642343498,
        "trace_id": 5587206235899591862
    }
}

running: False
schema_name_id: 2997
start_time: 2024-11-05 00:44:30
success: True
trace_id: 5587206235899591862

Partitions:

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

Schema:

attributes:

{
    "id": "string",
    "instance_type_id": "string",
    "newbook_region": "string",
    "template_id": "string",
    "tenant": "string"
}

created: 2024-11-05 23:46:48

ddl:

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