Schema Info

Schema Name: sfdl_prod_drivethru.stellar_imsprice_rules

created: 2023-02-07 01:47:36
disabled: False
format: raw
id: 1482
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1718013

created: 2026-04-17 04:58:38

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsprice_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsprice_rules`\n(\n `tenant`  string , `id`  string , `location_id`  string , `rule_name`  string , `adjustment_direction`  string , `adjustment_type`  string , `adjustment_amount`  string , `adjustment_applies`  string , `min_original_price`  string , `max_original_price`  string , `min_occupancy`  string , `max_occupancy`  string , `occupancy_type`  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`  string , `max_hours_before_departure`  string , `valid_days`  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_imsprice_rules/2026-04-17/1776419650'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsprice_rules"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsprice_rules/2026-04-17/1776419650
id: 1718013
processed: 1

raw_data:

{
    "adjustment_amount": 6,
    "adjustment_applies": 7,
    "adjustment_direction": 4,
    "adjustment_type": 5,
    "created_at": 23,
    "id": 1,
    "location_id": 2,
    "max_departure_time": 14,
    "max_hours": 18,
    "max_hours_before_departure": 20,
    "max_occupancy": 11,
    "max_original_price": 9,
    "max_return_time": 16,
    "min_departure_time": 13,
    "min_hours": 17,
    "min_hours_before_departure": 19,
    "min_occupancy": 10,
    "min_original_price": 8,
    "min_return_time": 15,
    "occupancy_type": 12,
    "rule_name": 3,
    "status": 22,
    "tenant": 0,
    "updated_at": 24,
    "valid_days": 21
}

schema_attributes:

{
    "adjustment_amount": "string",
    "adjustment_applies": "string",
    "adjustment_direction": "string",
    "adjustment_type": "string",
    "created_at": "string",
    "id": "string",
    "location_id": "string",
    "max_departure_time": "string",
    "max_hours": "string",
    "max_hours_before_departure": "string",
    "max_occupancy": "string",
    "max_original_price": "string",
    "max_return_time": "string",
    "min_departure_time": "string",
    "min_hours": "string",
    "min_hours_before_departure": "string",
    "min_occupancy": "string",
    "min_original_price": "string",
    "min_return_time": "string",
    "occupancy_type": "string",
    "rule_name": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string",
    "valid_days": "string"
}

schema_name_id: 1482
schema_scan_id: 162169364
updated: 2026-04-17 04:58:49

Version 1716793

created: 2026-04-16 05:20:02

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsprice_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsprice_rules`\n(\n `tenant`  string , `id`  string , `location_id`  string , `rule_name`  string , `adjustment_direction`  string , `adjustment_type`  string , `adjustment_amount`  string , `adjustment_applies`  string , `min_original_price`  string , `max_original_price`  string , `min_occupancy`  string , `max_occupancy`  string , `occupancy_type`  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`  string , `max_hours_before_departure`  string , `valid_days`  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_imsprice_rules/2026-04-16/1776334552'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsprice_rules"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsprice_rules/2026-04-16/1776334552
id: 1716793
processed: 1

raw_data:

{
    "adjustment_amount": 6,
    "adjustment_applies": 7,
    "adjustment_direction": 4,
    "adjustment_type": 5,
    "created_at": 23,
    "id": 1,
    "location_id": 2,
    "max_departure_time": 14,
    "max_hours": 18,
    "max_hours_before_departure": 20,
    "max_occupancy": 11,
    "max_original_price": 9,
    "max_return_time": 16,
    "min_departure_time": 13,
    "min_hours": 17,
    "min_hours_before_departure": 19,
    "min_occupancy": 10,
    "min_original_price": 8,
    "min_return_time": 15,
    "occupancy_type": 12,
    "rule_name": 3,
    "status": 22,
    "tenant": 0,
    "updated_at": 24,
    "valid_days": 21
}

schema_attributes:

{
    "adjustment_amount": "string",
    "adjustment_applies": "string",
    "adjustment_direction": "string",
    "adjustment_type": "string",
    "created_at": "string",
    "id": "string",
    "location_id": "string",
    "max_departure_time": "string",
    "max_hours": "string",
    "max_hours_before_departure": "string",
    "max_occupancy": "string",
    "max_original_price": "string",
    "max_return_time": "string",
    "min_departure_time": "string",
    "min_hours": "string",
    "min_hours_before_departure": "string",
    "min_occupancy": "string",
    "min_original_price": "string",
    "min_return_time": "string",
    "occupancy_type": "string",
    "rule_name": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string",
    "valid_days": "string"
}

schema_name_id: 1482
schema_scan_id: 162114469
updated: 2026-04-16 05:20:13

Version 1715535

created: 2026-04-15 03:43:05

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsprice_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsprice_rules`\n(\n `tenant`  string , `id`  string , `location_id`  string , `rule_name`  string , `adjustment_direction`  string , `adjustment_type`  string , `adjustment_amount`  string , `adjustment_applies`  string , `min_original_price`  string , `max_original_price`  string , `min_occupancy`  string , `max_occupancy`  string , `occupancy_type`  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`  string , `max_hours_before_departure`  string , `valid_days`  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_imsprice_rules/2026-04-15/1776242365'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsprice_rules"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsprice_rules/2026-04-15/1776242365
id: 1715535
processed: 1

raw_data:

