Schema Info

Schema Name: sfdl_prod_drivethru.stellar_imsclub_restrictions

created: 2023-02-07 01:48:55
disabled: False
format: raw
id: 1505
is_partitioned: False
is_schema_datatyped: True

name:

{
    "database": "sfdl_prod_drivethru",
    "table": "stellar_imsclub_restrictions"
}

type: drivethrucsv

Schema Versions: 15

Version 1717978

created: 2026-04-17 04:57:17

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclub_restrictions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclub_restrictions`\n(\n `tenant`  string , `id`  string , `location_id`  string , `restriction_name`  string , `coupons_allowed`  string , `min_departure_time`  string , `max_departure_time`  string , `min_return_time`  string , `max_return_time`  string , `min_hours`  string , `max_hours`  string , `min_hours_before_departure_book`  string , `max_hours_before_departure_book`  string , `min_hours_before_departure_cancel`  string , `max_hours_before_departure_cancel`  string , `min_hours_before_departure_free_cancel`  string , `max_hours_before_departure_bypass_restrictions`  string , `allow_same_day_bypass_restrictions`  string , `min_current_time_same_day_bypass`  string , `max_same_day_per_customer`  string , `max_same_time_same_day_per_customer`  string , `max_diff_unit_type_same_day_per_customer`  string , `max_same_weekend_sat_sun_per_customer`  string , `max_same_weekend_fri_sun_per_customer`  string , `max_same_weekend_fri_sat_per_customer`  string , `max_same_weekend_holiday_different_days_per_customer`  string , `max_same_weekend_holiday_same_days_per_customer`  string , `max_active_per_customer`  string , `max_active_weekday_per_customer`  string , `max_active_weekend_per_customer`  string , `max_per_week_per_customer`  string , `max_per_period_per_customer`  string , `max_weekday_per_period_per_customer`  string , `max_weekend_per_period_per_customer`  string , `max_per_period_per_location_per_customer`  string , `max_visiting_fleet_occupancy_per_location`  string , `disable_consecutive_per_customer`  string , `valid_days`  string , `holidays_only_if_valid_day`  string , `max_rental_days`  string , `valid_groups`  string , `valid_styles`  string , `status`  string , `created_at`  string , `updated_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_imsclub_restrictions/2026-04-17/1776419647'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclub_restrictions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsclub_restrictions/2026-04-17/1776419647
id: 1717978
processed: 1

raw_data:

{
    "allow_same_day_bypass_restrictions": 17,
    "coupons_allowed": 4,
    "created_at": 43,
    "disable_consecutive_per_customer": 36,
    "holidays_only_if_valid_day": 38,
    "id": 1,
    "location_id": 2,
    "max_active_per_customer": 27,
    "max_active_weekday_per_customer": 28,
    "max_active_weekend_per_customer": 29,
    "max_departure_time": 6,
    "max_diff_unit_type_same_day_per_customer": 21,
    "max_hours": 10,
    "max_hours_before_departure_book": 12,
    "max_hours_before_departure_bypass_restrictions": 16,
    "max_hours_before_departure_cancel": 14,
    "max_per_period_per_customer": 31,
    "max_per_period_per_location_per_customer": 34,
    "max_per_week_per_customer": 30,
    "max_rental_days": 39,
    "max_return_time": 8,
    "max_same_day_per_customer": 19,
    "max_same_time_same_day_per_customer": 20,
    "max_same_weekend_fri_sat_per_customer": 24,
    "max_same_weekend_fri_sun_per_customer": 23,
    "max_same_weekend_holiday_different_days_per_customer": 25,
    "max_same_weekend_holiday_same_days_per_customer": 26,
    "max_same_weekend_sat_sun_per_customer": 22,
    "max_visiting_fleet_occupancy_per_location": 35,
    "max_weekday_per_period_per_customer": 32,
    "max_weekend_per_period_per_customer": 33,
    "min_current_time_same_day_bypass": 18,
    "min_departure_time": 5,
    "min_hours": 9,
    "min_hours_before_departure_book": 11,
    "min_hours_before_departure_cancel": 13,
    "min_hours_before_departure_free_cancel": 15,
    "min_return_time": 7,
    "restriction_name": 3,
    "status": 42,
    "tenant": 0,
    "updated_at": 44,
    "valid_days": 37,
    "valid_groups": 40,
    "valid_styles": 41
}

schema_attributes:

{
    "allow_same_day_bypass_restrictions": "string",
    "coupons_allowed": "string",
    "created_at": "string",
    "disable_consecutive_per_customer": "string",
    "holidays_only_if_valid_day": "string",
    "id": "string",
    "location_id": "string",
    "max_active_per_customer": "string",
    "max_active_weekday_per_customer": "string",
    "max_active_weekend_per_customer": "string",
    "max_departure_time": "string",
    "max_diff_unit_type_same_day_per_customer": "string",
    "max_hours": "string",
    "max_hours_before_departure_book": "string",
    "max_hours_before_departure_bypass_restrictions": "string",
    "max_hours_before_departure_cancel": "string",
    "max_per_period_per_customer": "string",
    "max_per_period_per_location_per_customer": "string",
    "max_per_week_per_customer": "string",
    "max_rental_days": "string",
    "max_return_time": "string",
    "max_same_day_per_customer": "string",
    "max_same_time_same_day_per_customer": "string",
    "max_same_weekend_fri_sat_per_customer": "string",
    "max_same_weekend_fri_sun_per_customer": "string",
    "max_same_weekend_holiday_different_days_per_customer": "string",
    "max_same_weekend_holiday_same_days_per_customer": "string",
    "max_same_weekend_sat_sun_per_customer": "string",
    "max_visiting_fleet_occupancy_per_location": "string",
    "max_weekday_per_period_per_customer": "string",
    "max_weekend_per_period_per_customer": "string",
    "min_current_time_same_day_bypass": "string",
    "min_departure_time": "string",
    "min_hours": "string",
    "min_hours_before_departure_book": "string",
    "min_hours_before_departure_cancel": "string",
    "min_hours_before_departure_free_cancel": "string",
    "min_return_time": "string",
    "restriction_name": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string",
    "valid_days": "string",
    "valid_groups": "string",
    "valid_styles": "string"
}

schema_name_id: 1505
schema_scan_id: 162169316
updated: 2026-04-17 04:57:31

Version 1716704

created: 2026-04-16 05:16:27

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclub_restrictions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclub_restrictions`\n(\n `tenant`  string , `id`  string , `location_id`  string , `restriction_name`  string , `coupons_allowed`  string , `min_departure_time`  string , `max_departure_time`  string , `min_return_time`  string , `max_return_time`  string , `min_hours`  string , `max_hours`  string , `min_hours_before_departure_book`  string , `max_hours_before_departure_book`  string , `min_hours_before_departure_cancel`  string , `max_hours_before_departure_cancel`  string , `min_hours_before_departure_free_cancel`  string , `max_hours_before_departure_bypass_restrictions`  string , `allow_same_day_bypass_restrictions`  string , `min_current_time_same_day_bypass`  string , `max_same_day_per_customer`  string , `max_same_time_same_day_per_customer`  string , `max_diff_unit_type_same_day_per_customer`  string , `max_same_weekend_sat_sun_per_customer`  string , `max_same_weekend_fri_sun_per_customer`  string , `max_same_weekend_fri_sat_per_customer`  string , `max_same_weekend_holiday_different_days_per_customer`  string , `max_same_weekend_holiday_same_days_per_customer`  string , `max_active_per_customer`  string , `max_active_weekday_per_customer`  string , `max_active_weekend_per_customer`  string , `max_per_week_per_customer`  string , `max_per_period_per_customer`  string , `max_weekday_per_period_per_customer`  string , `max_weekend_per_period_per_customer`  string , `max_per_period_per_location_per_customer`  string , `max_visiting_fleet_occupancy_per_location`  string , `disable_consecutive_per_customer`  string , `valid_days`  string , `holidays_only_if_valid_day`  string , `max_rental_days`  string , `valid_groups`  string , `valid_styles`  string , `status`  string , `created_at`  string , `updated_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_imsclub_restrictions/2026-04-16/1776334545'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclub_restrictions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsclub_restrictions/2026-04-16/1776334545
id: 1716704
processed: 1

raw_data:

{
    "allow_same_day_bypass_restrictions": 17,
    "coupons_allowed": 4,
    "created_at": 43,
    "disable_consecutive_per_customer": 36,
    "holidays_only_if_valid_day": 38,
    "id": 1,
    "location_id": 2,
    "max_active_per_customer": 27,
    "max_active_weekday_per_customer": 28,
    "max_active_weekend_per_customer": 29,
    "max_departure_time": 6,
    "max_diff_unit_type_same_day_per_customer": 21,
    "max_hours": 10,
    "max_hours_before_departure_book": 12,
    "max_hours_before_departure_bypass_restrictions": 16,
    "max_hours_before_departure_cancel": 14,
    "max_per_period_per_customer": 31,
    "max_per_period_per_location_per_customer": 34,
    "max_per_week_per_customer": 30,
    "max_rental_days": 39,
    "max_return_time": 8,
    "max_same_day_per_customer": 19,
    "max_same_time_same_day_per_customer": 20,
    "max_same_weekend_fri_sat_per_customer": 24,
    "max_same_weekend_fri_sun_per_customer": 23,
    "max_same_weekend_holiday_different_days_per_customer": 25,
    "max_same_weekend_holiday_same_days_per_customer": 26,
    "max_same_weekend_sat_sun_per_customer": 22,
    "max_visiting_fleet_occupancy_per_location": 35,
    "max_weekday_per_period_per_customer": 32,
    "max_weekend_per_period_per_customer": 33,
    "min_current_time_same_day_bypass": 18,
    "min_departure_time": 5,
    "min_hours": 9,
    "min_hours_before_departure_book": 11,
    "min_hours_before_departure_cancel": 13,
    "min_hours_before_departure_free_cancel": 15,
    "min_return_time": 7,
    "restriction_name": 3,
    "status": 42,
    "tenant": 0,
    "updated_at": 44,
    "valid_days": 37,
    "valid_groups": 40,
    "valid_styles": 41
}

schema_attributes:

{
    "allow_same_day_bypass_restrictions": "string",
    "coupons_allowed": "string",
    "created_at": "string",
    "disable_consecutive_per_customer": "string",
    "holidays_only_if_valid_day": "string",
    "id": "string",
    "location_id": "string",
    "max_active_per_customer": "string",
    "max_active_weekday_per_customer": "string",
    "max_active_weekend_per_customer": "string",
    "max_departure_time": "string",
    "max_diff_unit_type_same_day_per_customer": "string",
    "max_hours": "string",
    "max_hours_before_departure_book": "string",
    "max_hours_before_departure_bypass_restrictions": "string",
    "max_hours_before_departure_cancel": "string",
    "max_per_period_per_customer": "string",
    "max_per_period_per_location_per_customer": "string",
    "max_per_week_per_customer": "string",
    "max_rental_days": "string",
    "max_return_time": "string",
    "max_same_day_per_customer": "string",
    "max_same_time_same_day_per_customer": "string",
    "max_same_weekend_fri_sat_per_customer": "string",
    "max_same_weekend_fri_sun_per_customer": "string",
    "max_same_weekend_holiday_different_days_per_customer": "string",
    "max_same_weekend_holiday_same_days_per_customer": "string",
    "max_same_weekend_sat_sun_per_customer": "string",
    "max_visiting_fleet_occupancy_per_location": "string",
    "max_weekday_per_period_per_customer": "string",
    "max_weekend_per_period_per_customer": "string",
    "min_current_time_same_day_bypass": "string",
    "min_departure_time": "string",
    "min_hours": "string",
    "min_hours_before_departure_book": "string",
    "min_hours_before_departure_cancel": "string",
    "min_hours_before_departure_free_cancel": "string",
    "min_return_time": "string",
    "restriction_name": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string",
    "valid_days": "string",
    "valid_groups": "string",
    "valid_styles": "string"
}

schema_name_id: 1505
schema_scan_id: 162114373
updated: 2026-04-16 05:16:38

Version 1715484

