Schema Info

Schema Name: sfdl_prod_drivethru.stellar_imsclub_tiers

created: 2023-02-07 01:46:11
disabled: False
format: raw
id: 1452
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717973

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclub_tiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclub_tiers`\n(\n `tenant`  string , `id`  string , `location_id`  string , `tier_name`  string , `frontend_display`  string , `frontend_name`  string , `frontend_position`  string , `term_length`  string , `term_length_type`  string , `term_auto_renew`  string , `term_fee`  string , `period_length`  string , `period_length_type`  string , `credits_per_period`  string , `hours_per_credit`  string , `period_fee`  string , `frontend_display_pricing`  string , `no_show_fee`  string , `allow_self_cancellations`  string , `cancellation_fee`  string , `application_fee`  string , `bdrd`  string , `max_pending_waitlist_entries`  string , `max_active_members`  string , `free_accessories`  string , `description`  string , `terms`  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_tiers/2026-04-17/1776419649'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclub_tiers"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsclub_tiers/2026-04-17/1776419649
id: 1717973
processed: 1

raw_data:

{
    "allow_self_cancellations": 18,
    "application_fee": 20,
    "bdrd": 21,
    "cancellation_fee": 19,
    "created_at": 28,
    "credits_per_period": 13,
    "description": 25,
    "free_accessories": 24,
    "frontend_display": 4,
    "frontend_display_pricing": 16,
    "frontend_name": 5,
    "frontend_position": 6,
    "hours_per_credit": 14,
    "id": 1,
    "location_id": 2,
    "max_active_members": 23,
    "max_pending_waitlist_entries": 22,
    "no_show_fee": 17,
    "period_fee": 15,
    "period_length": 11,
    "period_length_type": 12,
    "status": 27,
    "tenant": 0,
    "term_auto_renew": 9,
    "term_fee": 10,
    "term_length": 7,
    "term_length_type": 8,
    "terms": 26,
    "tier_name": 3,
    "updated_at": 29
}

schema_attributes:

{
    "allow_self_cancellations": "string",
    "application_fee": "string",
    "bdrd": "string",
    "cancellation_fee": "string",
    "created_at": "string",
    "credits_per_period": "string",
    "description": "string",
    "free_accessories": "string",
    "frontend_display": "string",
    "frontend_display_pricing": "string",
    "frontend_name": "string",
    "frontend_position": "string",
    "hours_per_credit": "string",
    "id": "string",
    "location_id": "string",
    "max_active_members": "string",
    "max_pending_waitlist_entries": "string",
    "no_show_fee": "string",
    "period_fee": "string",
    "period_length": "string",
    "period_length_type": "string",
    "status": "string",
    "tenant": "string",
    "term_auto_renew": "string",
    "term_fee": "string",
    "term_length": "string",
    "term_length_type": "string",
    "terms": "string",
    "tier_name": "string",
    "updated_at": "string"
}

schema_name_id: 1452
schema_scan_id: 162169311
updated: 2026-04-17 04:57:16

Version 1716737

created: 2026-04-16 05:17:39

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclub_tiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclub_tiers`\n(\n `tenant`  string , `id`  string , `location_id`  string , `tier_name`  string , `frontend_display`  string , `frontend_name`  string , `frontend_position`  string , `term_length`  string , `term_length_type`  string , `term_auto_renew`  string , `term_fee`  string , `period_length`  string , `period_length_type`  string , `credits_per_period`  string , `hours_per_credit`  string , `period_fee`  string , `frontend_display_pricing`  string , `no_show_fee`  string , `allow_self_cancellations`  string , `cancellation_fee`  string , `application_fee`  string , `bdrd`  string , `max_pending_waitlist_entries`  string , `max_active_members`  string , `free_accessories`  string , `description`  string , `terms`  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_tiers/2026-04-16/1776334545'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclub_tiers"
]

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

raw_data:

{
    "allow_self_cancellations": 18,
    "application_fee": 20,
    "bdrd": 21,
    "cancellation_fee": 19,
    "created_at": 28,
    "credits_per_period": 13,
    "description": 25,
    "free_accessories": 24,
    "frontend_display": 4,
    "frontend_display_pricing": 16,
    "frontend_name": 5,
    "frontend_position": 6,
    "hours_per_credit": 14,
    "id": 1,
    "location_id": 2,
    "max_active_members": 23,
    "max_pending_waitlist_entries": 22,
    "no_show_fee": 17,
    "period_fee": 15,
    "period_length": 11,
    "period_length_type": 12,
    "status": 27,
    "tenant": 0,
    "term_auto_renew": 9,
    "term_fee": 10,
    "term_length": 7,
    "term_length_type": 8,
    "terms": 26,
    "tier_name": 3,
    "updated_at": 29
}

schema_attributes:

{
    "allow_self_cancellations": "string",
    "application_fee": "string",
    "bdrd": "string",
    "cancellation_fee": "string",
    "created_at": "string",
    "credits_per_period": "string",
    "description": "string",
    "free_accessories": "string",
    "frontend_display": "string",
    "frontend_display_pricing": "string",
    "frontend_name": "string",
    "frontend_position": "string",
    "hours_per_credit": "string",
    "id": "string",
    "location_id": "string",
    "max_active_members": "string",
    "max_pending_waitlist_entries": "string",
    "no_show_fee": "string",
    "period_fee": "string",
    "period_length": "string",
    "period_length_type": "string",
    "status": "string",
    "tenant": "string",
    "term_auto_renew": "string",
    "term_fee": "string",
    "term_length": "string",
    "term_length_type": "string",
    "terms": "string",
    "tier_name": "string",
    "updated_at": "string"
}

schema_name_id: 1452
schema_scan_id: 162114406
updated: 2026-04-16 05:17:50

Version 1715463

