Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookbookings_guests_link

created: 2024-10-08 17:39:57
disabled: False
format: raw
id: 2450
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4748150

created: 2024-11-05 22:36:25

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_guests_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbookings_guests_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `booking_id`  string , `guest_id`  string , `primary_client`  string , `billed_client`  string , `guest_type`  string , `guest_type_id`  string , `guests_memberships_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_newbookbookings_guests_link/2024-11-05/1730866380'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_guests_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_guests_link/2024-11-05/1730866380
id: 4748150
processed: 1

raw_data:

{
    "billed_client": 6,
    "booking_id": 3,
    "guest_id": 4,
    "guest_type": 7,
    "guest_type_id": 8,
    "guests_memberships_id": 9,
    "id": 2,
    "newbook_region": 0,
    "primary_client": 5,
    "tenant": 1
}

schema_attributes:

{
    "billed_client": "string",
    "booking_id": "string",
    "guest_id": "string",
    "guest_type": "string",
    "guest_type_id": "string",
    "guests_memberships_id": "string",
    "id": "string",
    "newbook_region": "string",
    "primary_client": "string",
    "tenant": "string"
}

schema_name_id: 2450
schema_scan_id: 6674182
updated: 2024-11-05 22:36:36

Version 4747803

created: 2024-11-05 22:26:25

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_guests_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbookings_guests_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `booking_id`  string , `guest_id`  string , `primary_client`  string , `billed_client`  string , `guest_type`  string , `guest_type_id`  string , `guests_memberships_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_newbookbookings_guests_link/2024-11-05/1730866314'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_guests_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_guests_link/2024-11-05/1730866314
id: 4747803
processed: 1

raw_data:

{
    "billed_client": 6,
    "booking_id": 3,
    "guest_id": 4,
    "guest_type": 7,
    "guest_type_id": 8,
    "guests_memberships_id": 9,
    "id": 2,
    "newbook_region": 0,
    "primary_client": 5,
    "tenant": 1
}

schema_attributes:

{
    "billed_client": "string",
    "booking_id": "string",
    "guest_id": "string",
    "guest_type": "string",
    "guest_type_id": "string",
    "guests_memberships_id": "string",
    "id": "string",
    "newbook_region": "string",
    "primary_client": "string",
    "tenant": "string"
}

schema_name_id: 2450
schema_scan_id: 6673835
updated: 2024-11-05 22:26:38

Version 4747372

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_guests_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbookings_guests_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `booking_id`  string , `guest_id`  string , `primary_client`  string , `billed_client`  string , `guest_type`  string , `guest_type_id`  string , `guests_memberships_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_newbookbookings_guests_link/2024-11-05/1730866238'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_guests_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_guests_link/2024-11-05/1730866238
id: 4747372
processed: 1

raw_data:

{
    "billed_client": 6,
    "booking_id": 3,
    "guest_id": 4,
    "guest_type": 7,
    "guest_type_id": 8,
    "guests_memberships_id": 9,
    "id": 2,
    "newbook_region": 0,
    "primary_client": 5,
    "tenant": 1
}

schema_attributes:

{
    "billed_client": "string",
    "booking_id": "string",
    "guest_id": "string",
    "guest_type": "string",
    "guest_type_id": "string",
    "guests_memberships_id": "string",
    "id": "string",
    "newbook_region": "string",
    "primary_client": "string",
    "tenant": "string"
}

schema_name_id: 2450
schema_scan_id: 6673404
updated: 2024-11-05 22:14:23

Version 4745945

created: 2024-11-05 03:43:47

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_guests_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbookings_guests_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `booking_id`  string , `guest_id`  string , `primary_client`  string , `billed_client`  string , `guest_type`  string , `guest_type_id`  string , `guests_memberships_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_newbookbookings_guests_link/2024-11-04/1730785657'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_guests_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_guests_link/2024-11-04/1730785657
id: 4745945
processed: 1

raw_data:

{
    "billed_client": 6,
    "booking_id": 3,
    "guest_id": 4,
    "guest_type": 7,
    "guest_type_id": 8,
    "guests_memberships_id": 9,
    "id": 2,
    "newbook_region": 0,
    "primary_client": 5,
    "tenant": 1
}

schema_attributes:

{
    "billed_client": "string",
    "booking_id": "string",
    "guest_id": "string",
    "guest_type": "string",
    "guest_type_id": "string",
    "guests_memberships_id": "string",
    "id": "string",
    "newbook_region": "string",
    "primary_client": "string",
    "tenant": "string"
}