created: 2026-04-15 03:41:02

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclub_restrictions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclub_restrictions`\n(\n `tenant`  string , `id`  string , `location_id`  string , `restriction_name`  string , `coupons_allowed`  string , `min_departure_time`  string , `max_departure_time`  string , `min_return_time`  string , `max_return_time`  string , `min_hours`  string , `max_hours`  string , `min_hours_before_departure_book`  string , `max_hours_before_departure_book`  string , `min_hours_before_departure_cancel`  string , `max_hours_before_departure_cancel`  string , `min_hours_before_departure_free_cancel`  string , `max_hours_before_departure_bypass_restrictions`  string , `allow_same_day_bypass_restrictions`  string , `min_current_time_same_day_bypass`  string , `max_same_day_per_customer`  string , `max_same_time_same_day_per_customer`  string , `max_diff_unit_type_same_day_per_customer`  string , `max_same_weekend_sat_sun_per_customer`  string , `max_same_weekend_fri_sun_per_customer`  string , `max_same_weekend_fri_sat_per_customer`  string , `max_same_weekend_holiday_different_days_per_customer`  string , `max_same_weekend_holiday_same_days_per_customer`  string , `max_active_per_customer`  string , `max_active_weekday_per_customer`  string , `max_active_weekend_per_customer`  string , `max_per_week_per_customer`  string , `max_per_period_per_customer`  string , `max_weekday_per_period_per_customer`  string , `max_weekend_per_period_per_customer`  string , `max_per_period_per_location_per_customer`  string , `max_visiting_fleet_occupancy_per_location`  string , `disable_consecutive_per_customer`  string , `valid_days`  string , `holidays_only_if_valid_day`  string , `max_rental_days`  string , `valid_groups`  string , `valid_styles`  string , `status`  string , `created_at`  string , `updated_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_imsclub_restrictions/2026-04-15/1776242358'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclub_restrictions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsclub_restrictions/2026-04-15/1776242358
id: 1715484
processed: 1

raw_data:

{
    "allow_same_day_bypass_restrictions": 17,
    "coupons_allowed": 4,
    "created_at": 43,
    "disable_consecutive_per_customer": 36,
    "holidays_only_if_valid_day": 38,
    "id": 1,
    "location_id": 2,
    "max_active_per_customer": 27,
    "max_active_weekday_per_customer": 28,
    "max_active_weekend_per_customer": 29,
    "max_departure_time": 6,
    "max_diff_unit_type_same_day_per_customer": 21,
    "max_hours": 10,
    "max_hours_before_departure_book": 12,
    "max_hours_before_departure_bypass_restrictions": 16,
    "max_hours_before_departure_cancel": 14,
    "max_per_period_per_customer": 31,
    "max_per_period_per_location_per_customer": 34,
    "max_per_week_per_customer": 30,
    "max_rental_days": 39,
    "max_return_time": 8,
    "max_same_day_per_customer": 19,
    "max_same_time_same_day_per_customer": 20,
    "max_same_weekend_fri_sat_per_customer": 24,
    "max_same_weekend_fri_sun_per_customer": 23,
    "max_same_weekend_holiday_different_days_per_customer": 25,
    "max_same_weekend_holiday_same_days_per_customer": 26,
    "max_same_weekend_sat_sun_per_customer": 22,
    "max_visiting_fleet_occupancy_per_location": 35,
    "max_weekday_per_period_per_customer": 32,
    "max_weekend_per_period_per_customer": 33,
    "min_current_time_same_day_bypass": 18,
    "min_departure_time": 5,
    "min_hours": 9,
    "min_hours_before_departure_book": 11,
    "min_hours_before_departure_cancel": 13,
    "min_hours_before_departure_free_cancel": 15,
    "min_return_time": 7,
    "restriction_name": 3,
    "status": 42,
    "tenant": 0,
    "updated_at": 44,
    "valid_days": 37,
    "valid_groups": 40,
    "valid_styles": 41
}

schema_attributes:

{
    "allow_same_day_bypass_restrictions": "string",
    "coupons_allowed": "string",
    "created_at": "string",
    "disable_consecutive_per_customer": "string",
    "holidays_only_if_valid_day": "string",
    "id": "string",
    "location_id": "string",
    "max_active_per_customer": "string",
    "max_active_weekday_per_customer": "string",
    "max_active_weekend_per_customer": "string",
    "max_departure_time": "string",
    "max_diff_unit_type_same_day_per_customer": "string",
    "max_hours": "string",
    "max_hours_before_departure_book": "string",
    "max_hours_before_departure_bypass_restrictions": "string",
    "max_hours_before_departure_cancel": "string",
    "max_per_period_per_customer": "string",
    "max_per_period_per_location_per_customer": "string",
    "max_per_week_per_customer": "string",
    "max_rental_days": "string",
    "max_return_time": "string",
    "max_same_day_per_customer": "string",
    "max_same_time_same_day_per_customer": "string",
    "max_same_weekend_fri_sat_per_customer": "string",
    "max_same_weekend_fri_sun_per_customer": "string",
    "max_same_weekend_holiday_different_days_per_customer": "string",
    "max_same_weekend_holiday_same_days_per_customer": "string",
    "max_same_weekend_sat_sun_per_customer": "string",
    "max_visiting_fleet_occupancy_per_location": "string",
    "max_weekday_per_period_per_customer": "string",
    "max_weekend_per_period_per_customer": "string",
    "min_current_time_same_day_bypass": "string",
    "min_departure_time": "string",
    "min_hours": "string",
    "min_hours_before_departure_book": "string",
    "min_hours_before_departure_cancel": "string",
    "min_hours_before_departure_free_cancel": "string",
    "min_return_time": "string",
    "restriction_name": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string",
    "valid_days": "string",
    "valid_groups": "string",
    "valid_styles": "string"
}

schema_name_id: 1505
schema_scan_id: 162056367
updated: 2026-04-15 03:41:16

Version 1714387

created: 2026-04-14 05:04:13

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclub_restrictions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclub_restrictions`\n(\n `tenant`  string , `id`  string , `location_id`  string , `restriction_name`  string , `coupons_allowed`  string , `min_departure_time`  string , `max_departure_time`  string , `min_return_time`  string , `max_return_time`  string , `min_hours`  string , `max_hours`  string , `min_hours_before_departure_book`  string , `max_hours_before_departure_book`  string , `min_hours_before_departure_cancel`  string , `max_hours_before_departure_cancel`  string , `min_hours_before_departure_free_cancel`  string , `max_hours_before_departure_bypass_restrictions`  string , `allow_same_day_bypass_restrictions`  string , `min_current_time_same_day_bypass`  string , `max_same_day_per_customer`  string , `max_same_time_same_day_per_customer`  string , `max_diff_unit_type_same_day_per_customer`  string , `max_same_weekend_sat_sun_per_customer`  string , `max_same_weekend_fri_sun_per_customer`  string , `max_same_weekend_fri_sat_per_customer`  string , `max_same_weekend_holiday_different_days_per_customer`  string , `max_same_weekend_holiday_same_days_per_customer`  string , `max_active_per_customer`  string , `max_active_weekday_per_customer`  string , `max_active_weekend_per_customer`  string , `max_per_week_per_customer`  string , `max_per_period_per_customer`  string , `max_weekday_per_period_per_customer`  string , `max_weekend_per_period_per_customer`  string , `max_per_period_per_location_per_customer`  string , `max_visiting_fleet_occupancy_per_location`  string , `disable_consecutive_per_customer`  string , `valid_days`  string , `holidays_only_if_valid_day`  string , `max_rental_days`  string , `valid_groups`  string , `valid_styles`  string , `status`  string , `created_at`  string , `updated_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_imsclub_restrictions/2026-04-14/1776160758'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclub_restrictions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsclub_restrictions/2026-04-14/1776160758
id: 1714387
processed: 1

raw_data:

{
    "allow_same_day_bypass_restrictions": 17,
    "coupons_allowed": 4,
    "created_at": 43,
    "disable_consecutive_per_customer": 36,
    "holidays_only_if_valid_day": 38,
    "id": 1,
    "location_id": 2,
    "max_active_per_customer": 27,
    "max_active_weekday_per_customer": 28,
    "max_active_weekend_per_customer": 29,
    "max_departure_time": 6,
    "max_diff_unit_type_same_day_per_customer": 21,
    "max_hours": 10,
    "max_hours_before_departure_book": 12,
    "max_hours_before_departure_bypass_restrictions": 16,
    "max_hours_before_departure_cancel": 14,
    "max_per_period_per_customer": 31,
    "max_per_period_per_location_per_customer": 34,
    "max_per_week_per_customer": 30,
    "max_rental_days": 39,
    "max_return_time": 8,
    "max_same_day_per_customer": 19,
    "max_same_time_same_day_per_customer": 20,
    "max_same_weekend_fri_sat_per_customer": 24,
    "max_same_weekend_fri_sun_per_customer": 23,
    "max_same_weekend_holiday_different_days_per_customer": 25,
    "max_same_weekend_holiday_same_days_per_customer": 26,
    "max_same_weekend_sat_sun_per_customer": 22,
    "max_visiting_fleet_occupancy_per_location": 35,
    "max_weekday_per_period_per_customer": 32,
    "max_weekend_per_period_per_customer": 33,
    "min_current_time_same_day_bypass": 18,
    "min_departure_time": 5,
    "min_hours": 9,
    "min_hours_before_departure_book": 11,
    "min_hours_before_departure_cancel": 13,
    "min_hours_before_departure_free_cancel": 15,
    "min_return_time": 7,
    "restriction_name": 3,
    "status": 42,
    "tenant": 0,
    "updated_at": 44,
    "valid_days": 37,
    "valid_groups": 40,
    "valid_styles": 41
}

schema_attributes:

{
    "allow_same_day_bypass_restrictions": "string",
    "coupons_allowed": "string",
    "created_at": "string",
    "disable_consecutive_per_customer": "string",
    "holidays_only_if_valid_day": "string",
    "id": "string",
    "location_id": "string",
    "max_active_per_customer": "string",
    "max_active_weekday_per_customer": "string",
    "max_active_weekend_per_customer": "string",
    "max_departure_time": "string",
    "max_diff_unit_type_same_day_per_customer": "string",
    "max_hours": "string",
    "max_hours_before_departure_book": "string",
    "max_hours_before_departure_bypass_restrictions": "string",
    "max_hours_before_departure_cancel": "string",
    "max_per_period_per_customer": "string",
    "max_per_period_per_location_per_customer": "string",
    "max_per_week_per_customer": "string",
    "max_rental_days": "string",
    "max_return_time": "string",
    "max_same_day_per_customer": "string",
    "max_same_time_same_day_per_customer": "string",
    "max_same_weekend_fri_sat_per_customer": "string",
    "max_same_weekend_fri_sun_per_customer": "string",
    "max_same_weekend_holiday_different_days_per_customer": "string",
    "max_same_weekend_holiday_same_days_per_customer": "string",
    "max_same_weekend_sat_sun_per_customer": "string",
    "max_visiting_fleet_occupancy_per_location": "string",
    "max_weekday_per_period_per_customer": "string",
    "max_weekend_per_period_per_customer": "string",
    "min_current_time_same_day_bypass": "string",
    "min_departure_time": "string",
    "min_hours": "string",
    "min_hours_before_departure_book": "string",
    "min_hours_before_departure_cancel": "string",
    "min_hours_before_departure_free_cancel": "string",
    "min_return_time": "string",
    "restriction_name": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string",
    "valid_days": "string",
    "valid_groups": "string",
    "valid_styles": "string"
}

schema_name_id: 1505
schema_scan_id: 162003118
updated: 2026-04-14 05:04:24

Version 1713079

created: 2026-04-13 05:07:31

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclub_restrictions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclub_restrictions`\n(\n `tenant`  string , `id`  string , `location_id`  string , `restriction_name`  string , `coupons_allowed`  string , `min_departure_time`  string , `max_departure_time`  string , `min_return_time`  string , `max_return_time`  string , `min_hours`  string , `max_hours`  string , `min_hours_before_departure_book`  string , `max_hours_before_departure_book`  string , `min_hours_before_departure_cancel`  string , `max_hours_before_departure_cancel`  string , `min_hours_before_departure_free_cancel`  string , `max_hours_before_departure_bypass_restrictions`  string , `allow_same_day_bypass_restrictions`  string , `min_current_time_same_day_bypass`  string , `max_same_day_per_customer`  string , `max_same_time_same_day_per_customer`  string , `max_diff_unit_type_same_day_per_customer`  string , `max_same_weekend_sat_sun_per_customer`  string , `max_same_weekend_fri_sun_per_customer`  string , `max_same_weekend_fri_sat_per_customer`  string , `max_same_weekend_holiday_different_days_per_customer`  string , `max_same_weekend_holiday_same_days_per_customer`  string , `max_active_per_customer`  string , `max_active_weekday_per_customer`  string , `max_active_weekend_per_customer`  string , `max_per_week_per_customer`  string , `max_per_period_per_customer`  string , `max_weekday_per_period_per_customer`  string , `max_weekend_per_period_per_customer`  string , `max_per_period_per_location_per_customer`  string , `max_visiting_fleet_occupancy_per_location`  string , `disable_consecutive_per_customer`  string , `valid_days`  string , `holidays_only_if_valid_day`  string , `max_rental_days`  string , `valid_groups`  string , `valid_styles`  string , `status`  string , `created_at`  string , `updated_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_imsclub_restrictions/2026-04-13/1776074799'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclub_restrictions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsclub_restrictions/2026-04-13/1776074799
id: 1713079
processed: 1

raw_data:

{
    "allow_same_day_bypass_restrictions": 17,
    "coupons_allowed": 4,
    "created_at": 43,
    "disable_consecutive_per_customer": 36,
    "holidays_only_if_valid_day": 38,
    "id": 1,
    "location_id": 2,
    "max_active_per_customer": 27,
    "max_active_weekday_per_customer": 28,
    "max_active_weekend_per_customer": 29,
    "max_departure_time": 6,
    "max_diff_unit_type_same_day_per_customer": 21,
    "max_hours": 10,
    "max_hours_before_departure_book": 12,
    "max_hours_before_departure_bypass_restrictions": 16,
    "max_hours_before_departure_cancel": 14,
    "max_per_period_per_customer": 31,
    "max_per_period_per_location_per_customer": 34,
    "max_per_week_per_customer": 30,
    "max_rental_days": 39,
    "max_return_time": 8,
    "max_same_day_per_customer": 19,
    "max_same_time_same_day_per_customer": 20,
    "max_same_weekend_fri_sat_per_customer": 24,
    "max_same_weekend_fri_sun_per_customer": 23,
    "max_same_weekend_holiday_different_days_per_customer": 25,
    "max_same_weekend_holiday_same_days_per_customer": 26,
    "max_same_weekend_sat_sun_per_customer": 22,
    "max_visiting_fleet_occupancy_per_location": 35,
    "max_weekday_per_period_per_customer": 32,
    "max_weekend_per_period_per_customer": 33,
    "min_current_time_same_day_bypass": 18,
    "min_departure_time": 5,
    "min_hours": 9,
    "min_hours_before_departure_book": 11,
    "min_hours_before_departure_cancel": 13,
    "min_hours_before_departure_free_cancel": 15,
    "min_return_time": 7,
    "restriction_name": 3,
    "status": 42,
    "tenant": 0,
    "updated_at": 44,
    "valid_days": 37,
    "valid_groups": 40,
    "valid_styles": 41
}

schema_attributes:

{
    "allow_same_day_bypass_restrictions": "string",
    "coupons_allowed": "string",
    "created_at": "string",
    "disable_consecutive_per_customer": "string",
    "holidays_only_if_valid_day": "string",
    "id": "string",
    "location_id": "string",
    "max_active_per_customer": "string",
    "max_active_weekday_per_customer": "string",
    "max_active_weekend_per_customer": "string",
    "max_departure_time": "string",
    "max_diff_unit_type_same_day_per_customer": "string",
    "max_hours": "string",
    "max_hours_before_departure_book": "string",
    "max_hours_before_departure_bypass_restrictions": "string",
    "max_hours_before_departure_cancel": "string",
    "max_per_period_per_customer": "string",
    "max_per_period_per_location_per_customer": "string",
    "max_per_week_per_customer": "string",
    "max_rental_days": "string",
    "max_return_time": "string",
    "max_same_day_per_customer": "string",
    "max_same_time_same_day_per_customer": "string",
    "max_same_weekend_fri_sat_per_customer": "string",
    "max_same_weekend_fri_sun_per_customer": "string",
    "max_same_weekend_holiday_different_days_per_customer": "string",
    "max_same_weekend_holiday_same_days_per_customer": "string",
    "max_same_weekend_sat_sun_per_customer": "string",
    "max_visiting_fleet_occupancy_per_location": "string",
    "max_weekday_per_period_per_customer": "string",
    "max_weekend_per_period_per_customer": "string",
    "min_current_time_same_day_bypass": "string",
    "min_departure_time": "string",
    "min_hours": "string",
    "min_hours_before_departure_book": "string",
    "min_hours_before_departure_cancel": "string",
    "min_hours_before_departure_free_cancel": "string",
    "min_return_time": "string",
    "restriction_name": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string",
    "valid_days": "string",
    "valid_groups": "string",
    "valid_styles": "string"
}

schema_name_id: 1505
schema_scan_id: 161945284
updated: 2026-04-13 05:07:42

Version 1711920

created: 2026-04-12 05:05:10

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclub_restrictions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclub_restrictions`\n(\n `tenant`  string , `id`  string , `location_id`  string , `restriction_name`  string , `coupons_allowed`  string , `min_departure_time`  string , `max_departure_time`  string , `min_return_time`  string , `max_return_time`  string , `min_hours`  string , `max_hours`  string , `min_hours_before_departure_book`  string , `max_hours_before_departure_book`  string , `min_hours_before_departure_cancel`  string , `max_hours_before_departure_cancel`  string , `min_hours_before_departure_free_cancel`  string , `max_hours_before_departure_bypass_restrictions`  string , `allow_same_day_bypass_restrictions`  string , `min_current_time_same_day_bypass`  string , `max_same_day_per_customer`  string , `max_same_time_same_day_per_customer`  string , `max_diff_unit_type_same_day_per_customer`  string , `max_same_weekend_sat_sun_per_customer`  string , `max_same_weekend_fri_sun_per_customer`  string , `max_same_weekend_fri_sat_per_customer`  string , `max_same_weekend_holiday_different_days_per_customer`  string , `max_same_weekend_holiday_same_days_per_customer`  string , `max_active_per_customer`  string , `max_active_weekday_per_customer`  string , `max_active_weekend_per_customer`  string , `max_per_week_per_customer`  string , `max_per_period_per_customer`  string , `max_weekday_per_period_per_customer`  string , `max_weekend_per_period_per_customer`  string , `max_per_period_per_location_per_customer`  string , `max_visiting_fleet_occupancy_per_location`  string , `disable_consecutive_per_customer`  string , `valid_days`  string , `holidays_only_if_valid_day`  string , `max_rental_days`  string , `valid_groups`  string , `valid_styles`  string , `status`  string , `created_at`  string , `updated_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_imsclub_restrictions/2026-04-12/1775988157'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclub_restrictions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsclub_restrictions/2026-04-12/1775988157
id: 1711920
processed: 1

raw_data:

{
    "allow_same_day_bypass_restrictions": 17,
    "coupons_allowed": 4,
    "created_at": 43,
    "disable_consecutive_per_customer": 36,
    "holidays_only_if_valid_day": 38,
    "id": 1,
    "location_id": 2,
    "max_active_per_customer": 27,
    "max_active_weekday_per_customer": 28,
    "max_active_weekend_per_customer": 29,
    "max_departure_time": 6,
    "max_diff_unit_type_same_day_per_customer": 21,
    "max_hours": 10,
    "max_hours_before_departure_book": 12,
    "max_hours_before_departure_bypass_restrictions": 16,
    "max_hours_before_departure_cancel": 14,
    "max_per_period_per_customer": 31,
    "max_per_period_per_location_per_customer": 34,
    "max_per_week_per_customer": 30,
    "max_rental_days": 39,
    "max_return_time": 8,
    "max_same_day_per_customer": 19,
    "max_same_time_same_day_per_customer": 20,
    "max_same_weekend_fri_sat_per_customer": 24,
    "max_same_weekend_fri_sun_per_customer": 23,
    "max_same_weekend_holiday_different_days_per_customer": 25,
    "max_same_weekend_holiday_same_days_per_customer": 26,
    "max_same_weekend_sat_sun_per_customer": 22,
    "max_visiting_fleet_occupancy_per_location": 35,
    "max_weekday_per_period_per_customer": 32,
    "max_weekend_per_period_per_customer": 33,
    "min_current_time_same_day_bypass": 18,
    "min_departure_time": 5,
    "min_hours": 9,
    "min_hours_before_departure_book": 11,
    "min_hours_before_departure_cancel": 13,
    "min_hours_before_departure_free_cancel": 15,
    "min_return_time": 7,
    "restriction_name": 3,
    "status": 42,
    "tenant": 0,
    "updated_at": 44,
    "valid_days": 37,
    "valid_groups": 40,
    "valid_styles": 41
}

schema_attributes:

{
    "allow_same_day_bypass_restrictions": "string",
    "coupons_allowed": "string",
    "created_at": "string",
    "disable_consecutive_per_customer": "string",
    "holidays_only_if_valid_day": "string",
    "id": "string",
    "location_id": "string",
    "max_active_per_customer": "string",
    "max_active_weekday_per_customer": "string",
    "max_active_weekend_per_customer": "string",
    "max_departure_time": "string",
    "max_diff_unit_type_same_day_per_customer": "string",
    "max_hours": "string",
    "max_hours_before_departure_book": "string",
    "max_hours_before_departure_bypass_restrictions": "string",
    "max_hours_before_departure_cancel": "string",
    "max_per_period_per_customer": "string",
    "max_per_period_per_location_per_customer": "string",
    "max_per_week_per_customer": "string",
    "max_rental_days": "string",
    "max_return_time": "string",
    "max_same_day_per_customer": "string",
    "max_same_time_same_day_per_customer": "string",
    "max_same_weekend_fri_sat_per_customer": "string",
    "max_same_weekend_fri_sun_per_customer": "string",
    "max_same_weekend_holiday_different_days_per_customer": "string",
    "max_same_weekend_holiday_same_days_per_customer": "string",
    "max_same_weekend_sat_sun_per_customer": "string",
    "max_visiting_fleet_occupancy_per_location": "string",
    "max_weekday_per_period_per_customer": "string",
    "max_weekend_per_period_per_customer": "string",
    "min_current_time_same_day_bypass": "string",
    "min_departure_time": "string",
    "min_hours": "string",
    "min_hours_before_departure_book": "string",
    "min_hours_before_departure_cancel": "string",
    "min_hours_before_departure_free_cancel": "string",
    "min_return_time": "string",
    "restriction_name": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string",
    "valid_days": "string",
    "valid_groups": "string",
    "valid_styles": "string"
}

schema_name_id: 1505
schema_scan_id: 161896367
updated: 2026-04-12 05:05:24

Version 1710722

created: 2026-04-11 05:18:16

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclub_restrictions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclub_restrictions`\n(\n `tenant`  string , `id`  string , `location_id`  string , `restriction_name`  string , `coupons_allowed`  string , `min_departure_time`  string , `max_departure_time`  string , `min_return_time`  string , `max_return_time`  string , `min_hours`  string , `max_hours`  string , `min_hours_before_departure_book`  string , `max_hours_before_departure_book`  string , `min_hours_before_departure_cancel`  string , `max_hours_before_departure_cancel`  string , `min_hours_before_departure_free_cancel`  string , `max_hours_before_departure_bypass_restrictions`  string , `allow_same_day_bypass_restrictions`  string , `min_current_time_same_day_bypass`  string , `max_same_day_per_customer`  string , `max_same_time_same_day_per_customer`  string , `max_diff_unit_type_same_day_per_customer`  string , `max_same_weekend_sat_sun_per_customer`  string , `max_same_weekend_fri_sun_per_customer`  string , `max_same_weekend_fri_sat_per_customer`  string , `max_same_weekend_holiday_different_days_per_customer`  string , `max_same_weekend_holiday_same_days_per_customer`  string , `max_active_per_customer`  string , `max_active_weekday_per_customer`  string , `max_active_weekend_per_customer`  string , `max_per_week_per_customer`  string , `max_per_period_per_customer`  string , `max_weekday_per_period_per_customer`  string , `max_weekend_per_period_per_customer`  string , `max_per_period_per_location_per_customer`  string , `max_visiting_fleet_occupancy_per_location`  string , `disable_consecutive_per_customer`  string , `valid_days`  string , `holidays_only_if_valid_day`  string , `max_rental_days`  string , `valid_groups`  string , `valid_styles`  string , `status`  string , `created_at`  string , `updated_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_imsclub_restrictions/2026-04-11/1775902576'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclub_restrictions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsclub_restrictions/2026-04-11/1775902576
id: 1710722
processed: 1

raw_data:

{
    "allow_same_day_bypass_restrictions": 17,
    "coupons_allowed": 4,
    "created_at": 43,
    "disable_consecutive_per_customer": 36,
    "holidays_only_if_valid_day": 38,
    "id": 1,
    "location_id": 2,
    "max_active_per_customer": 27,
    "max_active_weekday_per_customer": 28,
    "max_active_weekend_per_customer": 29,
    "max_departure_time": 6,
    "max_diff_unit_type_same_day_per_customer": 21,
    "max_hours": 10,
    "max_hours_before_departure_book": 12,
    "max_hours_before_departure_bypass_restrictions": 16,
    "max_hours_before_departure_cancel": 14,
    "max_per_period_per_customer": 31,
    "max_per_period_per_location_per_customer": 34,
    "max_per_week_per_customer": 30,
    "max_rental_days": 39,
    "max_return_time": 8,
    "max_same_day_per_customer": 19,
    "max_same_time_same_day_per_customer": 20,
    "max_same_weekend_fri_sat_per_customer": 24,
    "max_same_weekend_fri_sun_per_customer": 23,
    "max_same_weekend_holiday_different_days_per_customer": 25,
    "max_same_weekend_holiday_same_days_per_customer": 26,
    "max_same_weekend_sat_sun_per_customer": 22,
    "max_visiting_fleet_occupancy_per_location": 35,
    "max_weekday_per_period_per_customer": 32,
    "max_weekend_per_period_per_customer": 33,
    "min_current_time_same_day_bypass": 18,
    "min_departure_time": 5,
    "min_hours": 9,
    "min_hours_before_departure_book": 11,
    "min_hours_before_departure_cancel": 13,
    "min_hours_before_departure_free_cancel": 15,
    "min_return_time": 7,
    "restriction_name": 3,
    "status": 42,
    "tenant": 0,
    "updated_at": 44,
    "valid_days": 37,
    "valid_groups": 40,
    "valid_styles": 41
}