{
    "adjustment_amount": 6,
    "adjustment_applies": 7,
    "adjustment_direction": 4,
    "adjustment_type": 5,
    "created_at": 23,
    "id": 1,
    "location_id": 2,
    "max_departure_time": 14,
    "max_hours": 18,
    "max_hours_before_departure": 20,
    "max_occupancy": 11,
    "max_original_price": 9,
    "max_return_time": 16,
    "min_departure_time": 13,
    "min_hours": 17,
    "min_hours_before_departure": 19,
    "min_occupancy": 10,
    "min_original_price": 8,
    "min_return_time": 15,
    "occupancy_type": 12,
    "rule_name": 3,
    "status": 22,
    "tenant": 0,
    "updated_at": 24,
    "valid_days": 21
}

schema_attributes:

{
    "adjustment_amount": "string",
    "adjustment_applies": "string",
    "adjustment_direction": "string",
    "adjustment_type": "string",
    "created_at": "string",
    "id": "string",
    "location_id": "string",
    "max_departure_time": "string",
    "max_hours": "string",
    "max_hours_before_departure": "string",
    "max_occupancy": "string",
    "max_original_price": "string",
    "max_return_time": "string",
    "min_departure_time": "string",
    "min_hours": "string",
    "min_hours_before_departure": "string",
    "min_occupancy": "string",
    "min_original_price": "string",
    "min_return_time": "string",
    "occupancy_type": "string",
    "rule_name": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string",
    "valid_days": "string"
}

schema_name_id: 1482
schema_scan_id: 162056422
updated: 2026-04-15 03:43:17

Version 1714399

created: 2026-04-14 05:04:45

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsprice_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsprice_rules`\n(\n `tenant`  string , `id`  string , `location_id`  string , `rule_name`  string , `adjustment_direction`  string , `adjustment_type`  string , `adjustment_amount`  string , `adjustment_applies`  string , `min_original_price`  string , `max_original_price`  string , `min_occupancy`  string , `max_occupancy`  string , `occupancy_type`  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`  string , `max_hours_before_departure`  string , `valid_days`  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_imsprice_rules/2026-04-14/1776160760'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsprice_rules"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsprice_rules/2026-04-14/1776160760
id: 1714399
processed: 1

raw_data:

{
    "adjustment_amount": 6,
    "adjustment_applies": 7,
    "adjustment_direction": 4,
    "adjustment_type": 5,
    "created_at": 23,
    "id": 1,
    "location_id": 2,
    "max_departure_time": 14,
    "max_hours": 18,
    "max_hours_before_departure": 20,
    "max_occupancy": 11,
    "max_original_price": 9,
    "max_return_time": 16,
    "min_departure_time": 13,
    "min_hours": 17,
    "min_hours_before_departure": 19,
    "min_occupancy": 10,
    "min_original_price": 8,
    "min_return_time": 15,
    "occupancy_type": 12,
    "rule_name": 3,
    "status": 22,
    "tenant": 0,
    "updated_at": 24,
    "valid_days": 21
}

schema_attributes:

{
    "adjustment_amount": "string",
    "adjustment_applies": "string",
    "adjustment_direction": "string",
    "adjustment_type": "string",
    "created_at": "string",
    "id": "string",
    "location_id": "string",
    "max_departure_time": "string",
    "max_hours": "string",
    "max_hours_before_departure": "string",
    "max_occupancy": "string",
    "max_original_price": "string",
    "max_return_time": "string",
    "min_departure_time": "string",
    "min_hours": "string",
    "min_hours_before_departure": "string",
    "min_occupancy": "string",
    "min_original_price": "string",
    "min_return_time": "string",
    "occupancy_type": "string",
    "rule_name": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string",
    "valid_days": "string"
}

schema_name_id: 1482
schema_scan_id: 162003133
updated: 2026-04-14 05:04:56

Version 1713164

created: 2026-04-13 05:10:45

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsprice_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsprice_rules`\n(\n `tenant`  string , `id`  string , `location_id`  string , `rule_name`  string , `adjustment_direction`  string , `adjustment_type`  string , `adjustment_amount`  string , `adjustment_applies`  string , `min_original_price`  string , `max_original_price`  string , `min_occupancy`  string , `max_occupancy`  string , `occupancy_type`  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`  string , `max_hours_before_departure`  string , `valid_days`  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_imsprice_rules/2026-04-13/1776074805'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsprice_rules"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsprice_rules/2026-04-13/1776074805
id: 1713164
processed: 1

raw_data:

{
    "adjustment_amount": 6,
    "adjustment_applies": 7,
    "adjustment_direction": 4,
    "adjustment_type": 5,
    "created_at": 23,
    "id": 1,
    "location_id": 2,
    "max_departure_time": 14,
    "max_hours": 18,
    "max_hours_before_departure": 20,
    "max_occupancy": 11,
    "max_original_price": 9,
    "max_return_time": 16,
    "min_departure_time": 13,
    "min_hours": 17,
    "min_hours_before_departure": 19,
    "min_occupancy": 10,
    "min_original_price": 8,
    "min_return_time": 15,
    "occupancy_type": 12,
    "rule_name": 3,
    "status": 22,
    "tenant": 0,
    "updated_at": 24,
    "valid_days": 21
}

schema_attributes:

{
    "adjustment_amount": "string",
    "adjustment_applies": "string",
    "adjustment_direction": "string",
    "adjustment_type": "string",
    "created_at": "string",
    "id": "string",
    "location_id": "string",
    "max_departure_time": "string",
    "max_hours": "string",
    "max_hours_before_departure": "string",
    "max_occupancy": "string",
    "max_original_price": "string",
    "max_return_time": "string",
    "min_departure_time": "string",
    "min_hours": "string",
    "min_hours_before_departure": "string",
    "min_occupancy": "string",
    "min_original_price": "string",
    "min_return_time": "string",
    "occupancy_type": "string",
    "rule_name": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string",
    "valid_days": "string"
}