created: 2026-04-15 03:40:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclub_tiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclub_tiers`\n(\n `tenant`  string , `id`  string , `location_id`  string , `tier_name`  string , `frontend_display`  string , `frontend_name`  string , `frontend_position`  string , `term_length`  string , `term_length_type`  string , `term_auto_renew`  string , `term_fee`  string , `period_length`  string , `period_length_type`  string , `credits_per_period`  string , `hours_per_credit`  string , `period_fee`  string , `frontend_display_pricing`  string , `no_show_fee`  string , `allow_self_cancellations`  string , `cancellation_fee`  string , `application_fee`  string , `bdrd`  string , `max_pending_waitlist_entries`  string , `max_active_members`  string , `free_accessories`  string , `description`  string , `terms`  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_tiers/2026-04-15/1776242358'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclub_tiers"
]

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

raw_data:

{
    "allow_self_cancellations": 18,
    "application_fee": 20,
    "bdrd": 21,
    "cancellation_fee": 19,
    "created_at": 28,
    "credits_per_period": 13,
    "description": 25,
    "free_accessories": 24,
    "frontend_display": 4,
    "frontend_display_pricing": 16,
    "frontend_name": 5,
    "frontend_position": 6,
    "hours_per_credit": 14,
    "id": 1,
    "location_id": 2,
    "max_active_members": 23,
    "max_pending_waitlist_entries": 22,
    "no_show_fee": 17,
    "period_fee": 15,
    "period_length": 11,
    "period_length_type": 12,
    "status": 27,
    "tenant": 0,
    "term_auto_renew": 9,
    "term_fee": 10,
    "term_length": 7,
    "term_length_type": 8,
    "terms": 26,
    "tier_name": 3,
    "updated_at": 29
}

schema_attributes:

{
    "allow_self_cancellations": "string",
    "application_fee": "string",
    "bdrd": "string",
    "cancellation_fee": "string",
    "created_at": "string",
    "credits_per_period": "string",
    "description": "string",
    "free_accessories": "string",
    "frontend_display": "string",
    "frontend_display_pricing": "string",
    "frontend_name": "string",
    "frontend_position": "string",
    "hours_per_credit": "string",
    "id": "string",
    "location_id": "string",
    "max_active_members": "string",
    "max_pending_waitlist_entries": "string",
    "no_show_fee": "string",
    "period_fee": "string",
    "period_length": "string",
    "period_length_type": "string",
    "status": "string",
    "tenant": "string",
    "term_auto_renew": "string",
    "term_fee": "string",
    "term_length": "string",
    "term_length_type": "string",
    "terms": "string",
    "tier_name": "string",
    "updated_at": "string"
}

schema_name_id: 1452
schema_scan_id: 162056346
updated: 2026-04-15 03:40:29

Version 1714326

created: 2026-04-14 05:01:27

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclub_tiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclub_tiers`\n(\n `tenant`  string , `id`  string , `location_id`  string , `tier_name`  string , `frontend_display`  string , `frontend_name`  string , `frontend_position`  string , `term_length`  string , `term_length_type`  string , `term_auto_renew`  string , `term_fee`  string , `period_length`  string , `period_length_type`  string , `credits_per_period`  string , `hours_per_credit`  string , `period_fee`  string , `frontend_display_pricing`  string , `no_show_fee`  string , `allow_self_cancellations`  string , `cancellation_fee`  string , `application_fee`  string , `bdrd`  string , `max_pending_waitlist_entries`  string , `max_active_members`  string , `free_accessories`  string , `description`  string , `terms`  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_tiers/2026-04-14/1776160757'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclub_tiers"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsclub_tiers/2026-04-14/1776160757
id: 1714326
processed: 1

raw_data:

{
    "allow_self_cancellations": 18,
    "application_fee": 20,
    "bdrd": 21,
    "cancellation_fee": 19,
    "created_at": 28,
    "credits_per_period": 13,
    "description": 25,
    "free_accessories": 24,
    "frontend_display": 4,
    "frontend_display_pricing": 16,
    "frontend_name": 5,
    "frontend_position": 6,
    "hours_per_credit": 14,
    "id": 1,
    "location_id": 2,
    "max_active_members": 23,
    "max_pending_waitlist_entries": 22,
    "no_show_fee": 17,
    "period_fee": 15,
    "period_length": 11,
    "period_length_type": 12,
    "status": 27,
    "tenant": 0,
    "term_auto_renew": 9,
    "term_fee": 10,
    "term_length": 7,
    "term_length_type": 8,
    "terms": 26,
    "tier_name": 3,
    "updated_at": 29
}

schema_attributes:

{
    "allow_self_cancellations": "string",
    "application_fee": "string",
    "bdrd": "string",
    "cancellation_fee": "string",
    "created_at": "string",
    "credits_per_period": "string",
    "description": "string",
    "free_accessories": "string",
    "frontend_display": "string",
    "frontend_display_pricing": "string",
    "frontend_name": "string",
    "frontend_position": "string",
    "hours_per_credit": "string",
    "id": "string",
    "location_id": "string",
    "max_active_members": "string",
    "max_pending_waitlist_entries": "string",
    "no_show_fee": "string",
    "period_fee": "string",
    "period_length": "string",
    "period_length_type": "string",
    "status": "string",
    "tenant": "string",
    "term_auto_renew": "string",
    "term_fee": "string",
    "term_length": "string",
    "term_length_type": "string",
    "terms": "string",
    "tier_name": "string",
    "updated_at": "string"
}

schema_name_id: 1452
schema_scan_id: 162002980
updated: 2026-04-14 05:01:38

Version 1713074

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclub_tiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclub_tiers`\n(\n `tenant`  string , `id`  string , `location_id`  string , `tier_name`  string , `frontend_display`  string , `frontend_name`  string , `frontend_position`  string , `term_length`  string , `term_length_type`  string , `term_auto_renew`  string , `term_fee`  string , `period_length`  string , `period_length_type`  string , `credits_per_period`  string , `hours_per_credit`  string , `period_fee`  string , `frontend_display_pricing`  string , `no_show_fee`  string , `allow_self_cancellations`  string , `cancellation_fee`  string , `application_fee`  string , `bdrd`  string , `max_pending_waitlist_entries`  string , `max_active_members`  string , `free_accessories`  string , `description`  string , `terms`  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_tiers/2026-04-13/1776074799'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclub_tiers"
]

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

raw_data:

{
    "allow_self_cancellations": 18,
    "application_fee": 20,
    "bdrd": 21,
    "cancellation_fee": 19,
    "created_at": 28,
    "credits_per_period": 13,
    "description": 25,
    "free_accessories": 24,
    "frontend_display": 4,
    "frontend_display_pricing": 16,
    "frontend_name": 5,
    "frontend_position": 6,
    "hours_per_credit": 14,
    "id": 1,
    "location_id": 2,
    "max_active_members": 23,
    "max_pending_waitlist_entries": 22,
    "no_show_fee": 17,
    "period_fee": 15,
    "period_length": 11,
    "period_length_type": 12,
    "status": 27,
    "tenant": 0,
    "term_auto_renew": 9,
    "term_fee": 10,
    "term_length": 7,
    "term_length_type": 8,
    "terms": 26,
    "tier_name": 3,
    "updated_at": 29
}

schema_attributes:

{
    "allow_self_cancellations": "string",
    "application_fee": "string",
    "bdrd": "string",
    "cancellation_fee": "string",
    "created_at": "string",
    "credits_per_period": "string",
    "description": "string",
    "free_accessories": "string",
    "frontend_display": "string",
    "frontend_display_pricing": "string",
    "frontend_name": "string",
    "frontend_position": "string",
    "hours_per_credit": "string",
    "id": "string",
    "location_id": "string",
    "max_active_members": "string",
    "max_pending_waitlist_entries": "string",
    "no_show_fee": "string",
    "period_fee": "string",
    "period_length": "string",
    "period_length_type": "string",
    "status": "string",
    "tenant": "string",
    "term_auto_renew": "string",
    "term_fee": "string",
    "term_length": "string",
    "term_length_type": "string",
    "terms": "string",
    "tier_name": "string",
    "updated_at": "string"
}

schema_name_id: 1452
schema_scan_id: 161945279
updated: 2026-04-13 05:07:29

Version 1711890

created: 2026-04-12 05:03:40

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclub_tiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclub_tiers`\n(\n `tenant`  string , `id`  string , `location_id`  string , `tier_name`  string , `frontend_display`  string , `frontend_name`  string , `frontend_position`  string , `term_length`  string , `term_length_type`  string , `term_auto_renew`  string , `term_fee`  string , `period_length`  string , `period_length_type`  string , `credits_per_period`  string , `hours_per_credit`  string , `period_fee`  string , `frontend_display_pricing`  string , `no_show_fee`  string , `allow_self_cancellations`  string , `cancellation_fee`  string , `application_fee`  string , `bdrd`  string , `max_pending_waitlist_entries`  string , `max_active_members`  string , `free_accessories`  string , `description`  string , `terms`  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_tiers/2026-04-12/1775988156'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclub_tiers"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsclub_tiers/2026-04-12/1775988156
id: 1711890
processed: 1

raw_data:

{
    "allow_self_cancellations": 18,
    "application_fee": 20,
    "bdrd": 21,
    "cancellation_fee": 19,
    "created_at": 28,
    "credits_per_period": 13,
    "description": 25,
    "free_accessories": 24,
    "frontend_display": 4,
    "frontend_display_pricing": 16,
    "frontend_name": 5,
    "frontend_position": 6,
    "hours_per_credit": 14,
    "id": 1,
    "location_id": 2,
    "max_active_members": 23,
    "max_pending_waitlist_entries": 22,
    "no_show_fee": 17,
    "period_fee": 15,
    "period_length": 11,
    "period_length_type": 12,
    "status": 27,
    "tenant": 0,
    "term_auto_renew": 9,
    "term_fee": 10,
    "term_length": 7,
    "term_length_type": 8,
    "terms": 26,
    "tier_name": 3,
    "updated_at": 29
}

schema_attributes:

{
    "allow_self_cancellations": "string",
    "application_fee": "string",
    "bdrd": "string",
    "cancellation_fee": "string",
    "created_at": "string",
    "credits_per_period": "string",
    "description": "string",
    "free_accessories": "string",
    "frontend_display": "string",
    "frontend_display_pricing": "string",
    "frontend_name": "string",
    "frontend_position": "string",
    "hours_per_credit": "string",
    "id": "string",
    "location_id": "string",
    "max_active_members": "string",
    "max_pending_waitlist_entries": "string",
    "no_show_fee": "string",
    "period_fee": "string",
    "period_length": "string",
    "period_length_type": "string",
    "status": "string",
    "tenant": "string",
    "term_auto_renew": "string",
    "term_fee": "string",
    "term_length": "string",
    "term_length_type": "string",
    "terms": "string",
    "tier_name": "string",
    "updated_at": "string"
}

schema_name_id: 1452
schema_scan_id: 161896329
updated: 2026-04-12 05:03:54

Version 1710748

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclub_tiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclub_tiers`\n(\n `tenant`  string , `id`  string , `location_id`  string , `tier_name`  string , `frontend_display`  string , `frontend_name`  string , `frontend_position`  string , `term_length`  string , `term_length_type`  string , `term_auto_renew`  string , `term_fee`  string , `period_length`  string , `period_length_type`  string , `credits_per_period`  string , `hours_per_credit`  string , `period_fee`  string , `frontend_display_pricing`  string , `no_show_fee`  string , `allow_self_cancellations`  string , `cancellation_fee`  string , `application_fee`  string , `bdrd`  string , `max_pending_waitlist_entries`  string , `max_active_members`  string , `free_accessories`  string , `description`  string , `terms`  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_tiers/2026-04-11/1775902576'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclub_tiers"
]

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

raw_data:

{
    "allow_self_cancellations": 18,
    "application_fee": 20,
    "bdrd": 21,
    "cancellation_fee": 19,
    "created_at": 28,
    "credits_per_period": 13,
    "description": 25,
    "free_accessories": 24,
    "frontend_display": 4,
    "frontend_display_pricing": 16,
    "frontend_name": 5,
    "frontend_position": 6,
    "hours_per_credit": 14,
    "id": 1,
    "location_id": 2,
    "max_active_members": 23,
    "max_pending_waitlist_entries": 22,
    "no_show_fee": 17,
    "period_fee": 15,
    "period_length": 11,
    "period_length_type": 12,
    "status": 27,
    "tenant": 0,
    "term_auto_renew": 9,
    "term_fee": 10,
    "term_length": 7,
    "term_length_type": 8,
    "terms": 26,
    "tier_name": 3,
    "updated_at": 29
}

schema_attributes:

{
    "allow_self_cancellations": "string",
    "application_fee": "string",
    "bdrd": "string",
    "cancellation_fee": "string",
    "created_at": "string",
    "credits_per_period": "string",
    "description": "string",
    "free_accessories": "string",
    "frontend_display": "string",
    "frontend_display_pricing": "string",
    "frontend_name": "string",
    "frontend_position": "string",
    "hours_per_credit": "string",
    "id": "string",
    "location_id": "string",
    "max_active_members": "string",
    "max_pending_waitlist_entries": "string",
    "no_show_fee": "string",
    "period_fee": "string",
    "period_length": "string",
    "period_length_type": "string",
    "status": "string",
    "tenant": "string",
    "term_auto_renew": "string",
    "term_fee": "string",
    "term_length": "string",
    "term_length_type": "string",
    "terms": "string",
    "tier_name": "string",
    "updated_at": "string"
}

schema_name_id: 1452
schema_scan_id: 161843967
updated: 2026-04-11 05:19:29

Version 1709547

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclub_tiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclub_tiers`\n(\n `tenant`  string , `id`  string , `location_id`  string , `tier_name`  string , `frontend_display`  string , `frontend_name`  string , `frontend_position`  string , `term_length`  string , `term_length_type`  string , `term_auto_renew`  string , `term_fee`  string , `period_length`  string , `period_length_type`  string , `credits_per_period`  string , `hours_per_credit`  string , `period_fee`  string , `frontend_display_pricing`  string , `no_show_fee`  string , `allow_self_cancellations`  string , `cancellation_fee`  string , `application_fee`  string , `bdrd`  string , `max_pending_waitlist_entries`  string , `max_active_members`  string , `free_accessories`  string , `description`  string , `terms`  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_tiers/2026-04-10/1775815217'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclub_tiers"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsclub_tiers/2026-04-10/1775815217
id: 1709547
processed: 1

raw_data:

{
    "allow_self_cancellations": 18,
    "application_fee": 20,
    "bdrd": 21,
    "cancellation_fee": 19,
    "created_at": 28,
    "credits_per_period": 13,
    "description": 25,
    "free_accessories": 24,
    "frontend_display": 4,
    "frontend_display_pricing": 16,
    "frontend_name": 5,
    "frontend_position": 6,
    "hours_per_credit": 14,
    "id": 1,
    "location_id": 2,
    "max_active_members": 23,
    "max_pending_waitlist_entries": 22,
    "no_show_fee": 17,
    "period_fee": 15,
    "period_length": 11,
    "period_length_type": 12,
    "status": 27,
    "tenant": 0,
    "term_auto_renew": 9,
    "term_fee": 10,
    "term_length": 7,
    "term_length_type": 8,
    "terms": 26,
    "tier_name": 3,
    "updated_at": 29
}

schema_attributes:

{
    "allow_self_cancellations": "string",
    "application_fee": "string",
    "bdrd": "string",
    "cancellation_fee": "string",
    "created_at": "string",
    "credits_per_period": "string",
    "description": "string",
    "free_accessories": "string",
    "frontend_display": "string",
    "frontend_display_pricing": "string",
    "frontend_name": "string",
    "frontend_position": "string",
    "hours_per_credit": "string",
    "id": "string",
    "location_id": "string",
    "max_active_members": "string",
    "max_pending_waitlist_entries": "string",
    "no_show_fee": "string",
    "period_fee": "string",
    "period_length": "string",
    "period_length_type": "string",
    "status": "string",
    "tenant": "string",
    "term_auto_renew": "string",
    "term_fee": "string",
    "term_length": "string",
    "term_length_type": "string",
    "terms": "string",
    "tier_name": "string",
    "updated_at": "string"
}

schema_name_id: 1452
schema_scan_id: 161788588
updated: 2026-04-10 05:02:28

Version 1708446

created: 2026-04-09 05:04:06

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclub_tiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclub_tiers`\n(\n `tenant`  string , `id`  string , `location_id`  string , `tier_name`  string , `frontend_display`  string , `frontend_name`  string , `frontend_position`  string , `term_length`  string , `term_length_type`  string , `term_auto_renew`  string , `term_fee`  string , `period_length`  string , `period_length_type`  string , `credits_per_period`  string , `hours_per_credit`  string , `period_fee`  string , `frontend_display_pricing`  string , `no_show_fee`  string , `allow_self_cancellations`  string , `cancellation_fee`  string , `application_fee`  string , `bdrd`  string , `max_pending_waitlist_entries`  string , `max_active_members`  string , `free_accessories`  string , `description`  string , `terms`  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_tiers/2026-04-09/1775728838'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclub_tiers"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsclub_tiers/2026-04-09/1775728838
id: 1708446
processed: 1

raw_data:

{
    "allow_self_cancellations": 18,
    "application_fee": 20,
    "bdrd": 21,
    "cancellation_fee": 19,
    "created_at": 28,
    "credits_per_period": 13,
    "description": 25,
    "free_accessories": 24,
    "frontend_display": 4,
    "frontend_display_pricing": 16,
    "frontend_name": 5,
    "frontend_position": 6,
    "hours_per_credit": 14,
    "id": 1,
    "location_id": 2,
    "max_active_members": 23,
    "max_pending_waitlist_entries": 22,
    "no_show_fee": 17,
    "period_fee": 15,
    "period_length": 11,
    "period_length_type": 12,
    "status": 27,
    "tenant": 0,
    "term_auto_renew": 9,
    "term_fee": 10,
    "term_length": 7,
    "term_length_type": 8,
    "terms": 26,
    "tier_name": 3,
    "updated_at": 29
}

schema_attributes:

{
    "allow_self_cancellations": "string",
    "application_fee": "string",
    "bdrd": "string",
    "cancellation_fee": "string",
    "created_at": "string",
    "credits_per_period": "string",
    "description": "string",
    "free_accessories": "string",
    "frontend_display": "string",
    "frontend_display_pricing": "string",
    "frontend_name": "string",
    "frontend_position": "string",
    "hours_per_credit": "string",
    "id": "string",
    "location_id": "string",
    "max_active_members": "string",
    "max_pending_waitlist_entries": "string",
    "no_show_fee": "string",
    "period_fee": "string",
    "period_length": "string",
    "period_length_type": "string",
    "status": "string",
    "tenant": "string",
    "term_auto_renew": "string",
    "term_fee": "string",
    "term_length": "string",
    "term_length_type": "string",
    "terms": "string",
    "tier_name": "string",
    "updated_at": "string"
}

schema_name_id: 1452
schema_scan_id: 161733009
updated: 2026-04-09 05:04:20

Version 1707228

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclub_tiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclub_tiers`\n(\n `tenant`  string , `id`  string , `location_id`  string , `tier_name`  string , `frontend_display`  string , `frontend_name`  string , `frontend_position`  string , `term_length`  string , `term_length_type`  string , `term_auto_renew`  string , `term_fee`  string , `period_length`  string , `period_length_type`  string , `credits_per_period`  string , `hours_per_credit`  string , `period_fee`  string , `frontend_display_pricing`  string , `no_show_fee`  string , `allow_self_cancellations`  string , `cancellation_fee`  string , `application_fee`  string , `bdrd`  string , `max_pending_waitlist_entries`  string , `max_active_members`  string , `free_accessories`  string , `description`  string , `terms`  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_tiers/2026-04-08/1775643001'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclub_tiers"
]

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

raw_data:

{
    "allow_self_cancellations": 18,
    "application_fee": 20,
    "bdrd": 21,
    "cancellation_fee": 19,
    "created_at": 28,
    "credits_per_period": 13,
    "description": 25,
    "free_accessories": 24,
    "frontend_display": 4,
    "frontend_display_pricing": 16,
    "frontend_name": 5,
    "frontend_position": 6,
    "hours_per_credit": 14,
    "id": 1,
    "location_id": 2,
    "max_active_members": 23,
    "max_pending_waitlist_entries": 22,
    "no_show_fee": 17,
    "period_fee": 15,
    "period_length": 11,
    "period_length_type": 12,
    "status": 27,
    "tenant": 0,
    "term_auto_renew": 9,
    "term_fee": 10,
    "term_length": 7,
    "term_length_type": 8,
    "terms": 26,
    "tier_name": 3,
    "updated_at": 29
}

schema_attributes:

{
    "allow_self_cancellations": "string",
    "application_fee": "string",
    "bdrd": "string",
    "cancellation_fee": "string",
    "created_at": "string",
    "credits_per_period": "string",
    "description": "string",
    "free_accessories": "string",
    "frontend_display": "string",
    "frontend_display_pricing": "string",
    "frontend_name": "string",
    "frontend_position": "string",
    "hours_per_credit": "string",
    "id": "string",
    "location_id": "string",
    "max_active_members": "string",
    "max_pending_waitlist_entries": "string",
    "no_show_fee": "string",
    "period_fee": "string",
    "period_length": "string",
    "period_length_type": "string",
    "status": "string",
    "tenant": "string",
    "term_auto_renew": "string",
    "term_fee": "string",
    "term_length": "string",
    "term_length_type": "string",
    "terms": "string",
    "tier_name": "string",
    "updated_at": "string"
}

schema_name_id: 1452
schema_scan_id: 161678387
updated: 2026-04-08 05:14:04

Version 1706054

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclub_tiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclub_tiers`\n(\n `tenant`  string , `id`  string , `location_id`  string , `tier_name`  string , `frontend_display`  string , `frontend_name`  string , `frontend_position`  string , `term_length`  string , `term_length_type`  string , `term_auto_renew`  string , `term_fee`  string , `period_length`  string , `period_length_type`  string , `credits_per_period`  string , `hours_per_credit`  string , `period_fee`  string , `frontend_display_pricing`  string , `no_show_fee`  string , `allow_self_cancellations`  string , `cancellation_fee`  string , `application_fee`  string , `bdrd`  string , `max_pending_waitlist_entries`  string , `max_active_members`  string , `free_accessories`  string , `description`  string , `terms`  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_tiers/2026-04-07/1775556857'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclub_tiers"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsclub_tiers/2026-04-07/1775556857
id: 1706054
processed: 1

raw_data:

{
    "allow_self_cancellations": 18,
    "application_fee": 20,
    "bdrd": 21,
    "cancellation_fee": 19,
    "created_at": 28,
    "credits_per_period": 13,
    "description": 25,
    "free_accessories": 24,
    "frontend_display": 4,
    "frontend_display_pricing": 16,
    "frontend_name": 5,
    "frontend_position": 6,
    "hours_per_credit": 14,
    "id": 1,
    "location_id": 2,
    "max_active_members": 23,
    "max_pending_waitlist_entries": 22,
    "no_show_fee": 17,
    "period_fee": 15,
    "period_length": 11,
    "period_length_type": 12,
    "status": 27,
    "tenant": 0,
    "term_auto_renew": 9,
    "term_fee": 10,
    "term_length": 7,
    "term_length_type": 8,
    "terms": 26,
    "tier_name": 3,
    "updated_at": 29
}

schema_attributes:

{
    "allow_self_cancellations": "string",
    "application_fee": "string",
    "bdrd": "string",
    "cancellation_fee": "string",
    "created_at": "string",
    "credits_per_period": "string",
    "description": "string",
    "free_accessories": "string",
    "frontend_display": "string",
    "frontend_display_pricing": "string",
    "frontend_name": "string",
    "frontend_position": "string",
    "hours_per_credit": "string",
    "id": "string",
    "location_id": "string",
    "max_active_members": "string",
    "max_pending_waitlist_entries": "string",
    "no_show_fee": "string",
    "period_fee": "string",
    "period_length": "string",
    "period_length_type": "string",
    "status": "string",
    "tenant": "string",
    "term_auto_renew": "string",
    "term_fee": "string",
    "term_length": "string",
    "term_length_type": "string",
    "terms": "string",
    "tier_name": "string",
    "updated_at": "string"
}

schema_name_id: 1452
schema_scan_id: 161622133
updated: 2026-04-07 05:17:49

Version 1704799

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclub_tiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclub_tiers`\n(\n `tenant`  string , `id`  string , `location_id`  string , `tier_name`  string , `frontend_display`  string , `frontend_name`  string , `frontend_position`  string , `term_length`  string , `term_length_type`  string , `term_auto_renew`  string , `term_fee`  string , `period_length`  string , `period_length_type`  string , `credits_per_period`  string , `hours_per_credit`  string , `period_fee`  string , `frontend_display_pricing`  string , `no_show_fee`  string , `allow_self_cancellations`  string , `cancellation_fee`  string , `application_fee`  string , `bdrd`  string , `max_pending_waitlist_entries`  string , `max_active_members`  string , `free_accessories`  string , `description`  string , `terms`  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_tiers/2026-04-06/1775470528'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclub_tiers"
]

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

raw_data:

{
    "allow_self_cancellations": 18,
    "application_fee": 20,
    "bdrd": 21,
    "cancellation_fee": 19,
    "created_at": 28,
    "credits_per_period": 13,
    "description": 25,
    "free_accessories": 24,
    "frontend_display": 4,
    "frontend_display_pricing": 16,
    "frontend_name": 5,
    "frontend_position": 6,
    "hours_per_credit": 14,
    "id": 1,
    "location_id": 2,
    "max_active_members": 23,
    "max_pending_waitlist_entries": 22,
    "no_show_fee": 17,
    "period_fee": 15,
    "period_length": 11,
    "period_length_type": 12,
    "status": 27,
    "tenant": 0,
    "term_auto_renew": 9,
    "term_fee": 10,
    "term_length": 7,
    "term_length_type": 8,
    "terms": 26,
    "tier_name": 3,
    "updated_at": 29
}

schema_attributes:

{
    "allow_self_cancellations": "string",
    "application_fee": "string",
    "bdrd": "string",
    "cancellation_fee": "string",
    "created_at": "string",
    "credits_per_period": "string",
    "description": "string",
    "free_accessories": "string",
    "frontend_display": "string",
    "frontend_display_pricing": "string",
    "frontend_name": "string",
    "frontend_position": "string",
    "hours_per_credit": "string",
    "id": "string",
    "location_id": "string",
    "max_active_members": "string",
    "max_pending_waitlist_entries": "string",
    "no_show_fee": "string",
    "period_fee": "string",
    "period_length": "string",
    "period_length_type": "string",
    "status": "string",
    "tenant": "string",
    "term_auto_renew": "string",
    "term_fee": "string",
    "term_length": "string",
    "term_length_type": "string",
    "terms": "string",
    "tier_name": "string",
    "updated_at": "string"
}

schema_name_id: 1452
schema_scan_id: 161564272
updated: 2026-04-06 05:18:00

Version 1703586

created: 2026-04-05 04:58:12

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclub_tiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclub_tiers`\n(\n `tenant`  string , `id`  string , `location_id`  string , `tier_name`  string , `frontend_display`  string , `frontend_name`  string , `frontend_position`  string , `term_length`  string , `term_length_type`  string , `term_auto_renew`  string , `term_fee`  string , `period_length`  string , `period_length_type`  string , `credits_per_period`  string , `hours_per_credit`  string , `period_fee`  string , `frontend_display_pricing`  string , `no_show_fee`  string , `allow_self_cancellations`  string , `cancellation_fee`  string , `application_fee`  string , `bdrd`  string , `max_pending_waitlist_entries`  string , `max_active_members`  string , `free_accessories`  string , `description`  string , `terms`  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_tiers/2026-04-05/1775382945'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclub_tiers"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsclub_tiers/2026-04-05/1775382945
id: 1703586
processed: 1

raw_data:

{
    "allow_self_cancellations": 18,
    "application_fee": 20,
    "bdrd": 21,
    "cancellation_fee": 19,
    "created_at": 28,
    "credits_per_period": 13,
    "description": 25,
    "free_accessories": 24,
    "frontend_display": 4,
    "frontend_display_pricing": 16,
    "frontend_name": 5,
    "frontend_position": 6,
    "hours_per_credit": 14,
    "id": 1,
    "location_id": 2,
    "max_active_members": 23,
    "max_pending_waitlist_entries": 22,
    "no_show_fee": 17,
    "period_fee": 15,
    "period_length": 11,
    "period_length_type": 12,
    "status": 27,
    "tenant": 0,
    "term_auto_renew": 9,
    "term_fee": 10,
    "term_length": 7,
    "term_length_type": 8,
    "terms": 26,
    "tier_name": 3,
    "updated_at": 29
}

schema_attributes:

{
    "allow_self_cancellations": "string",
    "application_fee": "string",
    "bdrd": "string",
    "cancellation_fee": "string",
    "created_at": "string",
    "credits_per_period": "string",
    "description": "string",
    "free_accessories": "string",
    "frontend_display": "string",
    "frontend_display_pricing": "string",
    "frontend_name": "string",
    "frontend_position": "string",
    "hours_per_credit": "string",
    "id": "string",
    "location_id": "string",
    "max_active_members": "string",
    "max_pending_waitlist_entries": "string",
    "no_show_fee": "string",
    "period_fee": "string",
    "period_length": "string",
    "period_length_type": "string",
    "status": "string",
    "tenant": "string",
    "term_auto_renew": "string",
    "term_fee": "string",
    "term_length": "string",
    "term_length_type": "string",
    "terms": "string",
    "tier_name": "string",
    "updated_at": "string"
}

schema_name_id: 1452
schema_scan_id: 161516583
updated: 2026-04-05 04:58:26

Version 1702432

created: 2026-04-04 04:56:35

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclub_tiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclub_tiers`\n(\n `tenant`  string , `id`  string , `location_id`  string , `tier_name`  string , `frontend_display`  string , `frontend_name`  string , `frontend_position`  string , `term_length`  string , `term_length_type`  string , `term_auto_renew`  string , `term_fee`  string , `period_length`  string , `period_length_type`  string , `credits_per_period`  string , `hours_per_credit`  string , `period_fee`  string , `frontend_display_pricing`  string , `no_show_fee`  string , `allow_self_cancellations`  string , `cancellation_fee`  string , `application_fee`  string , `bdrd`  string , `max_pending_waitlist_entries`  string , `max_active_members`  string , `free_accessories`  string , `description`  string , `terms`  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_tiers/2026-04-04/1775296469'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclub_tiers"
]

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

raw_data:

{
    "allow_self_cancellations": 18,
    "application_fee": 20,
    "bdrd": 21,
    "cancellation_fee": 19,
    "created_at": 28,
    "credits_per_period": 13,
    "description": 25,
    "free_accessories": 24,
    "frontend_display": 4,
    "frontend_display_pricing": 16,
    "frontend_name": 5,
    "frontend_position": 6,
    "hours_per_credit": 14,
    "id": 1,
    "location_id": 2,
    "max_active_members": 23,
    "max_pending_waitlist_entries": 22,
    "no_show_fee": 17,
    "period_fee": 15,
    "period_length": 11,
    "period_length_type": 12,
    "status": 27,
    "tenant": 0,
    "term_auto_renew": 9,
    "term_fee": 10,
    "term_length": 7,
    "term_length_type": 8,
    "terms": 26,
    "tier_name": 3,
    "updated_at": 29
}

schema_attributes:

{
    "allow_self_cancellations": "string",
    "application_fee": "string",
    "bdrd": "string",
    "cancellation_fee": "string",
    "created_at": "string",
    "credits_per_period": "string",
    "description": "string",
    "free_accessories": "string",
    "frontend_display": "string",
    "frontend_display_pricing": "string",
    "frontend_name": "string",
    "frontend_position": "string",
    "hours_per_credit": "string",
    "id": "string",
    "location_id": "string",
    "max_active_members": "string",
    "max_pending_waitlist_entries": "string",
    "no_show_fee": "string",
    "period_fee": "string",
    "period_length": "string",
    "period_length_type": "string",
    "status": "string",
    "tenant": "string",
    "term_auto_renew": "string",
    "term_fee": "string",
    "term_length": "string",
    "term_length_type": "string",
    "terms": "string",
    "tier_name": "string",
    "updated_at": "string"
}

schema_name_id: 1452
schema_scan_id: 161462132
updated: 2026-04-04 04:56:49

Version 1701206

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclub_tiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclub_tiers`\n(\n `tenant`  string , `id`  string , `location_id`  string , `tier_name`  string , `frontend_display`  string , `frontend_name`  string , `frontend_position`  string , `term_length`  string , `term_length_type`  string , `term_auto_renew`  string , `term_fee`  string , `period_length`  string , `period_length_type`  string , `credits_per_period`  string , `hours_per_credit`  string , `period_fee`  string , `frontend_display_pricing`  string , `no_show_fee`  string , `allow_self_cancellations`  string , `cancellation_fee`  string , `application_fee`  string , `bdrd`  string , `max_pending_waitlist_entries`  string , `max_active_members`  string , `free_accessories`  string , `description`  string , `terms`  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_tiers/2026-04-03/1775211032'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclub_tiers"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsclub_tiers/2026-04-03/1775211032
id: 1701206
processed: 1

raw_data:

{
    "allow_self_cancellations": 18,
    "application_fee": 20,
    "bdrd": 21,
    "cancellation_fee": 19,
    "created_at": 28,
    "credits_per_period": 13,
    "description": 25,
    "free_accessories": 24,
    "frontend_display": 4,
    "frontend_display_pricing": 16,
    "frontend_name": 5,
    "frontend_position": 6,
    "hours_per_credit": 14,
    "id": 1,
    "location_id": 2,
    "max_active_members": 23,
    "max_pending_waitlist_entries": 22,
    "no_show_fee": 17,
    "period_fee": 15,
    "period_length": 11,
    "period_length_type": 12,
    "status": 27,
    "tenant": 0,
    "term_auto_renew": 9,
    "term_fee": 10,
    "term_length": 7,
    "term_length_type": 8,
    "terms": 26,
    "tier_name": 3,
    "updated_at": 29
}

schema_attributes:

{
    "allow_self_cancellations": "string",
    "application_fee": "string",
    "bdrd": "string",
    "cancellation_fee": "string",
    "created_at": "string",
    "credits_per_period": "string",
    "description": "string",
    "free_accessories": "string",
    "frontend_display": "string",
    "frontend_display_pricing": "string",
    "frontend_name": "string",
    "frontend_position": "string",
    "hours_per_credit": "string",
    "id": "string",
    "location_id": "string",
    "max_active_members": "string",
    "max_pending_waitlist_entries": "string",
    "no_show_fee": "string",
    "period_fee": "string",
    "period_length": "string",
    "period_length_type": "string",
    "status": "string",
    "tenant": "string",
    "term_auto_renew": "string",
    "term_fee": "string",
    "term_length": "string",
    "term_length_type": "string",
    "terms": "string",
    "tier_name": "string",
    "updated_at": "string"
}

schema_name_id: 1452
schema_scan_id: 161404804
updated: 2026-04-03 05:11:47

Schema Scans: 15

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

Scan 162169311

duration: 0:00:12.333281

exit_message:

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

id: 162169311

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_tiers/2026-04-17/1776419649",
        "key": "raw/stellar_imsclub_tiers/2026-04-17/1776419649/club_tiers.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsclub_tiers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12698797289514498259,
        "service_name": "drive-thru",
        "span_id": 2307482543868021661,
        "trace_id": 671053228434799869
    }
}

running: False
schema_name_id: 1452
start_time: 2026-04-17 04:57:03
success: True
trace_id: 671053228434799869

Scan 162114406

duration: 0:00:12.458277

exit_message:

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

id: 162114406

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_tiers/2026-04-16/1776334545",
        "key": "raw/stellar_imsclub_tiers/2026-04-16/1776334545/club_tiers.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsclub_tiers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8007056718919167384,
        "service_name": "drive-thru",
        "span_id": 5260397950228090612,
        "trace_id": 15758029657366813307
    }
}

running: False
schema_name_id: 1452
start_time: 2026-04-16 05:17:38
success: True
trace_id: 15758029657366813307

Scan 162056346

duration: 0:00:12.481322

exit_message:

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

id: 162056346

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_tiers/2026-04-15/1776242358",
        "key": "raw/stellar_imsclub_tiers/2026-04-15/1776242358/club_tiers.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsclub_tiers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18114488660288822890,
        "service_name": "drive-thru",
        "span_id": 12069141686653215341,
        "trace_id": 15439000227879837398
    }
}

running: False
schema_name_id: 1452
start_time: 2026-04-15 03:40:17
success: True
trace_id: 15439000227879837398

Scan 162002980

duration: 0:00:12.469315

exit_message:

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

id: 162002980

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_tiers/2026-04-14/1776160757",
        "key": "raw/stellar_imsclub_tiers/2026-04-14/1776160757/club_tiers.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsclub_tiers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15516158602484392973,
        "service_name": "drive-thru",
        "span_id": 15576709572112519912,
        "trace_id": 6277597359917621868
    }
}

running: False
schema_name_id: 1452
start_time: 2026-04-14 05:01:26
success: True
trace_id: 6277597359917621868

Scan 161945279

duration: 0:00:12.375099

exit_message:

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

id: 161945279

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_tiers/2026-04-13/1776074799",
        "key": "raw/stellar_imsclub_tiers/2026-04-13/1776074799/club_tiers.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsclub_tiers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 410242659398080968,
        "service_name": "drive-thru",
        "span_id": 3244335519925904397,
        "trace_id": 14952359221382268401
    }
}

running: False
schema_name_id: 1452
start_time: 2026-04-13 05:07:17
success: True
trace_id: 14952359221382268401

Scan 161896329

duration: 0:00:14.788484

exit_message:

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

id: 161896329

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_tiers/2026-04-12/1775988156",
        "key": "raw/stellar_imsclub_tiers/2026-04-12/1775988156/club_tiers.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsclub_tiers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3484668937501371899,
        "service_name": "drive-thru",
        "span_id": 9213079541381004882,
        "trace_id": 3891928168426925755
    }
}

running: False
schema_name_id: 1452
start_time: 2026-04-12 05:03:39
success: True
trace_id: 3891928168426925755

Scan 161843967

duration: 0:00:14.946377

exit_message:

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

id: 161843967

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_tiers/2026-04-11/1775902576",
        "key": "raw/stellar_imsclub_tiers/2026-04-11/1775902576/club_tiers.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsclub_tiers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17583949550620148219,
        "service_name": "drive-thru",
        "span_id": 8866177051272963810,
        "trace_id": 5468735895144698276
    }
}

running: False
schema_name_id: 1452
start_time: 2026-04-11 05:19:14
success: True
trace_id: 5468735895144698276

Scan 161788588

duration: 0:00:12.296201

exit_message:

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

id: 161788588

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_tiers/2026-04-10/1775815217",
        "key": "raw/stellar_imsclub_tiers/2026-04-10/1775815217/club_tiers.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsclub_tiers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3620238171058918590,
        "service_name": "drive-thru",
        "span_id": 7190928815793619455,
        "trace_id": 5443922740671797372
    }
}

running: False
schema_name_id: 1452
start_time: 2026-04-10 05:02:15
success: True
trace_id: 5443922740671797372

Scan 161733009

duration: 0:00:15.075906

exit_message:

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

id: 161733009

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_tiers/2026-04-09/1775728838",
        "key": "raw/stellar_imsclub_tiers/2026-04-09/1775728838/club_tiers.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsclub_tiers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12940915760127745490,
        "service_name": "drive-thru",
        "span_id": 6488105420385151012,
        "trace_id": 10241420190056042025
    }
}

running: False
schema_name_id: 1452
start_time: 2026-04-09 05:04:05
success: True
trace_id: 10241420190056042025

Scan 161678387

duration: 0:00:15.034708

exit_message:

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

id: 161678387

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_tiers/2026-04-08/1775643001",
        "key": "raw/stellar_imsclub_tiers/2026-04-08/1775643001/club_tiers.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsclub_tiers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10542383254689838458,
        "service_name": "drive-thru",
        "span_id": 10431578715915711885,
        "trace_id": 18004559179260222603
    }
}

running: False
schema_name_id: 1452
start_time: 2026-04-08 05:13:49
success: True
trace_id: 18004559179260222603

Scan 161622133

duration: 0:00:14.894853

exit_message:

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

id: 161622133

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_tiers/2026-04-07/1775556857",
        "key": "raw/stellar_imsclub_tiers/2026-04-07/1775556857/club_tiers.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsclub_tiers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17027322252726286731,
        "service_name": "drive-thru",
        "span_id": 8528521271016192509,
        "trace_id": 3374438126832521716
    }
}

running: False
schema_name_id: 1452
start_time: 2026-04-07 05:17:34
success: True
trace_id: 3374438126832521716

Scan 161564272

duration: 0:00:12.401474

exit_message:

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

id: 161564272

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_tiers/2026-04-06/1775470528",
        "key": "raw/stellar_imsclub_tiers/2026-04-06/1775470528/club_tiers.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsclub_tiers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8968037867072480565,
        "service_name": "drive-thru",
        "span_id": 14509942328433084096,
        "trace_id": 18095974705389824714
    }
}

running: False
schema_name_id: 1452
start_time: 2026-04-06 05:17:48
success: True
trace_id: 18095974705389824714

Scan 161516583

duration: 0:00:14.879351

exit_message:

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

id: 161516583

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_tiers/2026-04-05/1775382945",
        "key": "raw/stellar_imsclub_tiers/2026-04-05/1775382945/club_tiers.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsclub_tiers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3418336873992323897,
        "service_name": "drive-thru",
        "span_id": 576654255543415120,
        "trace_id": 13378224955095004529
    }
}

running: False
schema_name_id: 1452
start_time: 2026-04-05 04:58:11
success: True
trace_id: 13378224955095004529

Scan 161462132

duration: 0:00:14.858801

exit_message:

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

id: 161462132

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_tiers/2026-04-04/1775296469",
        "key": "raw/stellar_imsclub_tiers/2026-04-04/1775296469/club_tiers.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsclub_tiers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12509951030232819319,
        "service_name": "drive-thru",
        "span_id": 8076076388414295442,
        "trace_id": 4123476167541468522
    }
}

running: False
schema_name_id: 1452
start_time: 2026-04-04 04:56:34
success: True
trace_id: 4123476167541468522

Scan 161404804

duration: 0:00:15.053847

exit_message:

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

id: 161404804

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_tiers/2026-04-03/1775211032",
        "key": "raw/stellar_imsclub_tiers/2026-04-03/1775211032/club_tiers.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsclub_tiers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6836716202130711996,
        "service_name": "drive-thru",
        "span_id": 16456712832624842740,
        "trace_id": 11315419530565824752
    }
}

running: False
schema_name_id: 1452
start_time: 2026-04-03 05:11:32
success: True
trace_id: 11315419530565824752

Partitions:

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

Schema:

attributes:

{
    "allow_self_cancellations": "string",
    "application_fee": "string",
    "bdrd": "string",
    "cancellation_fee": "string",
    "created_at": "string",
    "credits_per_period": "string",
    "description": "string",
    "free_accessories": "string",
    "frontend_display": "string",
    "frontend_display_pricing": "string",
    "frontend_name": "string",
    "frontend_position": "string",
    "hours_per_credit": "string",
    "id": "string",
    "location_id": "string",
    "max_active_members": "string",
    "max_pending_waitlist_entries": "string",
    "no_show_fee": "string",
    "period_fee": "string",
    "period_length": "string",
    "period_length_type": "string",
    "status": "string",
    "tenant": "string",
    "term_auto_renew": "string",
    "term_fee": "string",
    "term_length": "string",
    "term_length_type": "string",
    "terms": "string",
    "tier_name": "string",
    "updated_at": "string"
}

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

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_tiers`\n(\n `tenant`  string , `id`  string , `location_id`  string , `tier_name`  string , `frontend_display`  string , `frontend_name`  string , `frontend_position`  string , `term_length`  string , `term_length_type`  string , `term_auto_renew`  string , `term_fee`  string , `period_length`  string , `period_length_type`  string , `credits_per_period`  string , `hours_per_credit`  string , `period_fee`  string , `frontend_display_pricing`  string , `no_show_fee`  string , `allow_self_cancellations`  string , `cancellation_fee`  string , `application_fee`  string , `bdrd`  string , `max_pending_waitlist_entries`  string , `max_active_members`  string , `free_accessories`  string , `description`  string , `terms`  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_tiers/2026-04-17/1776419649'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclub_tiers`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclub_tiers"
}

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:46:11",
        "disabled": false,
        "format": "raw",
        "id": 1452,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "stellar_imsclub_tiers"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "allow_self_cancellations": "string",
            "application_fee": "string",
            "bdrd": "string",
            "cancellation_fee": "string",
            "created_at": "string",
            "credits_per_period": "string",
            "description": "string",
            "free_accessories": "string",
            "frontend_display": "string",
            "frontend_display_pricing": "string",
            "frontend_name": "string",
            "frontend_position": "string",
            "hours_per_credit": "string",
            "id": "string",
            "location_id": "string",
            "max_active_members": "string",
            "max_pending_waitlist_entries": "string",
            "no_show_fee": "string",
            "period_fee": "string",
            "period_length": "string",
            "period_length_type": "string",
            "status": "string",
            "tenant": "string",
            "term_auto_renew": "string",
            "term_fee": "string",
            "term_length": "string",
            "term_length_type": "string",
            "terms": "string",
            "tier_name": "string",
            "updated_at": "string"
        },
        "created": "2026-04-17 04:57:05",
        "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_tiers`\n(\n `tenant`  string , `id`  string , `location_id`  string , `tier_name`  string , `frontend_display`  string , `frontend_name`  string , `frontend_position`  string , `term_length`  string , `term_length_type`  string , `term_auto_renew`  string , `term_fee`  string , `period_length`  string , `period_length_type`  string , `credits_per_period`  string , `hours_per_credit`  string , `period_fee`  string , `frontend_display_pricing`  string , `no_show_fee`  string , `allow_self_cancellations`  string , `cancellation_fee`  string , `application_fee`  string , `bdrd`  string , `max_pending_waitlist_entries`  string , `max_active_members`  string , `free_accessories`  string , `description`  string , `terms`  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_tiers/2026-04-17/1776419649'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclub_tiers`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclub_tiers"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}