schema_attributes:

{
    "allow_same_day_bypass_restrictions": "string",
    "coupons_allowed": "string",
    "created_at": "string",
    "disable_consecutive_per_customer": "string",
    "holidays_only_if_valid_day": "string",
    "id": "string",
    "location_id": "string",
    "max_active_per_customer": "string",
    "max_active_weekday_per_customer": "string",
    "max_active_weekend_per_customer": "string",
    "max_departure_time": "string",
    "max_diff_unit_type_same_day_per_customer": "string",
    "max_hours": "string",
    "max_hours_before_departure_book": "string",
    "max_hours_before_departure_bypass_restrictions": "string",
    "max_hours_before_departure_cancel": "string",
    "max_per_period_per_customer": "string",
    "max_per_period_per_location_per_customer": "string",
    "max_per_week_per_customer": "string",
    "max_rental_days": "string",
    "max_return_time": "string",
    "max_same_day_per_customer": "string",
    "max_same_time_same_day_per_customer": "string",
    "max_same_weekend_fri_sat_per_customer": "string",
    "max_same_weekend_fri_sun_per_customer": "string",
    "max_same_weekend_holiday_different_days_per_customer": "string",
    "max_same_weekend_holiday_same_days_per_customer": "string",
    "max_same_weekend_sat_sun_per_customer": "string",
    "max_visiting_fleet_occupancy_per_location": "string",
    "max_weekday_per_period_per_customer": "string",
    "max_weekend_per_period_per_customer": "string",
    "min_current_time_same_day_bypass": "string",
    "min_departure_time": "string",
    "min_hours": "string",
    "min_hours_before_departure_book": "string",
    "min_hours_before_departure_cancel": "string",
    "min_hours_before_departure_free_cancel": "string",
    "min_return_time": "string",
    "restriction_name": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string",
    "valid_days": "string",
    "valid_groups": "string",
    "valid_styles": "string"
}

schema_name_id: 1505
schema_scan_id: 161843941
updated: 2026-04-11 05:18:30

Version 1709533

created: 2026-04-10 05:01:44

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclub_restrictions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclub_restrictions`\n(\n `tenant`  string , `id`  string , `location_id`  string , `restriction_name`  string , `coupons_allowed`  string , `min_departure_time`  string , `max_departure_time`  string , `min_return_time`  string , `max_return_time`  string , `min_hours`  string , `max_hours`  string , `min_hours_before_departure_book`  string , `max_hours_before_departure_book`  string , `min_hours_before_departure_cancel`  string , `max_hours_before_departure_cancel`  string , `min_hours_before_departure_free_cancel`  string , `max_hours_before_departure_bypass_restrictions`  string , `allow_same_day_bypass_restrictions`  string , `min_current_time_same_day_bypass`  string , `max_same_day_per_customer`  string , `max_same_time_same_day_per_customer`  string , `max_diff_unit_type_same_day_per_customer`  string , `max_same_weekend_sat_sun_per_customer`  string , `max_same_weekend_fri_sun_per_customer`  string , `max_same_weekend_fri_sat_per_customer`  string , `max_same_weekend_holiday_different_days_per_customer`  string , `max_same_weekend_holiday_same_days_per_customer`  string , `max_active_per_customer`  string , `max_active_weekday_per_customer`  string , `max_active_weekend_per_customer`  string , `max_per_week_per_customer`  string , `max_per_period_per_customer`  string , `max_weekday_per_period_per_customer`  string , `max_weekend_per_period_per_customer`  string , `max_per_period_per_location_per_customer`  string , `max_visiting_fleet_occupancy_per_location`  string , `disable_consecutive_per_customer`  string , `valid_days`  string , `holidays_only_if_valid_day`  string , `max_rental_days`  string , `valid_groups`  string , `valid_styles`  string , `status`  string , `created_at`  string , `updated_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_imsclub_restrictions/2026-04-10/1775815218'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclub_restrictions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsclub_restrictions/2026-04-10/1775815218
id: 1709533
processed: 1

raw_data:

{
    "allow_same_day_bypass_restrictions": 17,
    "coupons_allowed": 4,
    "created_at": 43,
    "disable_consecutive_per_customer": 36,
    "holidays_only_if_valid_day": 38,
    "id": 1,
    "location_id": 2,
    "max_active_per_customer": 27,
    "max_active_weekday_per_customer": 28,
    "max_active_weekend_per_customer": 29,
    "max_departure_time": 6,
    "max_diff_unit_type_same_day_per_customer": 21,
    "max_hours": 10,
    "max_hours_before_departure_book": 12,
    "max_hours_before_departure_bypass_restrictions": 16,
    "max_hours_before_departure_cancel": 14,
    "max_per_period_per_customer": 31,
    "max_per_period_per_location_per_customer": 34,
    "max_per_week_per_customer": 30,
    "max_rental_days": 39,
    "max_return_time": 8,
    "max_same_day_per_customer": 19,
    "max_same_time_same_day_per_customer": 20,
    "max_same_weekend_fri_sat_per_customer": 24,
    "max_same_weekend_fri_sun_per_customer": 23,
    "max_same_weekend_holiday_different_days_per_customer": 25,
    "max_same_weekend_holiday_same_days_per_customer": 26,
    "max_same_weekend_sat_sun_per_customer": 22,
    "max_visiting_fleet_occupancy_per_location": 35,
    "max_weekday_per_period_per_customer": 32,
    "max_weekend_per_period_per_customer": 33,
    "min_current_time_same_day_bypass": 18,
    "min_departure_time": 5,
    "min_hours": 9,
    "min_hours_before_departure_book": 11,
    "min_hours_before_departure_cancel": 13,
    "min_hours_before_departure_free_cancel": 15,
    "min_return_time": 7,
    "restriction_name": 3,
    "status": 42,
    "tenant": 0,
    "updated_at": 44,
    "valid_days": 37,
    "valid_groups": 40,
    "valid_styles": 41
}

schema_attributes:

{
    "allow_same_day_bypass_restrictions": "string",
    "coupons_allowed": "string",
    "created_at": "string",
    "disable_consecutive_per_customer": "string",
    "holidays_only_if_valid_day": "string",
    "id": "string",
    "location_id": "string",
    "max_active_per_customer": "string",
    "max_active_weekday_per_customer": "string",
    "max_active_weekend_per_customer": "string",
    "max_departure_time": "string",
    "max_diff_unit_type_same_day_per_customer": "string",
    "max_hours": "string",
    "max_hours_before_departure_book": "string",
    "max_hours_before_departure_bypass_restrictions": "string",
    "max_hours_before_departure_cancel": "string",
    "max_per_period_per_customer": "string",
    "max_per_period_per_location_per_customer": "string",
    "max_per_week_per_customer": "string",
    "max_rental_days": "string",
    "max_return_time": "string",
    "max_same_day_per_customer": "string",
    "max_same_time_same_day_per_customer": "string",
    "max_same_weekend_fri_sat_per_customer": "string",
    "max_same_weekend_fri_sun_per_customer": "string",
    "max_same_weekend_holiday_different_days_per_customer": "string",
    "max_same_weekend_holiday_same_days_per_customer": "string",
    "max_same_weekend_sat_sun_per_customer": "string",
    "max_visiting_fleet_occupancy_per_location": "string",
    "max_weekday_per_period_per_customer": "string",
    "max_weekend_per_period_per_customer": "string",
    "min_current_time_same_day_bypass": "string",
    "min_departure_time": "string",
    "min_hours": "string",
    "min_hours_before_departure_book": "string",
    "min_hours_before_departure_cancel": "string",
    "min_hours_before_departure_free_cancel": "string",
    "min_return_time": "string",
    "restriction_name": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string",
    "valid_days": "string",
    "valid_groups": "string",
    "valid_styles": "string"
}

schema_name_id: 1505
schema_scan_id: 161788572
updated: 2026-04-10 05:01:56

Version 1708394

created: 2026-04-09 05:02:08

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclub_restrictions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclub_restrictions`\n(\n `tenant`  string , `id`  string , `location_id`  string , `restriction_name`  string , `coupons_allowed`  string , `min_departure_time`  string , `max_departure_time`  string , `min_return_time`  string , `max_return_time`  string , `min_hours`  string , `max_hours`  string , `min_hours_before_departure_book`  string , `max_hours_before_departure_book`  string , `min_hours_before_departure_cancel`  string , `max_hours_before_departure_cancel`  string , `min_hours_before_departure_free_cancel`  string , `max_hours_before_departure_bypass_restrictions`  string , `allow_same_day_bypass_restrictions`  string , `min_current_time_same_day_bypass`  string , `max_same_day_per_customer`  string , `max_same_time_same_day_per_customer`  string , `max_diff_unit_type_same_day_per_customer`  string , `max_same_weekend_sat_sun_per_customer`  string , `max_same_weekend_fri_sun_per_customer`  string , `max_same_weekend_fri_sat_per_customer`  string , `max_same_weekend_holiday_different_days_per_customer`  string , `max_same_weekend_holiday_same_days_per_customer`  string , `max_active_per_customer`  string , `max_active_weekday_per_customer`  string , `max_active_weekend_per_customer`  string , `max_per_week_per_customer`  string , `max_per_period_per_customer`  string , `max_weekday_per_period_per_customer`  string , `max_weekend_per_period_per_customer`  string , `max_per_period_per_location_per_customer`  string , `max_visiting_fleet_occupancy_per_location`  string , `disable_consecutive_per_customer`  string , `valid_days`  string , `holidays_only_if_valid_day`  string , `max_rental_days`  string , `valid_groups`  string , `valid_styles`  string , `status`  string , `created_at`  string , `updated_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_imsclub_restrictions/2026-04-09/1775728840'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclub_restrictions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsclub_restrictions/2026-04-09/1775728840
id: 1708394
processed: 1

raw_data:

{
    "allow_same_day_bypass_restrictions": 17,
    "coupons_allowed": 4,
    "created_at": 43,
    "disable_consecutive_per_customer": 36,
    "holidays_only_if_valid_day": 38,
    "id": 1,
    "location_id": 2,
    "max_active_per_customer": 27,
    "max_active_weekday_per_customer": 28,
    "max_active_weekend_per_customer": 29,
    "max_departure_time": 6,
    "max_diff_unit_type_same_day_per_customer": 21,
    "max_hours": 10,
    "max_hours_before_departure_book": 12,
    "max_hours_before_departure_bypass_restrictions": 16,
    "max_hours_before_departure_cancel": 14,
    "max_per_period_per_customer": 31,
    "max_per_period_per_location_per_customer": 34,
    "max_per_week_per_customer": 30,
    "max_rental_days": 39,
    "max_return_time": 8,
    "max_same_day_per_customer": 19,
    "max_same_time_same_day_per_customer": 20,
    "max_same_weekend_fri_sat_per_customer": 24,
    "max_same_weekend_fri_sun_per_customer": 23,
    "max_same_weekend_holiday_different_days_per_customer": 25,
    "max_same_weekend_holiday_same_days_per_customer": 26,
    "max_same_weekend_sat_sun_per_customer": 22,
    "max_visiting_fleet_occupancy_per_location": 35,
    "max_weekday_per_period_per_customer": 32,
    "max_weekend_per_period_per_customer": 33,
    "min_current_time_same_day_bypass": 18,
    "min_departure_time": 5,
    "min_hours": 9,
    "min_hours_before_departure_book": 11,
    "min_hours_before_departure_cancel": 13,
    "min_hours_before_departure_free_cancel": 15,
    "min_return_time": 7,
    "restriction_name": 3,
    "status": 42,
    "tenant": 0,
    "updated_at": 44,
    "valid_days": 37,
    "valid_groups": 40,
    "valid_styles": 41
}

schema_attributes:

{
    "allow_same_day_bypass_restrictions": "string",
    "coupons_allowed": "string",
    "created_at": "string",
    "disable_consecutive_per_customer": "string",
    "holidays_only_if_valid_day": "string",
    "id": "string",
    "location_id": "string",
    "max_active_per_customer": "string",
    "max_active_weekday_per_customer": "string",
    "max_active_weekend_per_customer": "string",
    "max_departure_time": "string",
    "max_diff_unit_type_same_day_per_customer": "string",
    "max_hours": "string",
    "max_hours_before_departure_book": "string",
    "max_hours_before_departure_bypass_restrictions": "string",
    "max_hours_before_departure_cancel": "string",
    "max_per_period_per_customer": "string",
    "max_per_period_per_location_per_customer": "string",
    "max_per_week_per_customer": "string",
    "max_rental_days": "string",
    "max_return_time": "string",
    "max_same_day_per_customer": "string",
    "max_same_time_same_day_per_customer": "string",
    "max_same_weekend_fri_sat_per_customer": "string",
    "max_same_weekend_fri_sun_per_customer": "string",
    "max_same_weekend_holiday_different_days_per_customer": "string",
    "max_same_weekend_holiday_same_days_per_customer": "string",
    "max_same_weekend_sat_sun_per_customer": "string",
    "max_visiting_fleet_occupancy_per_location": "string",
    "max_weekday_per_period_per_customer": "string",
    "max_weekend_per_period_per_customer": "string",
    "min_current_time_same_day_bypass": "string",
    "min_departure_time": "string",
    "min_hours": "string",
    "min_hours_before_departure_book": "string",
    "min_hours_before_departure_cancel": "string",
    "min_hours_before_departure_free_cancel": "string",
    "min_return_time": "string",
    "restriction_name": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string",
    "valid_days": "string",
    "valid_groups": "string",
    "valid_styles": "string"
}

schema_name_id: 1505
schema_scan_id: 161732950
updated: 2026-04-09 05:02:21

Version 1707204

created: 2026-04-08 05:12:44

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclub_restrictions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclub_restrictions`\n(\n `tenant`  string , `id`  string , `location_id`  string , `restriction_name`  string , `coupons_allowed`  string , `min_departure_time`  string , `max_departure_time`  string , `min_return_time`  string , `max_return_time`  string , `min_hours`  string , `max_hours`  string , `min_hours_before_departure_book`  string , `max_hours_before_departure_book`  string , `min_hours_before_departure_cancel`  string , `max_hours_before_departure_cancel`  string , `min_hours_before_departure_free_cancel`  string , `max_hours_before_departure_bypass_restrictions`  string , `allow_same_day_bypass_restrictions`  string , `min_current_time_same_day_bypass`  string , `max_same_day_per_customer`  string , `max_same_time_same_day_per_customer`  string , `max_diff_unit_type_same_day_per_customer`  string , `max_same_weekend_sat_sun_per_customer`  string , `max_same_weekend_fri_sun_per_customer`  string , `max_same_weekend_fri_sat_per_customer`  string , `max_same_weekend_holiday_different_days_per_customer`  string , `max_same_weekend_holiday_same_days_per_customer`  string , `max_active_per_customer`  string , `max_active_weekday_per_customer`  string , `max_active_weekend_per_customer`  string , `max_per_week_per_customer`  string , `max_per_period_per_customer`  string , `max_weekday_per_period_per_customer`  string , `max_weekend_per_period_per_customer`  string , `max_per_period_per_location_per_customer`  string , `max_visiting_fleet_occupancy_per_location`  string , `disable_consecutive_per_customer`  string , `valid_days`  string , `holidays_only_if_valid_day`  string , `max_rental_days`  string , `valid_groups`  string , `valid_styles`  string , `status`  string , `created_at`  string , `updated_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_imsclub_restrictions/2026-04-08/1775643001'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclub_restrictions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsclub_restrictions/2026-04-08/1775643001
id: 1707204
processed: 1

raw_data:

{
    "allow_same_day_bypass_restrictions": 17,
    "coupons_allowed": 4,
    "created_at": 43,
    "disable_consecutive_per_customer": 36,
    "holidays_only_if_valid_day": 38,
    "id": 1,
    "location_id": 2,
    "max_active_per_customer": 27,
    "max_active_weekday_per_customer": 28,
    "max_active_weekend_per_customer": 29,
    "max_departure_time": 6,
    "max_diff_unit_type_same_day_per_customer": 21,
    "max_hours": 10,
    "max_hours_before_departure_book": 12,
    "max_hours_before_departure_bypass_restrictions": 16,
    "max_hours_before_departure_cancel": 14,
    "max_per_period_per_customer": 31,
    "max_per_period_per_location_per_customer": 34,
    "max_per_week_per_customer": 30,
    "max_rental_days": 39,
    "max_return_time": 8,
    "max_same_day_per_customer": 19,
    "max_same_time_same_day_per_customer": 20,
    "max_same_weekend_fri_sat_per_customer": 24,
    "max_same_weekend_fri_sun_per_customer": 23,
    "max_same_weekend_holiday_different_days_per_customer": 25,
    "max_same_weekend_holiday_same_days_per_customer": 26,
    "max_same_weekend_sat_sun_per_customer": 22,
    "max_visiting_fleet_occupancy_per_location": 35,
    "max_weekday_per_period_per_customer": 32,
    "max_weekend_per_period_per_customer": 33,
    "min_current_time_same_day_bypass": 18,
    "min_departure_time": 5,
    "min_hours": 9,
    "min_hours_before_departure_book": 11,
    "min_hours_before_departure_cancel": 13,
    "min_hours_before_departure_free_cancel": 15,
    "min_return_time": 7,
    "restriction_name": 3,
    "status": 42,
    "tenant": 0,
    "updated_at": 44,
    "valid_days": 37,
    "valid_groups": 40,
    "valid_styles": 41
}

schema_attributes:

{
    "allow_same_day_bypass_restrictions": "string",
    "coupons_allowed": "string",
    "created_at": "string",
    "disable_consecutive_per_customer": "string",
    "holidays_only_if_valid_day": "string",
    "id": "string",
    "location_id": "string",
    "max_active_per_customer": "string",
    "max_active_weekday_per_customer": "string",
    "max_active_weekend_per_customer": "string",
    "max_departure_time": "string",
    "max_diff_unit_type_same_day_per_customer": "string",
    "max_hours": "string",
    "max_hours_before_departure_book": "string",
    "max_hours_before_departure_bypass_restrictions": "string",
    "max_hours_before_departure_cancel": "string",
    "max_per_period_per_customer": "string",
    "max_per_period_per_location_per_customer": "string",
    "max_per_week_per_customer": "string",
    "max_rental_days": "string",
    "max_return_time": "string",
    "max_same_day_per_customer": "string",
    "max_same_time_same_day_per_customer": "string",
    "max_same_weekend_fri_sat_per_customer": "string",
    "max_same_weekend_fri_sun_per_customer": "string",
    "max_same_weekend_holiday_different_days_per_customer": "string",
    "max_same_weekend_holiday_same_days_per_customer": "string",
    "max_same_weekend_sat_sun_per_customer": "string",
    "max_visiting_fleet_occupancy_per_location": "string",
    "max_weekday_per_period_per_customer": "string",
    "max_weekend_per_period_per_customer": "string",
    "min_current_time_same_day_bypass": "string",
    "min_departure_time": "string",
    "min_hours": "string",
    "min_hours_before_departure_book": "string",
    "min_hours_before_departure_cancel": "string",
    "min_hours_before_departure_free_cancel": "string",
    "min_return_time": "string",
    "restriction_name": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string",
    "valid_days": "string",
    "valid_groups": "string",
    "valid_styles": "string"
}

schema_name_id: 1505
schema_scan_id: 161678362
updated: 2026-04-08 05:12:55

Version 1706038

created: 2026-04-07 05:17:01

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclub_restrictions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclub_restrictions`\n(\n `tenant`  string , `id`  string , `location_id`  string , `restriction_name`  string , `coupons_allowed`  string , `min_departure_time`  string , `max_departure_time`  string , `min_return_time`  string , `max_return_time`  string , `min_hours`  string , `max_hours`  string , `min_hours_before_departure_book`  string , `max_hours_before_departure_book`  string , `min_hours_before_departure_cancel`  string , `max_hours_before_departure_cancel`  string , `min_hours_before_departure_free_cancel`  string , `max_hours_before_departure_bypass_restrictions`  string , `allow_same_day_bypass_restrictions`  string , `min_current_time_same_day_bypass`  string , `max_same_day_per_customer`  string , `max_same_time_same_day_per_customer`  string , `max_diff_unit_type_same_day_per_customer`  string , `max_same_weekend_sat_sun_per_customer`  string , `max_same_weekend_fri_sun_per_customer`  string , `max_same_weekend_fri_sat_per_customer`  string , `max_same_weekend_holiday_different_days_per_customer`  string , `max_same_weekend_holiday_same_days_per_customer`  string , `max_active_per_customer`  string , `max_active_weekday_per_customer`  string , `max_active_weekend_per_customer`  string , `max_per_week_per_customer`  string , `max_per_period_per_customer`  string , `max_weekday_per_period_per_customer`  string , `max_weekend_per_period_per_customer`  string , `max_per_period_per_location_per_customer`  string , `max_visiting_fleet_occupancy_per_location`  string , `disable_consecutive_per_customer`  string , `valid_days`  string , `holidays_only_if_valid_day`  string , `max_rental_days`  string , `valid_groups`  string , `valid_styles`  string , `status`  string , `created_at`  string , `updated_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_imsclub_restrictions/2026-04-07/1775556856'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclub_restrictions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsclub_restrictions/2026-04-07/1775556856
id: 1706038
processed: 1

raw_data:

{
    "allow_same_day_bypass_restrictions": 17,
    "coupons_allowed": 4,
    "created_at": 43,
    "disable_consecutive_per_customer": 36,
    "holidays_only_if_valid_day": 38,
    "id": 1,
    "location_id": 2,
    "max_active_per_customer": 27,
    "max_active_weekday_per_customer": 28,
    "max_active_weekend_per_customer": 29,
    "max_departure_time": 6,
    "max_diff_unit_type_same_day_per_customer": 21,
    "max_hours": 10,
    "max_hours_before_departure_book": 12,
    "max_hours_before_departure_bypass_restrictions": 16,
    "max_hours_before_departure_cancel": 14,
    "max_per_period_per_customer": 31,
    "max_per_period_per_location_per_customer": 34,
    "max_per_week_per_customer": 30,
    "max_rental_days": 39,
    "max_return_time": 8,
    "max_same_day_per_customer": 19,
    "max_same_time_same_day_per_customer": 20,
    "max_same_weekend_fri_sat_per_customer": 24,
    "max_same_weekend_fri_sun_per_customer": 23,
    "max_same_weekend_holiday_different_days_per_customer": 25,
    "max_same_weekend_holiday_same_days_per_customer": 26,
    "max_same_weekend_sat_sun_per_customer": 22,
    "max_visiting_fleet_occupancy_per_location": 35,
    "max_weekday_per_period_per_customer": 32,
    "max_weekend_per_period_per_customer": 33,
    "min_current_time_same_day_bypass": 18,
    "min_departure_time": 5,
    "min_hours": 9,
    "min_hours_before_departure_book": 11,
    "min_hours_before_departure_cancel": 13,
    "min_hours_before_departure_free_cancel": 15,
    "min_return_time": 7,
    "restriction_name": 3,
    "status": 42,
    "tenant": 0,
    "updated_at": 44,
    "valid_days": 37,
    "valid_groups": 40,
    "valid_styles": 41
}

schema_attributes:

{
    "allow_same_day_bypass_restrictions": "string",
    "coupons_allowed": "string",
    "created_at": "string",
    "disable_consecutive_per_customer": "string",
    "holidays_only_if_valid_day": "string",
    "id": "string",
    "location_id": "string",
    "max_active_per_customer": "string",
    "max_active_weekday_per_customer": "string",
    "max_active_weekend_per_customer": "string",
    "max_departure_time": "string",
    "max_diff_unit_type_same_day_per_customer": "string",
    "max_hours": "string",
    "max_hours_before_departure_book": "string",
    "max_hours_before_departure_bypass_restrictions": "string",
    "max_hours_before_departure_cancel": "string",
    "max_per_period_per_customer": "string",
    "max_per_period_per_location_per_customer": "string",
    "max_per_week_per_customer": "string",
    "max_rental_days": "string",
    "max_return_time": "string",
    "max_same_day_per_customer": "string",
    "max_same_time_same_day_per_customer": "string",
    "max_same_weekend_fri_sat_per_customer": "string",
    "max_same_weekend_fri_sun_per_customer": "string",
    "max_same_weekend_holiday_different_days_per_customer": "string",
    "max_same_weekend_holiday_same_days_per_customer": "string",
    "max_same_weekend_sat_sun_per_customer": "string",
    "max_visiting_fleet_occupancy_per_location": "string",
    "max_weekday_per_period_per_customer": "string",
    "max_weekend_per_period_per_customer": "string",
    "min_current_time_same_day_bypass": "string",
    "min_departure_time": "string",
    "min_hours": "string",
    "min_hours_before_departure_book": "string",
    "min_hours_before_departure_cancel": "string",
    "min_hours_before_departure_free_cancel": "string",
    "min_return_time": "string",
    "restriction_name": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string",
    "valid_days": "string",
    "valid_groups": "string",
    "valid_styles": "string"
}

schema_name_id: 1505
schema_scan_id: 161622117
updated: 2026-04-07 05:17:15

Version 1704776