schema_name_id: 1482
schema_scan_id: 161945373
updated: 2026-04-13 05:10:59

Version 1711941

created: 2026-04-12 05:06:17

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsprice_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsprice_rules`\n(\n `tenant`  string , `id`  string , `location_id`  string , `rule_name`  string , `adjustment_direction`  string , `adjustment_type`  string , `adjustment_amount`  string , `adjustment_applies`  string , `min_original_price`  string , `max_original_price`  string , `min_occupancy`  string , `max_occupancy`  string , `occupancy_type`  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`  string , `max_hours_before_departure`  string , `valid_days`  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_imsprice_rules/2026-04-12/1775988163'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsprice_rules"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsprice_rules/2026-04-12/1775988163
id: 1711941
processed: 1

raw_data:

{
    "adjustment_amount": 6,
    "adjustment_applies": 7,
    "adjustment_direction": 4,
    "adjustment_type": 5,
    "created_at": 23,
    "id": 1,
    "location_id": 2,
    "max_departure_time": 14,
    "max_hours": 18,
    "max_hours_before_departure": 20,
    "max_occupancy": 11,
    "max_original_price": 9,
    "max_return_time": 16,
    "min_departure_time": 13,
    "min_hours": 17,
    "min_hours_before_departure": 19,
    "min_occupancy": 10,
    "min_original_price": 8,
    "min_return_time": 15,
    "occupancy_type": 12,
    "rule_name": 3,
    "status": 22,
    "tenant": 0,
    "updated_at": 24,
    "valid_days": 21
}

schema_attributes:

{
    "adjustment_amount": "string",
    "adjustment_applies": "string",
    "adjustment_direction": "string",
    "adjustment_type": "string",
    "created_at": "string",
    "id": "string",
    "location_id": "string",
    "max_departure_time": "string",
    "max_hours": "string",
    "max_hours_before_departure": "string",
    "max_occupancy": "string",
    "max_original_price": "string",
    "max_return_time": "string",
    "min_departure_time": "string",
    "min_hours": "string",
    "min_hours_before_departure": "string",
    "min_occupancy": "string",
    "min_original_price": "string",
    "min_return_time": "string",
    "occupancy_type": "string",
    "rule_name": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string",
    "valid_days": "string"
}

schema_name_id: 1482
schema_scan_id: 161896392
updated: 2026-04-12 05:06:28

Version 1710766

created: 2026-04-11 05:19:57

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsprice_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsprice_rules`\n(\n `tenant`  string , `id`  string , `location_id`  string , `rule_name`  string , `adjustment_direction`  string , `adjustment_type`  string , `adjustment_amount`  string , `adjustment_applies`  string , `min_original_price`  string , `max_original_price`  string , `min_occupancy`  string , `max_occupancy`  string , `occupancy_type`  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`  string , `max_hours_before_departure`  string , `valid_days`  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_imsprice_rules/2026-04-11/1775902577'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsprice_rules"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsprice_rules/2026-04-11/1775902577
id: 1710766
processed: 1

raw_data:

{
    "adjustment_amount": 6,
    "adjustment_applies": 7,
    "adjustment_direction": 4,
    "adjustment_type": 5,
    "created_at": 23,
    "id": 1,
    "location_id": 2,
    "max_departure_time": 14,
    "max_hours": 18,
    "max_hours_before_departure": 20,
    "max_occupancy": 11,
    "max_original_price": 9,
    "max_return_time": 16,
    "min_departure_time": 13,
    "min_hours": 17,
    "min_hours_before_departure": 19,
    "min_occupancy": 10,
    "min_original_price": 8,
    "min_return_time": 15,
    "occupancy_type": 12,
    "rule_name": 3,
    "status": 22,
    "tenant": 0,
    "updated_at": 24,
    "valid_days": 21
}

schema_attributes:

{
    "adjustment_amount": "string",
    "adjustment_applies": "string",
    "adjustment_direction": "string",
    "adjustment_type": "string",
    "created_at": "string",
    "id": "string",
    "location_id": "string",
    "max_departure_time": "string",
    "max_hours": "string",
    "max_hours_before_departure": "string",
    "max_occupancy": "string",
    "max_original_price": "string",
    "max_return_time": "string",
    "min_departure_time": "string",
    "min_hours": "string",
    "min_hours_before_departure": "string",
    "min_occupancy": "string",
    "min_original_price": "string",
    "min_return_time": "string",
    "occupancy_type": "string",
    "rule_name": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string",
    "valid_days": "string"
}

schema_name_id: 1482
schema_scan_id: 161843987
updated: 2026-04-11 05:20:08

Version 1709575

created: 2026-04-10 05:03:17

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsprice_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsprice_rules`\n(\n `tenant`  string , `id`  string , `location_id`  string , `rule_name`  string , `adjustment_direction`  string , `adjustment_type`  string , `adjustment_amount`  string , `adjustment_applies`  string , `min_original_price`  string , `max_original_price`  string , `min_occupancy`  string , `max_occupancy`  string , `occupancy_type`  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`  string , `max_hours_before_departure`  string , `valid_days`  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_imsprice_rules/2026-04-10/1775815219'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsprice_rules"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsprice_rules/2026-04-10/1775815219
id: 1709575
processed: 1

raw_data:

{
    "adjustment_amount": 6,
    "adjustment_applies": 7,
    "adjustment_direction": 4,
    "adjustment_type": 5,
    "created_at": 23,
    "id": 1,
    "location_id": 2,
    "max_departure_time": 14,
    "max_hours": 18,
    "max_hours_before_departure": 20,
    "max_occupancy": 11,
    "max_original_price": 9,
    "max_return_time": 16,
    "min_departure_time": 13,
    "min_hours": 17,
    "min_hours_before_departure": 19,
    "min_occupancy": 10,
    "min_original_price": 8,
    "min_return_time": 15,
    "occupancy_type": 12,
    "rule_name": 3,
    "status": 22,
    "tenant": 0,
    "updated_at": 24,
    "valid_days": 21
}

schema_attributes:

{
    "adjustment_amount": "string",
    "adjustment_applies": "string",
    "adjustment_direction": "string",
    "adjustment_type": "string",
    "created_at": "string",
    "id": "string",
    "location_id": "string",
    "max_departure_time": "string",
    "max_hours": "string",
    "max_hours_before_departure": "string",
    "max_occupancy": "string",
    "max_original_price": "string",
    "max_return_time": "string",
    "min_departure_time": "string",
    "min_hours": "string",
    "min_hours_before_departure": "string",
    "min_occupancy": "string",
    "min_original_price": "string",
    "min_return_time": "string",
    "occupancy_type": "string",
    "rule_name": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string",
    "valid_days": "string"
}

schema_name_id: 1482
schema_scan_id: 161788618
updated: 2026-04-10 05:03:31

Version 1708444

created: 2026-04-09 05:04:01

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsprice_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsprice_rules`\n(\n `tenant`  string , `id`  string , `location_id`  string , `rule_name`  string , `adjustment_direction`  string , `adjustment_type`  string , `adjustment_amount`  string , `adjustment_applies`  string , `min_original_price`  string , `max_original_price`  string , `min_occupancy`  string , `max_occupancy`  string , `occupancy_type`  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`  string , `max_hours_before_departure`  string , `valid_days`  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_imsprice_rules/2026-04-09/1775728840'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsprice_rules"
]

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

raw_data:

{
    "adjustment_amount": 6,
    "adjustment_applies": 7,
    "adjustment_direction": 4,
    "adjustment_type": 5,
    "created_at": 23,
    "id": 1,
    "location_id": 2,
    "max_departure_time": 14,
    "max_hours": 18,
    "max_hours_before_departure": 20,
    "max_occupancy": 11,
    "max_original_price": 9,
    "max_return_time": 16,
    "min_departure_time": 13,
    "min_hours": 17,
    "min_hours_before_departure": 19,
    "min_occupancy": 10,
    "min_original_price": 8,
    "min_return_time": 15,
    "occupancy_type": 12,
    "rule_name": 3,
    "status": 22,
    "tenant": 0,
    "updated_at": 24,
    "valid_days": 21
}

schema_attributes:

{
    "adjustment_amount": "string",
    "adjustment_applies": "string",
    "adjustment_direction": "string",
    "adjustment_type": "string",
    "created_at": "string",
    "id": "string",
    "location_id": "string",
    "max_departure_time": "string",
    "max_hours": "string",
    "max_hours_before_departure": "string",
    "max_occupancy": "string",
    "max_original_price": "string",
    "max_return_time": "string",
    "min_departure_time": "string",
    "min_hours": "string",
    "min_hours_before_departure": "string",
    "min_occupancy": "string",
    "min_original_price": "string",
    "min_return_time": "string",
    "occupancy_type": "string",
    "rule_name": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string",
    "valid_days": "string"
}

schema_name_id: 1482
schema_scan_id: 161733006
updated: 2026-04-09 05:04:14

Version 1707221

created: 2026-04-08 05:13:33

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsprice_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsprice_rules`\n(\n `tenant`  string , `id`  string , `location_id`  string , `rule_name`  string , `adjustment_direction`  string , `adjustment_type`  string , `adjustment_amount`  string , `adjustment_applies`  string , `min_original_price`  string , `max_original_price`  string , `min_occupancy`  string , `max_occupancy`  string , `occupancy_type`  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`  string , `max_hours_before_departure`  string , `valid_days`  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_imsprice_rules/2026-04-08/1775642999'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsprice_rules"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsprice_rules/2026-04-08/1775642999
id: 1707221
processed: 1

raw_data:

{
    "adjustment_amount": 6,
    "adjustment_applies": 7,
    "adjustment_direction": 4,
    "adjustment_type": 5,
    "created_at": 23,
    "id": 1,
    "location_id": 2,
    "max_departure_time": 14,
    "max_hours": 18,
    "max_hours_before_departure": 20,
    "max_occupancy": 11,
    "max_original_price": 9,
    "max_return_time": 16,
    "min_departure_time": 13,
    "min_hours": 17,
    "min_hours_before_departure": 19,
    "min_occupancy": 10,
    "min_original_price": 8,
    "min_return_time": 15,
    "occupancy_type": 12,
    "rule_name": 3,
    "status": 22,
    "tenant": 0,
    "updated_at": 24,
    "valid_days": 21
}

schema_attributes:

{
    "adjustment_amount": "string",
    "adjustment_applies": "string",
    "adjustment_direction": "string",
    "adjustment_type": "string",
    "created_at": "string",
    "id": "string",
    "location_id": "string",
    "max_departure_time": "string",
    "max_hours": "string",
    "max_hours_before_departure": "string",
    "max_occupancy": "string",
    "max_original_price": "string",
    "max_return_time": "string",
    "min_departure_time": "string",
    "min_hours": "string",
    "min_hours_before_departure": "string",
    "min_occupancy": "string",
    "min_original_price": "string",
    "min_return_time": "string",
    "occupancy_type": "string",
    "rule_name": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string",
    "valid_days": "string"
}

