Schema Info

Schema Name: sfdl_stage_drivethru.stellar_imsbookings

created: 2023-01-31 12:04:26
disabled: False
format: raw
id: 1739
is_partitioned: False
is_schema_datatyped: True

name:

{
    "database": "sfdl_stage_drivethru",
    "table": "stellar_imsbookings"
}

type: drivethrucsv

Schema Versions: 3

Version 496022

created: 2023-02-06 01:53:56

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.stellar_imsbookings`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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 , `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 , `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 , `cancellation_type`  string , `bypass_club_restrictions`  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-stage/raw/stellar_imsbookings/2023-02-06/1675669793'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.stellar_imsbookings"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-stage/raw/stellar_imsbookings/2023-02-06/1675669793
id: 496022
processed: 1

raw_data:

{
    "accessories_custom_price": 21,
    "accessories_total": 22,
    "adjustment_total": 50,
    "admin_id": 5,
    "agent_id": 69,
    "agent_name": 70,
    "amount_paid": 51,
    "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": 27,
    "bypass_club_restrictions": 64,
    "cancellation_fee": 31,
    "cancellation_type": 63,
    "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": 43,
    "checkin_tax_2": 44,
    "checkin_total": 45,
    "club_fees": 32,
    "club_fees_override": 33,
    "convenience_fee": 35,
    "convenience_fee_waived": 36,
    "coupon_amount": 67,
    "coupon_id": 65,
    "coupon_type": 66,
    "created_at": 74,
    "creator_id": 4,
    "customer_id": 3,
    "deleted_admin_id": 73,
    "deleted_at": 77,
    "deposit_override": 47,
    "deposit_total": 46,
    "deposit_waived": 48,
    "discount_total": 68,
    "finalized_at": 76,
    "frontend": 58,
    "grand_total": 49,
    "id": 1,
    "insurance": 23,
    "internal_application_fee": 37,
    "is_canceled": 62,
    "is_finalized": 61,
    "is_locked": 60,
    "is_on_hold": 59,
    "location_id": 2,
    "no_show_fee": 30,
    "notes": 52,
    "notes_contract": 53,
    "notes_for_customer": 56,
    "notes_for_customer_contract": 57,
    "notes_from_customer": 54,
    "notes_from_customer_contract": 55,
    "parking": 25,
    "parking_override": 26,
    "pets": 24,
    "pos_total": 28,
    "referrer_id": 71,
    "safety_reminder": 72,
    "subtotal": 34,
    "tax_1": 38,
    "tax_1_exempt": 39,
    "tax_1_rate_override": 40,
    "tax_2": 41,
    "tax_2_exempt": 42,
    "tenant": 0,
    "updated_at": 75,
    "use_club_credits": 29
}

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_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",
    "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",
    "parking": "string",
    "parking_override": "string",
    "pets": "string",
    "pos_total": "string",
    "referrer_id": "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: 1739
schema_scan_id: 4595691
updated: 2023-02-06 01:54:07

Version 495401

created: 2023-02-05 01:53:19

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.stellar_imsbookings`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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 , `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 , `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 , `cancellation_type`  string , `bypass_club_restrictions`  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-stage/raw/stellar_imsbookings/2023-02-05/1675583111'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.stellar_imsbookings"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-stage/raw/stellar_imsbookings/2023-02-05/1675583111
id: 495401
processed: 1

raw_data:

{
    "accessories_custom_price": 21,
    "accessories_total": 22,
    "adjustment_total": 50,
    "admin_id": 5,
    "agent_id": 69,
    "agent_name": 70,
    "amount_paid": 51,
    "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": 27,
    "bypass_club_restrictions": 64,
    "cancellation_fee": 31,
    "cancellation_type": 63,
    "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": 43,
    "checkin_tax_2": 44,
    "checkin_total": 45,
    "club_fees": 32,
    "club_fees_override": 33,
    "convenience_fee": 35,
    "convenience_fee_waived": 36,
    "coupon_amount": 67,
    "coupon_id": 65,
    "coupon_type": 66,
    "created_at": 74,
    "creator_id": 4,
    "customer_id": 3,
    "deleted_admin_id": 73,
    "deleted_at": 77,
    "deposit_override": 47,
    "deposit_total": 46,
    "deposit_waived": 48,
    "discount_total": 68,
    "finalized_at": 76,
    "frontend": 58,
    "grand_total": 49,
    "id": 1,
    "insurance": 23,
    "internal_application_fee": 37,
    "is_canceled": 62,
    "is_finalized": 61,
    "is_locked": 60,
    "is_on_hold": 59,
    "location_id": 2,
    "no_show_fee": 30,
    "notes": 52,
    "notes_contract": 53,
    "notes_for_customer": 56,
    "notes_for_customer_contract": 57,
    "notes_from_customer": 54,
    "notes_from_customer_contract": 55,
    "parking": 25,
    "parking_override": 26,
    "pets": 24,
    "pos_total": 28,
    "referrer_id": 71,
    "safety_reminder": 72,
    "subtotal": 34,
    "tax_1": 38,
    "tax_1_exempt": 39,
    "tax_1_rate_override": 40,
    "tax_2": 41,
    "tax_2_exempt": 42,
    "tenant": 0,
    "updated_at": 75,
    "use_club_credits": 29
}

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_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",
    "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",
    "parking": "string",
    "parking_override": "string",
    "pets": "string",
    "pos_total": "string",
    "referrer_id": "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: 1739
schema_scan_id: 4592957
updated: 2023-02-05 01:53:30

Version 494651

