Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_default_housekeepers

created: 2024-10-08 17:35:37
disabled: False
format: raw
id: 2394
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4747865

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_default_housekeepers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_default_housekeepers`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `site_id`  string , `created_on`  string , `active`  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_newbookaccommodation_sites_default_housekeepers/2024-11-05/1730866351'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_default_housekeepers"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_sites_default_housekeepers/2024-11-05/1730866351
id: 4747865
processed: 1

raw_data:

{
    "active": 6,
    "created_on": 5,
    "id": 2,
    "newbook_region": 0,
    "site_id": 4,
    "tenant": 1,
    "user_id": 3
}

schema_attributes:

{
    "active": "string",
    "created_on": "string",
    "id": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 2394
schema_scan_id: 6673898
updated: 2024-11-05 22:28:15

Version 4747680

created: 2024-11-05 22:23:10

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_default_housekeepers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_default_housekeepers`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `site_id`  string , `created_on`  string , `active`  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_newbookaccommodation_sites_default_housekeepers/2024-11-05/1730866288'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_default_housekeepers"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_sites_default_housekeepers/2024-11-05/1730866288
id: 4747680
processed: 1

raw_data:

{
    "active": 6,
    "created_on": 5,
    "id": 2,
    "newbook_region": 0,
    "site_id": 4,
    "tenant": 1,
    "user_id": 3
}

schema_attributes:

{
    "active": "string",
    "created_on": "string",
    "id": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 2394
schema_scan_id: 6673712
updated: 2024-11-05 22:23:21

Version 4747344

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_default_housekeepers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_default_housekeepers`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `site_id`  string , `created_on`  string , `active`  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_newbookaccommodation_sites_default_housekeepers/2024-11-05/1730866223'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_default_housekeepers"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_sites_default_housekeepers/2024-11-05/1730866223
id: 4747344
processed: 1

raw_data:

{
    "active": 6,
    "created_on": 5,
    "id": 2,
    "newbook_region": 0,
    "site_id": 4,
    "tenant": 1,
    "user_id": 3
}

schema_attributes:

{
    "active": "string",
    "created_on": "string",
    "id": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 2394
schema_scan_id: 6673376
updated: 2024-11-05 22:12:14

Version 4746798

created: 2024-11-05 04:23:55

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_default_housekeepers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_default_housekeepers`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `site_id`  string , `created_on`  string , `active`  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_newbookaccommodation_sites_default_housekeepers/2024-11-04/1730785641'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_default_housekeepers"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_sites_default_housekeepers/2024-11-04/1730785641
id: 4746798
processed: 1

raw_data:

{
    "active": 6,
    "created_on": 5,
    "id": 2,
    "newbook_region": 0,
    "site_id": 4,
    "tenant": 1,
    "user_id": 3
}

schema_attributes:

{
    "active": "string",
    "created_on": "string",
    "id": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 2394
schema_scan_id: 6672027
updated: 2024-11-05 04:24:08

Version 4745890

created: 2024-11-05 03:42:06

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_default_housekeepers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_default_housekeepers`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `site_id`  string , `created_on`  string , `active`  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_newbookaccommodation_sites_default_housekeepers/2024-11-04/1730785077'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_default_housekeepers"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_sites_default_housekeepers/2024-11-04/1730785077
id: 4745890
processed: 1

raw_data:

{
    "active": 6,
    "created_on": 5,
    "id": 2,
    "newbook_region": 0,
    "site_id": 4,
    "tenant": 1,
    "user_id": 3
}

schema_attributes:

{
    "active": "string",
    "created_on": "string",
    "id": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 2394
schema_scan_id: 6671107
updated: 2024-11-05 03:42:19

Version 4745019

created: 2024-11-05 03:18:30

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_default_housekeepers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_default_housekeepers`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `site_id`  string , `created_on`  string , `active`  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_newbookaccommodation_sites_default_housekeepers/2024-11-04/1730784771'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_default_housekeepers"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_sites_default_housekeepers/2024-11-04/1730784771
id: 4745019
processed: 1

raw_data:

{
    "active": 6,
    "created_on": 5,
    "id": 2,
    "newbook_region": 0,
    "site_id": 4,
    "tenant": 1,
    "user_id": 3
}

schema_attributes:

{
    "active": "string",
    "created_on": "string",
    "id": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 2394
schema_scan_id: 6670236
updated: 2024-11-05 03:18:41

Version 4744857

created: 2024-11-05 03:14:10

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_default_housekeepers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_default_housekeepers`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `site_id`  string , `created_on`  string , `active`  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_newbookaccommodation_sites_default_housekeepers/2024-11-04/1730784168'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_default_housekeepers"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_sites_default_housekeepers/2024-11-04/1730784168
id: 4744857
processed: 1

raw_data:

{
    "active": 6,
    "created_on": 5,
    "id": 2,
    "newbook_region": 0,
    "site_id": 4,
    "tenant": 1,
    "user_id": 3
}

schema_attributes:

{
    "active": "string",
    "created_on": "string",
    "id": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 2394
schema_scan_id: 6670074
updated: 2024-11-05 03:14:21

Version 4743148

created: 2024-11-05 02:28:53

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_default_housekeepers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_default_housekeepers`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `site_id`  string , `created_on`  string , `active`  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_newbookaccommodation_sites_default_housekeepers/2024-11-04/1730783862'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_default_housekeepers"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_sites_default_housekeepers/2024-11-04/1730783862
id: 4743148
processed: 1

raw_data:

{
    "active": 6,
    "created_on": 5,
    "id": 2,
    "newbook_region": 0,
    "site_id": 4,
    "tenant": 1,
    "user_id": 3
}

schema_attributes:

{
    "active": "string",
    "created_on": "string",
    "id": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 2394
schema_scan_id: 6668365
updated: 2024-11-05 02:29:04

Version 4743021

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_default_housekeepers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_default_housekeepers`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `site_id`  string , `created_on`  string , `active`  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_newbookaccommodation_sites_default_housekeepers/2024-11-04/1730784006'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_default_housekeepers"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_sites_default_housekeepers/2024-11-04/1730784006
id: 4743021
processed: 1

raw_data:

{
    "active": 6,
    "created_on": 5,
    "id": 2,
    "newbook_region": 0,
    "site_id": 4,
    "tenant": 1,
    "user_id": 3
}

schema_attributes:

{
    "active": "string",
    "created_on": "string",
    "id": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 2394
schema_scan_id: 6668238
updated: 2024-11-05 02:25:45

Version 4742371

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_default_housekeepers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_default_housekeepers`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `site_id`  string , `created_on`  string , `active`  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_newbookaccommodation_sites_default_housekeepers/2024-11-04/1730783718'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_default_housekeepers"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_sites_default_housekeepers/2024-11-04/1730783718
id: 4742371
processed: 1

raw_data:

{
    "active": 6,
    "created_on": 5,
    "id": 2,
    "newbook_region": 0,
    "site_id": 4,
    "tenant": 1,
    "user_id": 3
}

schema_attributes:

{
    "active": "string",
    "created_on": "string",
    "id": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 2394
schema_scan_id: 6667588
updated: 2024-11-05 02:08:41

Version 4741119

created: 2024-11-05 01:35:20

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_default_housekeepers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_default_housekeepers`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `site_id`  string , `created_on`  string , `active`  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_newbookaccommodation_sites_default_housekeepers/2024-11-04/1730783628'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_default_housekeepers"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_sites_default_housekeepers/2024-11-04/1730783628
id: 4741119
processed: 1

raw_data:

{
    "active": 6,
    "created_on": 5,
    "id": 2,
    "newbook_region": 0,
    "site_id": 4,
    "tenant": 1,
    "user_id": 3
}

schema_attributes:

{
    "active": "string",
    "created_on": "string",
    "id": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 2394
schema_scan_id: 6666336
updated: 2024-11-05 01:35:31

Version 4740866

created: 2024-11-05 01:28:35

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_default_housekeepers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_default_housekeepers`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `site_id`  string , `created_on`  string , `active`  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_newbookaccommodation_sites_default_housekeepers/2024-11-04/1730783474'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_default_housekeepers"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_sites_default_housekeepers/2024-11-04/1730783474
id: 4740866
processed: 1

raw_data:

{
    "active": 6,
    "created_on": 5,
    "id": 2,
    "newbook_region": 0,
    "site_id": 4,
    "tenant": 1,
    "user_id": 3
}

schema_attributes:

{
    "active": "string",
    "created_on": "string",
    "id": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 2394
schema_scan_id: 6666083
updated: 2024-11-05 01:28:46

Version 4739968

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_default_housekeepers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_default_housekeepers`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `site_id`  string , `created_on`  string , `active`  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_newbookaccommodation_sites_default_housekeepers/2024-11-04/1730783256'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_default_housekeepers"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_sites_default_housekeepers/2024-11-04/1730783256
id: 4739968
processed: 1

raw_data:

{
    "active": 6,
    "created_on": 5,
    "id": 2,
    "newbook_region": 0,
    "site_id": 4,
    "tenant": 1,
    "user_id": 3
}

schema_attributes:

{
    "active": "string",
    "created_on": "string",
    "id": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 2394
schema_scan_id: 6665185
updated: 2024-11-05 01:05:02

Version 4739033

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_default_housekeepers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_default_housekeepers`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `site_id`  string , `created_on`  string , `active`  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_newbookaccommodation_sites_default_housekeepers/2024-11-04/1730782858'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_default_housekeepers"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_sites_default_housekeepers/2024-11-04/1730782858
id: 4739033
processed: 1

raw_data:

{
    "active": 6,
    "created_on": 5,
    "id": 2,
    "newbook_region": 0,
    "site_id": 4,
    "tenant": 1,
    "user_id": 3
}

schema_attributes:

{
    "active": "string",
    "created_on": "string",
    "id": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 2394
schema_scan_id: 6664248
updated: 2024-11-05 00:40:15

Version 4738588

created: 2024-11-05 00:28:21

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_default_housekeepers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_default_housekeepers`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `site_id`  string , `created_on`  string , `active`  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_newbookaccommodation_sites_default_housekeepers/2024-11-04/1730782769'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_default_housekeepers"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_sites_default_housekeepers/2024-11-04/1730782769
id: 4738588
processed: 1

raw_data:

{
    "active": 6,
    "created_on": 5,
    "id": 2,
    "newbook_region": 0,
    "site_id": 4,
    "tenant": 1,
    "user_id": 3
}

schema_attributes:

{
    "active": "string",
    "created_on": "string",
    "id": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 2394
schema_scan_id: 6663801
updated: 2024-11-05 00:28:31

Schema Scans: 15

Last at 2024-11-05 22:28:01

Scan 6673898

duration: 0:00:13.831348

exit_message:

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

id: 6673898

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_newbookaccommodation_sites_default_housekeepers/2024-11-05/1730866351",
        "key": "raw/newbookdev_newbookaccommodation_sites_default_housekeepers/2024-11-05/1730866351/accommodation_sites_default_housekeepers.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_default_housekeepers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7506902394870450683,
        "service_name": "drive-thru",
        "span_id": 1068548049368921780,
        "trace_id": 12219285049313135772
    }
}

running: False
schema_name_id: 2394
start_time: 2024-11-05 22:28:01
success: True
trace_id: 12219285049313135772

Scan 6673712

duration: 0:00:11.481422

exit_message:

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

id: 6673712

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_newbookaccommodation_sites_default_housekeepers/2024-11-05/1730866288",
        "key": "raw/newbookdev_newbookaccommodation_sites_default_housekeepers/2024-11-05/1730866288/accommodation_sites_default_housekeepers.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_default_housekeepers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3382843778201465545,
        "service_name": "drive-thru",
        "span_id": 2924835895883485706,
        "trace_id": 10813779320871960485
    }
}

running: False
schema_name_id: 2394
start_time: 2024-11-05 22:23:09
success: True
trace_id: 10813779320871960485

Scan 6673376

duration: 0:00:11.508974

exit_message:

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

id: 6673376

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_newbookaccommodation_sites_default_housekeepers/2024-11-05/1730866223",
        "key": "raw/newbookdev_newbookaccommodation_sites_default_housekeepers/2024-11-05/1730866223/accommodation_sites_default_housekeepers.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_default_housekeepers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5167733880000993885,
        "service_name": "drive-thru",
        "span_id": 1371517659821330802,
        "trace_id": 14378018229098287241
    }
}

running: False
schema_name_id: 2394
start_time: 2024-11-05 22:12:03
success: True
trace_id: 14378018229098287241

Scan 6672027

duration: 0:00:14.090018

exit_message:

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

id: 6672027

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_newbookaccommodation_sites_default_housekeepers/2024-11-04/1730785641",
        "key": "raw/newbookdev_newbookaccommodation_sites_default_housekeepers/2024-11-04/1730785641/accommodation_sites_default_housekeepers.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_default_housekeepers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11878387950245133643,
        "service_name": "drive-thru",
        "span_id": 3772971325952543103,
        "trace_id": 3328215493036931265
    }
}

running: False
schema_name_id: 2394
start_time: 2024-11-05 04:23:54
success: True
trace_id: 3328215493036931265

Scan 6671107

duration: 0:00:14.021993

exit_message:

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

id: 6671107

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_newbookaccommodation_sites_default_housekeepers/2024-11-04/1730785077",
        "key": "raw/newbookdev_newbookaccommodation_sites_default_housekeepers/2024-11-04/1730785077/accommodation_sites_default_housekeepers.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_default_housekeepers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16120512232229952055,
        "service_name": "drive-thru",
        "span_id": 9208368077389788914,
        "trace_id": 2175245363838396873
    }
}

running: False
schema_name_id: 2394
start_time: 2024-11-05 03:42:05
success: True
trace_id: 2175245363838396873

Scan 6670236

duration: 0:00:11.398861

exit_message:

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

id: 6670236

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_newbookaccommodation_sites_default_housekeepers/2024-11-04/1730784771",
        "key": "raw/newbookdev_newbookaccommodation_sites_default_housekeepers/2024-11-04/1730784771/accommodation_sites_default_housekeepers.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_default_housekeepers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15975176129080654389,
        "service_name": "drive-thru",
        "span_id": 12554010185259959316,
        "trace_id": 16234666422723951585
    }
}

running: False
schema_name_id: 2394
start_time: 2024-11-05 03:18:30
success: True
trace_id: 16234666422723951585

Scan 6670074

duration: 0:00:11.404821

exit_message:

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

id: 6670074

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_newbookaccommodation_sites_default_housekeepers/2024-11-04/1730784168",
        "key": "raw/newbookdev_newbookaccommodation_sites_default_housekeepers/2024-11-04/1730784168/accommodation_sites_default_housekeepers.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_default_housekeepers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8494764531298992921,
        "service_name": "drive-thru",
        "span_id": 8096581464854376688,
        "trace_id": 15150534598187667477
    }
}

running: False
schema_name_id: 2394
start_time: 2024-11-05 03:14:10
success: True
trace_id: 15150534598187667477

Scan 6668365

duration: 0:00:11.330534

exit_message:

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

id: 6668365

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_newbookaccommodation_sites_default_housekeepers/2024-11-04/1730783862",
        "key": "raw/newbookdev_newbookaccommodation_sites_default_housekeepers/2024-11-04/1730783862/accommodation_sites_default_housekeepers.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_default_housekeepers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16106284581091086085,
        "service_name": "drive-thru",
        "span_id": 1166843447776158412,
        "trace_id": 4900185530487570797
    }
}

running: False
schema_name_id: 2394
start_time: 2024-11-05 02:28:52
success: True
trace_id: 4900185530487570797

Scan 6668238

duration: 0:00:11.484294

exit_message:

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

id: 6668238

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_newbookaccommodation_sites_default_housekeepers/2024-11-04/1730784006",
        "key": "raw/newbookdev_newbookaccommodation_sites_default_housekeepers/2024-11-04/1730784006/accommodation_sites_default_housekeepers.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_default_housekeepers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14794096686902261596,
        "service_name": "drive-thru",
        "span_id": 10283640172834151773,
        "trace_id": 14856124925455179557
    }
}

running: False
schema_name_id: 2394
start_time: 2024-11-05 02:25:34
success: True
trace_id: 14856124925455179557

Scan 6667588

duration: 0:00:13.904390

exit_message:

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

id: 6667588

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_newbookaccommodation_sites_default_housekeepers/2024-11-04/1730783718",
        "key": "raw/newbookdev_newbookaccommodation_sites_default_housekeepers/2024-11-04/1730783718/accommodation_sites_default_housekeepers.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_default_housekeepers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6509513897919169403,
        "service_name": "drive-thru",
        "span_id": 11626798569704220125,
        "trace_id": 16596265793570447222
    }
}

running: False
schema_name_id: 2394
start_time: 2024-11-05 02:08:27
success: True
trace_id: 16596265793570447222

Scan 6666336

duration: 0:00:11.567566

exit_message:

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

id: 6666336

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_newbookaccommodation_sites_default_housekeepers/2024-11-04/1730783628",
        "key": "raw/newbookdev_newbookaccommodation_sites_default_housekeepers/2024-11-04/1730783628/accommodation_sites_default_housekeepers.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_default_housekeepers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8368970166528657299,
        "service_name": "drive-thru",
        "span_id": 16605177476755692743,
        "trace_id": 3021836646303032934
    }
}

running: False
schema_name_id: 2394
start_time: 2024-11-05 01:35:19
success: True
trace_id: 3021836646303032934

Scan 6666083

duration: 0:00:11.374206

exit_message:

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

id: 6666083

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_newbookaccommodation_sites_default_housekeepers/2024-11-04/1730783474",
        "key": "raw/newbookdev_newbookaccommodation_sites_default_housekeepers/2024-11-04/1730783474/accommodation_sites_default_housekeepers.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_default_housekeepers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17857036129554018003,
        "service_name": "drive-thru",
        "span_id": 12402176220321505901,
        "trace_id": 15991176384448119412
    }
}

running: False
schema_name_id: 2394
start_time: 2024-11-05 01:28:35
success: True
trace_id: 15991176384448119412

Scan 6665185

duration: 0:00:13.904564

exit_message:

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

id: 6665185

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_newbookaccommodation_sites_default_housekeepers/2024-11-04/1730783256",
        "key": "raw/newbookdev_newbookaccommodation_sites_default_housekeepers/2024-11-04/1730783256/accommodation_sites_default_housekeepers.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_default_housekeepers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16425816676131875345,
        "service_name": "drive-thru",
        "span_id": 3913476971450674233,
        "trace_id": 5824033816136650228
    }
}

running: False
schema_name_id: 2394
start_time: 2024-11-05 01:04:48
success: True
trace_id: 5824033816136650228

Scan 6664248

duration: 0:00:11.340721

exit_message:

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

id: 6664248

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_newbookaccommodation_sites_default_housekeepers/2024-11-04/1730782858",
        "key": "raw/newbookdev_newbookaccommodation_sites_default_housekeepers/2024-11-04/1730782858/accommodation_sites_default_housekeepers.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_default_housekeepers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6216625681527241306,
        "service_name": "drive-thru",
        "span_id": 11340915404392125525,
        "trace_id": 3792697555525975285
    }
}

running: False
schema_name_id: 2394
start_time: 2024-11-05 00:40:04
success: True
trace_id: 3792697555525975285

Scan 6663801

duration: 0:00:11.362140

exit_message:

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

id: 6663801

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_newbookaccommodation_sites_default_housekeepers/2024-11-04/1730782769",
        "key": "raw/newbookdev_newbookaccommodation_sites_default_housekeepers/2024-11-04/1730782769/accommodation_sites_default_housekeepers.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_default_housekeepers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3606831370180618826,
        "service_name": "drive-thru",
        "span_id": 9264654691116306592,
        "trace_id": 11331509974844662771
    }
}

running: False
schema_name_id: 2394
start_time: 2024-11-05 00:28:20
success: True
trace_id: 11331509974844662771

Partitions:

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

Schema:

attributes:

{
    "active": "string",
    "created_on": "string",
    "id": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string",
    "user_id": "string"
}

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_default_housekeepers`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `site_id`  string , `created_on`  string , `active`  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_newbookaccommodation_sites_default_housekeepers/2024-11-05/1730866351'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_default_housekeepers`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_sites_default_housekeepers"
}

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