schema_name_id: 1482
schema_scan_id: 161678380
updated: 2026-04-08 05:13:47

Version 1706018

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsprice_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsprice_rules`\n(\n `tenant`  string , `id`  string , `location_id`  string , `rule_name`  string , `adjustment_direction`  string , `adjustment_type`  string , `adjustment_amount`  string , `adjustment_applies`  string , `min_original_price`  string , `max_original_price`  string , `min_occupancy`  string , `max_occupancy`  string , `occupancy_type`  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`  string , `max_hours_before_departure`  string , `valid_days`  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_imsprice_rules/2026-04-07/1775556859'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsprice_rules"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsprice_rules/2026-04-07/1775556859
id: 1706018
processed: 1

raw_data:

{
    "adjustment_amount": 6,
    "adjustment_applies": 7,
    "adjustment_direction": 4,
    "adjustment_type": 5,
    "created_at": 23,
    "id": 1,
    "location_id": 2,
    "max_departure_time": 14,
    "max_hours": 18,
    "max_hours_before_departure": 20,
    "max_occupancy": 11,
    "max_original_price": 9,
    "max_return_time": 16,
    "min_departure_time": 13,
    "min_hours": 17,
    "min_hours_before_departure": 19,
    "min_occupancy": 10,
    "min_original_price": 8,
    "min_return_time": 15,
    "occupancy_type": 12,
    "rule_name": 3,
    "status": 22,
    "tenant": 0,
    "updated_at": 24,
    "valid_days": 21
}

schema_attributes:

{
    "adjustment_amount": "string",
    "adjustment_applies": "string",
    "adjustment_direction": "string",
    "adjustment_type": "string",
    "created_at": "string",
    "id": "string",
    "location_id": "string",
    "max_departure_time": "string",
    "max_hours": "string",
    "max_hours_before_departure": "string",
    "max_occupancy": "string",
    "max_original_price": "string",
    "max_return_time": "string",
    "min_departure_time": "string",
    "min_hours": "string",
    "min_hours_before_departure": "string",
    "min_occupancy": "string",
    "min_original_price": "string",
    "min_return_time": "string",
    "occupancy_type": "string",
    "rule_name": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string",
    "valid_days": "string"
}

schema_name_id: 1482
schema_scan_id: 161622096
updated: 2026-04-07 05:16:24

Version 1704797

created: 2026-04-06 05:17:42

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsprice_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsprice_rules`\n(\n `tenant`  string , `id`  string , `location_id`  string , `rule_name`  string , `adjustment_direction`  string , `adjustment_type`  string , `adjustment_amount`  string , `adjustment_applies`  string , `min_original_price`  string , `max_original_price`  string , `min_occupancy`  string , `max_occupancy`  string , `occupancy_type`  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`  string , `max_hours_before_departure`  string , `valid_days`  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_imsprice_rules/2026-04-06/1775470535'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsprice_rules"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsprice_rules/2026-04-06/1775470535
id: 1704797
processed: 1

raw_data:

{
    "adjustment_amount": 6,
    "adjustment_applies": 7,
    "adjustment_direction": 4,
    "adjustment_type": 5,
    "created_at": 23,
    "id": 1,
    "location_id": 2,
    "max_departure_time": 14,
    "max_hours": 18,
    "max_hours_before_departure": 20,
    "max_occupancy": 11,
    "max_original_price": 9,
    "max_return_time": 16,
    "min_departure_time": 13,
    "min_hours": 17,
    "min_hours_before_departure": 19,
    "min_occupancy": 10,
    "min_original_price": 8,
    "min_return_time": 15,
    "occupancy_type": 12,
    "rule_name": 3,
    "status": 22,
    "tenant": 0,
    "updated_at": 24,
    "valid_days": 21
}

schema_attributes:

{
    "adjustment_amount": "string",
    "adjustment_applies": "string",
    "adjustment_direction": "string",
    "adjustment_type": "string",
    "created_at": "string",
    "id": "string",
    "location_id": "string",
    "max_departure_time": "string",
    "max_hours": "string",
    "max_hours_before_departure": "string",
    "max_occupancy": "string",
    "max_original_price": "string",
    "max_return_time": "string",
    "min_departure_time": "string",
    "min_hours": "string",
    "min_hours_before_departure": "string",
    "min_occupancy": "string",
    "min_original_price": "string",
    "min_return_time": "string",
    "occupancy_type": "string",
    "rule_name": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string",
    "valid_days": "string"
}

schema_name_id: 1482
schema_scan_id: 161564268
updated: 2026-04-06 05:17:54

Version 1703572

created: 2026-04-05 04:57:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsprice_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsprice_rules`\n(\n `tenant`  string , `id`  string , `location_id`  string , `rule_name`  string , `adjustment_direction`  string , `adjustment_type`  string , `adjustment_amount`  string , `adjustment_applies`  string , `min_original_price`  string , `max_original_price`  string , `min_occupancy`  string , `max_occupancy`  string , `occupancy_type`  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`  string , `max_hours_before_departure`  string , `valid_days`  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_imsprice_rules/2026-04-05/1775382948'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsprice_rules"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsprice_rules/2026-04-05/1775382948
id: 1703572
processed: 1

raw_data:

{
    "adjustment_amount": 6,
    "adjustment_applies": 7,
    "adjustment_direction": 4,
    "adjustment_type": 5,
    "created_at": 23,
    "id": 1,
    "location_id": 2,
    "max_departure_time": 14,
    "max_hours": 18,
    "max_hours_before_departure": 20,
    "max_occupancy": 11,
    "max_original_price": 9,
    "max_return_time": 16,
    "min_departure_time": 13,
    "min_hours": 17,
    "min_hours_before_departure": 19,
    "min_occupancy": 10,
    "min_original_price": 8,
    "min_return_time": 15,
    "occupancy_type": 12,
    "rule_name": 3,
    "status": 22,
    "tenant": 0,
    "updated_at": 24,
    "valid_days": 21
}

schema_attributes:

{
    "adjustment_amount": "string",
    "adjustment_applies": "string",
    "adjustment_direction": "string",
    "adjustment_type": "string",
    "created_at": "string",
    "id": "string",
    "location_id": "string",
    "max_departure_time": "string",
    "max_hours": "string",
    "max_hours_before_departure": "string",
    "max_occupancy": "string",
    "max_original_price": "string",
    "max_return_time": "string",
    "min_departure_time": "string",
    "min_hours": "string",
    "min_hours_before_departure": "string",
    "min_occupancy": "string",
    "min_original_price": "string",
    "min_return_time": "string",
    "occupancy_type": "string",
    "rule_name": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string",
    "valid_days": "string"
}

schema_name_id: 1482
schema_scan_id: 161516563
updated: 2026-04-05 04:57:46

Version 1702388

created: 2026-04-04 04:55:03

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsprice_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsprice_rules`\n(\n `tenant`  string , `id`  string , `location_id`  string , `rule_name`  string , `adjustment_direction`  string , `adjustment_type`  string , `adjustment_amount`  string , `adjustment_applies`  string , `min_original_price`  string , `max_original_price`  string , `min_occupancy`  string , `max_occupancy`  string , `occupancy_type`  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`  string , `max_hours_before_departure`  string , `valid_days`  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_imsprice_rules/2026-04-04/1775296466'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsprice_rules"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsprice_rules/2026-04-04/1775296466
id: 1702388
processed: 1

raw_data:

{
    "adjustment_amount": 6,
    "adjustment_applies": 7,
    "adjustment_direction": 4,
    "adjustment_type": 5,
    "created_at": 23,
    "id": 1,
    "location_id": 2,
    "max_departure_time": 14,
    "max_hours": 18,
    "max_hours_before_departure": 20,
    "max_occupancy": 11,
    "max_original_price": 9,
    "max_return_time": 16,
    "min_departure_time": 13,
    "min_hours": 17,
    "min_hours_before_departure": 19,
    "min_occupancy": 10,
    "min_original_price": 8,
    "min_return_time": 15,
    "occupancy_type": 12,
    "rule_name": 3,
    "status": 22,
    "tenant": 0,
    "updated_at": 24,
    "valid_days": 21
}

schema_attributes:

{
    "adjustment_amount": "string",
    "adjustment_applies": "string",
    "adjustment_direction": "string",
    "adjustment_type": "string",
    "created_at": "string",
    "id": "string",
    "location_id": "string",
    "max_departure_time": "string",
    "max_hours": "string",
    "max_hours_before_departure": "string",
    "max_occupancy": "string",
    "max_original_price": "string",
    "max_return_time": "string",
    "min_departure_time": "string",
    "min_hours": "string",
    "min_hours_before_departure": "string",
    "min_occupancy": "string",
    "min_original_price": "string",
    "min_return_time": "string",
    "occupancy_type": "string",
    "rule_name": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string",
    "valid_days": "string"
}

schema_name_id: 1482
schema_scan_id: 161462089
updated: 2026-04-04 04:55:14

Version 1701270

created: 2026-04-03 05:13:57

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsprice_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsprice_rules`\n(\n `tenant`  string , `id`  string , `location_id`  string , `rule_name`  string , `adjustment_direction`  string , `adjustment_type`  string , `adjustment_amount`  string , `adjustment_applies`  string , `min_original_price`  string , `max_original_price`  string , `min_occupancy`  string , `max_occupancy`  string , `occupancy_type`  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`  string , `max_hours_before_departure`  string , `valid_days`  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_imsprice_rules/2026-04-03/1775211037'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsprice_rules"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsprice_rules/2026-04-03/1775211037
id: 1701270
processed: 1

raw_data:

{
    "adjustment_amount": 6,
    "adjustment_applies": 7,
    "adjustment_direction": 4,
    "adjustment_type": 5,
    "created_at": 23,
    "id": 1,
    "location_id": 2,
    "max_departure_time": 14,
    "max_hours": 18,
    "max_hours_before_departure": 20,
    "max_occupancy": 11,
    "max_original_price": 9,
    "max_return_time": 16,
    "min_departure_time": 13,
    "min_hours": 17,
    "min_hours_before_departure": 19,
    "min_occupancy": 10,
    "min_original_price": 8,
    "min_return_time": 15,
    "occupancy_type": 12,
    "rule_name": 3,
    "status": 22,
    "tenant": 0,
    "updated_at": 24,
    "valid_days": 21
}

schema_attributes:

{
    "adjustment_amount": "string",
    "adjustment_applies": "string",
    "adjustment_direction": "string",
    "adjustment_type": "string",
    "created_at": "string",
    "id": "string",
    "location_id": "string",
    "max_departure_time": "string",
    "max_hours": "string",
    "max_hours_before_departure": "string",
    "max_occupancy": "string",
    "max_original_price": "string",
    "max_return_time": "string",
    "min_departure_time": "string",
    "min_hours": "string",
    "min_hours_before_departure": "string",
    "min_occupancy": "string",
    "min_original_price": "string",
    "min_return_time": "string",
    "occupancy_type": "string",
    "rule_name": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string",
    "valid_days": "string"
}

