Schema Info
Schema Name: sfdl_prod_drivethru.stellar_imsbookings
- created: 2023-02-07 01:46:49
- disabled: False
- format: raw
- id: 1467
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_prod_drivethru", "table": "stellar_imsbookings" } - type: drivethrucsv
Schema Versions: 15
-
Version 1717979
- created: 2026-04-17 04:57:20
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbookings`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbookings`\n(\n `tenant` string , `id` string , `location_id` string , `customer_id` string , `creator_id` string , `admin_id` string , `billing_firstname` string , `billing_lastname` string , `billing_street1` string , `billing_street2` string , `billing_city` string , `billing_state` string , `billing_country` string , `billing_zip` string , `cc_saved_name` string , `cc_saved_last4` string , `cc_saved_profile_id` string , `cc_saved_method_id` string , `cc_saved_address_id` string , `cc_preauth_id` string , `cc_preauth_amount` string , `cc_connect_type` string , `cc_connect_id` string , `accessories_custom_price` string , `accessories_total` string , `insurance` string , `pets` string , `parking` string , `parking_override` string , `boats_total` string , `pos_total` string , `use_club_credits` string , `no_show_fee` string , `cancellation_fee` string , `club_fees` string , `club_fees_override` string , `subtotal` string , `convenience_fee` string , `convenience_fee_waived` string , `internal_application_fee` string , `tax_1` string , `tax_1_exempt` string , `tax_1_rate_override` string , `tax_2` string , `tax_2_exempt` string , `checkin_tax_1` string , `checkin_tax_2` string , `checkin_total` string , `deposit_total` string , `deposit_override` string , `deposit_waived` string , `gratuity` string , `grand_total` string , `adjustment_total` string , `amount_paid` string , `notes` string , `notes_contract` string , `notes_from_customer` string , `notes_from_customer_contract` string , `notes_for_customer` string , `notes_for_customer_contract` string , `frontend` string , `is_on_hold` string , `is_locked` string , `is_finalized` string , `is_canceled` string , `override_turnaround_time` string , `cancellation_type` string , `bypass_club_restrictions` string , `renters_insurance_interest` string , `coupon_id` string , `coupon_type` string , `coupon_amount` string , `discount_total` string , `agent_id` string , `agent_name` string , `referrer_id` string , `safety_reminder` string , `deleted_admin_id` string , `created_at` string , `updated_at` string , `finalized_at` string , `deleted_at` 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-prod/raw/stellar_imsbookings/2026-04-17/1776419646'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbookings" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbookings/2026-04-17/1776419646
- id: 1717979
- processed: 1
- raw_data:
{ "accessories_custom_price": 23, "accessories_total": 24, "adjustment_total": 53, "admin_id": 5, "agent_id": 74, "agent_name": 75, "amount_paid": 54, "billing_city": 10, "billing_country": 12, "billing_firstname": 6, "billing_lastname": 7, "billing_state": 11, "billing_street1": 8, "billing_street2": 9, "billing_zip": 13, "boats_total": 29, "bypass_club_restrictions": 68, "cancellation_fee": 33, "cancellation_type": 67, "cc_connect_id": 22, "cc_connect_type": 21, "cc_preauth_amount": 20, "cc_preauth_id": 19, "cc_saved_address_id": 18, "cc_saved_last4": 15, "cc_saved_method_id": 17, "cc_saved_name": 14, "cc_saved_profile_id": 16, "checkin_tax_1": 45, "checkin_tax_2": 46, "checkin_total": 47, "club_fees": 34, "club_fees_override": 35, "convenience_fee": 37, "convenience_fee_waived": 38, "coupon_amount": 72, "coupon_id": 70, "coupon_type": 71, "created_at": 79, "creator_id": 4, "customer_id": 3, "deleted_admin_id": 78, "deleted_at": 82, "deposit_override": 49, "deposit_total": 48, "deposit_waived": 50, "discount_total": 73, "finalized_at": 81, "frontend": 61, "grand_total": 52, "gratuity": 51, "id": 1, "insurance": 25, "internal_application_fee": 39, "is_canceled": 65, "is_finalized": 64, "is_locked": 63, "is_on_hold": 62, "location_id": 2, "no_show_fee": 32, "notes": 55, "notes_contract": 56, "notes_for_customer": 59, "notes_for_customer_contract": 60, "notes_from_customer": 57, "notes_from_customer_contract": 58, "override_turnaround_time": 66, "parking": 27, "parking_override": 28, "pets": 26, "pos_total": 30, "referrer_id": 76, "renters_insurance_interest": 69, "safety_reminder": 77, "subtotal": 36, "tax_1": 40, "tax_1_exempt": 41, "tax_1_rate_override": 42, "tax_2": 43, "tax_2_exempt": 44, "tenant": 0, "updated_at": 80, "use_club_credits": 31 } - schema_attributes:
{ "accessories_custom_price": "string", "accessories_total": "string", "adjustment_total": "string", "admin_id": "string", "agent_id": "string", "agent_name": "string", "amount_paid": "string", "billing_city": "string", "billing_country": "string", "billing_firstname": "string", "billing_lastname": "string", "billing_state": "string", "billing_street1": "string", "billing_street2": "string", "billing_zip": "string", "boats_total": "string", "bypass_club_restrictions": "string", "cancellation_fee": "string", "cancellation_type": "string", "cc_connect_id": "string", "cc_connect_type": "string", "cc_preauth_amount": "string", "cc_preauth_id": "string", "cc_saved_address_id": "string", "cc_saved_last4": "string", "cc_saved_method_id": "string", "cc_saved_name": "string", "cc_saved_profile_id": "string", "checkin_tax_1": "string", "checkin_tax_2": "string", "checkin_total": "string", "club_fees": "string", "club_fees_override": "string", "convenience_fee": "string", "convenience_fee_waived": "string", "coupon_amount": "string", "coupon_id": "string", "coupon_type": "string", "created_at": "string", "creator_id": "string", "customer_id": "string", "deleted_admin_id": "string", "deleted_at": "string", "deposit_override": "string", "deposit_total": "string", "deposit_waived": "string", "discount_total": "string", "finalized_at": "string", "frontend": "string", "grand_total": "string", "gratuity": "string", "id": "string", "insurance": "string", "internal_application_fee": "string", "is_canceled": "string", "is_finalized": "string", "is_locked": "string", "is_on_hold": "string", "location_id": "string", "no_show_fee": "string", "notes": "string", "notes_contract": "string", "notes_for_customer": "string", "notes_for_customer_contract": "string", "notes_from_customer": "string", "notes_from_customer_contract": "string", "override_turnaround_time": "string", "parking": "string", "parking_override": "string", "pets": "string", "pos_total": "string", "referrer_id": "string", "renters_insurance_interest": "string", "safety_reminder": "string", "subtotal": "string", "tax_1": "string", "tax_1_exempt": "string", "tax_1_rate_override": "string", "tax_2": "string", "tax_2_exempt": "string", "tenant": "string", "updated_at": "string", "use_club_credits": "string" } - schema_name_id: 1467
- schema_scan_id: 162169318
- updated: 2026-04-17 04:57:31
-
Version 1716787
- created: 2026-04-16 05:19:45
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbookings`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbookings`\n(\n `tenant` string , `id` string , `location_id` string , `customer_id` string , `creator_id` string , `admin_id` string , `billing_firstname` string , `billing_lastname` string , `billing_street1` string , `billing_street2` string , `billing_city` string , `billing_state` string , `billing_country` string , `billing_zip` string , `cc_saved_name` string , `cc_saved_last4` string , `cc_saved_profile_id` string , `cc_saved_method_id` string , `cc_saved_address_id` string , `cc_preauth_id` string , `cc_preauth_amount` string , `cc_connect_type` string , `cc_connect_id` string , `accessories_custom_price` string , `accessories_total` string , `insurance` string , `pets` string , `parking` string , `parking_override` string , `boats_total` string , `pos_total` string , `use_club_credits` string , `no_show_fee` string , `cancellation_fee` string , `club_fees` string , `club_fees_override` string , `subtotal` string , `convenience_fee` string , `convenience_fee_waived` string , `internal_application_fee` string , `tax_1` string , `tax_1_exempt` string , `tax_1_rate_override` string , `tax_2` string , `tax_2_exempt` string , `checkin_tax_1` string , `checkin_tax_2` string , `checkin_total` string , `deposit_total` string , `deposit_override` string , `deposit_waived` string , `gratuity` string , `grand_total` string , `adjustment_total` string , `amount_paid` string , `notes` string , `notes_contract` string , `notes_from_customer` string , `notes_from_customer_contract` string , `notes_for_customer` string , `notes_for_customer_contract` string , `frontend` string , `is_on_hold` string , `is_locked` string , `is_finalized` string , `is_canceled` string , `override_turnaround_time` string , `cancellation_type` string , `bypass_club_restrictions` string , `renters_insurance_interest` string , `coupon_id` string , `coupon_type` string , `coupon_amount` string , `discount_total` string , `agent_id` string , `agent_name` string , `referrer_id` string , `safety_reminder` string , `deleted_admin_id` string , `created_at` string , `updated_at` string , `finalized_at` string , `deleted_at` 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-prod/raw/stellar_imsbookings/2026-04-16/1776334546'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbookings" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbookings/2026-04-16/1776334546
- id: 1716787
- processed: 1
- raw_data:
{ "accessories_custom_price": 23, "accessories_total": 24, "adjustment_total": 53, "admin_id": 5, "agent_id": 74, "agent_name": 75, "amount_paid": 54, "billing_city": 10, "billing_country": 12, "billing_firstname": 6, "billing_lastname": 7, "billing_state": 11, "billing_street1": 8, "billing_street2": 9, "billing_zip": 13, "boats_total": 29, "bypass_club_restrictions": 68, "cancellation_fee": 33, "cancellation_type": 67, "cc_connect_id": 22, "cc_connect_type": 21, "cc_preauth_amount": 20, "cc_preauth_id": 19, "cc_saved_address_id": 18, "cc_saved_last4": 15, "cc_saved_method_id": 17, "cc_saved_name": 14, "cc_saved_profile_id": 16, "checkin_tax_1": 45, "checkin_tax_2": 46, "checkin_total": 47, "club_fees": 34, "club_fees_override": 35, "convenience_fee": 37, "convenience_fee_waived": 38, "coupon_amount": 72, "coupon_id": 70, "coupon_type": 71, "created_at": 79, "creator_id": 4, "customer_id": 3, "deleted_admin_id": 78, "deleted_at": 82, "deposit_override": 49, "deposit_total": 48, "deposit_waived": 50, "discount_total": 73, "finalized_at": 81, "frontend": 61, "grand_total": 52, "gratuity": 51, "id": 1, "insurance": 25, "internal_application_fee": 39, "is_canceled": 65, "is_finalized": 64, "is_locked": 63, "is_on_hold": 62, "location_id": 2, "no_show_fee": 32, "notes": 55, "notes_contract": 56, "notes_for_customer": 59, "notes_for_customer_contract": 60, "notes_from_customer": 57, "notes_from_customer_contract": 58, "override_turnaround_time": 66, "parking": 27, "parking_override": 28, "pets": 26, "pos_total": 30, "referrer_id": 76, "renters_insurance_interest": 69, "safety_reminder": 77, "subtotal": 36, "tax_1": 40, "tax_1_exempt": 41, "tax_1_rate_override": 42, "tax_2": 43, "tax_2_exempt": 44, "tenant": 0, "updated_at": 80, "use_club_credits": 31 } - schema_attributes:
{ "accessories_custom_price": "string", "accessories_total": "string", "adjustment_total": "string", "admin_id": "string", "agent_id": "string", "agent_name": "string", "amount_paid": "string", "billing_city": "string", "billing_country": "string", "billing_firstname": "string", "billing_lastname": "string", "billing_state": "string", "billing_street1": "string", "billing_street2": "string", "billing_zip": "string", "boats_total": "string", "bypass_club_restrictions": "string", "cancellation_fee": "string", "cancellation_type": "string", "cc_connect_id": "string", "cc_connect_type": "string", "cc_preauth_amount": "string", "cc_preauth_id": "string", "cc_saved_address_id": "string", "cc_saved_last4": "string", "cc_saved_method_id": "string", "cc_saved_name": "string", "cc_saved_profile_id": "string", "checkin_tax_1": "string", "checkin_tax_2": "string", "checkin_total": "string", "club_fees": "string", "club_fees_override": "string", "convenience_fee": "string", "convenience_fee_waived": "string", "coupon_amount": "string", "coupon_id": "string", "coupon_type": "string", "created_at": "string", "creator_id": "string", "customer_id": "string", "deleted_admin_id": "string", "deleted_at": "string", "deposit_override": "string", "deposit_total": "string", "deposit_waived": "string", "discount_total": "string", "finalized_at": "string", "frontend": "string", "grand_total": "string", "gratuity": "string", "id": "string", "insurance": "string", "internal_application_fee": "string", "is_canceled": "string", "is_finalized": "string", "is_locked": "string", "is_on_hold": "string", "location_id": "string", "no_show_fee": "string", "notes": "string", "notes_contract": "string", "notes_for_customer": "string", "notes_for_customer_contract": "string", "notes_from_customer": "string", "notes_from_customer_contract": "string", "override_turnaround_time": "string", "parking": "string", "parking_override": "string", "pets": "string", "pos_total": "string", "referrer_id": "string", "renters_insurance_interest": "string", "safety_reminder": "string", "subtotal": "string", "tax_1": "string", "tax_1_exempt": "string", "tax_1_rate_override": "string", "tax_2": "string", "tax_2_exempt": "string", "tenant": "string", "updated_at": "string", "use_club_credits": "string" } - schema_name_id: 1467
- schema_scan_id: 162114461
- updated: 2026-04-16 05:19:57
-
Version 1715548
- created: 2026-04-15 03:43:37
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbookings`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbookings`\n(\n `tenant` string , `id` string , `location_id` string , `customer_id` string , `creator_id` string , `admin_id` string , `billing_firstname` string , `billing_lastname` string , `billing_street1` string , `billing_street2` string , `billing_city` string , `billing_state` string , `billing_country` string , `billing_zip` string , `cc_saved_name` string , `cc_saved_last4` string , `cc_saved_profile_id` string , `cc_saved_method_id` string , `cc_saved_address_id` string , `cc_preauth_id` string , `cc_preauth_amount` string , `cc_connect_type` string , `cc_connect_id` string , `accessories_custom_price` string , `accessories_total` string , `insurance` string , `pets` string , `parking` string , `parking_override` string , `boats_total` string , `pos_total` string , `use_club_credits` string , `no_show_fee` string , `cancellation_fee` string , `club_fees` string , `club_fees_override` string , `subtotal` string , `convenience_fee` string , `convenience_fee_waived` string , `internal_application_fee` string , `tax_1` string , `tax_1_exempt` string , `tax_1_rate_override` string , `tax_2` string , `tax_2_exempt` string , `checkin_tax_1` string , `checkin_tax_2` string , `checkin_total` string , `deposit_total` string , `deposit_override` string , `deposit_waived` string , `gratuity` string , `grand_total` string , `adjustment_total` string , `amount_paid` string , `notes` string , `notes_contract` string , `notes_from_customer` string , `notes_from_customer_contract` string , `notes_for_customer` string , `notes_for_customer_contract` string , `frontend` string , `is_on_hold` string , `is_locked` string , `is_finalized` string , `is_canceled` string , `override_turnaround_time` string , `cancellation_type` string , `bypass_club_restrictions` string , `renters_insurance_interest` string , `coupon_id` string , `coupon_type` string , `coupon_amount` string , `discount_total` string , `agent_id` string , `agent_name` string , `referrer_id` string , `safety_reminder` string , `deleted_admin_id` string , `created_at` string , `updated_at` string , `finalized_at` string , `deleted_at` 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-prod/raw/stellar_imsbookings/2026-04-15/1776242357'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbookings" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbookings/2026-04-15/1776242357
- id: 1715548
- processed: 1
- raw_data:
{ "accessories_custom_price": 23, "accessories_total": 24, "adjustment_total": 53, "admin_id": 5, "agent_id": 74, "agent_name": 75, "amount_paid": 54, "billing_city": 10, "billing_country": 12, "billing_firstname": 6, "billing_lastname": 7, "billing_state": 11, "billing_street1": 8, "billing_street2": 9, "billing_zip": 13, "boats_total": 29, "bypass_club_restrictions": 68, "cancellation_fee": 33, "cancellation_type": 67, "cc_connect_id": 22, "cc_connect_type": 21, "cc_preauth_amount": 20, "cc_preauth_id": 19, "cc_saved_address_id": 18, "cc_saved_last4": 15, "cc_saved_method_id": 17, "cc_saved_name": 14, "cc_saved_profile_id": 16, "checkin_tax_1": 45, "checkin_tax_2": 46, "checkin_total": 47, "club_fees": 34, "club_fees_override": 35, "convenience_fee": 37, "convenience_fee_waived": 38, "coupon_amount": 72, "coupon_id": 70, "coupon_type": 71, "created_at": 79, "creator_id": 4, "customer_id": 3, "deleted_admin_id": 78, "deleted_at": 82, "deposit_override": 49, "deposit_total": 48, "deposit_waived": 50, "discount_total": 73, "finalized_at": 81, "frontend": 61, "grand_total": 52, "gratuity": 51, "id": 1, "insurance": 25, "internal_application_fee": 39, "is_canceled": 65, "is_finalized": 64, "is_locked": 63, "is_on_hold": 62, "location_id": 2, "no_show_fee": 32, "notes": 55, "notes_contract": 56, "notes_for_customer": 59, "notes_for_customer_contract": 60, "notes_from_customer": 57, "notes_from_customer_contract": 58, "override_turnaround_time": 66, "parking": 27, "parking_override": 28, "pets": 26, "pos_total": 30, "referrer_id": 76, "renters_insurance_interest": 69, "safety_reminder": 77, "subtotal": 36, "tax_1": 40, "tax_1_exempt": 41, "tax_1_rate_override": 42, "tax_2": 43, "tax_2_exempt": 44, "tenant": 0, "updated_at": 80, "use_club_credits": 31 } - schema_attributes:
{ "accessories_custom_price": "string", "accessories_total": "string", "adjustment_total": "string", "admin_id": "string", "agent_id": "string", "agent_name": "string", "amount_paid": "string", "billing_city": "string", "billing_country": "string", "billing_firstname": "string", "billing_lastname": "string", "billing_state": "string", "billing_street1": "string", "billing_street2": "string", "billing_zip": "string", "boats_total": "string", "bypass_club_restrictions": "string", "cancellation_fee": "string", "cancellation_type": "string", "cc_connect_id": "string", "cc_connect_type": "string", "cc_preauth_amount": "string", "cc_preauth_id": "string", "cc_saved_address_id": "string", "cc_saved_last4": "string", "cc_saved_method_id": "string", "cc_saved_name": "string", "cc_saved_profile_id": "string", "checkin_tax_1": "string", "checkin_tax_2": "string", "checkin_total": "string", "club_fees": "string", "club_fees_override": "string", "convenience_fee": "string", "convenience_fee_waived": "string", "coupon_amount": "string", "coupon_id": "string", "coupon_type": "string", "created_at": "string", "creator_id": "string", "customer_id": "string", "deleted_admin_id": "string", "deleted_at": "string", "deposit_override": "string", "deposit_total": "string", "deposit_waived": "string", "discount_total": "string", "finalized_at": "string", "frontend": "string", "grand_total": "string", "gratuity": "string", "id": "string", "insurance": "string", "internal_application_fee": "string", "is_canceled": "string", "is_finalized": "string", "is_locked": "string", "is_on_hold": "string", "location_id": "string", "no_show_fee": "string", "notes": "string", "notes_contract": "string", "notes_for_customer": "string", "notes_for_customer_contract": "string", "notes_from_customer": "string", "notes_from_customer_contract": "string", "override_turnaround_time": "string", "parking": "string", "parking_override": "string", "pets": "string", "pos_total": "string", "referrer_id": "string", "renters_insurance_interest": "string", "safety_reminder": "string", "subtotal": "string", "tax_1": "string", "tax_1_exempt": "string", "tax_1_rate_override": "string", "tax_2": "string", "tax_2_exempt": "string", "tenant": "string", "updated_at": "string", "use_club_credits": "string" } - schema_name_id: 1467
- schema_scan_id: 162056435
- updated: 2026-04-15 03:43:48
-
Version 1714347
- created: 2026-04-14 05:02:27
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbookings`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbookings`\n(\n `tenant` string , `id` string , `location_id` string , `customer_id` string , `creator_id` string , `admin_id` string , `billing_firstname` string , `billing_lastname` string , `billing_street1` string , `billing_street2` string , `billing_city` string , `billing_state` string , `billing_country` string , `billing_zip` string , `cc_saved_name` string , `cc_saved_last4` string , `cc_saved_profile_id` string , `cc_saved_method_id` string , `cc_saved_address_id` string , `cc_preauth_id` string , `cc_preauth_amount` string , `cc_connect_type` string , `cc_connect_id` string , `accessories_custom_price` string , `accessories_total` string , `insurance` string , `pets` string , `parking` string , `parking_override` string , `boats_total` string , `pos_total` string , `use_club_credits` string , `no_show_fee` string , `cancellation_fee` string , `club_fees` string , `club_fees_override` string , `subtotal` string , `convenience_fee` string , `convenience_fee_waived` string , `internal_application_fee` string , `tax_1` string , `tax_1_exempt` string , `tax_1_rate_override` string , `tax_2` string , `tax_2_exempt` string , `checkin_tax_1` string , `checkin_tax_2` string , `checkin_total` string , `deposit_total` string , `deposit_override` string , `deposit_waived` string , `gratuity` string , `grand_total` string , `adjustment_total` string , `amount_paid` string , `notes` string , `notes_contract` string , `notes_from_customer` string , `notes_from_customer_contract` string , `notes_for_customer` string , `notes_for_customer_contract` string , `frontend` string , `is_on_hold` string , `is_locked` string , `is_finalized` string , `is_canceled` string , `override_turnaround_time` string , `cancellation_type` string , `bypass_club_restrictions` string , `renters_insurance_interest` string , `coupon_id` string , `coupon_type` string , `coupon_amount` string , `discount_total` string , `agent_id` string , `agent_name` string , `referrer_id` string , `safety_reminder` string , `deleted_admin_id` string , `created_at` string , `updated_at` string , `finalized_at` string , `deleted_at` 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-prod/raw/stellar_imsbookings/2026-04-14/1776160755'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbookings" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbookings/2026-04-14/1776160755
- id: 1714347
- processed: 1
- raw_data:
{ "accessories_custom_price": 23, "accessories_total": 24, "adjustment_total": 53, "admin_id": 5, "agent_id": 74, "agent_name": 75, "amount_paid": 54, "billing_city": 10, "billing_country": 12, "billing_firstname": 6, "billing_lastname": 7, "billing_state": 11, "billing_street1": 8, "billing_street2": 9, "billing_zip": 13, "boats_total": 29, "bypass_club_restrictions": 68, "cancellation_fee": 33, "cancellation_type": 67, "cc_connect_id": 22, "cc_connect_type": 21, "cc_preauth_amount": 20, "cc_preauth_id": 19, "cc_saved_address_id": 18, "cc_saved_last4": 15, "cc_saved_method_id": 17, "cc_saved_name": 14, "cc_saved_profile_id": 16, "checkin_tax_1": 45, "checkin_tax_2": 46, "checkin_total": 47, "club_fees": 34, "club_fees_override": 35, "convenience_fee": 37, "convenience_fee_waived": 38, "coupon_amount": 72, "coupon_id": 70, "coupon_type": 71, "created_at": 79, "creator_id": 4, "customer_id": 3, "deleted_admin_id": 78, "deleted_at": 82, "deposit_override": 49, "deposit_total": 48, "deposit_waived": 50, "discount_total": 73, "finalized_at": 81, "frontend": 61, "grand_total": 52, "gratuity": 51, "id": 1, "insurance": 25, "internal_application_fee": 39, "is_canceled": 65, "is_finalized": 64, "is_locked": 63, "is_on_hold": 62, "location_id": 2, "no_show_fee": 32, "notes": 55, "notes_contract": 56, "notes_for_customer": 59, "notes_for_customer_contract": 60, "notes_from_customer": 57, "notes_from_customer_contract": 58, "override_turnaround_time": 66, "parking": 27, "parking_override": 28, "pets": 26, "pos_total": 30, "referrer_id": 76, "renters_insurance_interest": 69, "safety_reminder": 77, "subtotal": 36, "tax_1": 40, "tax_1_exempt": 41, "tax_1_rate_override": 42, "tax_2": 43, "tax_2_exempt": 44, "tenant": 0, "updated_at": 80, "use_club_credits": 31 } - schema_attributes:
{ "accessories_custom_price": "string", "accessories_total": "string", "adjustment_total": "string", "admin_id": "string", "agent_id": "string", "agent_name": "string", "amount_paid": "string", "billing_city": "string", "billing_country": "string", "billing_firstname": "string", "billing_lastname": "string", "billing_state": "string", "billing_street1": "string", "billing_street2": "string", "billing_zip": "string", "boats_total": "string", "bypass_club_restrictions": "string", "cancellation_fee": "string", "cancellation_type": "string", "cc_connect_id": "string", "cc_connect_type": "string", "cc_preauth_amount": "string", "cc_preauth_id": "string", "cc_saved_address_id": "string", "cc_saved_last4": "string", "cc_saved_method_id": "string", "cc_saved_name": "string", "cc_saved_profile_id": "string", "checkin_tax_1": "string", "checkin_tax_2": "string", "checkin_total": "string", "club_fees": "string", "club_fees_override": "string", "convenience_fee": "string", "convenience_fee_waived": "string", "coupon_amount": "string", "coupon_id": "string", "coupon_type": "string", "created_at": "string", "creator_id": "string", "customer_id": "string", "deleted_admin_id": "string", "deleted_at": "string", "deposit_override": "string", "deposit_total": "string", "deposit_waived": "string", "discount_total": "string", "finalized_at": "string", "frontend": "string", "grand_total": "string", "gratuity": "string", "id": "string", "insurance": "string", "internal_application_fee": "string", "is_canceled": "string", "is_finalized": "string", "is_locked": "string", "is_on_hold": "string", "location_id": "string", "no_show_fee": "string", "notes": "string", "notes_contract": "string", "notes_for_customer": "string", "notes_for_customer_contract": "string", "notes_from_customer": "string", "notes_from_customer_contract": "string", "override_turnaround_time": "string", "parking": "string", "parking_override": "string", "pets": "string", "pos_total": "string", "referrer_id": "string", "renters_insurance_interest": "string", "safety_reminder": "string", "subtotal": "string", "tax_1": "string", "tax_1_exempt": "string", "tax_1_rate_override": "string", "tax_2": "string", "tax_2_exempt": "string", "tenant": "string", "updated_at": "string", "use_club_credits": "string" } - schema_name_id: 1467
- schema_scan_id: 162003028
- updated: 2026-04-14 05:02:41
-
Version 1713159
- created: 2026-04-13 05:10:32
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbookings`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbookings`\n(\n `tenant` string , `id` string , `location_id` string , `customer_id` string , `creator_id` string , `admin_id` string , `billing_firstname` string , `billing_lastname` string , `billing_street1` string , `billing_street2` string , `billing_city` string , `billing_state` string , `billing_country` string , `billing_zip` string , `cc_saved_name` string , `cc_saved_last4` string , `cc_saved_profile_id` string , `cc_saved_method_id` string , `cc_saved_address_id` string , `cc_preauth_id` string , `cc_preauth_amount` string , `cc_connect_type` string , `cc_connect_id` string , `accessories_custom_price` string , `accessories_total` string , `insurance` string , `pets` string , `parking` string , `parking_override` string , `boats_total` string , `pos_total` string , `use_club_credits` string , `no_show_fee` string , `cancellation_fee` string , `club_fees` string , `club_fees_override` string , `subtotal` string , `convenience_fee` string , `convenience_fee_waived` string , `internal_application_fee` string , `tax_1` string , `tax_1_exempt` string , `tax_1_rate_override` string , `tax_2` string , `tax_2_exempt` string , `checkin_tax_1` string , `checkin_tax_2` string , `checkin_total` string , `deposit_total` string , `deposit_override` string , `deposit_waived` string , `gratuity` string , `grand_total` string , `adjustment_total` string , `amount_paid` string , `notes` string , `notes_contract` string , `notes_from_customer` string , `notes_from_customer_contract` string , `notes_for_customer` string , `notes_for_customer_contract` string , `frontend` string , `is_on_hold` string , `is_locked` string , `is_finalized` string , `is_canceled` string , `override_turnaround_time` string , `cancellation_type` string , `bypass_club_restrictions` string , `renters_insurance_interest` string , `coupon_id` string , `coupon_type` string , `coupon_amount` string , `discount_total` string , `agent_id` string , `agent_name` string , `referrer_id` string , `safety_reminder` string , `deleted_admin_id` string , `created_at` string , `updated_at` string , `finalized_at` string , `deleted_at` 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-prod/raw/stellar_imsbookings/2026-04-13/1776074798'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbookings" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbookings/2026-04-13/1776074798
- id: 1713159
- processed: 1
- raw_data:
{ "accessories_custom_price": 23, "accessories_total": 24, "adjustment_total": 53, "admin_id": 5, "agent_id": 74, "agent_name": 75, "amount_paid": 54, "billing_city": 10, "billing_country": 12, "billing_firstname": 6, "billing_lastname": 7, "billing_state": 11, "billing_street1": 8, "billing_street2": 9, "billing_zip": 13, "boats_total": 29, "bypass_club_restrictions": 68, "cancellation_fee": 33, "cancellation_type": 67, "cc_connect_id": 22, "cc_connect_type": 21, "cc_preauth_amount": 20, "cc_preauth_id": 19, "cc_saved_address_id": 18, "cc_saved_last4": 15, "cc_saved_method_id": 17, "cc_saved_name": 14, "cc_saved_profile_id": 16, "checkin_tax_1": 45, "checkin_tax_2": 46, "checkin_total": 47, "club_fees": 34, "club_fees_override": 35, "convenience_fee": 37, "convenience_fee_waived": 38, "coupon_amount": 72, "coupon_id": 70, "coupon_type": 71, "created_at": 79, "creator_id": 4, "customer_id": 3, "deleted_admin_id": 78, "deleted_at": 82, "deposit_override": 49, "deposit_total": 48, "deposit_waived": 50, "discount_total": 73, "finalized_at": 81, "frontend": 61, "grand_total": 52, "gratuity": 51, "id": 1, "insurance": 25, "internal_application_fee": 39, "is_canceled": 65, "is_finalized": 64, "is_locked": 63, "is_on_hold": 62, "location_id": 2, "no_show_fee": 32, "notes": 55, "notes_contract": 56, "notes_for_customer": 59, "notes_for_customer_contract": 60, "notes_from_customer": 57, "notes_from_customer_contract": 58, "override_turnaround_time": 66, "parking": 27, "parking_override": 28, "pets": 26, "pos_total": 30, "referrer_id": 76, "renters_insurance_interest": 69, "safety_reminder": 77, "subtotal": 36, "tax_1": 40, "tax_1_exempt": 41, "tax_1_rate_override": 42, "tax_2": 43, "tax_2_exempt": 44, "tenant": 0, "updated_at": 80, "use_club_credits": 31 } - schema_attributes:
{ "accessories_custom_price": "string", "accessories_total": "string", "adjustment_total": "string", "admin_id": "string", "agent_id": "string", "agent_name": "string", "amount_paid": "string", "billing_city": "string", "billing_country": "string", "billing_firstname": "string", "billing_lastname": "string", "billing_state": "string", "billing_street1": "string", "billing_street2": "string", "billing_zip": "string", "boats_total": "string", "bypass_club_restrictions": "string", "cancellation_fee": "string", "cancellation_type": "string", "cc_connect_id": "string", "cc_connect_type": "string", "cc_preauth_amount": "string", "cc_preauth_id": "string", "cc_saved_address_id": "string", "cc_saved_last4": "string", "cc_saved_method_id": "string", "cc_saved_name": "string", "cc_saved_profile_id": "string", "checkin_tax_1": "string", "checkin_tax_2": "string", "checkin_total": "string", "club_fees": "string", "club_fees_override": "string", "convenience_fee": "string", "convenience_fee_waived": "string", "coupon_amount": "string", "coupon_id": "string", "coupon_type": "string", "created_at": "string", "creator_id": "string", "customer_id": "string", "deleted_admin_id": "string", "deleted_at": "string", "deposit_override": "string", "deposit_total": "string", "deposit_waived": "string", "discount_total": "string", "finalized_at": "string", "frontend": "string", "grand_total": "string", "gratuity": "string", "id": "string", "insurance": "string", "internal_application_fee": "string", "is_canceled": "string", "is_finalized": "string", "is_locked": "string", "is_on_hold": "string", "location_id": "string", "no_show_fee": "string", "notes": "string", "notes_contract": "string", "notes_for_customer": "string", "notes_for_customer_contract": "string", "notes_from_customer": "string", "notes_from_customer_contract": "string", "override_turnaround_time": "string", "parking": "string", "parking_override": "string", "pets": "string", "pos_total": "string", "referrer_id": "string", "renters_insurance_interest": "string", "safety_reminder": "string", "subtotal": "string", "tax_1": "string", "tax_1_exempt": "string", "tax_1_rate_override": "string", "tax_2": "string", "tax_2_exempt": "string", "tenant": "string", "updated_at": "string", "use_club_credits": "string" } - schema_name_id: 1467
- schema_scan_id: 161945367
- updated: 2026-04-13 05:10:46
-
Version 1711982
- created: 2026-04-12 05:08:34
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbookings`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbookings`\n(\n `tenant` string , `id` string , `location_id` string , `customer_id` string , `creator_id` string , `admin_id` string , `billing_firstname` string , `billing_lastname` string , `billing_street1` string , `billing_street2` string , `billing_city` string , `billing_state` string , `billing_country` string , `billing_zip` string , `cc_saved_name` string , `cc_saved_last4` string , `cc_saved_profile_id` string , `cc_saved_method_id` string , `cc_saved_address_id` string , `cc_preauth_id` string , `cc_preauth_amount` string , `cc_connect_type` string , `cc_connect_id` string , `accessories_custom_price` string , `accessories_total` string , `insurance` string , `pets` string , `parking` string , `parking_override` string , `boats_total` string , `pos_total` string , `use_club_credits` string , `no_show_fee` string , `cancellation_fee` string , `club_fees` string , `club_fees_override` string , `subtotal` string , `convenience_fee` string , `convenience_fee_waived` string , `internal_application_fee` string , `tax_1` string , `tax_1_exempt` string , `tax_1_rate_override` string , `tax_2` string , `tax_2_exempt` string , `checkin_tax_1` string , `checkin_tax_2` string , `checkin_total` string , `deposit_total` string , `deposit_override` string , `deposit_waived` string , `gratuity` string , `grand_total` string , `adjustment_total` string , `amount_paid` string , `notes` string , `notes_contract` string , `notes_from_customer` string , `notes_from_customer_contract` string , `notes_for_customer` string , `notes_for_customer_contract` string , `frontend` string , `is_on_hold` string , `is_locked` string , `is_finalized` string , `is_canceled` string , `override_turnaround_time` string , `cancellation_type` string , `bypass_club_restrictions` string , `renters_insurance_interest` string , `coupon_id` string , `coupon_type` string , `coupon_amount` string , `discount_total` string , `agent_id` string , `agent_name` string , `referrer_id` string , `safety_reminder` string , `deleted_admin_id` string , `created_at` string , `updated_at` string , `finalized_at` string , `deleted_at` 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-prod/raw/stellar_imsbookings/2026-04-12/1775988156'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbookings" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbookings/2026-04-12/1775988156
- id: 1711982
- processed: 1
- raw_data:
{ "accessories_custom_price": 23, "accessories_total": 24, "adjustment_total": 53, "admin_id": 5, "agent_id": 74, "agent_name": 75, "amount_paid": 54, "billing_city": 10, "billing_country": 12, "billing_firstname": 6, "billing_lastname": 7, "billing_state": 11, "billing_street1": 8, "billing_street2": 9, "billing_zip": 13, "boats_total": 29, "bypass_club_restrictions": 68, "cancellation_fee": 33, "cancellation_type": 67, "cc_connect_id": 22, "cc_connect_type": 21, "cc_preauth_amount": 20, "cc_preauth_id": 19, "cc_saved_address_id": 18, "cc_saved_last4": 15, "cc_saved_method_id": 17, "cc_saved_name": 14, "cc_saved_profile_id": 16, "checkin_tax_1": 45, "checkin_tax_2": 46, "checkin_total": 47, "club_fees": 34, "club_fees_override": 35, "convenience_fee": 37, "convenience_fee_waived": 38, "coupon_amount": 72, "coupon_id": 70, "coupon_type": 71, "created_at": 79, "creator_id": 4, "customer_id": 3, "deleted_admin_id": 78, "deleted_at": 82, "deposit_override": 49, "deposit_total": 48, "deposit_waived": 50, "discount_total": 73, "finalized_at": 81, "frontend": 61, "grand_total": 52, "gratuity": 51, "id": 1, "insurance": 25, "internal_application_fee": 39, "is_canceled": 65, "is_finalized": 64, "is_locked": 63, "is_on_hold": 62, "location_id": 2, "no_show_fee": 32, "notes": 55, "notes_contract": 56, "notes_for_customer": 59, "notes_for_customer_contract": 60, "notes_from_customer": 57, "notes_from_customer_contract": 58, "override_turnaround_time": 66, "parking": 27, "parking_override": 28, "pets": 26, "pos_total": 30, "referrer_id": 76, "renters_insurance_interest": 69, "safety_reminder": 77, "subtotal": 36, "tax_1": 40, "tax_1_exempt": 41, "tax_1_rate_override": 42, "tax_2": 43, "tax_2_exempt": 44, "tenant": 0, "updated_at": 80, "use_club_credits": 31 } - schema_attributes:
{ "accessories_custom_price": "string", "accessories_total": "string", "adjustment_total": "string", "admin_id": "string", "agent_id": "string", "agent_name": "string", "amount_paid": "string", "billing_city": "string", "billing_country": "string", "billing_firstname": "string", "billing_lastname": "string", "billing_state": "string", "billing_street1": "string", "billing_street2": "string", "billing_zip": "string", "boats_total": "string", "bypass_club_restrictions": "string", "cancellation_fee": "string", "cancellation_type": "string", "cc_connect_id": "string", "cc_connect_type": "string", "cc_preauth_amount": "string", "cc_preauth_id": "string", "cc_saved_address_id": "string", "cc_saved_last4": "string", "cc_saved_method_id": "string", "cc_saved_name": "string", "cc_saved_profile_id": "string", "checkin_tax_1": "string", "checkin_tax_2": "string", "checkin_total": "string", "club_fees": "string", "club_fees_override": "string", "convenience_fee": "string", "convenience_fee_waived": "string", "coupon_amount": "string", "coupon_id": "string", "coupon_type": "string", "created_at": "string", "creator_id": "string", "customer_id": "string", "deleted_admin_id": "string", "deleted_at": "string", "deposit_override": "string", "deposit_total": "string", "deposit_waived": "string", "discount_total": "string", "finalized_at": "string", "frontend": "string", "grand_total": "string", "gratuity": "string", "id": "string", "insurance": "string", "internal_application_fee": "string", "is_canceled": "string", "is_finalized": "string", "is_locked": "string", "is_on_hold": "string", "location_id": "string", "no_show_fee": "string", "notes": "string", "notes_contract": "string", "notes_for_customer": "string", "notes_for_customer_contract": "string", "notes_from_customer": "string", "notes_from_customer_contract": "string", "override_turnaround_time": "string", "parking": "string", "parking_override": "string", "pets": "string", "pos_total": "string", "referrer_id": "string", "renters_insurance_interest": "string", "safety_reminder": "string", "subtotal": "string", "tax_1": "string", "tax_1_exempt": "string", "tax_1_rate_override": "string", "tax_2": "string", "tax_2_exempt": "string", "tenant": "string", "updated_at": "string", "use_club_credits": "string" } - schema_name_id: 1467
- schema_scan_id: 161896444
- updated: 2026-04-12 05:08:48
-
Version 1710782
- created: 2026-04-11 05:20:36
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbookings`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbookings`\n(\n `tenant` string , `id` string , `location_id` string , `customer_id` string , `creator_id` string , `admin_id` string , `billing_firstname` string , `billing_lastname` string , `billing_street1` string , `billing_street2` string , `billing_city` string , `billing_state` string , `billing_country` string , `billing_zip` string , `cc_saved_name` string , `cc_saved_last4` string , `cc_saved_profile_id` string , `cc_saved_method_id` string , `cc_saved_address_id` string , `cc_preauth_id` string , `cc_preauth_amount` string , `cc_connect_type` string , `cc_connect_id` string , `accessories_custom_price` string , `accessories_total` string , `insurance` string , `pets` string , `parking` string , `parking_override` string , `boats_total` string , `pos_total` string , `use_club_credits` string , `no_show_fee` string , `cancellation_fee` string , `club_fees` string , `club_fees_override` string , `subtotal` string , `convenience_fee` string , `convenience_fee_waived` string , `internal_application_fee` string , `tax_1` string , `tax_1_exempt` string , `tax_1_rate_override` string , `tax_2` string , `tax_2_exempt` string , `checkin_tax_1` string , `checkin_tax_2` string , `checkin_total` string , `deposit_total` string , `deposit_override` string , `deposit_waived` string , `gratuity` string , `grand_total` string , `adjustment_total` string , `amount_paid` string , `notes` string , `notes_contract` string , `notes_from_customer` string , `notes_from_customer_contract` string , `notes_for_customer` string , `notes_for_customer_contract` string , `frontend` string , `is_on_hold` string , `is_locked` string , `is_finalized` string , `is_canceled` string , `override_turnaround_time` string , `cancellation_type` string , `bypass_club_restrictions` string , `renters_insurance_interest` string , `coupon_id` string , `coupon_type` string , `coupon_amount` string , `discount_total` string , `agent_id` string , `agent_name` string , `referrer_id` string , `safety_reminder` string , `deleted_admin_id` string , `created_at` string , `updated_at` string , `finalized_at` string , `deleted_at` 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-prod/raw/stellar_imsbookings/2026-04-11/1775902577'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbookings" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbookings/2026-04-11/1775902577
- id: 1710782
- processed: 1
- raw_data:
{ "accessories_custom_price": 23, "accessories_total": 24, "adjustment_total": 53, "admin_id": 5, "agent_id": 74, "agent_name": 75, "amount_paid": 54, "billing_city": 10, "billing_country": 12, "billing_firstname": 6, "billing_lastname": 7, "billing_state": 11, "billing_street1": 8, "billing_street2": 9, "billing_zip": 13, "boats_total": 29, "bypass_club_restrictions": 68, "cancellation_fee": 33, "cancellation_type": 67, "cc_connect_id": 22, "cc_connect_type": 21, "cc_preauth_amount": 20, "cc_preauth_id": 19, "cc_saved_address_id": 18, "cc_saved_last4": 15, "cc_saved_method_id": 17, "cc_saved_name": 14, "cc_saved_profile_id": 16, "checkin_tax_1": 45, "checkin_tax_2": 46, "checkin_total": 47, "club_fees": 34, "club_fees_override": 35, "convenience_fee": 37, "convenience_fee_waived": 38, "coupon_amount": 72, "coupon_id": 70, "coupon_type": 71, "created_at": 79, "creator_id": 4, "customer_id": 3, "deleted_admin_id": 78, "deleted_at": 82, "deposit_override": 49, "deposit_total": 48, "deposit_waived": 50, "discount_total": 73, "finalized_at": 81, "frontend": 61, "grand_total": 52, "gratuity": 51, "id": 1, "insurance": 25, "internal_application_fee": 39, "is_canceled": 65, "is_finalized": 64, "is_locked": 63, "is_on_hold": 62, "location_id": 2, "no_show_fee": 32, "notes": 55, "notes_contract": 56, "notes_for_customer": 59, "notes_for_customer_contract": 60, "notes_from_customer": 57, "notes_from_customer_contract": 58, "override_turnaround_time": 66, "parking": 27, "parking_override": 28, "pets": 26, "pos_total": 30, "referrer_id": 76, "renters_insurance_interest": 69, "safety_reminder": 77, "subtotal": 36, "tax_1": 40, "tax_1_exempt": 41, "tax_1_rate_override": 42, "tax_2": 43, "tax_2_exempt": 44, "tenant": 0, "updated_at": 80, "use_club_credits": 31 } - schema_attributes:
{ "accessories_custom_price": "string", "accessories_total": "string", "adjustment_total": "string", "admin_id": "string", "agent_id": "string", "agent_name": "string", "amount_paid": "string", "billing_city": "string", "billing_country": "string", "billing_firstname": "string", "billing_lastname": "string", "billing_state": "string", "billing_street1": "string", "billing_street2": "string", "billing_zip": "string", "boats_total": "string", "bypass_club_restrictions": "string", "cancellation_fee": "string", "cancellation_type": "string", "cc_connect_id": "string", "cc_connect_type": "string", "cc_preauth_amount": "string", "cc_preauth_id": "string", "cc_saved_address_id": "string", "cc_saved_last4": "string", "cc_saved_method_id": "string", "cc_saved_name": "string", "cc_saved_profile_id": "string", "checkin_tax_1": "string", "checkin_tax_2": "string", "checkin_total": "string", "club_fees": "string", "club_fees_override": "string", "convenience_fee": "string", "convenience_fee_waived": "string", "coupon_amount": "string", "coupon_id": "string", "coupon_type": "string", "created_at": "string", "creator_id": "string", "customer_id": "string", "deleted_admin_id": "string", "deleted_at": "string", "deposit_override": "string", "deposit_total": "string", "deposit_waived": "string", "discount_total": "string", "finalized_at": "string", "frontend": "string", "grand_total": "string", "gratuity": "string", "id": "string", "insurance": "string", "internal_application_fee": "string", "is_canceled": "string", "is_finalized": "string", "is_locked": "string", "is_on_hold": "string", "location_id": "string", "no_show_fee": "string", "notes": "string", "notes_contract": "string", "notes_for_customer": "string", "notes_for_customer_contract": "string", "notes_from_customer": "string", "notes_from_customer_contract": "string", "override_turnaround_time": "string", "parking": "string", "parking_override": "string", "pets": "string", "pos_total": "string", "referrer_id": "string", "renters_insurance_interest": "string", "safety_reminder": "string", "subtotal": "string", "tax_1": "string", "tax_1_exempt": "string", "tax_1_rate_override": "string", "tax_2": "string", "tax_2_exempt": "string", "tenant": "string", "updated_at": "string", "use_club_credits": "string" } - schema_name_id: 1467
- schema_scan_id: 161844005
- updated: 2026-04-11 05:20:47
-
Version 1709597
- created: 2026-04-10 05:04:13
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbookings`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbookings`\n(\n `tenant` string , `id` string , `location_id` string , `customer_id` string , `creator_id` string , `admin_id` string , `billing_firstname` string , `billing_lastname` string , `billing_street1` string , `billing_street2` string , `billing_city` string , `billing_state` string , `billing_country` string , `billing_zip` string , `cc_saved_name` string , `cc_saved_last4` string , `cc_saved_profile_id` string , `cc_saved_method_id` string , `cc_saved_address_id` string , `cc_preauth_id` string , `cc_preauth_amount` string , `cc_connect_type` string , `cc_connect_id` string , `accessories_custom_price` string , `accessories_total` string , `insurance` string , `pets` string , `parking` string , `parking_override` string , `boats_total` string , `pos_total` string , `use_club_credits` string , `no_show_fee` string , `cancellation_fee` string , `club_fees` string , `club_fees_override` string , `subtotal` string , `convenience_fee` string , `convenience_fee_waived` string , `internal_application_fee` string , `tax_1` string , `tax_1_exempt` string , `tax_1_rate_override` string , `tax_2` string , `tax_2_exempt` string , `checkin_tax_1` string , `checkin_tax_2` string , `checkin_total` string , `deposit_total` string , `deposit_override` string , `deposit_waived` string , `gratuity` string , `grand_total` string , `adjustment_total` string , `amount_paid` string , `notes` string , `notes_contract` string , `notes_from_customer` string , `notes_from_customer_contract` string , `notes_for_customer` string , `notes_for_customer_contract` string , `frontend` string , `is_on_hold` string , `is_locked` string , `is_finalized` string , `is_canceled` string , `override_turnaround_time` string , `cancellation_type` string , `bypass_club_restrictions` string , `renters_insurance_interest` string , `coupon_id` string , `coupon_type` string , `coupon_amount` string , `discount_total` string , `agent_id` string , `agent_name` string , `referrer_id` string , `safety_reminder` string , `deleted_admin_id` string , `created_at` string , `updated_at` string , `finalized_at` string , `deleted_at` 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-prod/raw/stellar_imsbookings/2026-04-10/1775815218'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbookings" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbookings/2026-04-10/1775815218
- id: 1709597
- processed: 1
- raw_data:
{ "accessories_custom_price": 23, "accessories_total": 24, "adjustment_total": 53, "admin_id": 5, "agent_id": 74, "agent_name": 75, "amount_paid": 54, "billing_city": 10, "billing_country": 12, "billing_firstname": 6, "billing_lastname": 7, "billing_state": 11, "billing_street1": 8, "billing_street2": 9, "billing_zip": 13, "boats_total": 29, "bypass_club_restrictions": 68, "cancellation_fee": 33, "cancellation_type": 67, "cc_connect_id": 22, "cc_connect_type": 21, "cc_preauth_amount": 20, "cc_preauth_id": 19, "cc_saved_address_id": 18, "cc_saved_last4": 15, "cc_saved_method_id": 17, "cc_saved_name": 14, "cc_saved_profile_id": 16, "checkin_tax_1": 45, "checkin_tax_2": 46, "checkin_total": 47, "club_fees": 34, "club_fees_override": 35, "convenience_fee": 37, "convenience_fee_waived": 38, "coupon_amount": 72, "coupon_id": 70, "coupon_type": 71, "created_at": 79, "creator_id": 4, "customer_id": 3, "deleted_admin_id": 78, "deleted_at": 82, "deposit_override": 49, "deposit_total": 48, "deposit_waived": 50, "discount_total": 73, "finalized_at": 81, "frontend": 61, "grand_total": 52, "gratuity": 51, "id": 1, "insurance": 25, "internal_application_fee": 39, "is_canceled": 65, "is_finalized": 64, "is_locked": 63, "is_on_hold": 62, "location_id": 2, "no_show_fee": 32, "notes": 55, "notes_contract": 56, "notes_for_customer": 59, "notes_for_customer_contract": 60, "notes_from_customer": 57, "notes_from_customer_contract": 58, "override_turnaround_time": 66, "parking": 27, "parking_override": 28, "pets": 26, "pos_total": 30, "referrer_id": 76, "renters_insurance_interest": 69, "safety_reminder": 77, "subtotal": 36, "tax_1": 40, "tax_1_exempt": 41, "tax_1_rate_override": 42, "tax_2": 43, "tax_2_exempt": 44, "tenant": 0, "updated_at": 80, "use_club_credits": 31 } - schema_attributes:
{ "accessories_custom_price": "string", "accessories_total": "string", "adjustment_total": "string", "admin_id": "string", "agent_id": "string", "agent_name": "string", "amount_paid": "string", "billing_city": "string", "billing_country": "string", "billing_firstname": "string", "billing_lastname": "string", "billing_state": "string", "billing_street1": "string", "billing_street2": "string", "billing_zip": "string", "boats_total": "string", "bypass_club_restrictions": "string", "cancellation_fee": "string", "cancellation_type": "string", "cc_connect_id": "string", "cc_connect_type": "string", "cc_preauth_amount": "string", "cc_preauth_id": "string", "cc_saved_address_id": "string", "cc_saved_last4": "string", "cc_saved_method_id": "string", "cc_saved_name": "string", "cc_saved_profile_id": "string", "checkin_tax_1": "string", "checkin_tax_2": "string", "checkin_total": "string", "club_fees": "string", "club_fees_override": "string", "convenience_fee": "string", "convenience_fee_waived": "string", "coupon_amount": "string", "coupon_id": "string", "coupon_type": "string", "created_at": "string", "creator_id": "string", "customer_id": "string", "deleted_admin_id": "string", "deleted_at": "string", "deposit_override": "string", "deposit_total": "string", "deposit_waived": "string", "discount_total": "string", "finalized_at": "string", "frontend": "string", "grand_total": "string", "gratuity": "string", "id": "string", "insurance": "string", "internal_application_fee": "string", "is_canceled": "string", "is_finalized": "string", "is_locked": "string", "is_on_hold": "string", "location_id": "string", "no_show_fee": "string", "notes": "string", "notes_contract": "string", "notes_for_customer": "string", "notes_for_customer_contract": "string", "notes_from_customer": "string", "notes_from_customer_contract": "string", "override_turnaround_time": "string", "parking": "string", "parking_override": "string", "pets": "string", "pos_total": "string", "referrer_id": "string", "renters_insurance_interest": "string", "safety_reminder": "string", "subtotal": "string", "tax_1": "string", "tax_1_exempt": "string", "tax_1_rate_override": "string", "tax_2": "string", "tax_2_exempt": "string", "tenant": "string", "updated_at": "string", "use_club_credits": "string" } - schema_name_id: 1467
- schema_scan_id: 161788648
- updated: 2026-04-10 05:04:27
-
Version 1708465
- created: 2026-04-09 05:04:56
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbookings`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbookings`\n(\n `tenant` string , `id` string , `location_id` string , `customer_id` string , `creator_id` string , `admin_id` string , `billing_firstname` string , `billing_lastname` string , `billing_street1` string , `billing_street2` string , `billing_city` string , `billing_state` string , `billing_country` string , `billing_zip` string , `cc_saved_name` string , `cc_saved_last4` string , `cc_saved_profile_id` string , `cc_saved_method_id` string , `cc_saved_address_id` string , `cc_preauth_id` string , `cc_preauth_amount` string , `cc_connect_type` string , `cc_connect_id` string , `accessories_custom_price` string , `accessories_total` string , `insurance` string , `pets` string , `parking` string , `parking_override` string , `boats_total` string , `pos_total` string , `use_club_credits` string , `no_show_fee` string , `cancellation_fee` string , `club_fees` string , `club_fees_override` string , `subtotal` string , `convenience_fee` string , `convenience_fee_waived` string , `internal_application_fee` string , `tax_1` string , `tax_1_exempt` string , `tax_1_rate_override` string , `tax_2` string , `tax_2_exempt` string , `checkin_tax_1` string , `checkin_tax_2` string , `checkin_total` string , `deposit_total` string , `deposit_override` string , `deposit_waived` string , `gratuity` string , `grand_total` string , `adjustment_total` string , `amount_paid` string , `notes` string , `notes_contract` string , `notes_from_customer` string , `notes_from_customer_contract` string , `notes_for_customer` string , `notes_for_customer_contract` string , `frontend` string , `is_on_hold` string , `is_locked` string , `is_finalized` string , `is_canceled` string , `override_turnaround_time` string , `cancellation_type` string , `bypass_club_restrictions` string , `renters_insurance_interest` string , `coupon_id` string , `coupon_type` string , `coupon_amount` string , `discount_total` string , `agent_id` string , `agent_name` string , `referrer_id` string , `safety_reminder` string , `deleted_admin_id` string , `created_at` string , `updated_at` string , `finalized_at` string , `deleted_at` 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-prod/raw/stellar_imsbookings/2026-04-09/1775728838'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbookings" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbookings/2026-04-09/1775728838
- id: 1708465
- processed: 1
- raw_data:
{ "accessories_custom_price": 23, "accessories_total": 24, "adjustment_total": 53, "admin_id": 5, "agent_id": 74, "agent_name": 75, "amount_paid": 54, "billing_city": 10, "billing_country": 12, "billing_firstname": 6, "billing_lastname": 7, "billing_state": 11, "billing_street1": 8, "billing_street2": 9, "billing_zip": 13, "boats_total": 29, "bypass_club_restrictions": 68, "cancellation_fee": 33, "cancellation_type": 67, "cc_connect_id": 22, "cc_connect_type": 21, "cc_preauth_amount": 20, "cc_preauth_id": 19, "cc_saved_address_id": 18, "cc_saved_last4": 15, "cc_saved_method_id": 17, "cc_saved_name": 14, "cc_saved_profile_id": 16, "checkin_tax_1": 45, "checkin_tax_2": 46, "checkin_total": 47, "club_fees": 34, "club_fees_override": 35, "convenience_fee": 37, "convenience_fee_waived": 38, "coupon_amount": 72, "coupon_id": 70, "coupon_type": 71, "created_at": 79, "creator_id": 4, "customer_id": 3, "deleted_admin_id": 78, "deleted_at": 82, "deposit_override": 49, "deposit_total": 48, "deposit_waived": 50, "discount_total": 73, "finalized_at": 81, "frontend": 61, "grand_total": 52, "gratuity": 51, "id": 1, "insurance": 25, "internal_application_fee": 39, "is_canceled": 65, "is_finalized": 64, "is_locked": 63, "is_on_hold": 62, "location_id": 2, "no_show_fee": 32, "notes": 55, "notes_contract": 56, "notes_for_customer": 59, "notes_for_customer_contract": 60, "notes_from_customer": 57, "notes_from_customer_contract": 58, "override_turnaround_time": 66, "parking": 27, "parking_override": 28, "pets": 26, "pos_total": 30, "referrer_id": 76, "renters_insurance_interest": 69, "safety_reminder": 77, "subtotal": 36, "tax_1": 40, "tax_1_exempt": 41, "tax_1_rate_override": 42, "tax_2": 43, "tax_2_exempt": 44, "tenant": 0, "updated_at": 80, "use_club_credits": 31 } - schema_attributes:
{ "accessories_custom_price": "string", "accessories_total": "string", "adjustment_total": "string", "admin_id": "string", "agent_id": "string", "agent_name": "string", "amount_paid": "string", "billing_city": "string", "billing_country": "string", "billing_firstname": "string", "billing_lastname": "string", "billing_state": "string", "billing_street1": "string", "billing_street2": "string", "billing_zip": "string", "boats_total": "string", "bypass_club_restrictions": "string", "cancellation_fee": "string", "cancellation_type": "string", "cc_connect_id": "string", "cc_connect_type": "string", "cc_preauth_amount": "string", "cc_preauth_id": "string", "cc_saved_address_id": "string", "cc_saved_last4": "string", "cc_saved_method_id": "string", "cc_saved_name": "string", "cc_saved_profile_id": "string", "checkin_tax_1": "string", "checkin_tax_2": "string", "checkin_total": "string", "club_fees": "string", "club_fees_override": "string", "convenience_fee": "string", "convenience_fee_waived": "string", "coupon_amount": "string", "coupon_id": "string", "coupon_type": "string", "created_at": "string", "creator_id": "string", "customer_id": "string", "deleted_admin_id": "string", "deleted_at": "string", "deposit_override": "string", "deposit_total": "string", "deposit_waived": "string", "discount_total": "string", "finalized_at": "string", "frontend": "string", "grand_total": "string", "gratuity": "string", "id": "string", "insurance": "string", "internal_application_fee": "string", "is_canceled": "string", "is_finalized": "string", "is_locked": "string", "is_on_hold": "string", "location_id": "string", "no_show_fee": "string", "notes": "string", "notes_contract": "string", "notes_for_customer": "string", "notes_for_customer_contract": "string", "notes_from_customer": "string", "notes_from_customer_contract": "string", "override_turnaround_time": "string", "parking": "string", "parking_override": "string", "pets": "string", "pos_total": "string", "referrer_id": "string", "renters_insurance_interest": "string", "safety_reminder": "string", "subtotal": "string", "tax_1": "string", "tax_1_exempt": "string", "tax_1_rate_override": "string", "tax_2": "string", "tax_2_exempt": "string", "tenant": "string", "updated_at": "string", "use_club_credits": "string" } - schema_name_id: 1467
- schema_scan_id: 161733030
- updated: 2026-04-09 05:05:09
-
Version 1707282
- created: 2026-04-08 05:16:02
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbookings`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbookings`\n(\n `tenant` string , `id` string , `location_id` string , `customer_id` string , `creator_id` string , `admin_id` string , `billing_firstname` string , `billing_lastname` string , `billing_street1` string , `billing_street2` string , `billing_city` string , `billing_state` string , `billing_country` string , `billing_zip` string , `cc_saved_name` string , `cc_saved_last4` string , `cc_saved_profile_id` string , `cc_saved_method_id` string , `cc_saved_address_id` string , `cc_preauth_id` string , `cc_preauth_amount` string , `cc_connect_type` string , `cc_connect_id` string , `accessories_custom_price` string , `accessories_total` string , `insurance` string , `pets` string , `parking` string , `parking_override` string , `boats_total` string , `pos_total` string , `use_club_credits` string , `no_show_fee` string , `cancellation_fee` string , `club_fees` string , `club_fees_override` string , `subtotal` string , `convenience_fee` string , `convenience_fee_waived` string , `internal_application_fee` string , `tax_1` string , `tax_1_exempt` string , `tax_1_rate_override` string , `tax_2` string , `tax_2_exempt` string , `checkin_tax_1` string , `checkin_tax_2` string , `checkin_total` string , `deposit_total` string , `deposit_override` string , `deposit_waived` string , `gratuity` string , `grand_total` string , `adjustment_total` string , `amount_paid` string , `notes` string , `notes_contract` string , `notes_from_customer` string , `notes_from_customer_contract` string , `notes_for_customer` string , `notes_for_customer_contract` string , `frontend` string , `is_on_hold` string , `is_locked` string , `is_finalized` string , `is_canceled` string , `override_turnaround_time` string , `cancellation_type` string , `bypass_club_restrictions` string , `renters_insurance_interest` string , `coupon_id` string , `coupon_type` string , `coupon_amount` string , `discount_total` string , `agent_id` string , `agent_name` string , `referrer_id` string , `safety_reminder` string , `deleted_admin_id` string , `created_at` string , `updated_at` string , `finalized_at` string , `deleted_at` 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-prod/raw/stellar_imsbookings/2026-04-08/1775643000'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbookings" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbookings/2026-04-08/1775643000
- id: 1707282
- processed: 1
- raw_data:
{ "accessories_custom_price": 23, "accessories_total": 24, "adjustment_total": 53, "admin_id": 5, "agent_id": 74, "agent_name": 75, "amount_paid": 54, "billing_city": 10, "billing_country": 12, "billing_firstname": 6, "billing_lastname": 7, "billing_state": 11, "billing_street1": 8, "billing_street2": 9, "billing_zip": 13, "boats_total": 29, "bypass_club_restrictions": 68, "cancellation_fee": 33, "cancellation_type": 67, "cc_connect_id": 22, "cc_connect_type": 21, "cc_preauth_amount": 20, "cc_preauth_id": 19, "cc_saved_address_id": 18, "cc_saved_last4": 15, "cc_saved_method_id": 17, "cc_saved_name": 14, "cc_saved_profile_id": 16, "checkin_tax_1": 45, "checkin_tax_2": 46, "checkin_total": 47, "club_fees": 34, "club_fees_override": 35, "convenience_fee": 37, "convenience_fee_waived": 38, "coupon_amount": 72, "coupon_id": 70, "coupon_type": 71, "created_at": 79, "creator_id": 4, "customer_id": 3, "deleted_admin_id": 78, "deleted_at": 82, "deposit_override": 49, "deposit_total": 48, "deposit_waived": 50, "discount_total": 73, "finalized_at": 81, "frontend": 61, "grand_total": 52, "gratuity": 51, "id": 1, "insurance": 25, "internal_application_fee": 39, "is_canceled": 65, "is_finalized": 64, "is_locked": 63, "is_on_hold": 62, "location_id": 2, "no_show_fee": 32, "notes": 55, "notes_contract": 56, "notes_for_customer": 59, "notes_for_customer_contract": 60, "notes_from_customer": 57, "notes_from_customer_contract": 58, "override_turnaround_time": 66, "parking": 27, "parking_override": 28, "pets": 26, "pos_total": 30, "referrer_id": 76, "renters_insurance_interest": 69, "safety_reminder": 77, "subtotal": 36, "tax_1": 40, "tax_1_exempt": 41, "tax_1_rate_override": 42, "tax_2": 43, "tax_2_exempt": 44, "tenant": 0, "updated_at": 80, "use_club_credits": 31 } - schema_attributes:
{ "accessories_custom_price": "string", "accessories_total": "string", "adjustment_total": "string", "admin_id": "string", "agent_id": "string", "agent_name": "string", "amount_paid": "string", "billing_city": "string", "billing_country": "string", "billing_firstname": "string", "billing_lastname": "string", "billing_state": "string", "billing_street1": "string", "billing_street2": "string", "billing_zip": "string", "boats_total": "string", "bypass_club_restrictions": "string", "cancellation_fee": "string", "cancellation_type": "string", "cc_connect_id": "string", "cc_connect_type": "string", "cc_preauth_amount": "string", "cc_preauth_id": "string", "cc_saved_address_id": "string", "cc_saved_last4": "string", "cc_saved_method_id": "string", "cc_saved_name": "string", "cc_saved_profile_id": "string", "checkin_tax_1": "string", "checkin_tax_2": "string", "checkin_total": "string", "club_fees": "string", "club_fees_override": "string", "convenience_fee": "string", "convenience_fee_waived": "string", "coupon_amount": "string", "coupon_id": "string", "coupon_type": "string", "created_at": "string", "creator_id": "string", "customer_id": "string", "deleted_admin_id": "string", "deleted_at": "string", "deposit_override": "string", "deposit_total": "string", "deposit_waived": "string", "discount_total": "string", "finalized_at": "string", "frontend": "string", "grand_total": "string", "gratuity": "string", "id": "string", "insurance": "string", "internal_application_fee": "string", "is_canceled": "string", "is_finalized": "string", "is_locked": "string", "is_on_hold": "string", "location_id": "string", "no_show_fee": "string", "notes": "string", "notes_contract": "string", "notes_for_customer": "string", "notes_for_customer_contract": "string", "notes_from_customer": "string", "notes_from_customer_contract": "string", "override_turnaround_time": "string", "parking": "string", "parking_override": "string", "pets": "string", "pos_total": "string", "referrer_id": "string", "renters_insurance_interest": "string", "safety_reminder": "string", "subtotal": "string", "tax_1": "string", "tax_1_exempt": "string", "tax_1_rate_override": "string", "tax_2": "string", "tax_2_exempt": "string", "tenant": "string", "updated_at": "string", "use_club_credits": "string" } - schema_name_id: 1467
- schema_scan_id: 161678441
- updated: 2026-04-08 05:16:13
-
Version 1706088
- created: 2026-04-07 05:19:11
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbookings`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbookings`\n(\n `tenant` string , `id` string , `location_id` string , `customer_id` string , `creator_id` string , `admin_id` string , `billing_firstname` string , `billing_lastname` string , `billing_street1` string , `billing_street2` string , `billing_city` string , `billing_state` string , `billing_country` string , `billing_zip` string , `cc_saved_name` string , `cc_saved_last4` string , `cc_saved_profile_id` string , `cc_saved_method_id` string , `cc_saved_address_id` string , `cc_preauth_id` string , `cc_preauth_amount` string , `cc_connect_type` string , `cc_connect_id` string , `accessories_custom_price` string , `accessories_total` string , `insurance` string , `pets` string , `parking` string , `parking_override` string , `boats_total` string , `pos_total` string , `use_club_credits` string , `no_show_fee` string , `cancellation_fee` string , `club_fees` string , `club_fees_override` string , `subtotal` string , `convenience_fee` string , `convenience_fee_waived` string , `internal_application_fee` string , `tax_1` string , `tax_1_exempt` string , `tax_1_rate_override` string , `tax_2` string , `tax_2_exempt` string , `checkin_tax_1` string , `checkin_tax_2` string , `checkin_total` string , `deposit_total` string , `deposit_override` string , `deposit_waived` string , `gratuity` string , `grand_total` string , `adjustment_total` string , `amount_paid` string , `notes` string , `notes_contract` string , `notes_from_customer` string , `notes_from_customer_contract` string , `notes_for_customer` string , `notes_for_customer_contract` string , `frontend` string , `is_on_hold` string , `is_locked` string , `is_finalized` string , `is_canceled` string , `override_turnaround_time` string , `cancellation_type` string , `bypass_club_restrictions` string , `renters_insurance_interest` string , `coupon_id` string , `coupon_type` string , `coupon_amount` string , `discount_total` string , `agent_id` string , `agent_name` string , `referrer_id` string , `safety_reminder` string , `deleted_admin_id` string , `created_at` string , `updated_at` string , `finalized_at` string , `deleted_at` 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-prod/raw/stellar_imsbookings/2026-04-07/1775556859'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbookings" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbookings/2026-04-07/1775556859
- id: 1706088
- processed: 1
- raw_data:
{ "accessories_custom_price": 23, "accessories_total": 24, "adjustment_total": 53, "admin_id": 5, "agent_id": 74, "agent_name": 75, "amount_paid": 54, "billing_city": 10, "billing_country": 12, "billing_firstname": 6, "billing_lastname": 7, "billing_state": 11, "billing_street1": 8, "billing_street2": 9, "billing_zip": 13, "boats_total": 29, "bypass_club_restrictions": 68, "cancellation_fee": 33, "cancellation_type": 67, "cc_connect_id": 22, "cc_connect_type": 21, "cc_preauth_amount": 20, "cc_preauth_id": 19, "cc_saved_address_id": 18, "cc_saved_last4": 15, "cc_saved_method_id": 17, "cc_saved_name": 14, "cc_saved_profile_id": 16, "checkin_tax_1": 45, "checkin_tax_2": 46, "checkin_total": 47, "club_fees": 34, "club_fees_override": 35, "convenience_fee": 37, "convenience_fee_waived": 38, "coupon_amount": 72, "coupon_id": 70, "coupon_type": 71, "created_at": 79, "creator_id": 4, "customer_id": 3, "deleted_admin_id": 78, "deleted_at": 82, "deposit_override": 49, "deposit_total": 48, "deposit_waived": 50, "discount_total": 73, "finalized_at": 81, "frontend": 61, "grand_total": 52, "gratuity": 51, "id": 1, "insurance": 25, "internal_application_fee": 39, "is_canceled": 65, "is_finalized": 64, "is_locked": 63, "is_on_hold": 62, "location_id": 2, "no_show_fee": 32, "notes": 55, "notes_contract": 56, "notes_for_customer": 59, "notes_for_customer_contract": 60, "notes_from_customer": 57, "notes_from_customer_contract": 58, "override_turnaround_time": 66, "parking": 27, "parking_override": 28, "pets": 26, "pos_total": 30, "referrer_id": 76, "renters_insurance_interest": 69, "safety_reminder": 77, "subtotal": 36, "tax_1": 40, "tax_1_exempt": 41, "tax_1_rate_override": 42, "tax_2": 43, "tax_2_exempt": 44, "tenant": 0, "updated_at": 80, "use_club_credits": 31 } - schema_attributes:
{ "accessories_custom_price": "string", "accessories_total": "string", "adjustment_total": "string", "admin_id": "string", "agent_id": "string", "agent_name": "string", "amount_paid": "string", "billing_city": "string", "billing_country": "string", "billing_firstname": "string", "billing_lastname": "string", "billing_state": "string", "billing_street1": "string", "billing_street2": "string", "billing_zip": "string", "boats_total": "string", "bypass_club_restrictions": "string", "cancellation_fee": "string", "cancellation_type": "string", "cc_connect_id": "string", "cc_connect_type": "string", "cc_preauth_amount": "string", "cc_preauth_id": "string", "cc_saved_address_id": "string", "cc_saved_last4": "string", "cc_saved_method_id": "string", "cc_saved_name": "string", "cc_saved_profile_id": "string", "checkin_tax_1": "string", "checkin_tax_2": "string", "checkin_total": "string", "club_fees": "string", "club_fees_override": "string", "convenience_fee": "string", "convenience_fee_waived": "string", "coupon_amount": "string", "coupon_id": "string", "coupon_type": "string", "created_at": "string", "creator_id": "string", "customer_id": "string", "deleted_admin_id": "string", "deleted_at": "string", "deposit_override": "string", "deposit_total": "string", "deposit_waived": "string", "discount_total": "string", "finalized_at": "string", "frontend": "string", "grand_total": "string", "gratuity": "string", "id": "string", "insurance": "string", "internal_application_fee": "string", "is_canceled": "string", "is_finalized": "string", "is_locked": "string", "is_on_hold": "string", "location_id": "string", "no_show_fee": "string", "notes": "string", "notes_contract": "string", "notes_for_customer": "string", "notes_for_customer_contract": "string", "notes_from_customer": "string", "notes_from_customer_contract": "string", "override_turnaround_time": "string", "parking": "string", "parking_override": "string", "pets": "string", "pos_total": "string", "referrer_id": "string", "renters_insurance_interest": "string", "safety_reminder": "string", "subtotal": "string", "tax_1": "string", "tax_1_exempt": "string", "tax_1_rate_override": "string", "tax_2": "string", "tax_2_exempt": "string", "tenant": "string", "updated_at": "string", "use_club_credits": "string" } - schema_name_id: 1467
- schema_scan_id: 161622181
- updated: 2026-04-07 05:19:22
-
Version 1704795
- created: 2026-04-06 05:17:37
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbookings`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbookings`\n(\n `tenant` string , `id` string , `location_id` string , `customer_id` string , `creator_id` string , `admin_id` string , `billing_firstname` string , `billing_lastname` string , `billing_street1` string , `billing_street2` string , `billing_city` string , `billing_state` string , `billing_country` string , `billing_zip` string , `cc_saved_name` string , `cc_saved_last4` string , `cc_saved_profile_id` string , `cc_saved_method_id` string , `cc_saved_address_id` string , `cc_preauth_id` string , `cc_preauth_amount` string , `cc_connect_type` string , `cc_connect_id` string , `accessories_custom_price` string , `accessories_total` string , `insurance` string , `pets` string , `parking` string , `parking_override` string , `boats_total` string , `pos_total` string , `use_club_credits` string , `no_show_fee` string , `cancellation_fee` string , `club_fees` string , `club_fees_override` string , `subtotal` string , `convenience_fee` string , `convenience_fee_waived` string , `internal_application_fee` string , `tax_1` string , `tax_1_exempt` string , `tax_1_rate_override` string , `tax_2` string , `tax_2_exempt` string , `checkin_tax_1` string , `checkin_tax_2` string , `checkin_total` string , `deposit_total` string , `deposit_override` string , `deposit_waived` string , `gratuity` string , `grand_total` string , `adjustment_total` string , `amount_paid` string , `notes` string , `notes_contract` string , `notes_from_customer` string , `notes_from_customer_contract` string , `notes_for_customer` string , `notes_for_customer_contract` string , `frontend` string , `is_on_hold` string , `is_locked` string , `is_finalized` string , `is_canceled` string , `override_turnaround_time` string , `cancellation_type` string , `bypass_club_restrictions` string , `renters_insurance_interest` string , `coupon_id` string , `coupon_type` string , `coupon_amount` string , `discount_total` string , `agent_id` string , `agent_name` string , `referrer_id` string , `safety_reminder` string , `deleted_admin_id` string , `created_at` string , `updated_at` string , `finalized_at` string , `deleted_at` 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-prod/raw/stellar_imsbookings/2026-04-06/1775470528'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbookings" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbookings/2026-04-06/1775470528
- id: 1704795
- processed: 1
- raw_data:
{ "accessories_custom_price": 23, "accessories_total": 24, "adjustment_total": 53, "admin_id": 5, "agent_id": 74, "agent_name": 75, "amount_paid": 54, "billing_city": 10, "billing_country": 12, "billing_firstname": 6, "billing_lastname": 7, "billing_state": 11, "billing_street1": 8, "billing_street2": 9, "billing_zip": 13, "boats_total": 29, "bypass_club_restrictions": 68, "cancellation_fee": 33, "cancellation_type": 67, "cc_connect_id": 22, "cc_connect_type": 21, "cc_preauth_amount": 20, "cc_preauth_id": 19, "cc_saved_address_id": 18, "cc_saved_last4": 15, "cc_saved_method_id": 17, "cc_saved_name": 14, "cc_saved_profile_id": 16, "checkin_tax_1": 45, "checkin_tax_2": 46, "checkin_total": 47, "club_fees": 34, "club_fees_override": 35, "convenience_fee": 37, "convenience_fee_waived": 38, "coupon_amount": 72, "coupon_id": 70, "coupon_type": 71, "created_at": 79, "creator_id": 4, "customer_id": 3, "deleted_admin_id": 78, "deleted_at": 82, "deposit_override": 49, "deposit_total": 48, "deposit_waived": 50, "discount_total": 73, "finalized_at": 81, "frontend": 61, "grand_total": 52, "gratuity": 51, "id": 1, "insurance": 25, "internal_application_fee": 39, "is_canceled": 65, "is_finalized": 64, "is_locked": 63, "is_on_hold": 62, "location_id": 2, "no_show_fee": 32, "notes": 55, "notes_contract": 56, "notes_for_customer": 59, "notes_for_customer_contract": 60, "notes_from_customer": 57, "notes_from_customer_contract": 58, "override_turnaround_time": 66, "parking": 27, "parking_override": 28, "pets": 26, "pos_total": 30, "referrer_id": 76, "renters_insurance_interest": 69, "safety_reminder": 77, "subtotal": 36, "tax_1": 40, "tax_1_exempt": 41, "tax_1_rate_override": 42, "tax_2": 43, "tax_2_exempt": 44, "tenant": 0, "updated_at": 80, "use_club_credits": 31 } - schema_attributes:
{ "accessories_custom_price": "string", "accessories_total": "string", "adjustment_total": "string", "admin_id": "string", "agent_id": "string", "agent_name": "string", "amount_paid": "string", "billing_city": "string", "billing_country": "string", "billing_firstname": "string", "billing_lastname": "string", "billing_state": "string", "billing_street1": "string", "billing_street2": "string", "billing_zip": "string", "boats_total": "string", "bypass_club_restrictions": "string", "cancellation_fee": "string", "cancellation_type": "string", "cc_connect_id": "string", "cc_connect_type": "string", "cc_preauth_amount": "string", "cc_preauth_id": "string", "cc_saved_address_id": "string", "cc_saved_last4": "string", "cc_saved_method_id": "string", "cc_saved_name": "string", "cc_saved_profile_id": "string", "checkin_tax_1": "string", "checkin_tax_2": "string", "checkin_total": "string", "club_fees": "string", "club_fees_override": "string", "convenience_fee": "string", "convenience_fee_waived": "string", "coupon_amount": "string", "coupon_id": "string", "coupon_type": "string", "created_at": "string", "creator_id": "string", "customer_id": "string", "deleted_admin_id": "string", "deleted_at": "string", "deposit_override": "string", "deposit_total": "string", "deposit_waived": "string", "discount_total": "string", "finalized_at": "string", "frontend": "string", "grand_total": "string", "gratuity": "string", "id": "string", "insurance": "string", "internal_application_fee": "string", "is_canceled": "string", "is_finalized": "string", "is_locked": "string", "is_on_hold": "string", "location_id": "string", "no_show_fee": "string", "notes": "string", "notes_contract": "string", "notes_for_customer": "string", "notes_for_customer_contract": "string", "notes_from_customer": "string", "notes_from_customer_contract": "string", "override_turnaround_time": "string", "parking": "string", "parking_override": "string", "pets": "string", "pos_total": "string", "referrer_id": "string", "renters_insurance_interest": "string", "safety_reminder": "string", "subtotal": "string", "tax_1": "string", "tax_1_exempt": "string", "tax_1_rate_override": "string", "tax_2": "string", "tax_2_exempt": "string", "tenant": "string", "updated_at": "string", "use_club_credits": "string" } - schema_name_id: 1467
- schema_scan_id: 161564265
- updated: 2026-04-06 05:17:48
-
Version 1703621
- created: 2026-04-05 04:59:18
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbookings`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbookings`\n(\n `tenant` string , `id` string , `location_id` string , `customer_id` string , `creator_id` string , `admin_id` string , `billing_firstname` string , `billing_lastname` string , `billing_street1` string , `billing_street2` string , `billing_city` string , `billing_state` string , `billing_country` string , `billing_zip` string , `cc_saved_name` string , `cc_saved_last4` string , `cc_saved_profile_id` string , `cc_saved_method_id` string , `cc_saved_address_id` string , `cc_preauth_id` string , `cc_preauth_amount` string , `cc_connect_type` string , `cc_connect_id` string , `accessories_custom_price` string , `accessories_total` string , `insurance` string , `pets` string , `parking` string , `parking_override` string , `boats_total` string , `pos_total` string , `use_club_credits` string , `no_show_fee` string , `cancellation_fee` string , `club_fees` string , `club_fees_override` string , `subtotal` string , `convenience_fee` string , `convenience_fee_waived` string , `internal_application_fee` string , `tax_1` string , `tax_1_exempt` string , `tax_1_rate_override` string , `tax_2` string , `tax_2_exempt` string , `checkin_tax_1` string , `checkin_tax_2` string , `checkin_total` string , `deposit_total` string , `deposit_override` string , `deposit_waived` string , `gratuity` string , `grand_total` string , `adjustment_total` string , `amount_paid` string , `notes` string , `notes_contract` string , `notes_from_customer` string , `notes_from_customer_contract` string , `notes_for_customer` string , `notes_for_customer_contract` string , `frontend` string , `is_on_hold` string , `is_locked` string , `is_finalized` string , `is_canceled` string , `override_turnaround_time` string , `cancellation_type` string , `bypass_club_restrictions` string , `renters_insurance_interest` string , `coupon_id` string , `coupon_type` string , `coupon_amount` string , `discount_total` string , `agent_id` string , `agent_name` string , `referrer_id` string , `safety_reminder` string , `deleted_admin_id` string , `created_at` string , `updated_at` string , `finalized_at` string , `deleted_at` 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-prod/raw/stellar_imsbookings/2026-04-05/1775382946'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbookings" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbookings/2026-04-05/1775382946
- id: 1703621
- processed: 1
- raw_data:
{ "accessories_custom_price": 23, "accessories_total": 24, "adjustment_total": 53, "admin_id": 5, "agent_id": 74, "agent_name": 75, "amount_paid": 54, "billing_city": 10, "billing_country": 12, "billing_firstname": 6, "billing_lastname": 7, "billing_state": 11, "billing_street1": 8, "billing_street2": 9, "billing_zip": 13, "boats_total": 29, "bypass_club_restrictions": 68, "cancellation_fee": 33, "cancellation_type": 67, "cc_connect_id": 22, "cc_connect_type": 21, "cc_preauth_amount": 20, "cc_preauth_id": 19, "cc_saved_address_id": 18, "cc_saved_last4": 15, "cc_saved_method_id": 17, "cc_saved_name": 14, "cc_saved_profile_id": 16, "checkin_tax_1": 45, "checkin_tax_2": 46, "checkin_total": 47, "club_fees": 34, "club_fees_override": 35, "convenience_fee": 37, "convenience_fee_waived": 38, "coupon_amount": 72, "coupon_id": 70, "coupon_type": 71, "created_at": 79, "creator_id": 4, "customer_id": 3, "deleted_admin_id": 78, "deleted_at": 82, "deposit_override": 49, "deposit_total": 48, "deposit_waived": 50, "discount_total": 73, "finalized_at": 81, "frontend": 61, "grand_total": 52, "gratuity": 51, "id": 1, "insurance": 25, "internal_application_fee": 39, "is_canceled": 65, "is_finalized": 64, "is_locked": 63, "is_on_hold": 62, "location_id": 2, "no_show_fee": 32, "notes": 55, "notes_contract": 56, "notes_for_customer": 59, "notes_for_customer_contract": 60, "notes_from_customer": 57, "notes_from_customer_contract": 58, "override_turnaround_time": 66, "parking": 27, "parking_override": 28, "pets": 26, "pos_total": 30, "referrer_id": 76, "renters_insurance_interest": 69, "safety_reminder": 77, "subtotal": 36, "tax_1": 40, "tax_1_exempt": 41, "tax_1_rate_override": 42, "tax_2": 43, "tax_2_exempt": 44, "tenant": 0, "updated_at": 80, "use_club_credits": 31 } - schema_attributes:
{ "accessories_custom_price": "string", "accessories_total": "string", "adjustment_total": "string", "admin_id": "string", "agent_id": "string", "agent_name": "string", "amount_paid": "string", "billing_city": "string", "billing_country": "string", "billing_firstname": "string", "billing_lastname": "string", "billing_state": "string", "billing_street1": "string", "billing_street2": "string", "billing_zip": "string", "boats_total": "string", "bypass_club_restrictions": "string", "cancellation_fee": "string", "cancellation_type": "string", "cc_connect_id": "string", "cc_connect_type": "string", "cc_preauth_amount": "string", "cc_preauth_id": "string", "cc_saved_address_id": "string", "cc_saved_last4": "string", "cc_saved_method_id": "string", "cc_saved_name": "string", "cc_saved_profile_id": "string", "checkin_tax_1": "string", "checkin_tax_2": "string", "checkin_total": "string", "club_fees": "string", "club_fees_override": "string", "convenience_fee": "string", "convenience_fee_waived": "string", "coupon_amount": "string", "coupon_id": "string", "coupon_type": "string", "created_at": "string", "creator_id": "string", "customer_id": "string", "deleted_admin_id": "string", "deleted_at": "string", "deposit_override": "string", "deposit_total": "string", "deposit_waived": "string", "discount_total": "string", "finalized_at": "string", "frontend": "string", "grand_total": "string", "gratuity": "string", "id": "string", "insurance": "string", "internal_application_fee": "string", "is_canceled": "string", "is_finalized": "string", "is_locked": "string", "is_on_hold": "string", "location_id": "string", "no_show_fee": "string", "notes": "string", "notes_contract": "string", "notes_for_customer": "string", "notes_for_customer_contract": "string", "notes_from_customer": "string", "notes_from_customer_contract": "string", "override_turnaround_time": "string", "parking": "string", "parking_override": "string", "pets": "string", "pos_total": "string", "referrer_id": "string", "renters_insurance_interest": "string", "safety_reminder": "string", "subtotal": "string", "tax_1": "string", "tax_1_exempt": "string", "tax_1_rate_override": "string", "tax_2": "string", "tax_2_exempt": "string", "tenant": "string", "updated_at": "string", "use_club_credits": "string" } - schema_name_id: 1467
- schema_scan_id: 161516640
- updated: 2026-04-05 04:59:29
-
Version 1702437
- created: 2026-04-04 04:56:47
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbookings`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbookings`\n(\n `tenant` string , `id` string , `location_id` string , `customer_id` string , `creator_id` string , `admin_id` string , `billing_firstname` string , `billing_lastname` string , `billing_street1` string , `billing_street2` string , `billing_city` string , `billing_state` string , `billing_country` string , `billing_zip` string , `cc_saved_name` string , `cc_saved_last4` string , `cc_saved_profile_id` string , `cc_saved_method_id` string , `cc_saved_address_id` string , `cc_preauth_id` string , `cc_preauth_amount` string , `cc_connect_type` string , `cc_connect_id` string , `accessories_custom_price` string , `accessories_total` string , `insurance` string , `pets` string , `parking` string , `parking_override` string , `boats_total` string , `pos_total` string , `use_club_credits` string , `no_show_fee` string , `cancellation_fee` string , `club_fees` string , `club_fees_override` string , `subtotal` string , `convenience_fee` string , `convenience_fee_waived` string , `internal_application_fee` string , `tax_1` string , `tax_1_exempt` string , `tax_1_rate_override` string , `tax_2` string , `tax_2_exempt` string , `checkin_tax_1` string , `checkin_tax_2` string , `checkin_total` string , `deposit_total` string , `deposit_override` string , `deposit_waived` string , `gratuity` string , `grand_total` string , `adjustment_total` string , `amount_paid` string , `notes` string , `notes_contract` string , `notes_from_customer` string , `notes_from_customer_contract` string , `notes_for_customer` string , `notes_for_customer_contract` string , `frontend` string , `is_on_hold` string , `is_locked` string , `is_finalized` string , `is_canceled` string , `override_turnaround_time` string , `cancellation_type` string , `bypass_club_restrictions` string , `renters_insurance_interest` string , `coupon_id` string , `coupon_type` string , `coupon_amount` string , `discount_total` string , `agent_id` string , `agent_name` string , `referrer_id` string , `safety_reminder` string , `deleted_admin_id` string , `created_at` string , `updated_at` string , `finalized_at` string , `deleted_at` 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-prod/raw/stellar_imsbookings/2026-04-04/1775296467'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbookings" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbookings/2026-04-04/1775296467
- id: 1702437
- processed: 1
- raw_data:
{ "accessories_custom_price": 23, "accessories_total": 24, "adjustment_total": 53, "admin_id": 5, "agent_id": 74, "agent_name": 75, "amount_paid": 54, "billing_city": 10, "billing_country": 12, "billing_firstname": 6, "billing_lastname": 7, "billing_state": 11, "billing_street1": 8, "billing_street2": 9, "billing_zip": 13, "boats_total": 29, "bypass_club_restrictions": 68, "cancellation_fee": 33, "cancellation_type": 67, "cc_connect_id": 22, "cc_connect_type": 21, "cc_preauth_amount": 20, "cc_preauth_id": 19, "cc_saved_address_id": 18, "cc_saved_last4": 15, "cc_saved_method_id": 17, "cc_saved_name": 14, "cc_saved_profile_id": 16, "checkin_tax_1": 45, "checkin_tax_2": 46, "checkin_total": 47, "club_fees": 34, "club_fees_override": 35, "convenience_fee": 37, "convenience_fee_waived": 38, "coupon_amount": 72, "coupon_id": 70, "coupon_type": 71, "created_at": 79, "creator_id": 4, "customer_id": 3, "deleted_admin_id": 78, "deleted_at": 82, "deposit_override": 49, "deposit_total": 48, "deposit_waived": 50, "discount_total": 73, "finalized_at": 81, "frontend": 61, "grand_total": 52, "gratuity": 51, "id": 1, "insurance": 25, "internal_application_fee": 39, "is_canceled": 65, "is_finalized": 64, "is_locked": 63, "is_on_hold": 62, "location_id": 2, "no_show_fee": 32, "notes": 55, "notes_contract": 56, "notes_for_customer": 59, "notes_for_customer_contract": 60, "notes_from_customer": 57, "notes_from_customer_contract": 58, "override_turnaround_time": 66, "parking": 27, "parking_override": 28, "pets": 26, "pos_total": 30, "referrer_id": 76, "renters_insurance_interest": 69, "safety_reminder": 77, "subtotal": 36, "tax_1": 40, "tax_1_exempt": 41, "tax_1_rate_override": 42, "tax_2": 43, "tax_2_exempt": 44, "tenant": 0, "updated_at": 80, "use_club_credits": 31 } - schema_attributes:
{ "accessories_custom_price": "string", "accessories_total": "string", "adjustment_total": "string", "admin_id": "string", "agent_id": "string", "agent_name": "string", "amount_paid": "string", "billing_city": "string", "billing_country": "string", "billing_firstname": "string", "billing_lastname": "string", "billing_state": "string", "billing_street1": "string", "billing_street2": "string", "billing_zip": "string", "boats_total": "string", "bypass_club_restrictions": "string", "cancellation_fee": "string", "cancellation_type": "string", "cc_connect_id": "string", "cc_connect_type": "string", "cc_preauth_amount": "string", "cc_preauth_id": "string", "cc_saved_address_id": "string", "cc_saved_last4": "string", "cc_saved_method_id": "string", "cc_saved_name": "string", "cc_saved_profile_id": "string", "checkin_tax_1": "string", "checkin_tax_2": "string", "checkin_total": "string", "club_fees": "string", "club_fees_override": "string", "convenience_fee": "string", "convenience_fee_waived": "string", "coupon_amount": "string", "coupon_id": "string", "coupon_type": "string", "created_at": "string", "creator_id": "string", "customer_id": "string", "deleted_admin_id": "string", "deleted_at": "string", "deposit_override": "string", "deposit_total": "string", "deposit_waived": "string", "discount_total": "string", "finalized_at": "string", "frontend": "string", "grand_total": "string", "gratuity": "string", "id": "string", "insurance": "string", "internal_application_fee": "string", "is_canceled": "string", "is_finalized": "string", "is_locked": "string", "is_on_hold": "string", "location_id": "string", "no_show_fee": "string", "notes": "string", "notes_contract": "string", "notes_for_customer": "string", "notes_for_customer_contract": "string", "notes_from_customer": "string", "notes_from_customer_contract": "string", "override_turnaround_time": "string", "parking": "string", "parking_override": "string", "pets": "string", "pos_total": "string", "referrer_id": "string", "renters_insurance_interest": "string", "safety_reminder": "string", "subtotal": "string", "tax_1": "string", "tax_1_exempt": "string", "tax_1_rate_override": "string", "tax_2": "string", "tax_2_exempt": "string", "tenant": "string", "updated_at": "string", "use_club_credits": "string" } - schema_name_id: 1467
- schema_scan_id: 161462137
- updated: 2026-04-04 04:56:58
-
Version 1701288
- created: 2026-04-03 05:14:42
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbookings`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbookings`\n(\n `tenant` string , `id` string , `location_id` string , `customer_id` string , `creator_id` string , `admin_id` string , `billing_firstname` string , `billing_lastname` string , `billing_street1` string , `billing_street2` string , `billing_city` string , `billing_state` string , `billing_country` string , `billing_zip` string , `cc_saved_name` string , `cc_saved_last4` string , `cc_saved_profile_id` string , `cc_saved_method_id` string , `cc_saved_address_id` string , `cc_preauth_id` string , `cc_preauth_amount` string , `cc_connect_type` string , `cc_connect_id` string , `accessories_custom_price` string , `accessories_total` string , `insurance` string , `pets` string , `parking` string , `parking_override` string , `boats_total` string , `pos_total` string , `use_club_credits` string , `no_show_fee` string , `cancellation_fee` string , `club_fees` string , `club_fees_override` string , `subtotal` string , `convenience_fee` string , `convenience_fee_waived` string , `internal_application_fee` string , `tax_1` string , `tax_1_exempt` string , `tax_1_rate_override` string , `tax_2` string , `tax_2_exempt` string , `checkin_tax_1` string , `checkin_tax_2` string , `checkin_total` string , `deposit_total` string , `deposit_override` string , `deposit_waived` string , `gratuity` string , `grand_total` string , `adjustment_total` string , `amount_paid` string , `notes` string , `notes_contract` string , `notes_from_customer` string , `notes_from_customer_contract` string , `notes_for_customer` string , `notes_for_customer_contract` string , `frontend` string , `is_on_hold` string , `is_locked` string , `is_finalized` string , `is_canceled` string , `override_turnaround_time` string , `cancellation_type` string , `bypass_club_restrictions` string , `renters_insurance_interest` string , `coupon_id` string , `coupon_type` string , `coupon_amount` string , `discount_total` string , `agent_id` string , `agent_name` string , `referrer_id` string , `safety_reminder` string , `deleted_admin_id` string , `created_at` string , `updated_at` string , `finalized_at` string , `deleted_at` 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-prod/raw/stellar_imsbookings/2026-04-03/1775211035'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbookings" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbookings/2026-04-03/1775211035
- id: 1701288
- processed: 1
- raw_data:
{ "accessories_custom_price": 23, "accessories_total": 24, "adjustment_total": 53, "admin_id": 5, "agent_id": 74, "agent_name": 75, "amount_paid": 54, "billing_city": 10, "billing_country": 12, "billing_firstname": 6, "billing_lastname": 7, "billing_state": 11, "billing_street1": 8, "billing_street2": 9, "billing_zip": 13, "boats_total": 29, "bypass_club_restrictions": 68, "cancellation_fee": 33, "cancellation_type": 67, "cc_connect_id": 22, "cc_connect_type": 21, "cc_preauth_amount": 20, "cc_preauth_id": 19, "cc_saved_address_id": 18, "cc_saved_last4": 15, "cc_saved_method_id": 17, "cc_saved_name": 14, "cc_saved_profile_id": 16, "checkin_tax_1": 45, "checkin_tax_2": 46, "checkin_total": 47, "club_fees": 34, "club_fees_override": 35, "convenience_fee": 37, "convenience_fee_waived": 38, "coupon_amount": 72, "coupon_id": 70, "coupon_type": 71, "created_at": 79, "creator_id": 4, "customer_id": 3, "deleted_admin_id": 78, "deleted_at": 82, "deposit_override": 49, "deposit_total": 48, "deposit_waived": 50, "discount_total": 73, "finalized_at": 81, "frontend": 61, "grand_total": 52, "gratuity": 51, "id": 1, "insurance": 25, "internal_application_fee": 39, "is_canceled": 65, "is_finalized": 64, "is_locked": 63, "is_on_hold": 62, "location_id": 2, "no_show_fee": 32, "notes": 55, "notes_contract": 56, "notes_for_customer": 59, "notes_for_customer_contract": 60, "notes_from_customer": 57, "notes_from_customer_contract": 58, "override_turnaround_time": 66, "parking": 27, "parking_override": 28, "pets": 26, "pos_total": 30, "referrer_id": 76, "renters_insurance_interest": 69, "safety_reminder": 77, "subtotal": 36, "tax_1": 40, "tax_1_exempt": 41, "tax_1_rate_override": 42, "tax_2": 43, "tax_2_exempt": 44, "tenant": 0, "updated_at": 80, "use_club_credits": 31 } - schema_attributes:
{ "accessories_custom_price": "string", "accessories_total": "string", "adjustment_total": "string", "admin_id": "string", "agent_id": "string", "agent_name": "string", "amount_paid": "string", "billing_city": "string", "billing_country": "string", "billing_firstname": "string", "billing_lastname": "string", "billing_state": "string", "billing_street1": "string", "billing_street2": "string", "billing_zip": "string", "boats_total": "string", "bypass_club_restrictions": "string", "cancellation_fee": "string", "cancellation_type": "string", "cc_connect_id": "string", "cc_connect_type": "string", "cc_preauth_amount": "string", "cc_preauth_id": "string", "cc_saved_address_id": "string", "cc_saved_last4": "string", "cc_saved_method_id": "string", "cc_saved_name": "string", "cc_saved_profile_id": "string", "checkin_tax_1": "string", "checkin_tax_2": "string", "checkin_total": "string", "club_fees": "string", "club_fees_override": "string", "convenience_fee": "string", "convenience_fee_waived": "string", "coupon_amount": "string", "coupon_id": "string", "coupon_type": "string", "created_at": "string", "creator_id": "string", "customer_id": "string", "deleted_admin_id": "string", "deleted_at": "string", "deposit_override": "string", "deposit_total": "string", "deposit_waived": "string", "discount_total": "string", "finalized_at": "string", "frontend": "string", "grand_total": "string", "gratuity": "string", "id": "string", "insurance": "string", "internal_application_fee": "string", "is_canceled": "string", "is_finalized": "string", "is_locked": "string", "is_on_hold": "string", "location_id": "string", "no_show_fee": "string", "notes": "string", "notes_contract": "string", "notes_for_customer": "string", "notes_for_customer_contract": "string", "notes_from_customer": "string", "notes_from_customer_contract": "string", "override_turnaround_time": "string", "parking": "string", "parking_override": "string", "pets": "string", "pos_total": "string", "referrer_id": "string", "renters_insurance_interest": "string", "safety_reminder": "string", "subtotal": "string", "tax_1": "string", "tax_1_exempt": "string", "tax_1_rate_override": "string", "tax_2": "string", "tax_2_exempt": "string", "tenant": "string", "updated_at": "string", "use_club_credits": "string" } - schema_name_id: 1467
- schema_scan_id: 161404887
- updated: 2026-04-03 05:14:55
Schema Scans: 15
Last at 2026-04-17 04:57:18
-
Scan 162169318
- duration: 0:00:13.934778
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162169318
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-prod", "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbookings/2026-04-17/1776419646", "key": "raw/stellar_imsbookings/2026-04-17/1776419646/bookings.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsbookings", "type": "drivethrucsv" }, "trace_context": { "parent_id": 16428905805583867098, "service_name": "drive-thru", "span_id": 7539893334152822165, "trace_id": 14503014521923129648 } } - running: False
- schema_name_id: 1467
- start_time: 2026-04-17 04:57:18
- success: True
- trace_id: 14503014521923129648
-
Scan 162114461
- duration: 0:00:13.678829
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162114461
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-prod", "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbookings/2026-04-16/1776334546", "key": "raw/stellar_imsbookings/2026-04-16/1776334546/bookings.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsbookings", "type": "drivethrucsv" }, "trace_context": { "parent_id": 15444387378104254564, "service_name": "drive-thru", "span_id": 9361021347615863930, "trace_id": 1860825152518147886 } } - running: False
- schema_name_id: 1467
- start_time: 2026-04-16 05:19:43
- success: True
- trace_id: 1860825152518147886
-
Scan 162056435
- duration: 0:00:13.789700
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162056435
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-prod", "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbookings/2026-04-15/1776242357", "key": "raw/stellar_imsbookings/2026-04-15/1776242357/bookings.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsbookings", "type": "drivethrucsv" }, "trace_context": { "parent_id": 600509110680686026, "service_name": "drive-thru", "span_id": 7395632753277025467, "trace_id": 7330545094923718749 } } - running: False
- schema_name_id: 1467
- start_time: 2026-04-15 03:43:35
- success: True
- trace_id: 7330545094923718749
-
Scan 162003028
- duration: 0:00:16.409816
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162003028
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-prod", "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbookings/2026-04-14/1776160755", "key": "raw/stellar_imsbookings/2026-04-14/1776160755/bookings.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsbookings", "type": "drivethrucsv" }, "trace_context": { "parent_id": 5102061521916561229, "service_name": "drive-thru", "span_id": 17401710414327889480, "trace_id": 5488403031787500794 } } - running: False
- schema_name_id: 1467
- start_time: 2026-04-14 05:02:25
- success: True
- trace_id: 5488403031787500794
-
Scan 161945367
- duration: 0:00:16.733654
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161945367
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-prod", "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbookings/2026-04-13/1776074798", "key": "raw/stellar_imsbookings/2026-04-13/1776074798/bookings.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsbookings", "type": "drivethrucsv" }, "trace_context": { "parent_id": 15353168402517184294, "service_name": "drive-thru", "span_id": 11742904595627917237, "trace_id": 16629223401117468838 } } - running: False
- schema_name_id: 1467
- start_time: 2026-04-13 05:10:29
- success: True
- trace_id: 16629223401117468838
-
Scan 161896444
- duration: 0:00:16.547660
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161896444
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-prod", "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbookings/2026-04-12/1775988156", "key": "raw/stellar_imsbookings/2026-04-12/1775988156/bookings.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsbookings", "type": "drivethrucsv" }, "trace_context": { "parent_id": 1692116866175106416, "service_name": "drive-thru", "span_id": 4092832304207831615, "trace_id": 1732865935082462931 } } - running: False
- schema_name_id: 1467
- start_time: 2026-04-12 05:08:32
- success: True
- trace_id: 1732865935082462931
-
Scan 161844005
- duration: 0:00:13.832289
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161844005
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-prod", "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbookings/2026-04-11/1775902577", "key": "raw/stellar_imsbookings/2026-04-11/1775902577/bookings.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsbookings", "type": "drivethrucsv" }, "trace_context": { "parent_id": 13987565613190289629, "service_name": "drive-thru", "span_id": 705263325859820858, "trace_id": 11147843857044637643 } } - running: False
- schema_name_id: 1467
- start_time: 2026-04-11 05:20:33
- success: True
- trace_id: 11147843857044637643
-
Scan 161788648
- duration: 0:00:16.306298
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161788648
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-prod", "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbookings/2026-04-10/1775815218", "key": "raw/stellar_imsbookings/2026-04-10/1775815218/bookings.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsbookings", "type": "drivethrucsv" }, "trace_context": { "parent_id": 482668290868487294, "service_name": "drive-thru", "span_id": 1761576042203441471, "trace_id": 3294331688055703948 } } - running: False
- schema_name_id: 1467
- start_time: 2026-04-10 05:04:11
- success: True
- trace_id: 3294331688055703948
-
Scan 161733030
- duration: 0:00:16.257965
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161733030
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-prod", "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbookings/2026-04-09/1775728838", "key": "raw/stellar_imsbookings/2026-04-09/1775728838/bookings.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsbookings", "type": "drivethrucsv" }, "trace_context": { "parent_id": 4688224436789258436, "service_name": "drive-thru", "span_id": 7759116903511292410, "trace_id": 12052014156720614173 } } - running: False
- schema_name_id: 1467
- start_time: 2026-04-09 05:04:53
- success: True
- trace_id: 12052014156720614173
-
Scan 161678441
- duration: 0:00:13.935906
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161678441
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-prod", "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbookings/2026-04-08/1775643000", "key": "raw/stellar_imsbookings/2026-04-08/1775643000/bookings.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsbookings", "type": "drivethrucsv" }, "trace_context": { "parent_id": 1169631121618296233, "service_name": "drive-thru", "span_id": 4619007610336426614, "trace_id": 11137723866393307066 } } - running: False
- schema_name_id: 1467
- start_time: 2026-04-08 05:15:59
- success: True
- trace_id: 11137723866393307066
-
Scan 161622181
- duration: 0:00:13.806171
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161622181
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-prod", "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbookings/2026-04-07/1775556859", "key": "raw/stellar_imsbookings/2026-04-07/1775556859/bookings.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsbookings", "type": "drivethrucsv" }, "trace_context": { "parent_id": 288510435601691026, "service_name": "drive-thru", "span_id": 13052703554628511090, "trace_id": 15178202210248594352 } } - running: False
- schema_name_id: 1467
- start_time: 2026-04-07 05:19:08
- success: True
- trace_id: 15178202210248594352
-
Scan 161564265
- duration: 0:00:14.183769
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161564265
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-prod", "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbookings/2026-04-06/1775470528", "key": "raw/stellar_imsbookings/2026-04-06/1775470528/bookings.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsbookings", "type": "drivethrucsv" }, "trace_context": { "parent_id": 5651051445283661985, "service_name": "drive-thru", "span_id": 6005368120968580036, "trace_id": 8738723850963652194 } } - running: False
- schema_name_id: 1467
- start_time: 2026-04-06 05:17:34
- success: True
- trace_id: 8738723850963652194
-
Scan 161516640
- duration: 0:00:14.189048
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161516640
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-prod", "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbookings/2026-04-05/1775382946", "key": "raw/stellar_imsbookings/2026-04-05/1775382946/bookings.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsbookings", "type": "drivethrucsv" }, "trace_context": { "parent_id": 1337542805375228683, "service_name": "drive-thru", "span_id": 3358990673465438291, "trace_id": 18322378196865182486 } } - running: False
- schema_name_id: 1467
- start_time: 2026-04-05 04:59:15
- success: True
- trace_id: 18322378196865182486
-
Scan 161462137
- duration: 0:00:13.724878
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161462137
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-prod", "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbookings/2026-04-04/1775296467", "key": "raw/stellar_imsbookings/2026-04-04/1775296467/bookings.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsbookings", "type": "drivethrucsv" }, "trace_context": { "parent_id": 854717846462642403, "service_name": "drive-thru", "span_id": 10970576294456421347, "trace_id": 16165194890372912876 } } - running: False
- schema_name_id: 1467
- start_time: 2026-04-04 04:56:45
- success: True
- trace_id: 16165194890372912876
-
Scan 161404887
- duration: 0:00:16.468211
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161404887
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-prod", "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbookings/2026-04-03/1775211035", "key": "raw/stellar_imsbookings/2026-04-03/1775211035/bookings.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsbookings", "type": "drivethrucsv" }, "trace_context": { "parent_id": 5458884139219531047, "service_name": "drive-thru", "span_id": 8712270542499050816, "trace_id": 13343215351076357112 } } - running: False
- schema_name_id: 1467
- start_time: 2026-04-03 05:14:39
- success: True
- trace_id: 13343215351076357112
- attributes:
{ "accessories_custom_price": "string", "accessories_total": "string", "adjustment_total": "string", "admin_id": "string", "agent_id": "string", "agent_name": "string", "amount_paid": "string", "billing_city": "string", "billing_country": "string", "billing_firstname": "string", "billing_lastname": "string", "billing_state": "string", "billing_street1": "string", "billing_street2": "string", "billing_zip": "string", "boats_total": "string", "bypass_club_restrictions": "string", "cancellation_fee": "string", "cancellation_type": "string", "cc_connect_id": "string", "cc_connect_type": "string", "cc_preauth_amount": "string", "cc_preauth_id": "string", "cc_saved_address_id": "string", "cc_saved_last4": "string", "cc_saved_method_id": "string", "cc_saved_name": "string", "cc_saved_profile_id": "string", "checkin_tax_1": "string", "checkin_tax_2": "string", "checkin_total": "string", "club_fees": "string", "club_fees_override": "string", "convenience_fee": "string", "convenience_fee_waived": "string", "coupon_amount": "string", "coupon_id": "string", "coupon_type": "string", "created_at": "string", "creator_id": "string", "customer_id": "string", "deleted_admin_id": "string", "deleted_at": "string", "deposit_override": "string", "deposit_total": "string", "deposit_waived": "string", "discount_total": "string", "finalized_at": "string", "frontend": "string", "grand_total": "string", "gratuity": "string", "id": "string", "insurance": "string", "internal_application_fee": "string", "is_canceled": "string", "is_finalized": "string", "is_locked": "string", "is_on_hold": "string", "location_id": "string", "no_show_fee": "string", "notes": "string", "notes_contract": "string", "notes_for_customer": "string", "notes_for_customer_contract": "string", "notes_from_customer": "string", "notes_from_customer_contract": "string", "override_turnaround_time": "string", "parking": "string", "parking_override": "string", "pets": "string", "pos_total": "string", "referrer_id": "string", "renters_insurance_interest": "string", "safety_reminder": "string", "subtotal": "string", "tax_1": "string", "tax_1_exempt": "string", "tax_1_rate_override": "string", "tax_2": "string", "tax_2_exempt": "string", "tenant": "string", "updated_at": "string", "use_club_credits": "string" } - created: 2026-04-17 04:57:20
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbookings`\n(\n `tenant` string , `id` string , `location_id` string , `customer_id` string , `creator_id` string , `admin_id` string , `billing_firstname` string , `billing_lastname` string , `billing_street1` string , `billing_street2` string , `billing_city` string , `billing_state` string , `billing_country` string , `billing_zip` string , `cc_saved_name` string , `cc_saved_last4` string , `cc_saved_profile_id` string , `cc_saved_method_id` string , `cc_saved_address_id` string , `cc_preauth_id` string , `cc_preauth_amount` string , `cc_connect_type` string , `cc_connect_id` string , `accessories_custom_price` string , `accessories_total` string , `insurance` string , `pets` string , `parking` string , `parking_override` string , `boats_total` string , `pos_total` string , `use_club_credits` string , `no_show_fee` string , `cancellation_fee` string , `club_fees` string , `club_fees_override` string , `subtotal` string , `convenience_fee` string , `convenience_fee_waived` string , `internal_application_fee` string , `tax_1` string , `tax_1_exempt` string , `tax_1_rate_override` string , `tax_2` string , `tax_2_exempt` string , `checkin_tax_1` string , `checkin_tax_2` string , `checkin_total` string , `deposit_total` string , `deposit_override` string , `deposit_waived` string , `gratuity` string , `grand_total` string , `adjustment_total` string , `amount_paid` string , `notes` string , `notes_contract` string , `notes_from_customer` string , `notes_from_customer_contract` string , `notes_for_customer` string , `notes_for_customer_contract` string , `frontend` string , `is_on_hold` string , `is_locked` string , `is_finalized` string , `is_canceled` string , `override_turnaround_time` string , `cancellation_type` string , `bypass_club_restrictions` string , `renters_insurance_interest` string , `coupon_id` string , `coupon_type` string , `coupon_amount` string , `discount_total` string , `agent_id` string , `agent_name` string , `referrer_id` string , `safety_reminder` string , `deleted_admin_id` string , `created_at` string , `updated_at` string , `finalized_at` string , `deleted_at` 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-prod/raw/stellar_imsbookings/2026-04-17/1776419646'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbookings`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbookings" }
- hostname: schemamanager-5475496c57-7dpqb
- name: schema_manager
- process_start: 2026-01-09 11:27:47
- sf_env: prod
- version: 2112174301
{
"name": {
"created": "2023-02-07 01:46:49",
"disabled": false,
"format": "raw",
"id": 1467,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_prod_drivethru",
"table": "stellar_imsbookings"
},
"type": "drivethrucsv"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"accessories_custom_price": "string",
"accessories_total": "string",
"adjustment_total": "string",
"admin_id": "string",
"agent_id": "string",
"agent_name": "string",
"amount_paid": "string",
"billing_city": "string",
"billing_country": "string",
"billing_firstname": "string",
"billing_lastname": "string",
"billing_state": "string",
"billing_street1": "string",
"billing_street2": "string",
"billing_zip": "string",
"boats_total": "string",
"bypass_club_restrictions": "string",
"cancellation_fee": "string",
"cancellation_type": "string",
"cc_connect_id": "string",
"cc_connect_type": "string",
"cc_preauth_amount": "string",
"cc_preauth_id": "string",
"cc_saved_address_id": "string",
"cc_saved_last4": "string",
"cc_saved_method_id": "string",
"cc_saved_name": "string",
"cc_saved_profile_id": "string",
"checkin_tax_1": "string",
"checkin_tax_2": "string",
"checkin_total": "string",
"club_fees": "string",
"club_fees_override": "string",
"convenience_fee": "string",
"convenience_fee_waived": "string",
"coupon_amount": "string",
"coupon_id": "string",
"coupon_type": "string",
"created_at": "string",
"creator_id": "string",
"customer_id": "string",
"deleted_admin_id": "string",
"deleted_at": "string",
"deposit_override": "string",
"deposit_total": "string",
"deposit_waived": "string",
"discount_total": "string",
"finalized_at": "string",
"frontend": "string",
"grand_total": "string",
"gratuity": "string",
"id": "string",
"insurance": "string",
"internal_application_fee": "string",
"is_canceled": "string",
"is_finalized": "string",
"is_locked": "string",
"is_on_hold": "string",
"location_id": "string",
"no_show_fee": "string",
"notes": "string",
"notes_contract": "string",
"notes_for_customer": "string",
"notes_for_customer_contract": "string",
"notes_from_customer": "string",
"notes_from_customer_contract": "string",
"override_turnaround_time": "string",
"parking": "string",
"parking_override": "string",
"pets": "string",
"pos_total": "string",
"referrer_id": "string",
"renters_insurance_interest": "string",
"safety_reminder": "string",
"subtotal": "string",
"tax_1": "string",
"tax_1_exempt": "string",
"tax_1_rate_override": "string",
"tax_2": "string",
"tax_2_exempt": "string",
"tenant": "string",
"updated_at": "string",
"use_club_credits": "string"
},
"created": "2026-04-17 04:57:20",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbookings`\n(\n `tenant` string , `id` string , `location_id` string , `customer_id` string , `creator_id` string , `admin_id` string , `billing_firstname` string , `billing_lastname` string , `billing_street1` string , `billing_street2` string , `billing_city` string , `billing_state` string , `billing_country` string , `billing_zip` string , `cc_saved_name` string , `cc_saved_last4` string , `cc_saved_profile_id` string , `cc_saved_method_id` string , `cc_saved_address_id` string , `cc_preauth_id` string , `cc_preauth_amount` string , `cc_connect_type` string , `cc_connect_id` string , `accessories_custom_price` string , `accessories_total` string , `insurance` string , `pets` string , `parking` string , `parking_override` string , `boats_total` string , `pos_total` string , `use_club_credits` string , `no_show_fee` string , `cancellation_fee` string , `club_fees` string , `club_fees_override` string , `subtotal` string , `convenience_fee` string , `convenience_fee_waived` string , `internal_application_fee` string , `tax_1` string , `tax_1_exempt` string , `tax_1_rate_override` string , `tax_2` string , `tax_2_exempt` string , `checkin_tax_1` string , `checkin_tax_2` string , `checkin_total` string , `deposit_total` string , `deposit_override` string , `deposit_waived` string , `gratuity` string , `grand_total` string , `adjustment_total` string , `amount_paid` string , `notes` string , `notes_contract` string , `notes_from_customer` string , `notes_from_customer_contract` string , `notes_for_customer` string , `notes_for_customer_contract` string , `frontend` string , `is_on_hold` string , `is_locked` string , `is_finalized` string , `is_canceled` string , `override_turnaround_time` string , `cancellation_type` string , `bypass_club_restrictions` string , `renters_insurance_interest` string , `coupon_id` string , `coupon_type` string , `coupon_amount` string , `discount_total` string , `agent_id` string , `agent_name` string , `referrer_id` string , `safety_reminder` string , `deleted_admin_id` string , `created_at` string , `updated_at` string , `finalized_at` string , `deleted_at` 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-prod/raw/stellar_imsbookings/2026-04-17/1776419646'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbookings`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbookings"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}