created: 2026-04-06 05:16:55

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclub_restrictions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclub_restrictions`\n(\n `tenant`  string , `id`  string , `location_id`  string , `restriction_name`  string , `coupons_allowed`  string , `min_departure_time`  string , `max_departure_time`  string , `min_return_time`  string , `max_return_time`  string , `min_hours`  string , `max_hours`  string , `min_hours_before_departure_book`  string , `max_hours_before_departure_book`  string , `min_hours_before_departure_cancel`  string , `max_hours_before_departure_cancel`  string , `min_hours_before_departure_free_cancel`  string , `max_hours_before_departure_bypass_restrictions`  string , `allow_same_day_bypass_restrictions`  string , `min_current_time_same_day_bypass`  string , `max_same_day_per_customer`  string , `max_same_time_same_day_per_customer`  string , `max_diff_unit_type_same_day_per_customer`  string , `max_same_weekend_sat_sun_per_customer`  string , `max_same_weekend_fri_sun_per_customer`  string , `max_same_weekend_fri_sat_per_customer`  string , `max_same_weekend_holiday_different_days_per_customer`  string , `max_same_weekend_holiday_same_days_per_customer`  string , `max_active_per_customer`  string , `max_active_weekday_per_customer`  string , `max_active_weekend_per_customer`  string , `max_per_week_per_customer`  string , `max_per_period_per_customer`  string , `max_weekday_per_period_per_customer`  string , `max_weekend_per_period_per_customer`  string , `max_per_period_per_location_per_customer`  string , `max_visiting_fleet_occupancy_per_location`  string , `disable_consecutive_per_customer`  string , `valid_days`  string , `holidays_only_if_valid_day`  string , `max_rental_days`  string , `valid_groups`  string , `valid_styles`  string , `status`  string , `created_at`  string , `updated_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_imsclub_restrictions/2026-04-06/1775470528'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclub_restrictions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsclub_restrictions/2026-04-06/1775470528
id: 1704776
processed: 1

raw_data:

{
    "allow_same_day_bypass_restrictions": 17,
    "coupons_allowed": 4,
    "created_at": 43,
    "disable_consecutive_per_customer": 36,
    "holidays_only_if_valid_day": 38,
    "id": 1,
    "location_id": 2,
    "max_active_per_customer": 27,
    "max_active_weekday_per_customer": 28,
    "max_active_weekend_per_customer": 29,
    "max_departure_time": 6,
    "max_diff_unit_type_same_day_per_customer": 21,
    "max_hours": 10,
    "max_hours_before_departure_book": 12,
    "max_hours_before_departure_bypass_restrictions": 16,
    "max_hours_before_departure_cancel": 14,
    "max_per_period_per_customer": 31,
    "max_per_period_per_location_per_customer": 34,
    "max_per_week_per_customer": 30,
    "max_rental_days": 39,
    "max_return_time": 8,
    "max_same_day_per_customer": 19,
    "max_same_time_same_day_per_customer": 20,
    "max_same_weekend_fri_sat_per_customer": 24,
    "max_same_weekend_fri_sun_per_customer": 23,
    "max_same_weekend_holiday_different_days_per_customer": 25,
    "max_same_weekend_holiday_same_days_per_customer": 26,
    "max_same_weekend_sat_sun_per_customer": 22,
    "max_visiting_fleet_occupancy_per_location": 35,
    "max_weekday_per_period_per_customer": 32,
    "max_weekend_per_period_per_customer": 33,
    "min_current_time_same_day_bypass": 18,
    "min_departure_time": 5,
    "min_hours": 9,
    "min_hours_before_departure_book": 11,
    "min_hours_before_departure_cancel": 13,
    "min_hours_before_departure_free_cancel": 15,
    "min_return_time": 7,
    "restriction_name": 3,
    "status": 42,
    "tenant": 0,
    "updated_at": 44,
    "valid_days": 37,
    "valid_groups": 40,
    "valid_styles": 41
}

schema_attributes:

{
    "allow_same_day_bypass_restrictions": "string",
    "coupons_allowed": "string",
    "created_at": "string",
    "disable_consecutive_per_customer": "string",
    "holidays_only_if_valid_day": "string",
    "id": "string",
    "location_id": "string",
    "max_active_per_customer": "string",
    "max_active_weekday_per_customer": "string",
    "max_active_weekend_per_customer": "string",
    "max_departure_time": "string",
    "max_diff_unit_type_same_day_per_customer": "string",
    "max_hours": "string",
    "max_hours_before_departure_book": "string",
    "max_hours_before_departure_bypass_restrictions": "string",
    "max_hours_before_departure_cancel": "string",
    "max_per_period_per_customer": "string",
    "max_per_period_per_location_per_customer": "string",
    "max_per_week_per_customer": "string",
    "max_rental_days": "string",
    "max_return_time": "string",
    "max_same_day_per_customer": "string",
    "max_same_time_same_day_per_customer": "string",
    "max_same_weekend_fri_sat_per_customer": "string",
    "max_same_weekend_fri_sun_per_customer": "string",
    "max_same_weekend_holiday_different_days_per_customer": "string",
    "max_same_weekend_holiday_same_days_per_customer": "string",
    "max_same_weekend_sat_sun_per_customer": "string",
    "max_visiting_fleet_occupancy_per_location": "string",
    "max_weekday_per_period_per_customer": "string",
    "max_weekend_per_period_per_customer": "string",
    "min_current_time_same_day_bypass": "string",
    "min_departure_time": "string",
    "min_hours": "string",
    "min_hours_before_departure_book": "string",
    "min_hours_before_departure_cancel": "string",
    "min_hours_before_departure_free_cancel": "string",
    "min_return_time": "string",
    "restriction_name": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string",
    "valid_days": "string",
    "valid_groups": "string",
    "valid_styles": "string"
}

schema_name_id: 1505
schema_scan_id: 161564247
updated: 2026-04-06 05:17:06

Version 1703583

created: 2026-04-05 04:58:03

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclub_restrictions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclub_restrictions`\n(\n `tenant`  string , `id`  string , `location_id`  string , `restriction_name`  string , `coupons_allowed`  string , `min_departure_time`  string , `max_departure_time`  string , `min_return_time`  string , `max_return_time`  string , `min_hours`  string , `max_hours`  string , `min_hours_before_departure_book`  string , `max_hours_before_departure_book`  string , `min_hours_before_departure_cancel`  string , `max_hours_before_departure_cancel`  string , `min_hours_before_departure_free_cancel`  string , `max_hours_before_departure_bypass_restrictions`  string , `allow_same_day_bypass_restrictions`  string , `min_current_time_same_day_bypass`  string , `max_same_day_per_customer`  string , `max_same_time_same_day_per_customer`  string , `max_diff_unit_type_same_day_per_customer`  string , `max_same_weekend_sat_sun_per_customer`  string , `max_same_weekend_fri_sun_per_customer`  string , `max_same_weekend_fri_sat_per_customer`  string , `max_same_weekend_holiday_different_days_per_customer`  string , `max_same_weekend_holiday_same_days_per_customer`  string , `max_active_per_customer`  string , `max_active_weekday_per_customer`  string , `max_active_weekend_per_customer`  string , `max_per_week_per_customer`  string , `max_per_period_per_customer`  string , `max_weekday_per_period_per_customer`  string , `max_weekend_per_period_per_customer`  string , `max_per_period_per_location_per_customer`  string , `max_visiting_fleet_occupancy_per_location`  string , `disable_consecutive_per_customer`  string , `valid_days`  string , `holidays_only_if_valid_day`  string , `max_rental_days`  string , `valid_groups`  string , `valid_styles`  string , `status`  string , `created_at`  string , `updated_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_imsclub_restrictions/2026-04-05/1775382946'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclub_restrictions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsclub_restrictions/2026-04-05/1775382946
id: 1703583
processed: 1

raw_data:

{
    "allow_same_day_bypass_restrictions": 17,
    "coupons_allowed": 4,
    "created_at": 43,
    "disable_consecutive_per_customer": 36,
    "holidays_only_if_valid_day": 38,
    "id": 1,
    "location_id": 2,
    "max_active_per_customer": 27,
    "max_active_weekday_per_customer": 28,
    "max_active_weekend_per_customer": 29,
    "max_departure_time": 6,
    "max_diff_unit_type_same_day_per_customer": 21,
    "max_hours": 10,
    "max_hours_before_departure_book": 12,
    "max_hours_before_departure_bypass_restrictions": 16,
    "max_hours_before_departure_cancel": 14,
    "max_per_period_per_customer": 31,
    "max_per_period_per_location_per_customer": 34,
    "max_per_week_per_customer": 30,
    "max_rental_days": 39,
    "max_return_time": 8,
    "max_same_day_per_customer": 19,
    "max_same_time_same_day_per_customer": 20,
    "max_same_weekend_fri_sat_per_customer": 24,
    "max_same_weekend_fri_sun_per_customer": 23,
    "max_same_weekend_holiday_different_days_per_customer": 25,
    "max_same_weekend_holiday_same_days_per_customer": 26,
    "max_same_weekend_sat_sun_per_customer": 22,
    "max_visiting_fleet_occupancy_per_location": 35,
    "max_weekday_per_period_per_customer": 32,
    "max_weekend_per_period_per_customer": 33,
    "min_current_time_same_day_bypass": 18,
    "min_departure_time": 5,
    "min_hours": 9,
    "min_hours_before_departure_book": 11,
    "min_hours_before_departure_cancel": 13,
    "min_hours_before_departure_free_cancel": 15,
    "min_return_time": 7,
    "restriction_name": 3,
    "status": 42,
    "tenant": 0,
    "updated_at": 44,
    "valid_days": 37,
    "valid_groups": 40,
    "valid_styles": 41
}

schema_attributes:

{
    "allow_same_day_bypass_restrictions": "string",
    "coupons_allowed": "string",
    "created_at": "string",
    "disable_consecutive_per_customer": "string",
    "holidays_only_if_valid_day": "string",
    "id": "string",
    "location_id": "string",
    "max_active_per_customer": "string",
    "max_active_weekday_per_customer": "string",
    "max_active_weekend_per_customer": "string",
    "max_departure_time": "string",
    "max_diff_unit_type_same_day_per_customer": "string",
    "max_hours": "string",
    "max_hours_before_departure_book": "string",
    "max_hours_before_departure_bypass_restrictions": "string",
    "max_hours_before_departure_cancel": "string",
    "max_per_period_per_customer": "string",
    "max_per_period_per_location_per_customer": "string",
    "max_per_week_per_customer": "string",
    "max_rental_days": "string",
    "max_return_time": "string",
    "max_same_day_per_customer": "string",
    "max_same_time_same_day_per_customer": "string",
    "max_same_weekend_fri_sat_per_customer": "string",
    "max_same_weekend_fri_sun_per_customer": "string",
    "max_same_weekend_holiday_different_days_per_customer": "string",
    "max_same_weekend_holiday_same_days_per_customer": "string",
    "max_same_weekend_sat_sun_per_customer": "string",
    "max_visiting_fleet_occupancy_per_location": "string",
    "max_weekday_per_period_per_customer": "string",
    "max_weekend_per_period_per_customer": "string",
    "min_current_time_same_day_bypass": "string",
    "min_departure_time": "string",
    "min_hours": "string",
    "min_hours_before_departure_book": "string",
    "min_hours_before_departure_cancel": "string",
    "min_hours_before_departure_free_cancel": "string",
    "min_return_time": "string",
    "restriction_name": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string",
    "valid_days": "string",
    "valid_groups": "string",
    "valid_styles": "string"
}

schema_name_id: 1505
schema_scan_id: 161516576
updated: 2026-04-05 04:58:17

Version 1702409

created: 2026-04-04 04:55:46

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclub_restrictions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclub_restrictions`\n(\n `tenant`  string , `id`  string , `location_id`  string , `restriction_name`  string , `coupons_allowed`  string , `min_departure_time`  string , `max_departure_time`  string , `min_return_time`  string , `max_return_time`  string , `min_hours`  string , `max_hours`  string , `min_hours_before_departure_book`  string , `max_hours_before_departure_book`  string , `min_hours_before_departure_cancel`  string , `max_hours_before_departure_cancel`  string , `min_hours_before_departure_free_cancel`  string , `max_hours_before_departure_bypass_restrictions`  string , `allow_same_day_bypass_restrictions`  string , `min_current_time_same_day_bypass`  string , `max_same_day_per_customer`  string , `max_same_time_same_day_per_customer`  string , `max_diff_unit_type_same_day_per_customer`  string , `max_same_weekend_sat_sun_per_customer`  string , `max_same_weekend_fri_sun_per_customer`  string , `max_same_weekend_fri_sat_per_customer`  string , `max_same_weekend_holiday_different_days_per_customer`  string , `max_same_weekend_holiday_same_days_per_customer`  string , `max_active_per_customer`  string , `max_active_weekday_per_customer`  string , `max_active_weekend_per_customer`  string , `max_per_week_per_customer`  string , `max_per_period_per_customer`  string , `max_weekday_per_period_per_customer`  string , `max_weekend_per_period_per_customer`  string , `max_per_period_per_location_per_customer`  string , `max_visiting_fleet_occupancy_per_location`  string , `disable_consecutive_per_customer`  string , `valid_days`  string , `holidays_only_if_valid_day`  string , `max_rental_days`  string , `valid_groups`  string , `valid_styles`  string , `status`  string , `created_at`  string , `updated_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_imsclub_restrictions/2026-04-04/1775296469'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclub_restrictions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsclub_restrictions/2026-04-04/1775296469
id: 1702409
processed: 1