schema_name_id: 2450
schema_scan_id: 6671165
updated: 2024-11-05 03:43:58

Version 4745378

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_guests_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbookings_guests_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `booking_id`  string , `guest_id`  string , `primary_client`  string , `billed_client`  string , `guest_type`  string , `guest_type_id`  string , `guests_memberships_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_newbookbookings_guests_link/2024-11-04/1730784781'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_guests_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_guests_link/2024-11-04/1730784781
id: 4745378
processed: 1

raw_data:

{
    "billed_client": 6,
    "booking_id": 3,
    "guest_id": 4,
    "guest_type": 7,
    "guest_type_id": 8,
    "guests_memberships_id": 9,
    "id": 2,
    "newbook_region": 0,
    "primary_client": 5,
    "tenant": 1
}

schema_attributes:

{
    "billed_client": "string",
    "booking_id": "string",
    "guest_id": "string",
    "guest_type": "string",
    "guest_type_id": "string",
    "guests_memberships_id": "string",
    "id": "string",
    "newbook_region": "string",
    "primary_client": "string",
    "tenant": "string"
}

schema_name_id: 2450
schema_scan_id: 6670594
updated: 2024-11-05 03:28:01

Version 4745234

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_guests_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbookings_guests_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `booking_id`  string , `guest_id`  string , `primary_client`  string , `billed_client`  string , `guest_type`  string , `guest_type_id`  string , `guests_memberships_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_newbookbookings_guests_link/2024-11-04/1730785086'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_guests_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_guests_link/2024-11-04/1730785086
id: 4745234
processed: 1

raw_data:

{
    "billed_client": 6,
    "booking_id": 3,
    "guest_id": 4,
    "guest_type": 7,
    "guest_type_id": 8,
    "guests_memberships_id": 9,
    "id": 2,
    "newbook_region": 0,
    "primary_client": 5,
    "tenant": 1
}

schema_attributes:

{
    "billed_client": "string",
    "booking_id": "string",
    "guest_id": "string",
    "guest_type": "string",
    "guest_type_id": "string",
    "guests_memberships_id": "string",
    "id": "string",
    "newbook_region": "string",
    "primary_client": "string",
    "tenant": "string"
}

schema_name_id: 2450
schema_scan_id: 6670451
updated: 2024-11-05 03:24:17

Version 4744343

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_guests_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbookings_guests_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `booking_id`  string , `guest_id`  string , `primary_client`  string , `billed_client`  string , `guest_type`  string , `guest_type_id`  string , `guests_memberships_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_newbookbookings_guests_link/2024-11-04/1730784178'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_guests_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_guests_link/2024-11-04/1730784178
id: 4744343
processed: 1

raw_data:

{
    "billed_client": 6,
    "booking_id": 3,
    "guest_id": 4,
    "guest_type": 7,
    "guest_type_id": 8,
    "guests_memberships_id": 9,
    "id": 2,
    "newbook_region": 0,
    "primary_client": 5,
    "tenant": 1
}

schema_attributes:

{
    "billed_client": "string",
    "booking_id": "string",
    "guest_id": "string",
    "guest_type": "string",
    "guest_type_id": "string",
    "guests_memberships_id": "string",
    "id": "string",
    "newbook_region": "string",
    "primary_client": "string",
    "tenant": "string"
}

schema_name_id: 2450
schema_scan_id: 6669560
updated: 2024-11-05 03:00:34

Version 4743657

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_guests_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbookings_guests_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `booking_id`  string , `guest_id`  string , `primary_client`  string , `billed_client`  string , `guest_type`  string , `guest_type_id`  string , `guests_memberships_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_newbookbookings_guests_link/2024-11-04/1730784015'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_guests_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_guests_link/2024-11-04/1730784015
id: 4743657
processed: 1

raw_data:

{
    "billed_client": 6,
    "booking_id": 3,
    "guest_id": 4,
    "guest_type": 7,
    "guest_type_id": 8,
    "guests_memberships_id": 9,
    "id": 2,
    "newbook_region": 0,
    "primary_client": 5,
    "tenant": 1
}

schema_attributes:

{
    "billed_client": "string",
    "booking_id": "string",
    "guest_id": "string",
    "guest_type": "string",
    "guest_type_id": "string",
    "guests_memberships_id": "string",
    "id": "string",
    "newbook_region": "string",
    "primary_client": "string",
    "tenant": "string"
}

