Schema Info
Schema Name: sfdl_prod_drivethru.stellar_imsclub_restriction_club_tiers
- created: 2023-02-07 01:47:04
- disabled: False
- format: raw
- id: 1471
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_prod_drivethru", "table": "stellar_imsclub_restriction_club_tiers" } - type: drivethrucsv
Schema Versions: 15
-
Version 1717969
- created: 2026-04-17 04:56:58
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclub_restriction_club_tiers`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclub_restriction_club_tiers`\n(\n `tenant` string , `club_restriction_id` string , `club_tier_id` 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_restriction_club_tiers/2026-04-17/1776419646'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclub_restriction_club_tiers" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsclub_restriction_club_tiers/2026-04-17/1776419646
- id: 1717969
- processed: 1
- raw_data:
{ "club_restriction_id": 1, "club_tier_id": 2, "tenant": 0 } - schema_attributes:
{ "club_restriction_id": "string", "club_tier_id": "string", "tenant": "string" } - schema_name_id: 1471
- schema_scan_id: 162169307
- updated: 2026-04-17 04:57:09
-
Version 1716718
- created: 2026-04-16 05:16:57
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclub_restriction_club_tiers`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclub_restriction_club_tiers`\n(\n `tenant` string , `club_restriction_id` string , `club_tier_id` 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_restriction_club_tiers/2026-04-16/1776334546'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclub_restriction_club_tiers" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsclub_restriction_club_tiers/2026-04-16/1776334546
- id: 1716718
- processed: 1
- raw_data:
{ "club_restriction_id": 1, "club_tier_id": 2, "tenant": 0 } - schema_attributes:
{ "club_restriction_id": "string", "club_tier_id": "string", "tenant": "string" } - schema_name_id: 1471
- schema_scan_id: 162114387
- updated: 2026-04-16 05:17:08
-
Version 1715466
- created: 2026-04-15 03:40:23
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclub_restriction_club_tiers`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclub_restriction_club_tiers`\n(\n `tenant` string , `club_restriction_id` string , `club_tier_id` 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_restriction_club_tiers/2026-04-15/1776242358'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclub_restriction_club_tiers" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsclub_restriction_club_tiers/2026-04-15/1776242358
- id: 1715466
- processed: 1
- raw_data:
{ "club_restriction_id": 1, "club_tier_id": 2, "tenant": 0 } - schema_attributes:
{ "club_restriction_id": "string", "club_tier_id": "string", "tenant": "string" } - schema_name_id: 1471
- schema_scan_id: 162056349
- updated: 2026-04-15 03:40:34
-
Version 1714310
- created: 2026-04-14 05:00:46
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclub_restriction_club_tiers`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclub_restriction_club_tiers`\n(\n `tenant` string , `club_restriction_id` string , `club_tier_id` 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_restriction_club_tiers/2026-04-14/1776160756'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclub_restriction_club_tiers" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsclub_restriction_club_tiers/2026-04-14/1776160756
- id: 1714310
- processed: 1
- raw_data:
{ "club_restriction_id": 1, "club_tier_id": 2, "tenant": 0 } - schema_attributes:
{ "club_restriction_id": "string", "club_tier_id": "string", "tenant": "string" } - schema_name_id: 1471
- schema_scan_id: 162002944
- updated: 2026-04-14 05:00:57
-
Version 1713129
- created: 2026-04-13 05:09:20
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclub_restriction_club_tiers`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclub_restriction_club_tiers`\n(\n `tenant` string , `club_restriction_id` string , `club_tier_id` 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_restriction_club_tiers/2026-04-13/1776074799'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclub_restriction_club_tiers" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsclub_restriction_club_tiers/2026-04-13/1776074799
- id: 1713129
- processed: 1
- raw_data:
{ "club_restriction_id": 1, "club_tier_id": 2, "tenant": 0 } - schema_attributes:
{ "club_restriction_id": "string", "club_tier_id": "string", "tenant": "string" } - schema_name_id: 1471
- schema_scan_id: 161945335
- updated: 2026-04-13 05:09:34
-
Version 1711888
- created: 2026-04-12 05:03:31
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclub_restriction_club_tiers`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclub_restriction_club_tiers`\n(\n `tenant` string , `club_restriction_id` string , `club_tier_id` 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_restriction_club_tiers/2026-04-12/1775988155'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclub_restriction_club_tiers" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsclub_restriction_club_tiers/2026-04-12/1775988155
- id: 1711888
- processed: 1
- raw_data:
{ "club_restriction_id": 1, "club_tier_id": 2, "tenant": 0 } - schema_attributes:
{ "club_restriction_id": "string", "club_tier_id": "string", "tenant": "string" } - schema_name_id: 1471
- schema_scan_id: 161896325
- updated: 2026-04-12 05:03:43
-
Version 1710672
- created: 2026-04-11 05:16:19
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclub_restriction_club_tiers`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclub_restriction_club_tiers`\n(\n `tenant` string , `club_restriction_id` string , `club_tier_id` 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_restriction_club_tiers/2026-04-11/1775902573'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclub_restriction_club_tiers" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsclub_restriction_club_tiers/2026-04-11/1775902573
- id: 1710672
- processed: 1
- raw_data:
{ "club_restriction_id": 1, "club_tier_id": 2, "tenant": 0 } - schema_attributes:
{ "club_restriction_id": "string", "club_tier_id": "string", "tenant": "string" } - schema_name_id: 1471
- schema_scan_id: 161843890
- updated: 2026-04-11 05:16:31
-
Version 1709507
- created: 2026-04-10 05:00:42
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclub_restriction_club_tiers`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclub_restriction_club_tiers`\n(\n `tenant` string , `club_restriction_id` string , `club_tier_id` 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_restriction_club_tiers/2026-04-10/1775815216'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclub_restriction_club_tiers" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsclub_restriction_club_tiers/2026-04-10/1775815216
- id: 1709507
- processed: 1
- raw_data:
{ "club_restriction_id": 1, "club_tier_id": 2, "tenant": 0 } - schema_attributes:
{ "club_restriction_id": "string", "club_tier_id": "string", "tenant": "string" } - schema_name_id: 1471
- schema_scan_id: 161788542
- updated: 2026-04-10 05:00:53
-
Version 1708387
- created: 2026-04-09 05:01:53
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclub_restriction_club_tiers`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclub_restriction_club_tiers`\n(\n `tenant` string , `club_restriction_id` string , `club_tier_id` 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_restriction_club_tiers/2026-04-09/1775728838'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclub_restriction_club_tiers" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsclub_restriction_club_tiers/2026-04-09/1775728838
- id: 1708387
- processed: 1
- raw_data:
{ "club_restriction_id": 1, "club_tier_id": 2, "tenant": 0 } - schema_attributes:
{ "club_restriction_id": "string", "club_tier_id": "string", "tenant": "string" } - schema_name_id: 1471
- schema_scan_id: 161732944
- updated: 2026-04-09 05:02:04
-
Version 1707244
- created: 2026-04-08 05:14:33
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclub_restriction_club_tiers`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclub_restriction_club_tiers`\n(\n `tenant` string , `club_restriction_id` string , `club_tier_id` 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_restriction_club_tiers/2026-04-08/1775643000'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclub_restriction_club_tiers" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsclub_restriction_club_tiers/2026-04-08/1775643000
- id: 1707244
- processed: 1
- raw_data:
{ "club_restriction_id": 1, "club_tier_id": 2, "tenant": 0 } - schema_attributes:
{ "club_restriction_id": "string", "club_tier_id": "string", "tenant": "string" } - schema_name_id: 1471
- schema_scan_id: 161678403
- updated: 2026-04-08 05:14:47
-
Version 1706005
- created: 2026-04-07 05:15:44
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclub_restriction_club_tiers`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclub_restriction_club_tiers`\n(\n `tenant` string , `club_restriction_id` string , `club_tier_id` 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_restriction_club_tiers/2026-04-07/1775556856'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclub_restriction_club_tiers" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsclub_restriction_club_tiers/2026-04-07/1775556856
- id: 1706005
- processed: 1
- raw_data:
{ "club_restriction_id": 1, "club_tier_id": 2, "tenant": 0 } - schema_attributes:
{ "club_restriction_id": "string", "club_tier_id": "string", "tenant": "string" } - schema_name_id: 1471
- schema_scan_id: 161622083
- updated: 2026-04-07 05:15:57
-
Version 1704786
- created: 2026-04-06 05:17:19
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclub_restriction_club_tiers`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclub_restriction_club_tiers`\n(\n `tenant` string , `club_restriction_id` string , `club_tier_id` 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_restriction_club_tiers/2026-04-06/1775470527'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclub_restriction_club_tiers" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsclub_restriction_club_tiers/2026-04-06/1775470527
- id: 1704786
- processed: 1
- raw_data:
{ "club_restriction_id": 1, "club_tier_id": 2, "tenant": 0 } - schema_attributes:
{ "club_restriction_id": "string", "club_tier_id": "string", "tenant": "string" } - schema_name_id: 1471
- schema_scan_id: 161564257
- updated: 2026-04-06 05:17:32
-
Version 1703592
- created: 2026-04-05 04:58:25
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclub_restriction_club_tiers`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclub_restriction_club_tiers`\n(\n `tenant` string , `club_restriction_id` string , `club_tier_id` 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_restriction_club_tiers/2026-04-05/1775382944'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclub_restriction_club_tiers" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsclub_restriction_club_tiers/2026-04-05/1775382944
- id: 1703592
- processed: 1
- raw_data:
{ "club_restriction_id": 1, "club_tier_id": 2, "tenant": 0 } - schema_attributes:
{ "club_restriction_id": "string", "club_tier_id": "string", "tenant": "string" } - schema_name_id: 1471
- schema_scan_id: 161516586
- updated: 2026-04-05 04:58:41
-
Version 1702440
- created: 2026-04-04 04:56:55
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclub_restriction_club_tiers`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclub_restriction_club_tiers`\n(\n `tenant` string , `club_restriction_id` string , `club_tier_id` 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_restriction_club_tiers/2026-04-04/1775296469'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclub_restriction_club_tiers" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsclub_restriction_club_tiers/2026-04-04/1775296469
- id: 1702440
- processed: 1
- raw_data:
{ "club_restriction_id": 1, "club_tier_id": 2, "tenant": 0 } - schema_attributes:
{ "club_restriction_id": "string", "club_tier_id": "string", "tenant": "string" } - schema_name_id: 1471
- schema_scan_id: 161462141
- updated: 2026-04-04 04:57:09
-
Version 1701231
- created: 2026-04-03 05:12:32
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclub_restriction_club_tiers`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclub_restriction_club_tiers`\n(\n `tenant` string , `club_restriction_id` string , `club_tier_id` 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_restriction_club_tiers/2026-04-03/1775211034'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclub_restriction_club_tiers" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsclub_restriction_club_tiers/2026-04-03/1775211034
- id: 1701231
- processed: 1
- raw_data:
{ "club_restriction_id": 1, "club_tier_id": 2, "tenant": 0 } - schema_attributes:
{ "club_restriction_id": "string", "club_tier_id": "string", "tenant": "string" } - schema_name_id: 1471
- schema_scan_id: 161404830
- updated: 2026-04-03 05:12:43
Schema Scans: 15
Last at 2026-04-17 04:56:58
-
Scan 162169307
- duration: 0:00:11.520213
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162169307
- 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_restriction_club_tiers/2026-04-17/1776419646", "key": "raw/stellar_imsclub_restriction_club_tiers/2026-04-17/1776419646/club_restriction_club_tiers.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsclub_restriction_club_tiers", "type": "drivethrucsv" }, "trace_context": { "parent_id": 632362266143668088, "service_name": "drive-thru", "span_id": 3845714604731007272, "trace_id": 13512344190919228525 } } - running: False
- schema_name_id: 1471
- start_time: 2026-04-17 04:56:58
- success: True
- trace_id: 13512344190919228525
-
Scan 162114387
- duration: 0:00:11.814470
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162114387
- 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_restriction_club_tiers/2026-04-16/1776334546", "key": "raw/stellar_imsclub_restriction_club_tiers/2026-04-16/1776334546/club_restriction_club_tiers.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsclub_restriction_club_tiers", "type": "drivethrucsv" }, "trace_context": { "parent_id": 10580738725218373631, "service_name": "drive-thru", "span_id": 14530294726590601255, "trace_id": 17858142993410128253 } } - running: False
- schema_name_id: 1471
- start_time: 2026-04-16 05:16:57
- success: True
- trace_id: 17858142993410128253
-
Scan 162056349
- duration: 0:00:11.594064
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162056349
- 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_restriction_club_tiers/2026-04-15/1776242358", "key": "raw/stellar_imsclub_restriction_club_tiers/2026-04-15/1776242358/club_restriction_club_tiers.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsclub_restriction_club_tiers", "type": "drivethrucsv" }, "trace_context": { "parent_id": 9703498292793238511, "service_name": "drive-thru", "span_id": 17282719509896461494, "trace_id": 2048178557616219341 } } - running: False
- schema_name_id: 1471
- start_time: 2026-04-15 03:40:22
- success: True
- trace_id: 2048178557616219341
-
Scan 162002944
- duration: 0:00:11.490340
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162002944
- 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_restriction_club_tiers/2026-04-14/1776160756", "key": "raw/stellar_imsclub_restriction_club_tiers/2026-04-14/1776160756/club_restriction_club_tiers.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsclub_restriction_club_tiers", "type": "drivethrucsv" }, "trace_context": { "parent_id": 3348060697145995132, "service_name": "drive-thru", "span_id": 5997458818240069530, "trace_id": 2959569824226106606 } } - running: False
- schema_name_id: 1471
- start_time: 2026-04-14 05:00:46
- success: True
- trace_id: 2959569824226106606
-
Scan 161945335
- duration: 0:00:14.286713
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161945335
- 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_restriction_club_tiers/2026-04-13/1776074799", "key": "raw/stellar_imsclub_restriction_club_tiers/2026-04-13/1776074799/club_restriction_club_tiers.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsclub_restriction_club_tiers", "type": "drivethrucsv" }, "trace_context": { "parent_id": 1628739153602921035, "service_name": "drive-thru", "span_id": 9571062649204947526, "trace_id": 13934261959797731042 } } - running: False
- schema_name_id: 1471
- start_time: 2026-04-13 05:09:20
- success: True
- trace_id: 13934261959797731042
-
Scan 161896325
- duration: 0:00:11.501736
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161896325
- 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_restriction_club_tiers/2026-04-12/1775988155", "key": "raw/stellar_imsclub_restriction_club_tiers/2026-04-12/1775988155/club_restriction_club_tiers.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsclub_restriction_club_tiers", "type": "drivethrucsv" }, "trace_context": { "parent_id": 16223560343815201460, "service_name": "drive-thru", "span_id": 12753654455678053273, "trace_id": 15910225361686884126 } } - running: False
- schema_name_id: 1471
- start_time: 2026-04-12 05:03:31
- success: True
- trace_id: 15910225361686884126
-
Scan 161843890
- duration: 0:00:11.589370
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161843890
- 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_restriction_club_tiers/2026-04-11/1775902573", "key": "raw/stellar_imsclub_restriction_club_tiers/2026-04-11/1775902573/club_restriction_club_tiers.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsclub_restriction_club_tiers", "type": "drivethrucsv" }, "trace_context": { "parent_id": 1200667217759540375, "service_name": "drive-thru", "span_id": 6899029488909772592, "trace_id": 2857633529671736367 } } - running: False
- schema_name_id: 1471
- start_time: 2026-04-11 05:16:19
- success: True
- trace_id: 2857633529671736367
-
Scan 161788542
- duration: 0:00:11.575101
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161788542
- 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_restriction_club_tiers/2026-04-10/1775815216", "key": "raw/stellar_imsclub_restriction_club_tiers/2026-04-10/1775815216/club_restriction_club_tiers.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsclub_restriction_club_tiers", "type": "drivethrucsv" }, "trace_context": { "parent_id": 15281764180642264131, "service_name": "drive-thru", "span_id": 8129468973784534342, "trace_id": 12724094265891455132 } } - running: False
- schema_name_id: 1471
- start_time: 2026-04-10 05:00:42
- success: True
- trace_id: 12724094265891455132
-
Scan 161732944
- duration: 0:00:11.467381
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161732944
- 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_restriction_club_tiers/2026-04-09/1775728838", "key": "raw/stellar_imsclub_restriction_club_tiers/2026-04-09/1775728838/club_restriction_club_tiers.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsclub_restriction_club_tiers", "type": "drivethrucsv" }, "trace_context": { "parent_id": 11622315550923850187, "service_name": "drive-thru", "span_id": 7333154034566834790, "trace_id": 2839177852322963364 } } - running: False
- schema_name_id: 1471
- start_time: 2026-04-09 05:01:53
- success: True
- trace_id: 2839177852322963364
-
Scan 161678403
- duration: 0:00:14.014560
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161678403
- 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_restriction_club_tiers/2026-04-08/1775643000", "key": "raw/stellar_imsclub_restriction_club_tiers/2026-04-08/1775643000/club_restriction_club_tiers.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsclub_restriction_club_tiers", "type": "drivethrucsv" }, "trace_context": { "parent_id": 18183745899229596351, "service_name": "drive-thru", "span_id": 3790834280813938510, "trace_id": 11291765912781318695 } } - running: False
- schema_name_id: 1471
- start_time: 2026-04-08 05:14:33
- success: True
- trace_id: 11291765912781318695
-
Scan 161622083
- duration: 0:00:14.115893
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161622083
- 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_restriction_club_tiers/2026-04-07/1775556856", "key": "raw/stellar_imsclub_restriction_club_tiers/2026-04-07/1775556856/club_restriction_club_tiers.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsclub_restriction_club_tiers", "type": "drivethrucsv" }, "trace_context": { "parent_id": 6663465560288086582, "service_name": "drive-thru", "span_id": 11381946233016612709, "trace_id": 2560420441607005658 } } - running: False
- schema_name_id: 1471
- start_time: 2026-04-07 05:15:43
- success: True
- trace_id: 2560420441607005658
-
Scan 161564257
- duration: 0:00:13.973934
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161564257
- 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_restriction_club_tiers/2026-04-06/1775470527", "key": "raw/stellar_imsclub_restriction_club_tiers/2026-04-06/1775470527/club_restriction_club_tiers.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsclub_restriction_club_tiers", "type": "drivethrucsv" }, "trace_context": { "parent_id": 13538377723053716257, "service_name": "drive-thru", "span_id": 11333699681462160903, "trace_id": 3193514901456257190 } } - running: False
- schema_name_id: 1471
- start_time: 2026-04-06 05:17:18
- success: True
- trace_id: 3193514901456257190
-
Scan 161516586
- duration: 0:00:26.276512
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161516586
- 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_restriction_club_tiers/2026-04-05/1775382944", "key": "raw/stellar_imsclub_restriction_club_tiers/2026-04-05/1775382944/club_restriction_club_tiers.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsclub_restriction_club_tiers", "type": "drivethrucsv" }, "trace_context": { "parent_id": 3114145679508844781, "service_name": "drive-thru", "span_id": 5172472719328500003, "trace_id": 2949492077868462238 } } - running: False
- schema_name_id: 1471
- start_time: 2026-04-05 04:58:14
- success: True
- trace_id: 2949492077868462238
-
Scan 161462141
- duration: 0:00:14.037714
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161462141
- 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_restriction_club_tiers/2026-04-04/1775296469", "key": "raw/stellar_imsclub_restriction_club_tiers/2026-04-04/1775296469/club_restriction_club_tiers.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsclub_restriction_club_tiers", "type": "drivethrucsv" }, "trace_context": { "parent_id": 8302379292882151659, "service_name": "drive-thru", "span_id": 3128464768748966674, "trace_id": 14880913978370185961 } } - running: False
- schema_name_id: 1471
- start_time: 2026-04-04 04:56:55
- success: True
- trace_id: 14880913978370185961
-
Scan 161404830
- duration: 0:00:11.631871
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161404830
- 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_restriction_club_tiers/2026-04-03/1775211034", "key": "raw/stellar_imsclub_restriction_club_tiers/2026-04-03/1775211034/club_restriction_club_tiers.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsclub_restriction_club_tiers", "type": "drivethrucsv" }, "trace_context": { "parent_id": 12299092224510203144, "service_name": "drive-thru", "span_id": 16070074851847837897, "trace_id": 11376567942724872288 } } - running: False
- schema_name_id: 1471
- start_time: 2026-04-03 05:12:31
- success: True
- trace_id: 11376567942724872288
- attributes:
{ "club_restriction_id": "string", "club_tier_id": "string", "tenant": "string" } - created: 2026-04-17 04:56:58
- 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_restriction_club_tiers`\n(\n `tenant` string , `club_restriction_id` string , `club_tier_id` 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_restriction_club_tiers/2026-04-17/1776419646'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclub_restriction_club_tiers`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclub_restriction_club_tiers" }
- hostname: schemamanager-5475496c57-7dpqb
- name: schema_manager
- process_start: 2026-01-09 11:27:47
- sf_env: prod
- version: 2112174301
{
"name": {
"created": "2023-02-07 01:47:04",
"disabled": false,
"format": "raw",
"id": 1471,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_prod_drivethru",
"table": "stellar_imsclub_restriction_club_tiers"
},
"type": "drivethrucsv"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"club_restriction_id": "string",
"club_tier_id": "string",
"tenant": "string"
},
"created": "2026-04-17 04:56:58",
"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_restriction_club_tiers`\n(\n `tenant` string , `club_restriction_id` string , `club_tier_id` 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_restriction_club_tiers/2026-04-17/1776419646'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclub_restriction_club_tiers`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclub_restriction_club_tiers"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}