raw_data:

{
    "allow_same_day_bypass_restrictions": 17,
    "coupons_allowed": 4,
    "created_at": 43,
    "disable_consecutive_per_customer": 36,
    "holidays_only_if_valid_day": 38,
    "id": 1,
    "location_id": 2,
    "max_active_per_customer": 27,
    "max_active_weekday_per_customer": 28,
    "max_active_weekend_per_customer": 29,
    "max_departure_time": 6,
    "max_diff_unit_type_same_day_per_customer": 21,
    "max_hours": 10,
    "max_hours_before_departure_book": 12,
    "max_hours_before_departure_bypass_restrictions": 16,
    "max_hours_before_departure_cancel": 14,
    "max_per_period_per_customer": 31,
    "max_per_period_per_location_per_customer": 34,
    "max_per_week_per_customer": 30,
    "max_rental_days": 39,
    "max_return_time": 8,
    "max_same_day_per_customer": 19,
    "max_same_time_same_day_per_customer": 20,
    "max_same_weekend_fri_sat_per_customer": 24,
    "max_same_weekend_fri_sun_per_customer": 23,
    "max_same_weekend_holiday_different_days_per_customer": 25,
    "max_same_weekend_holiday_same_days_per_customer": 26,
    "max_same_weekend_sat_sun_per_customer": 22,
    "max_visiting_fleet_occupancy_per_location": 35,
    "max_weekday_per_period_per_customer": 32,
    "max_weekend_per_period_per_customer": 33,
    "min_current_time_same_day_bypass": 18,
    "min_departure_time": 5,
    "min_hours": 9,
    "min_hours_before_departure_book": 11,
    "min_hours_before_departure_cancel": 13,
    "min_hours_before_departure_free_cancel": 15,
    "min_return_time": 7,
    "restriction_name": 3,
    "status": 42,
    "tenant": 0,
    "updated_at": 44,
    "valid_days": 37,
    "valid_groups": 40,
    "valid_styles": 41
}

schema_attributes:

{
    "allow_same_day_bypass_restrictions": "string",
    "coupons_allowed": "string",
    "created_at": "string",
    "disable_consecutive_per_customer": "string",
    "holidays_only_if_valid_day": "string",
    "id": "string",
    "location_id": "string",
    "max_active_per_customer": "string",
    "max_active_weekday_per_customer": "string",
    "max_active_weekend_per_customer": "string",
    "max_departure_time": "string",
    "max_diff_unit_type_same_day_per_customer": "string",
    "max_hours": "string",
    "max_hours_before_departure_book": "string",
    "max_hours_before_departure_bypass_restrictions": "string",
    "max_hours_before_departure_cancel": "string",
    "max_per_period_per_customer": "string",
    "max_per_period_per_location_per_customer": "string",
    "max_per_week_per_customer": "string",
    "max_rental_days": "string",
    "max_return_time": "string",
    "max_same_day_per_customer": "string",
    "max_same_time_same_day_per_customer": "string",
    "max_same_weekend_fri_sat_per_customer": "string",
    "max_same_weekend_fri_sun_per_customer": "string",
    "max_same_weekend_holiday_different_days_per_customer": "string",
    "max_same_weekend_holiday_same_days_per_customer": "string",
    "max_same_weekend_sat_sun_per_customer": "string",
    "max_visiting_fleet_occupancy_per_location": "string",
    "max_weekday_per_period_per_customer": "string",
    "max_weekend_per_period_per_customer": "string",
    "min_current_time_same_day_bypass": "string",
    "min_departure_time": "string",
    "min_hours": "string",
    "min_hours_before_departure_book": "string",
    "min_hours_before_departure_cancel": "string",
    "min_hours_before_departure_free_cancel": "string",
    "min_return_time": "string",
    "restriction_name": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string",
    "valid_days": "string",
    "valid_groups": "string",
    "valid_styles": "string"
}

schema_name_id: 1505
schema_scan_id: 161462110
updated: 2026-04-04 04:56:00

Version 1701196

created: 2026-04-03 05:11:09

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclub_restrictions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclub_restrictions`\n(\n `tenant`  string , `id`  string , `location_id`  string , `restriction_name`  string , `coupons_allowed`  string , `min_departure_time`  string , `max_departure_time`  string , `min_return_time`  string , `max_return_time`  string , `min_hours`  string , `max_hours`  string , `min_hours_before_departure_book`  string , `max_hours_before_departure_book`  string , `min_hours_before_departure_cancel`  string , `max_hours_before_departure_cancel`  string , `min_hours_before_departure_free_cancel`  string , `max_hours_before_departure_bypass_restrictions`  string , `allow_same_day_bypass_restrictions`  string , `min_current_time_same_day_bypass`  string , `max_same_day_per_customer`  string , `max_same_time_same_day_per_customer`  string , `max_diff_unit_type_same_day_per_customer`  string , `max_same_weekend_sat_sun_per_customer`  string , `max_same_weekend_fri_sun_per_customer`  string , `max_same_weekend_fri_sat_per_customer`  string , `max_same_weekend_holiday_different_days_per_customer`  string , `max_same_weekend_holiday_same_days_per_customer`  string , `max_active_per_customer`  string , `max_active_weekday_per_customer`  string , `max_active_weekend_per_customer`  string , `max_per_week_per_customer`  string , `max_per_period_per_customer`  string , `max_weekday_per_period_per_customer`  string , `max_weekend_per_period_per_customer`  string , `max_per_period_per_location_per_customer`  string , `max_visiting_fleet_occupancy_per_location`  string , `disable_consecutive_per_customer`  string , `valid_days`  string , `holidays_only_if_valid_day`  string , `max_rental_days`  string , `valid_groups`  string , `valid_styles`  string , `status`  string , `created_at`  string , `updated_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_imsclub_restrictions/2026-04-03/1775211034'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclub_restrictions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsclub_restrictions/2026-04-03/1775211034
id: 1701196
processed: 1

raw_data:

{
    "allow_same_day_bypass_restrictions": 17,
    "coupons_allowed": 4,
    "created_at": 43,
    "disable_consecutive_per_customer": 36,
    "holidays_only_if_valid_day": 38,
    "id": 1,
    "location_id": 2,
    "max_active_per_customer": 27,
    "max_active_weekday_per_customer": 28,
    "max_active_weekend_per_customer": 29,
    "max_departure_time": 6,
    "max_diff_unit_type_same_day_per_customer": 21,
    "max_hours": 10,
    "max_hours_before_departure_book": 12,
    "max_hours_before_departure_bypass_restrictions": 16,
    "max_hours_before_departure_cancel": 14,
    "max_per_period_per_customer": 31,
    "max_per_period_per_location_per_customer": 34,
    "max_per_week_per_customer": 30,
    "max_rental_days": 39,
    "max_return_time": 8,
    "max_same_day_per_customer": 19,
    "max_same_time_same_day_per_customer": 20,
    "max_same_weekend_fri_sat_per_customer": 24,
    "max_same_weekend_fri_sun_per_customer": 23,
    "max_same_weekend_holiday_different_days_per_customer": 25,
    "max_same_weekend_holiday_same_days_per_customer": 26,
    "max_same_weekend_sat_sun_per_customer": 22,
    "max_visiting_fleet_occupancy_per_location": 35,
    "max_weekday_per_period_per_customer": 32,
    "max_weekend_per_period_per_customer": 33,
    "min_current_time_same_day_bypass": 18,
    "min_departure_time": 5,
    "min_hours": 9,
    "min_hours_before_departure_book": 11,
    "min_hours_before_departure_cancel": 13,
    "min_hours_before_departure_free_cancel": 15,
    "min_return_time": 7,
    "restriction_name": 3,
    "status": 42,
    "tenant": 0,
    "updated_at": 44,
    "valid_days": 37,
    "valid_groups": 40,
    "valid_styles": 41
}

schema_attributes:

{
    "allow_same_day_bypass_restrictions": "string",
    "coupons_allowed": "string",
    "created_at": "string",
    "disable_consecutive_per_customer": "string",
    "holidays_only_if_valid_day": "string",
    "id": "string",
    "location_id": "string",
    "max_active_per_customer": "string",
    "max_active_weekday_per_customer": "string",
    "max_active_weekend_per_customer": "string",
    "max_departure_time": "string",
    "max_diff_unit_type_same_day_per_customer": "string",
    "max_hours": "string",
    "max_hours_before_departure_book": "string",
    "max_hours_before_departure_bypass_restrictions": "string",
    "max_hours_before_departure_cancel": "string",
    "max_per_period_per_customer": "string",
    "max_per_period_per_location_per_customer": "string",
    "max_per_week_per_customer": "string",
    "max_rental_days": "string",
    "max_return_time": "string",
    "max_same_day_per_customer": "string",
    "max_same_time_same_day_per_customer": "string",
    "max_same_weekend_fri_sat_per_customer": "string",
    "max_same_weekend_fri_sun_per_customer": "string",
    "max_same_weekend_holiday_different_days_per_customer": "string",
    "max_same_weekend_holiday_same_days_per_customer": "string",
    "max_same_weekend_sat_sun_per_customer": "string",
    "max_visiting_fleet_occupancy_per_location": "string",
    "max_weekday_per_period_per_customer": "string",
    "max_weekend_per_period_per_customer": "string",
    "min_current_time_same_day_bypass": "string",
    "min_departure_time": "string",
    "min_hours": "string",
    "min_hours_before_departure_book": "string",
    "min_hours_before_departure_cancel": "string",
    "min_hours_before_departure_free_cancel": "string",
    "min_return_time": "string",
    "restriction_name": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string",
    "valid_days": "string",
    "valid_groups": "string",
    "valid_styles": "string"
}

schema_name_id: 1505
schema_scan_id: 161404794
updated: 2026-04-03 05:11:23

Schema Scans: 15

Last at 2026-04-17 04:57:15

Scan 162169316

duration: 0:00:15.355075

exit_message:

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

id: 162169316

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_imsclub_restrictions/2026-04-17/1776419647",
        "key": "raw/stellar_imsclub_restrictions/2026-04-17/1776419647/club_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsclub_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16618529202309070588,
        "service_name": "drive-thru",
        "span_id": 16142343360725224472,
        "trace_id": 9873911151845915003
    }
}

running: False
schema_name_id: 1505
start_time: 2026-04-17 04:57:15
success: True
trace_id: 9873911151845915003

Scan 162114373

duration: 0:00:12.720486

exit_message:

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

id: 162114373

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_imsclub_restrictions/2026-04-16/1776334545",
        "key": "raw/stellar_imsclub_restrictions/2026-04-16/1776334545/club_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsclub_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3744595598788562041,
        "service_name": "drive-thru",
        "span_id": 8724146646247373890,
        "trace_id": 17233041253701813844
    }
}

running: False
schema_name_id: 1505
start_time: 2026-04-16 05:16:25
success: True
trace_id: 17233041253701813844

Scan 162056367

duration: 0:00:15.134847

exit_message:

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

id: 162056367

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_imsclub_restrictions/2026-04-15/1776242358",
        "key": "raw/stellar_imsclub_restrictions/2026-04-15/1776242358/club_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsclub_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 680397063599601323,
        "service_name": "drive-thru",
        "span_id": 8764072768737668433,
        "trace_id": 7702878061978282442
    }
}

running: False
schema_name_id: 1505
start_time: 2026-04-15 03:41:01
success: True
trace_id: 7702878061978282442

Scan 162003118

duration: 0:00:12.771208

exit_message:

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

id: 162003118

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_imsclub_restrictions/2026-04-14/1776160758",
        "key": "raw/stellar_imsclub_restrictions/2026-04-14/1776160758/club_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsclub_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6537012925631238920,
        "service_name": "drive-thru",
        "span_id": 10344184449452860523,
        "trace_id": 17895198565425741629
    }
}

running: False
schema_name_id: 1505
start_time: 2026-04-14 05:04:11
success: True
trace_id: 17895198565425741629

Scan 161945284

duration: 0:00:12.743640

exit_message:

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

id: 161945284

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_imsclub_restrictions/2026-04-13/1776074799",
        "key": "raw/stellar_imsclub_restrictions/2026-04-13/1776074799/club_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsclub_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5378519264106721216,
        "service_name": "drive-thru",
        "span_id": 1575262592940556064,
        "trace_id": 3095493693042483098
    }
}

running: False
schema_name_id: 1505
start_time: 2026-04-13 05:07:29
success: True
trace_id: 3095493693042483098

Scan 161896367

duration: 0:00:15.149796

exit_message:

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