created: 2023-02-04 01:44:39

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.stellar_imsbookings`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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 , `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 , `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 , `cancellation_type`  string , `bypass_club_restrictions`  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-stage/raw/stellar_imsbookings/2023-02-04/1675496658'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.stellar_imsbookings"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-stage/raw/stellar_imsbookings/2023-02-04/1675496658
id: 494651
processed: 1

raw_data:

{
    "accessories_custom_price": 21,
    "accessories_total": 22,
    "adjustment_total": 50,
    "admin_id": 5,
    "agent_id": 69,
    "agent_name": 70,
    "amount_paid": 51,
    "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": 27,
    "bypass_club_restrictions": 64,
    "cancellation_fee": 31,
    "cancellation_type": 63,
    "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": 43,
    "checkin_tax_2": 44,
    "checkin_total": 45,
    "club_fees": 32,
    "club_fees_override": 33,
    "convenience_fee": 35,
    "convenience_fee_waived": 36,
    "coupon_amount": 67,
    "coupon_id": 65,
    "coupon_type": 66,
    "created_at": 74,
    "creator_id": 4,
    "customer_id": 3,
    "deleted_admin_id": 73,
    "deleted_at": 77,
    "deposit_override": 47,
    "deposit_total": 46,
    "deposit_waived": 48,
    "discount_total": 68,
    "finalized_at": 76,
    "frontend": 58,
    "grand_total": 49,
    "id": 1,
    "insurance": 23,
    "internal_application_fee": 37,
    "is_canceled": 62,
    "is_finalized": 61,
    "is_locked": 60,
    "is_on_hold": 59,
    "location_id": 2,
    "no_show_fee": 30,
    "notes": 52,
    "notes_contract": 53,
    "notes_for_customer": 56,
    "notes_for_customer_contract": 57,
    "notes_from_customer": 54,
    "notes_from_customer_contract": 55,
    "parking": 25,
    "parking_override": 26,
    "pets": 24,
    "pos_total": 28,
    "referrer_id": 71,
    "safety_reminder": 72,
    "subtotal": 34,
    "tax_1": 38,
    "tax_1_exempt": 39,
    "tax_1_rate_override": 40,
    "tax_2": 41,
    "tax_2_exempt": 42,
    "tenant": 0,
    "updated_at": 75,
    "use_club_credits": 29
}

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_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",
    "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",
    "parking": "string",
    "parking_override": "string",
    "pets": "string",
    "pos_total": "string",
    "referrer_id": "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: 1739
schema_scan_id: 4589817
updated: 2023-02-04 01:44:50

Schema Scans: 3

Last at 2023-02-06 01:53:54

Scan 4595691

duration: 0:00:13.461199

exit_message:

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

id: 4595691

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-stage/raw/stellar_imsbookings/2023-02-06/1675669793",
        "key": "raw/stellar_imsbookings/2023-02-06/1675669793/bookings.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.stellar_imsbookings",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2703768204983996196,
        "service_name": "drive-thru",
        "span_id": 12478611929609433280,
        "trace_id": 3022177105245173553
    }
}

running: False
schema_name_id: 1739
start_time: 2023-02-06 01:53:54
success: True
trace_id: 3022177105245173553

Scan 4592957

duration: 0:00:13.488582

exit_message:

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

id: 4592957

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-stage/raw/stellar_imsbookings/2023-02-05/1675583111",
        "key": "raw/stellar_imsbookings/2023-02-05/1675583111/bookings.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.stellar_imsbookings",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7980063562993846590,
        "service_name": "drive-thru",
        "span_id": 16462223559177434293,
        "trace_id": 10298270291676394423
    }
}

running: False
schema_name_id: 1739
start_time: 2023-02-05 01:53:17
success: True
trace_id: 10298270291676394423

Scan 4589817

duration: 0:00:13.457770

exit_message:

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

id: 4589817

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-stage/raw/stellar_imsbookings/2023-02-04/1675496658",
        "key": "raw/stellar_imsbookings/2023-02-04/1675496658/bookings.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.stellar_imsbookings",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11397076814987447382,
        "service_name": "drive-thru",
        "span_id": 15361411672759897689,
        "trace_id": 15684853607165112269
    }
}

running: False
schema_name_id: 1739
start_time: 2023-02-04 01:44:37
success: True
trace_id: 15684853607165112269

Partitions:

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

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_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",
    "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",
    "parking": "string",
    "parking_override": "string",
    "pets": "string",
    "pos_total": "string",
    "referrer_id": "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: 2023-02-06 01:53:56

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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 , `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 , `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 , `cancellation_type`  string , `bypass_club_restrictions`  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-stage/raw/stellar_imsbookings/2023-02-06/1675669793'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_drivethru.stellar_imsbookings`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_drivethru.stellar_imsbookings"
}

Server:

hostname: schemamanager-5c55c886bf-h2ts4
name: schema_manager
process_start: 2025-10-21 13:03:27
sf_env: stage
version: 2112174301

Raw:

{
    "name": {
        "created": "2023-01-31 12:04:26",
        "disabled": false,
        "format": "raw",
        "id": 1739,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_stage_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_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",
            "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",
            "parking": "string",
            "parking_override": "string",
            "pets": "string",
            "pos_total": "string",
            "referrer_id": "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": "2023-02-06 01:53:56",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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 , `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 , `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 , `cancellation_type`  string , `bypass_club_restrictions`  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-stage/raw/stellar_imsbookings/2023-02-06/1675669793'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_drivethru.stellar_imsbookings`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_drivethru.stellar_imsbookings"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}