schema_name_id: 1482
schema_scan_id: 161404868
updated: 2026-04-03 05:14:08

Schema Scans: 15

Last at 2026-04-17 04:58:37

Scan 162169364

duration: 0:00:12.119457

exit_message:

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

id: 162169364

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_imsprice_rules/2026-04-17/1776419650",
        "key": "raw/stellar_imsprice_rules/2026-04-17/1776419650/price_rules.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsprice_rules",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14542090825579552637,
        "service_name": "drive-thru",
        "span_id": 12007943805625871039,
        "trace_id": 2745005608278518490
    }
}

running: False
schema_name_id: 1482
start_time: 2026-04-17 04:58:37
success: True
trace_id: 2745005608278518490

Scan 162114469

duration: 0:00:12.473114

exit_message:

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

id: 162114469

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_imsprice_rules/2026-04-16/1776334552",
        "key": "raw/stellar_imsprice_rules/2026-04-16/1776334552/price_rules.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsprice_rules",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3266602981178950495,
        "service_name": "drive-thru",
        "span_id": 1466806353328417875,
        "trace_id": 3860654427344262557
    }
}

running: False
schema_name_id: 1482
start_time: 2026-04-16 05:20:00
success: True
trace_id: 3860654427344262557

Scan 162056422

duration: 0:00:12.360751

exit_message:

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

id: 162056422

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_imsprice_rules/2026-04-15/1776242365",
        "key": "raw/stellar_imsprice_rules/2026-04-15/1776242365/price_rules.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsprice_rules",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5651475516589639329,
        "service_name": "drive-thru",
        "span_id": 1049309115823369442,
        "trace_id": 17216560779135555887
    }
}

running: False
schema_name_id: 1482
start_time: 2026-04-15 03:43:04
success: True
trace_id: 17216560779135555887

Scan 162003133

duration: 0:00:12.251468

exit_message:

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

id: 162003133

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_imsprice_rules/2026-04-14/1776160760",
        "key": "raw/stellar_imsprice_rules/2026-04-14/1776160760/price_rules.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsprice_rules",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5172277996718646677,
        "service_name": "drive-thru",
        "span_id": 15057606499088891587,
        "trace_id": 7483015108241610046
    }
}

running: False
schema_name_id: 1482
start_time: 2026-04-14 05:04:44
success: True
trace_id: 7483015108241610046

Scan 161945373

duration: 0:00:14.809859

exit_message:

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

id: 161945373

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_imsprice_rules/2026-04-13/1776074805",
        "key": "raw/stellar_imsprice_rules/2026-04-13/1776074805/price_rules.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsprice_rules",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6487391537846711358,
        "service_name": "drive-thru",
        "span_id": 15821290309509346899,
        "trace_id": 14785851250969570324
    }
}

running: False
schema_name_id: 1482
start_time: 2026-04-13 05:10:44
success: True
trace_id: 14785851250969570324

Scan 161896392

duration: 0:00:12.198987

exit_message:

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

id: 161896392

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_imsprice_rules/2026-04-12/1775988163",
        "key": "raw/stellar_imsprice_rules/2026-04-12/1775988163/price_rules.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsprice_rules",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9253318399304171927,
        "service_name": "drive-thru",
        "span_id": 6980605544352820123,
        "trace_id": 12202399864391612353
    }
}

running: False
schema_name_id: 1482
start_time: 2026-04-12 05:06:16
success: True
trace_id: 12202399864391612353

Scan 161843987

duration: 0:00:12.110274

exit_message:

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

id: 161843987

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_imsprice_rules/2026-04-11/1775902577",
        "key": "raw/stellar_imsprice_rules/2026-04-11/1775902577/price_rules.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsprice_rules",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4748163194855977219,
        "service_name": "drive-thru",
        "span_id": 5851333708934403698,
        "trace_id": 1420556605413945103
    }
}

running: False
schema_name_id: 1482
start_time: 2026-04-11 05:19:56
success: True
trace_id: 1420556605413945103

Scan 161788618

duration: 0:00:14.870240

exit_message:

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

id: 161788618

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_imsprice_rules/2026-04-10/1775815219",
        "key": "raw/stellar_imsprice_rules/2026-04-10/1775815219/price_rules.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsprice_rules",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11148704450111302048,
        "service_name": "drive-thru",
        "span_id": 13725686131126664947,
        "trace_id": 18136504488715526853
    }
}

running: False
schema_name_id: 1482
start_time: 2026-04-10 05:03:16
success: True
trace_id: 18136504488715526853

Scan 161733006

duration: 0:00:14.757920

exit_message:

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

id: 161733006

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_imsprice_rules/2026-04-09/1775728840",
        "key": "raw/stellar_imsprice_rules/2026-04-09/1775728840/price_rules.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsprice_rules",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17886366497748525757,
        "service_name": "drive-thru",
        "span_id": 8791001056068843773,
        "trace_id": 11142222021764384033
    }
}

running: False
schema_name_id: 1482
start_time: 2026-04-09 05:04:00
success: True
trace_id: 11142222021764384033

Scan 161678380

duration: 0:00:14.720727

exit_message:

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

id: 161678380

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_imsprice_rules/2026-04-08/1775642999",
        "key": "raw/stellar_imsprice_rules/2026-04-08/1775642999/price_rules.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsprice_rules",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3045120350947269354,
        "service_name": "drive-thru",
        "span_id": 10444317756499674523,
        "trace_id": 12021907147428037401
    }
}

running: False
schema_name_id: 1482
start_time: 2026-04-08 05:13:32
success: True
trace_id: 12021907147428037401