schema_name_id: 2450
schema_scan_id: 6668874
updated: 2024-11-05 02:42:39

Version 4743045

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_guests_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbookings_guests_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `booking_id`  string , `guest_id`  string , `primary_client`  string , `billed_client`  string , `guest_type`  string , `guest_type_id`  string , `guests_memberships_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_newbookbookings_guests_link/2024-11-04/1730783870'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_guests_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_guests_link/2024-11-04/1730783870
id: 4743045
processed: 1

raw_data:

{
    "billed_client": 6,
    "booking_id": 3,
    "guest_id": 4,
    "guest_type": 7,
    "guest_type_id": 8,
    "guests_memberships_id": 9,
    "id": 2,
    "newbook_region": 0,
    "primary_client": 5,
    "tenant": 1
}

schema_attributes:

{
    "billed_client": "string",
    "booking_id": "string",
    "guest_id": "string",
    "guest_type": "string",
    "guest_type_id": "string",
    "guests_memberships_id": "string",
    "id": "string",
    "newbook_region": "string",
    "primary_client": "string",
    "tenant": "string"
}

schema_name_id: 2450
schema_scan_id: 6668262
updated: 2024-11-05 02:26:25

Version 4742309

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_guests_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbookings_guests_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `booking_id`  string , `guest_id`  string , `primary_client`  string , `billed_client`  string , `guest_type`  string , `guest_type_id`  string , `guests_memberships_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_newbookbookings_guests_link/2024-11-04/1730783728'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_guests_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_guests_link/2024-11-04/1730783728
id: 4742309
processed: 1

raw_data:

{
    "billed_client": 6,
    "booking_id": 3,
    "guest_id": 4,
    "guest_type": 7,
    "guest_type_id": 8,
    "guests_memberships_id": 9,
    "id": 2,
    "newbook_region": 0,
    "primary_client": 5,
    "tenant": 1
}

schema_attributes:

{
    "billed_client": "string",
    "booking_id": "string",
    "guest_id": "string",
    "guest_type": "string",
    "guest_type_id": "string",
    "guests_memberships_id": "string",
    "id": "string",
    "newbook_region": "string",
    "primary_client": "string",
    "tenant": "string"
}

schema_name_id: 2450
schema_scan_id: 6667526
updated: 2024-11-05 02:07:02

Version 4741820

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_guests_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbookings_guests_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `booking_id`  string , `guest_id`  string , `primary_client`  string , `billed_client`  string , `guest_type`  string , `guest_type_id`  string , `guests_memberships_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_newbookbookings_guests_link/2024-11-04/1730783635'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_guests_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_guests_link/2024-11-04/1730783635
id: 4741820
processed: 1

raw_data:

{
    "billed_client": 6,
    "booking_id": 3,
    "guest_id": 4,
    "guest_type": 7,
    "guest_type_id": 8,
    "guests_memberships_id": 9,
    "id": 2,
    "newbook_region": 0,
    "primary_client": 5,
    "tenant": 1
}

schema_attributes:

{
    "billed_client": "string",
    "booking_id": "string",
    "guest_id": "string",
    "guest_type": "string",
    "guest_type_id": "string",
    "guests_memberships_id": "string",
    "id": "string",
    "newbook_region": "string",
    "primary_client": "string",
    "tenant": "string"
}

schema_name_id: 2450
schema_scan_id: 6667037
updated: 2024-11-05 01:53:47

Version 4740767

created: 2024-11-05 01:25:54

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_guests_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbookings_guests_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `booking_id`  string , `guest_id`  string , `primary_client`  string , `billed_client`  string , `guest_type`  string , `guest_type_id`  string , `guests_memberships_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_newbookbookings_guests_link/2024-11-04/1730783484'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_guests_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_guests_link/2024-11-04/1730783484
id: 4740767
processed: 1

raw_data:

{
    "billed_client": 6,
    "booking_id": 3,
    "guest_id": 4,
    "guest_type": 7,
    "guest_type_id": 8,
    "guests_memberships_id": 9,
    "id": 2,
    "newbook_region": 0,
    "primary_client": 5,
    "tenant": 1
}

schema_attributes:

{
    "billed_client": "string",
    "booking_id": "string",
    "guest_id": "string",
    "guest_type": "string",
    "guest_type_id": "string",
    "guests_memberships_id": "string",
    "id": "string",
    "newbook_region": "string",
    "primary_client": "string",
    "tenant": "string"
}