id: 161896367

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_imsclub_restrictions/2026-04-12/1775988157",
        "key": "raw/stellar_imsclub_restrictions/2026-04-12/1775988157/club_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsclub_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3291759444541156160,
        "service_name": "drive-thru",
        "span_id": 15948357580521161300,
        "trace_id": 1842236831723690746
    }
}

running: False
schema_name_id: 1505
start_time: 2026-04-12 05:05:09
success: True
trace_id: 1842236831723690746

Scan 161843941

duration: 0:00:15.405132

exit_message:

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

id: 161843941

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_imsclub_restrictions/2026-04-11/1775902576",
        "key": "raw/stellar_imsclub_restrictions/2026-04-11/1775902576/club_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsclub_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7744943258928390026,
        "service_name": "drive-thru",
        "span_id": 12788942743501273663,
        "trace_id": 2319906927452018403
    }
}

running: False
schema_name_id: 1505
start_time: 2026-04-11 05:18:14
success: True
trace_id: 2319906927452018403

Scan 161788572

duration: 0:00:12.865810

exit_message:

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

id: 161788572

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_imsclub_restrictions/2026-04-10/1775815218",
        "key": "raw/stellar_imsclub_restrictions/2026-04-10/1775815218/club_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsclub_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1093107403376018231,
        "service_name": "drive-thru",
        "span_id": 12364901183300238093,
        "trace_id": 15144642136704724756
    }
}

running: False
schema_name_id: 1505
start_time: 2026-04-10 05:01:43
success: True
trace_id: 15144642136704724756

Scan 161732950

duration: 0:00:15.157786

exit_message:

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

id: 161732950

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_imsclub_restrictions/2026-04-09/1775728840",
        "key": "raw/stellar_imsclub_restrictions/2026-04-09/1775728840/club_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsclub_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5112593778843691279,
        "service_name": "drive-thru",
        "span_id": 6442752896435156288,
        "trace_id": 11459891186174116803
    }
}

running: False
schema_name_id: 1505
start_time: 2026-04-09 05:02:06
success: True
trace_id: 11459891186174116803

Scan 161678362

duration: 0:00:12.640338

exit_message:

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

id: 161678362

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_imsclub_restrictions/2026-04-08/1775643001",
        "key": "raw/stellar_imsclub_restrictions/2026-04-08/1775643001/club_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsclub_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2821601091860446324,
        "service_name": "drive-thru",
        "span_id": 18424344247931096762,
        "trace_id": 13624405826399674332
    }
}

running: False
schema_name_id: 1505
start_time: 2026-04-08 05:12:43
success: True
trace_id: 13624405826399674332

Scan 161622117

duration: 0:00:15.289535

exit_message:

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

id: 161622117

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_imsclub_restrictions/2026-04-07/1775556856",
        "key": "raw/stellar_imsclub_restrictions/2026-04-07/1775556856/club_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsclub_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16953991515689008260,
        "service_name": "drive-thru",
        "span_id": 18095239892732879624,
        "trace_id": 13343580466696812872
    }
}

running: False
schema_name_id: 1505
start_time: 2026-04-07 05:17:00
success: True
trace_id: 13343580466696812872

Scan 161564247

duration: 0:00:12.674551

exit_message:

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

id: 161564247

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_imsclub_restrictions/2026-04-06/1775470528",
        "key": "raw/stellar_imsclub_restrictions/2026-04-06/1775470528/club_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsclub_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11443141041667563217,
        "service_name": "drive-thru",
        "span_id": 6009981276785206364,
        "trace_id": 17919544311766270750
    }
}

running: False
schema_name_id: 1505
start_time: 2026-04-06 05:16:54
success: True
trace_id: 17919544311766270750

Scan 161516576

duration: 0:00:15.298782

exit_message:

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

id: 161516576

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_imsclub_restrictions/2026-04-05/1775382946",
        "key": "raw/stellar_imsclub_restrictions/2026-04-05/1775382946/club_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsclub_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10224274962073295668,
        "service_name": "drive-thru",
        "span_id": 256900305935692342,
        "trace_id": 15674211138036437608
    }
}

running: False
schema_name_id: 1505
start_time: 2026-04-05 04:58:01
success: True
trace_id: 15674211138036437608

Scan 161462110

duration: 0:00:15.306862

exit_message:

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

id: 161462110

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_imsclub_restrictions/2026-04-04/1775296469",
        "key": "raw/stellar_imsclub_restrictions/2026-04-04/1775296469/club_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsclub_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6802496748664362089,
        "service_name": "drive-thru",
        "span_id": 16601424597347212903,
        "trace_id": 6195810928775643127
    }
}

running: False
schema_name_id: 1505
start_time: 2026-04-04 04:55:45
success: True
trace_id: 6195810928775643127

Scan 161404794

duration: 0:00:15.210507

exit_message:

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

id: 161404794

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_imsclub_restrictions/2026-04-03/1775211034",
        "key": "raw/stellar_imsclub_restrictions/2026-04-03/1775211034/club_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsclub_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15754204176477463078,
        "service_name": "drive-thru",
        "span_id": 5132196698406132410,
        "trace_id": 3964833240052543916
    }
}

running: False
schema_name_id: 1505
start_time: 2026-04-03 05:11:08
success: True
trace_id: 3964833240052543916

Partitions:

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

Schema:

attributes:

{
    "allow_same_day_bypass_restrictions": "string",
    "coupons_allowed": "string",
    "created_at": "string",
    "disable_consecutive_per_customer": "string",
    "holidays_only_if_valid_day": "string",
    "id": "string",
    "location_id": "string",
    "max_active_per_customer": "string",
    "max_active_weekday_per_customer": "string",
    "max_active_weekend_per_customer": "string",
    "max_departure_time": "string",
    "max_diff_unit_type_same_day_per_customer": "string",
    "max_hours": "string",
    "max_hours_before_departure_book": "string",
    "max_hours_before_departure_bypass_restrictions": "string",
    "max_hours_before_departure_cancel": "string",
    "max_per_period_per_customer": "string",
    "max_per_period_per_location_per_customer": "string",
    "max_per_week_per_customer": "string",
    "max_rental_days": "string",
    "max_return_time": "string",
    "max_same_day_per_customer": "string",
    "max_same_time_same_day_per_customer": "string",
    "max_same_weekend_fri_sat_per_customer": "string",
    "max_same_weekend_fri_sun_per_customer": "string",
    "max_same_weekend_holiday_different_days_per_customer": "string",
    "max_same_weekend_holiday_same_days_per_customer": "string",
    "max_same_weekend_sat_sun_per_customer": "string",
    "max_visiting_fleet_occupancy_per_location": "string",
    "max_weekday_per_period_per_customer": "string",
    "max_weekend_per_period_per_customer": "string",
    "min_current_time_same_day_bypass": "string",
    "min_departure_time": "string",
    "min_hours": "string",
    "min_hours_before_departure_book": "string",
    "min_hours_before_departure_cancel": "string",
    "min_hours_before_departure_free_cancel": "string",
    "min_return_time": "string",
    "restriction_name": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string",
    "valid_days": "string",
    "valid_groups": "string",
    "valid_styles": "string"
}

created: 2026-04-17 04:57:17

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclub_restrictions`\n(\n `tenant`  string , `id`  string , `location_id`  string , `restriction_name`  string , `coupons_allowed`  string , `min_departure_time`  string , `max_departure_time`  string , `min_return_time`  string , `max_return_time`  string , `min_hours`  string , `max_hours`  string , `min_hours_before_departure_book`  string , `max_hours_before_departure_book`  string , `min_hours_before_departure_cancel`  string , `max_hours_before_departure_cancel`  string , `min_hours_before_departure_free_cancel`  string , `max_hours_before_departure_bypass_restrictions`  string , `allow_same_day_bypass_restrictions`  string , `min_current_time_same_day_bypass`  string , `max_same_day_per_customer`  string , `max_same_time_same_day_per_customer`  string , `max_diff_unit_type_same_day_per_customer`  string , `max_same_weekend_sat_sun_per_customer`  string , `max_same_weekend_fri_sun_per_customer`  string , `max_same_weekend_fri_sat_per_customer`  string , `max_same_weekend_holiday_different_days_per_customer`  string , `max_same_weekend_holiday_same_days_per_customer`  string , `max_active_per_customer`  string , `max_active_weekday_per_customer`  string , `max_active_weekend_per_customer`  string , `max_per_week_per_customer`  string , `max_per_period_per_customer`  string , `max_weekday_per_period_per_customer`  string , `max_weekend_per_period_per_customer`  string , `max_per_period_per_location_per_customer`  string , `max_visiting_fleet_occupancy_per_location`  string , `disable_consecutive_per_customer`  string , `valid_days`  string , `holidays_only_if_valid_day`  string , `max_rental_days`  string , `valid_groups`  string , `valid_styles`  string , `status`  string , `created_at`  string , `updated_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_imsclub_restrictions/2026-04-17/1776419647'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclub_restrictions`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclub_restrictions"
}

Server:

hostname: schemamanager-5475496c57-7dpqb
name: schema_manager
process_start: 2026-01-09 11:27:47
sf_env: prod
version: 2112174301

Raw:

{
    "name": {
        "created": "2023-02-07 01:48:55",
        "disabled": false,
        "format": "raw",
        "id": 1505,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "stellar_imsclub_restrictions"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "allow_same_day_bypass_restrictions": "string",
            "coupons_allowed": "string",
            "created_at": "string",
            "disable_consecutive_per_customer": "string",
            "holidays_only_if_valid_day": "string",
            "id": "string",
            "location_id": "string",
            "max_active_per_customer": "string",
            "max_active_weekday_per_customer": "string",
            "max_active_weekend_per_customer": "string",
            "max_departure_time": "string",
            "max_diff_unit_type_same_day_per_customer": "string",
            "max_hours": "string",
            "max_hours_before_departure_book": "string",
            "max_hours_before_departure_bypass_restrictions": "string",
            "max_hours_before_departure_cancel": "string",
            "max_per_period_per_customer": "string",
            "max_per_period_per_location_per_customer": "string",
            "max_per_week_per_customer": "string",
            "max_rental_days": "string",
            "max_return_time": "string",
            "max_same_day_per_customer": "string",
            "max_same_time_same_day_per_customer": "string",
            "max_same_weekend_fri_sat_per_customer": "string",
            "max_same_weekend_fri_sun_per_customer": "string",
            "max_same_weekend_holiday_different_days_per_customer": "string",
            "max_same_weekend_holiday_same_days_per_customer": "string",
            "max_same_weekend_sat_sun_per_customer": "string",
            "max_visiting_fleet_occupancy_per_location": "string",
            "max_weekday_per_period_per_customer": "string",
            "max_weekend_per_period_per_customer": "string",
            "min_current_time_same_day_bypass": "string",
            "min_departure_time": "string",
            "min_hours": "string",
            "min_hours_before_departure_book": "string",
            "min_hours_before_departure_cancel": "string",
            "min_hours_before_departure_free_cancel": "string",
            "min_return_time": "string",
            "restriction_name": "string",
            "status": "string",
            "tenant": "string",
            "updated_at": "string",
            "valid_days": "string",
            "valid_groups": "string",
            "valid_styles": "string"
        },
        "created": "2026-04-17 04:57:17",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclub_restrictions`\n(\n `tenant`  string , `id`  string , `location_id`  string , `restriction_name`  string , `coupons_allowed`  string , `min_departure_time`  string , `max_departure_time`  string , `min_return_time`  string , `max_return_time`  string , `min_hours`  string , `max_hours`  string , `min_hours_before_departure_book`  string , `max_hours_before_departure_book`  string , `min_hours_before_departure_cancel`  string , `max_hours_before_departure_cancel`  string , `min_hours_before_departure_free_cancel`  string , `max_hours_before_departure_bypass_restrictions`  string , `allow_same_day_bypass_restrictions`  string , `min_current_time_same_day_bypass`  string , `max_same_day_per_customer`  string , `max_same_time_same_day_per_customer`  string , `max_diff_unit_type_same_day_per_customer`  string , `max_same_weekend_sat_sun_per_customer`  string , `max_same_weekend_fri_sun_per_customer`  string , `max_same_weekend_fri_sat_per_customer`  string , `max_same_weekend_holiday_different_days_per_customer`  string , `max_same_weekend_holiday_same_days_per_customer`  string , `max_active_per_customer`  string , `max_active_weekday_per_customer`  string , `max_active_weekend_per_customer`  string , `max_per_week_per_customer`  string , `max_per_period_per_customer`  string , `max_weekday_per_period_per_customer`  string , `max_weekend_per_period_per_customer`  string , `max_per_period_per_location_per_customer`  string , `max_visiting_fleet_occupancy_per_location`  string , `disable_consecutive_per_customer`  string , `valid_days`  string , `holidays_only_if_valid_day`  string , `max_rental_days`  string , `valid_groups`  string , `valid_styles`  string , `status`  string , `created_at`  string , `updated_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_imsclub_restrictions/2026-04-17/1776419647'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclub_restrictions`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclub_restrictions"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}