Scan 161622096

duration: 0:00:12.220239

exit_message:

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

id: 161622096

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_imsprice_rules/2026-04-07/1775556859",
        "key": "raw/stellar_imsprice_rules/2026-04-07/1775556859/price_rules.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsprice_rules",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13772485412518059220,
        "service_name": "drive-thru",
        "span_id": 16244573361724628368,
        "trace_id": 13482422641615680037
    }
}

running: False
schema_name_id: 1482
start_time: 2026-04-07 05:16:12
success: True
trace_id: 13482422641615680037

Scan 161564268

duration: 0:00:12.187315

exit_message:

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

id: 161564268

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_imsprice_rules/2026-04-06/1775470535",
        "key": "raw/stellar_imsprice_rules/2026-04-06/1775470535/price_rules.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsprice_rules",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5538083786627023529,
        "service_name": "drive-thru",
        "span_id": 341774194421409693,
        "trace_id": 7198875014101596324
    }
}

running: False
schema_name_id: 1482
start_time: 2026-04-06 05:17:41
success: True
trace_id: 7198875014101596324

Scan 161516563

duration: 0:00:14.697906

exit_message:

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

id: 161516563

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_imsprice_rules/2026-04-05/1775382948",
        "key": "raw/stellar_imsprice_rules/2026-04-05/1775382948/price_rules.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsprice_rules",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4854976178361340825,
        "service_name": "drive-thru",
        "span_id": 13620800690763845121,
        "trace_id": 11688155654752219202
    }
}

running: False
schema_name_id: 1482
start_time: 2026-04-05 04:57:32
success: True
trace_id: 11688155654752219202

Scan 161462089

duration: 0:00:12.271531

exit_message:

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

id: 161462089

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_imsprice_rules/2026-04-04/1775296466",
        "key": "raw/stellar_imsprice_rules/2026-04-04/1775296466/price_rules.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsprice_rules",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11465597691703878315,
        "service_name": "drive-thru",
        "span_id": 16759461331880461450,
        "trace_id": 14416371464949215456
    }
}

running: False
schema_name_id: 1482
start_time: 2026-04-04 04:55:02
success: True
trace_id: 14416371464949215456

Scan 161404868

duration: 0:00:12.331589

exit_message:

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

id: 161404868

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_imsprice_rules/2026-04-03/1775211037",
        "key": "raw/stellar_imsprice_rules/2026-04-03/1775211037/price_rules.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsprice_rules",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12906886521076264995,
        "service_name": "drive-thru",
        "span_id": 9726149468236906842,
        "trace_id": 2152290940457423954
    }
}

running: False
schema_name_id: 1482
start_time: 2026-04-03 05:13:56
success: True
trace_id: 2152290940457423954

Partitions:

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

Schema:

attributes:

{
    "adjustment_amount": "string",
    "adjustment_applies": "string",
    "adjustment_direction": "string",
    "adjustment_type": "string",
    "created_at": "string",
    "id": "string",
    "location_id": "string",
    "max_departure_time": "string",
    "max_hours": "string",
    "max_hours_before_departure": "string",
    "max_occupancy": "string",
    "max_original_price": "string",
    "max_return_time": "string",
    "min_departure_time": "string",
    "min_hours": "string",
    "min_hours_before_departure": "string",
    "min_occupancy": "string",
    "min_original_price": "string",
    "min_return_time": "string",
    "occupancy_type": "string",
    "rule_name": "string",
    "status": "string",
    "tenant": "string",
    "updated_at": "string",
    "valid_days": "string"
}

created: 2026-04-17 04:58:38

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsprice_rules`\n(\n `tenant`  string , `id`  string , `location_id`  string , `rule_name`  string , `adjustment_direction`  string , `adjustment_type`  string , `adjustment_amount`  string , `adjustment_applies`  string , `min_original_price`  string , `max_original_price`  string , `min_occupancy`  string , `max_occupancy`  string , `occupancy_type`  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`  string , `max_hours_before_departure`  string , `valid_days`  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_imsprice_rules/2026-04-17/1776419650'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsprice_rules`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsprice_rules"
}

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:47:36",
        "disabled": false,
        "format": "raw",
        "id": 1482,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "stellar_imsprice_rules"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "adjustment_amount": "string",
            "adjustment_applies": "string",
            "adjustment_direction": "string",
            "adjustment_type": "string",
            "created_at": "string",
            "id": "string",
            "location_id": "string",
            "max_departure_time": "string",
            "max_hours": "string",
            "max_hours_before_departure": "string",
            "max_occupancy": "string",
            "max_original_price": "string",
            "max_return_time": "string",
            "min_departure_time": "string",
            "min_hours": "string",
            "min_hours_before_departure": "string",
            "min_occupancy": "string",
            "min_original_price": "string",
            "min_return_time": "string",
            "occupancy_type": "string",
            "rule_name": "string",
            "status": "string",
            "tenant": "string",
            "updated_at": "string",
            "valid_days": "string"
        },
        "created": "2026-04-17 04:58:38",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsprice_rules`\n(\n `tenant`  string , `id`  string , `location_id`  string , `rule_name`  string , `adjustment_direction`  string , `adjustment_type`  string , `adjustment_amount`  string , `adjustment_applies`  string , `min_original_price`  string , `max_original_price`  string , `min_occupancy`  string , `max_occupancy`  string , `occupancy_type`  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`  string , `max_hours_before_departure`  string , `valid_days`  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_imsprice_rules/2026-04-17/1776419650'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsprice_rules`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsprice_rules"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}