schema_name_id: 2450
schema_scan_id: 6665984
updated: 2024-11-05 01:26:08

Version 4740034

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_guests_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbookings_guests_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `booking_id`  string , `guest_id`  string , `primary_client`  string , `billed_client`  string , `guest_type`  string , `guest_type_id`  string , `guests_memberships_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_newbookbookings_guests_link/2024-11-04/1730783265'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_guests_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_guests_link/2024-11-04/1730783265
id: 4740034
processed: 1

raw_data:

{
    "billed_client": 6,
    "booking_id": 3,
    "guest_id": 4,
    "guest_type": 7,
    "guest_type_id": 8,
    "guests_memberships_id": 9,
    "id": 2,
    "newbook_region": 0,
    "primary_client": 5,
    "tenant": 1
}

schema_attributes:

{
    "billed_client": "string",
    "booking_id": "string",
    "guest_id": "string",
    "guest_type": "string",
    "guest_type_id": "string",
    "guests_memberships_id": "string",
    "id": "string",
    "newbook_region": "string",
    "primary_client": "string",
    "tenant": "string"
}

schema_name_id: 2450
schema_scan_id: 6665251
updated: 2024-11-05 01:06:45

Version 4739113

created: 2024-11-05 00:42:11

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_guests_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbookings_guests_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `booking_id`  string , `guest_id`  string , `primary_client`  string , `billed_client`  string , `guest_type`  string , `guest_type_id`  string , `guests_memberships_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_newbookbookings_guests_link/2024-11-04/1730782868'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_guests_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_guests_link/2024-11-04/1730782868
id: 4739113
processed: 1

raw_data:

{
    "billed_client": 6,
    "booking_id": 3,
    "guest_id": 4,
    "guest_type": 7,
    "guest_type_id": 8,
    "guests_memberships_id": 9,
    "id": 2,
    "newbook_region": 0,
    "primary_client": 5,
    "tenant": 1
}

schema_attributes:

{
    "billed_client": "string",
    "booking_id": "string",
    "guest_id": "string",
    "guest_type": "string",
    "guest_type_id": "string",
    "guests_memberships_id": "string",
    "id": "string",
    "newbook_region": "string",
    "primary_client": "string",
    "tenant": "string"
}

schema_name_id: 2450
schema_scan_id: 6664328
updated: 2024-11-05 00:42:25

Version 4738461

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_guests_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbookings_guests_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `booking_id`  string , `guest_id`  string , `primary_client`  string , `billed_client`  string , `guest_type`  string , `guest_type_id`  string , `guests_memberships_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_newbookbookings_guests_link/2024-11-04/1730782741'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_guests_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_guests_link/2024-11-04/1730782741
id: 4738461
processed: 1

raw_data:

{
    "billed_client": 6,
    "booking_id": 3,
    "guest_id": 4,
    "guest_type": 7,
    "guest_type_id": 8,
    "guests_memberships_id": 9,
    "id": 2,
    "newbook_region": 0,
    "primary_client": 5,
    "tenant": 1
}

schema_attributes:

{
    "billed_client": "string",
    "booking_id": "string",
    "guest_id": "string",
    "guest_type": "string",
    "guest_type_id": "string",
    "guests_memberships_id": "string",
    "id": "string",
    "newbook_region": "string",
    "primary_client": "string",
    "tenant": "string"
}

schema_name_id: 2450
schema_scan_id: 6663672
updated: 2024-11-05 00:25:17

Schema Scans: 15

Last at 2024-11-05 22:36:24

Scan 6674182

duration: 0:00:11.689525

exit_message:

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

id: 6674182

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_newbookbookings_guests_link/2024-11-05/1730866380",
        "key": "raw/newbookdev_newbookbookings_guests_link/2024-11-05/1730866380/bookings_guests_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_guests_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2980545902701504580,
        "service_name": "drive-thru",
        "span_id": 16289965653795004142,
        "trace_id": 15753366692065798001
    }
}

running: False
schema_name_id: 2450
start_time: 2024-11-05 22:36:24
success: True
trace_id: 15753366692065798001

Scan 6673835

duration: 0:00:13.987874

exit_message:

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

id: 6673835

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_newbookbookings_guests_link/2024-11-05/1730866314",
        "key": "raw/newbookdev_newbookbookings_guests_link/2024-11-05/1730866314/bookings_guests_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_guests_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13483453840611503635,
        "service_name": "drive-thru",
        "span_id": 360720231975805008,
        "trace_id": 4206195247272682609
    }
}

running: False
schema_name_id: 2450
start_time: 2024-11-05 22:26:25
success: True
trace_id: 4206195247272682609

Scan 6673404

duration: 0:00:11.677589

exit_message:

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

id: 6673404

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_newbookbookings_guests_link/2024-11-05/1730866238",
        "key": "raw/newbookdev_newbookbookings_guests_link/2024-11-05/1730866238/bookings_guests_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_guests_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5631545747870501895,
        "service_name": "drive-thru",
        "span_id": 12713547087701953541,
        "trace_id": 18085356798992722213
    }
}

running: False
schema_name_id: 2450
start_time: 2024-11-05 22:14:11
success: True
trace_id: 18085356798992722213

Scan 6671165

duration: 0:00:11.541290

exit_message:

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

id: 6671165

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_newbookbookings_guests_link/2024-11-04/1730785657",
        "key": "raw/newbookdev_newbookbookings_guests_link/2024-11-04/1730785657/bookings_guests_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_guests_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13868004630472575244,
        "service_name": "drive-thru",
        "span_id": 3972751783751379328,
        "trace_id": 17836458653982414775
    }
}

running: False
schema_name_id: 2450
start_time: 2024-11-05 03:43:47
success: True
trace_id: 17836458653982414775

Scan 6670594

duration: 0:00:11.371433

exit_message:

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

id: 6670594

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_newbookbookings_guests_link/2024-11-04/1730784781",
        "key": "raw/newbookdev_newbookbookings_guests_link/2024-11-04/1730784781/bookings_guests_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_guests_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7042645305146235815,
        "service_name": "drive-thru",
        "span_id": 11099500582536417427,
        "trace_id": 6303084045480756966
    }
}

running: False
schema_name_id: 2450
start_time: 2024-11-05 03:27:49
success: True
trace_id: 6303084045480756966

Scan 6670451

duration: 0:00:11.621383

exit_message:

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

id: 6670451

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_newbookbookings_guests_link/2024-11-04/1730785086",
        "key": "raw/newbookdev_newbookbookings_guests_link/2024-11-04/1730785086/bookings_guests_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_guests_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14943207157511530300,
        "service_name": "drive-thru",
        "span_id": 7994162581839825128,
        "trace_id": 16267520896987615869
    }
}

running: False
schema_name_id: 2450
start_time: 2024-11-05 03:24:05
success: True
trace_id: 16267520896987615869

Scan 6669560

duration: 0:00:11.444466

exit_message:

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

id: 6669560

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_newbookbookings_guests_link/2024-11-04/1730784178",
        "key": "raw/newbookdev_newbookbookings_guests_link/2024-11-04/1730784178/bookings_guests_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_guests_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11594172075831039518,
        "service_name": "drive-thru",
        "span_id": 12491656238581208981,
        "trace_id": 1328579972198940750
    }
}

running: False
schema_name_id: 2450
start_time: 2024-11-05 03:00:23
success: True
trace_id: 1328579972198940750

Scan 6668874

duration: 0:00:14.095599

exit_message:

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

id: 6668874

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_newbookbookings_guests_link/2024-11-04/1730784015",
        "key": "raw/newbookdev_newbookbookings_guests_link/2024-11-04/1730784015/bookings_guests_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_guests_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10398482471462275802,
        "service_name": "drive-thru",
        "span_id": 3503525589651810626,
        "trace_id": 7950176349386451174
    }
}

running: False
schema_name_id: 2450
start_time: 2024-11-05 02:42:24
success: True
trace_id: 7950176349386451174

Scan 6668262

duration: 0:00:14.091043

exit_message:

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

id: 6668262

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_newbookbookings_guests_link/2024-11-04/1730783870",
        "key": "raw/newbookdev_newbookbookings_guests_link/2024-11-04/1730783870/bookings_guests_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_guests_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8135331003636327491,
        "service_name": "drive-thru",
        "span_id": 13286448273735755329,
        "trace_id": 818603206241215945
    }
}

running: False
schema_name_id: 2450
start_time: 2024-11-05 02:26:11
success: True
trace_id: 818603206241215945

Scan 6667526

duration: 0:00:13.972554

exit_message:

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

id: 6667526

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_newbookbookings_guests_link/2024-11-04/1730783728",
        "key": "raw/newbookdev_newbookbookings_guests_link/2024-11-04/1730783728/bookings_guests_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_guests_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10453407761778251090,
        "service_name": "drive-thru",
        "span_id": 933625827786111150,
        "trace_id": 742327475515863448
    }
}

running: False
schema_name_id: 2450
start_time: 2024-11-05 02:06:48
success: True
trace_id: 742327475515863448

Scan 6667037

duration: 0:00:11.486838

exit_message:

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

id: 6667037

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_newbookbookings_guests_link/2024-11-04/1730783635",
        "key": "raw/newbookdev_newbookbookings_guests_link/2024-11-04/1730783635/bookings_guests_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_guests_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15641468614894476225,
        "service_name": "drive-thru",
        "span_id": 4855518089219753528,
        "trace_id": 16719815179170319506
    }
}

running: False
schema_name_id: 2450
start_time: 2024-11-05 01:53:36
success: True
trace_id: 16719815179170319506

Scan 6665984

duration: 0:00:14.056146

exit_message:

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

id: 6665984

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_newbookbookings_guests_link/2024-11-04/1730783484",
        "key": "raw/newbookdev_newbookbookings_guests_link/2024-11-04/1730783484/bookings_guests_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_guests_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10231653298746912944,
        "service_name": "drive-thru",
        "span_id": 6822903916697534929,
        "trace_id": 1394846491895179769
    }
}

running: False
schema_name_id: 2450
start_time: 2024-11-05 01:25:54
success: True
trace_id: 1394846491895179769

Scan 6665251

duration: 0:00:11.471313

exit_message:

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

id: 6665251

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_newbookbookings_guests_link/2024-11-04/1730783265",
        "key": "raw/newbookdev_newbookbookings_guests_link/2024-11-04/1730783265/bookings_guests_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_guests_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15462545926020541324,
        "service_name": "drive-thru",
        "span_id": 2629659240463955708,
        "trace_id": 3934380049778918479
    }
}

running: False
schema_name_id: 2450
start_time: 2024-11-05 01:06:34
success: True
trace_id: 3934380049778918479

Scan 6664328

duration: 0:00:14.014761

exit_message:

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

id: 6664328

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_newbookbookings_guests_link/2024-11-04/1730782868",
        "key": "raw/newbookdev_newbookbookings_guests_link/2024-11-04/1730782868/bookings_guests_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_guests_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18065320627845192025,
        "service_name": "drive-thru",
        "span_id": 7758466582741270612,
        "trace_id": 17392869267459165147
    }
}

running: False
schema_name_id: 2450
start_time: 2024-11-05 00:42:11
success: True
trace_id: 17392869267459165147

Scan 6663672

duration: 0:00:14.052894

exit_message:

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

id: 6663672

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_newbookbookings_guests_link/2024-11-04/1730782741",
        "key": "raw/newbookdev_newbookbookings_guests_link/2024-11-04/1730782741/bookings_guests_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_guests_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3469137419740722820,
        "service_name": "drive-thru",
        "span_id": 8439500624642759986,
        "trace_id": 12707107723779899595
    }
}

running: False
schema_name_id: 2450
start_time: 2024-11-05 00:25:03
success: True
trace_id: 12707107723779899595

Partitions:

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

Schema:

attributes:

{
    "billed_client": "string",
    "booking_id": "string",
    "guest_id": "string",
    "guest_type": "string",
    "guest_type_id": "string",
    "guests_memberships_id": "string",
    "id": "string",
    "newbook_region": "string",
    "primary_client": "string",
    "tenant": "string"
}

created: 2024-11-05 22:36:25

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbookings_guests_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `booking_id`  string , `guest_id`  string , `primary_client`  string , `billed_client`  string , `guest_type`  string , `guest_type_id`  string , `guests_memberships_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_newbookbookings_guests_link/2024-11-05/1730866380'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_guests_link`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_guests_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 17:39:57",
        "disabled": false,
        "format": "raw",
        "id": 2450,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "newbookdev_newbookbookings_guests_link"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "billed_client": "string",
            "booking_id": "string",
            "guest_id": "string",
            "guest_type": "string",
            "guest_type_id": "string",
            "guests_memberships_id": "string",
            "id": "string",
            "newbook_region": "string",
            "primary_client": "string",
            "tenant": "string"
        },
        "created": "2024-11-05 22:36:25",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbookings_guests_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `booking_id`  string , `guest_id`  string , `primary_client`  string , `billed_client`  string , `guest_type`  string , `guest_type_id`  string , `guests_memberships_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_newbookbookings_guests_link/2024-11-05/1730866380'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_guests_link`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_guests_link"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}