Schema Info

Schema Name: sfdl_prod_drivethru.stellar_imsclub_restriction_seasons

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717913

created: 2026-04-17 04:54:27

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclub_restriction_seasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclub_restriction_seasons`\n(\n `tenant`  string , `club_restriction_id`  string , `season_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_seasons/2026-04-17/1776419647'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclub_restriction_seasons"
]

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

raw_data:

{
    "club_restriction_id": 1,
    "season_id": 2,
    "tenant": 0
}

schema_attributes:

{
    "club_restriction_id": "string",
    "season_id": "string",
    "tenant": "string"
}

schema_name_id: 1462
schema_scan_id: 162169249
updated: 2026-04-17 04:54:41

Version 1716775

created: 2026-04-16 05:19:08

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclub_restriction_seasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclub_restriction_seasons`\n(\n `tenant`  string , `club_restriction_id`  string , `season_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_seasons/2026-04-16/1776334545'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclub_restriction_seasons"
]

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

raw_data:

{
    "club_restriction_id": 1,
    "season_id": 2,
    "tenant": 0
}

schema_attributes:

{
    "club_restriction_id": "string",
    "season_id": "string",
    "tenant": "string"
}

schema_name_id: 1462
schema_scan_id: 162114446
updated: 2026-04-16 05:19:22

Version 1715462

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclub_restriction_seasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclub_restriction_seasons`\n(\n `tenant`  string , `club_restriction_id`  string , `season_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_seasons/2026-04-15/1776242358'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclub_restriction_seasons"
]

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

raw_data:

{
    "club_restriction_id": 1,
    "season_id": 2,
    "tenant": 0
}

schema_attributes:

{
    "club_restriction_id": "string",
    "season_id": "string",
    "tenant": "string"
}

schema_name_id: 1462
schema_scan_id: 162056345
updated: 2026-04-15 03:40:30

Version 1714401

created: 2026-04-14 05:04:49

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclub_restriction_seasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclub_restriction_seasons`\n(\n `tenant`  string , `club_restriction_id`  string , `season_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_seasons/2026-04-14/1776160757'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclub_restriction_seasons"
]

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

raw_data:

{
    "club_restriction_id": 1,
    "season_id": 2,
    "tenant": 0
}

schema_attributes:

{
    "club_restriction_id": "string",
    "season_id": "string",
    "tenant": "string"
}

schema_name_id: 1462
schema_scan_id: 162003135
updated: 2026-04-14 05:05:00

Version 1713124

created: 2026-04-13 05:09:09

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclub_restriction_seasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclub_restriction_seasons`\n(\n `tenant`  string , `club_restriction_id`  string , `season_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_seasons/2026-04-13/1776074799'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclub_restriction_seasons"
]

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

raw_data:

{
    "club_restriction_id": 1,
    "season_id": 2,
    "tenant": 0
}

schema_attributes:

{
    "club_restriction_id": "string",
    "season_id": "string",
    "tenant": "string"
}

schema_name_id: 1462
schema_scan_id: 161945330
updated: 2026-04-13 05:09:21

Version 1711897

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclub_restriction_seasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclub_restriction_seasons`\n(\n `tenant`  string , `club_restriction_id`  string , `season_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_seasons/2026-04-12/1775988156'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclub_restriction_seasons"
]

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

raw_data:

{
    "club_restriction_id": 1,
    "season_id": 2,
    "tenant": 0
}

schema_attributes:

{
    "club_restriction_id": "string",
    "season_id": "string",
    "tenant": "string"
}

schema_name_id: 1462
schema_scan_id: 161896339
updated: 2026-04-12 05:04:17

Version 1710740

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclub_restriction_seasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclub_restriction_seasons`\n(\n `tenant`  string , `club_restriction_id`  string , `season_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_seasons/2026-04-11/1775902575'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclub_restriction_seasons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsclub_restriction_seasons/2026-04-11/1775902575
id: 1710740
processed: 1

raw_data:

{
    "club_restriction_id": 1,
    "season_id": 2,
    "tenant": 0
}

schema_attributes:

{
    "club_restriction_id": "string",
    "season_id": "string",
    "tenant": "string"
}

schema_name_id: 1462
schema_scan_id: 161843959
updated: 2026-04-11 05:19:10

Version 1709529

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclub_restriction_seasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclub_restriction_seasons`\n(\n `tenant`  string , `club_restriction_id`  string , `season_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_seasons/2026-04-10/1775815218'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclub_restriction_seasons"
]

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

raw_data:

{
    "club_restriction_id": 1,
    "season_id": 2,
    "tenant": 0
}

schema_attributes:

{
    "club_restriction_id": "string",
    "season_id": "string",
    "tenant": "string"
}

schema_name_id: 1462
schema_scan_id: 161788568
updated: 2026-04-10 05:01:47

Version 1708360

created: 2026-04-09 05:00:48

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclub_restriction_seasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclub_restriction_seasons`\n(\n `tenant`  string , `club_restriction_id`  string , `season_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_seasons/2026-04-09/1775728837'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclub_restriction_seasons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsclub_restriction_seasons/2026-04-09/1775728837
id: 1708360
processed: 1

raw_data:

{
    "club_restriction_id": 1,
    "season_id": 2,
    "tenant": 0
}

schema_attributes:

{
    "club_restriction_id": "string",
    "season_id": "string",
    "tenant": "string"
}

schema_name_id: 1462
schema_scan_id: 161732912
updated: 2026-04-09 05:01:02

Version 1707260

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclub_restriction_seasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclub_restriction_seasons`\n(\n `tenant`  string , `club_restriction_id`  string , `season_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_seasons/2026-04-08/1775643001'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclub_restriction_seasons"
]

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

raw_data:

{
    "club_restriction_id": 1,
    "season_id": 2,
    "tenant": 0
}

schema_attributes:

{
    "club_restriction_id": "string",
    "season_id": "string",
    "tenant": "string"
}

schema_name_id: 1462
schema_scan_id: 161678420
updated: 2026-04-08 05:15:22

Version 1706015

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclub_restriction_seasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclub_restriction_seasons`\n(\n `tenant`  string , `club_restriction_id`  string , `season_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_seasons/2026-04-07/1775556856'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclub_restriction_seasons"
]

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

raw_data:

{
    "club_restriction_id": 1,
    "season_id": 2,
    "tenant": 0
}

schema_attributes:

{
    "club_restriction_id": "string",
    "season_id": "string",
    "tenant": "string"
}

schema_name_id: 1462
schema_scan_id: 161622093
updated: 2026-04-07 05:16:19

Version 1704769

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclub_restriction_seasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclub_restriction_seasons`\n(\n `tenant`  string , `club_restriction_id`  string , `season_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_seasons/2026-04-06/1775470528'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclub_restriction_seasons"
]

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

raw_data:

{
    "club_restriction_id": 1,
    "season_id": 2,
    "tenant": 0
}

schema_attributes:

{
    "club_restriction_id": "string",
    "season_id": "string",
    "tenant": "string"
}

schema_name_id: 1462
schema_scan_id: 161564242
updated: 2026-04-06 05:16:53

Version 1703551

created: 2026-04-05 04:56:42

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclub_restriction_seasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclub_restriction_seasons`\n(\n `tenant`  string , `club_restriction_id`  string , `season_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_seasons/2026-04-05/1775382944'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclub_restriction_seasons"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsclub_restriction_seasons/2026-04-05/1775382944
id: 1703551
processed: 1

raw_data:

{
    "club_restriction_id": 1,
    "season_id": 2,
    "tenant": 0
}

schema_attributes:

{
    "club_restriction_id": "string",
    "season_id": "string",
    "tenant": "string"
}

schema_name_id: 1462
schema_scan_id: 161516527
updated: 2026-04-05 04:56:55

Version 1702436

created: 2026-04-04 04:56:46

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclub_restriction_seasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclub_restriction_seasons`\n(\n `tenant`  string , `club_restriction_id`  string , `season_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_seasons/2026-04-04/1775296469'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclub_restriction_seasons"
]

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

raw_data:

{
    "club_restriction_id": 1,
    "season_id": 2,
    "tenant": 0
}

schema_attributes:

{
    "club_restriction_id": "string",
    "season_id": "string",
    "tenant": "string"
}

schema_name_id: 1462
schema_scan_id: 161462138
updated: 2026-04-04 04:57:00

Version 1701254

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclub_restriction_seasons`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclub_restriction_seasons`\n(\n `tenant`  string , `club_restriction_id`  string , `season_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_seasons/2026-04-03/1775211034'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclub_restriction_seasons"
]

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

raw_data:

{
    "club_restriction_id": 1,
    "season_id": 2,
    "tenant": 0
}

schema_attributes:

{
    "club_restriction_id": "string",
    "season_id": "string",
    "tenant": "string"
}

schema_name_id: 1462
schema_scan_id: 161404853
updated: 2026-04-03 05:13:31

Schema Scans: 15

Last at 2026-04-17 04:54:27

Scan 162169249

duration: 0:00:14.106965

exit_message:

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

id: 162169249

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_seasons/2026-04-17/1776419647",
        "key": "raw/stellar_imsclub_restriction_seasons/2026-04-17/1776419647/club_restriction_seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsclub_restriction_seasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11571417505063605483,
        "service_name": "drive-thru",
        "span_id": 11700234798611819658,
        "trace_id": 6895921959857824705
    }
}

running: False
schema_name_id: 1462
start_time: 2026-04-17 04:54:27
success: True
trace_id: 6895921959857824705

Scan 162114446

duration: 0:00:14.077726

exit_message:

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

id: 162114446

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_seasons/2026-04-16/1776334545",
        "key": "raw/stellar_imsclub_restriction_seasons/2026-04-16/1776334545/club_restriction_seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsclub_restriction_seasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16107194768407769247,
        "service_name": "drive-thru",
        "span_id": 18182123098159656065,
        "trace_id": 15787375741100483447
    }
}

running: False
schema_name_id: 1462
start_time: 2026-04-16 05:19:08
success: True
trace_id: 15787375741100483447

Scan 162056345

duration: 0:00:14.133573

exit_message:

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

id: 162056345

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_seasons/2026-04-15/1776242358",
        "key": "raw/stellar_imsclub_restriction_seasons/2026-04-15/1776242358/club_restriction_seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsclub_restriction_seasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5647764342829154317,
        "service_name": "drive-thru",
        "span_id": 16424961068658610332,
        "trace_id": 7766983564219067893
    }
}

running: False
schema_name_id: 1462
start_time: 2026-04-15 03:40:16
success: True
trace_id: 7766983564219067893

Scan 162003135

duration: 0:00:11.528958

exit_message:

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

id: 162003135

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_seasons/2026-04-14/1776160757",
        "key": "raw/stellar_imsclub_restriction_seasons/2026-04-14/1776160757/club_restriction_seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsclub_restriction_seasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15547644045507250979,
        "service_name": "drive-thru",
        "span_id": 10038096438089935654,
        "trace_id": 7382244579968284150
    }
}

running: False
schema_name_id: 1462
start_time: 2026-04-14 05:04:49
success: True
trace_id: 7382244579968284150

Scan 161945330

duration: 0:00:12.135087

exit_message:

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

id: 161945330

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_seasons/2026-04-13/1776074799",
        "key": "raw/stellar_imsclub_restriction_seasons/2026-04-13/1776074799/club_restriction_seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsclub_restriction_seasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14642322587294399708,
        "service_name": "drive-thru",
        "span_id": 16625725175483263949,
        "trace_id": 15180707298399093716
    }
}

running: False
schema_name_id: 1462
start_time: 2026-04-13 05:09:08
success: True
trace_id: 15180707298399093716

Scan 161896339

duration: 0:00:14.045239

exit_message:

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

id: 161896339

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_seasons/2026-04-12/1775988156",
        "key": "raw/stellar_imsclub_restriction_seasons/2026-04-12/1775988156/club_restriction_seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsclub_restriction_seasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16911252139989976476,
        "service_name": "drive-thru",
        "span_id": 15977299535013884247,
        "trace_id": 2961918527203378729
    }
}

running: False
schema_name_id: 1462
start_time: 2026-04-12 05:04:03
success: True
trace_id: 2961918527203378729

Scan 161843959

duration: 0:00:14.196775

exit_message:

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

id: 161843959

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_seasons/2026-04-11/1775902575",
        "key": "raw/stellar_imsclub_restriction_seasons/2026-04-11/1775902575/club_restriction_seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsclub_restriction_seasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7640980203660015707,
        "service_name": "drive-thru",
        "span_id": 5068677387840224853,
        "trace_id": 14464933783755467197
    }
}

running: False
schema_name_id: 1462
start_time: 2026-04-11 05:18:56
success: True
trace_id: 14464933783755467197

Scan 161788568

duration: 0:00:11.562492

exit_message:

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

id: 161788568

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_seasons/2026-04-10/1775815218",
        "key": "raw/stellar_imsclub_restriction_seasons/2026-04-10/1775815218/club_restriction_seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsclub_restriction_seasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1365104079680657139,
        "service_name": "drive-thru",
        "span_id": 16780831448801847641,
        "trace_id": 11988625218471429201
    }
}

running: False
schema_name_id: 1462
start_time: 2026-04-10 05:01:36
success: True
trace_id: 11988625218471429201

Scan 161732912

duration: 0:00:14.050541

exit_message:

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

id: 161732912

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_seasons/2026-04-09/1775728837",
        "key": "raw/stellar_imsclub_restriction_seasons/2026-04-09/1775728837/club_restriction_seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsclub_restriction_seasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13879787464853346140,
        "service_name": "drive-thru",
        "span_id": 14400178662189973411,
        "trace_id": 14226914327843337184
    }
}

running: False
schema_name_id: 1462
start_time: 2026-04-09 05:00:48
success: True
trace_id: 14226914327843337184

Scan 161678420

duration: 0:00:11.582056

exit_message:

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

id: 161678420

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_seasons/2026-04-08/1775643001",
        "key": "raw/stellar_imsclub_restriction_seasons/2026-04-08/1775643001/club_restriction_seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsclub_restriction_seasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13501463322169630678,
        "service_name": "drive-thru",
        "span_id": 11333250842710042928,
        "trace_id": 13384183378750931409
    }
}

running: False
schema_name_id: 1462
start_time: 2026-04-08 05:15:10
success: True
trace_id: 13384183378750931409

Scan 161622093

duration: 0:00:11.557084

exit_message:

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

id: 161622093

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_seasons/2026-04-07/1775556856",
        "key": "raw/stellar_imsclub_restriction_seasons/2026-04-07/1775556856/club_restriction_seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsclub_restriction_seasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9641477717769077997,
        "service_name": "drive-thru",
        "span_id": 4662680817876871491,
        "trace_id": 8239252897937185219
    }
}

running: False
schema_name_id: 1462
start_time: 2026-04-07 05:16:07
success: True
trace_id: 8239252897937185219

Scan 161564242

duration: 0:00:11.598635

exit_message:

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

id: 161564242

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_seasons/2026-04-06/1775470528",
        "key": "raw/stellar_imsclub_restriction_seasons/2026-04-06/1775470528/club_restriction_seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsclub_restriction_seasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6222652157371110725,
        "service_name": "drive-thru",
        "span_id": 16784905260755621738,
        "trace_id": 17464551212203704366
    }
}

running: False
schema_name_id: 1462
start_time: 2026-04-06 05:16:42
success: True
trace_id: 17464551212203704366

Scan 161516527

duration: 0:00:13.996097

exit_message:

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

id: 161516527

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_seasons/2026-04-05/1775382944",
        "key": "raw/stellar_imsclub_restriction_seasons/2026-04-05/1775382944/club_restriction_seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsclub_restriction_seasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8900301860584383627,
        "service_name": "drive-thru",
        "span_id": 5397694090712392650,
        "trace_id": 5676472417397921872
    }
}

running: False
schema_name_id: 1462
start_time: 2026-04-05 04:56:42
success: True
trace_id: 5676472417397921872

Scan 161462138

duration: 0:00:14.038487

exit_message:

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

id: 161462138

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_seasons/2026-04-04/1775296469",
        "key": "raw/stellar_imsclub_restriction_seasons/2026-04-04/1775296469/club_restriction_seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsclub_restriction_seasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14209480382019974604,
        "service_name": "drive-thru",
        "span_id": 15958999441635288405,
        "trace_id": 7018253454294896641
    }
}

running: False
schema_name_id: 1462
start_time: 2026-04-04 04:56:46
success: True
trace_id: 7018253454294896641

Scan 161404853

duration: 0:00:11.645977

exit_message:

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

id: 161404853

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_seasons/2026-04-03/1775211034",
        "key": "raw/stellar_imsclub_restriction_seasons/2026-04-03/1775211034/club_restriction_seasons.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsclub_restriction_seasons",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13399444748149070474,
        "service_name": "drive-thru",
        "span_id": 16287163681076232630,
        "trace_id": 12988764431455967505
    }
}

running: False
schema_name_id: 1462
start_time: 2026-04-03 05:13:20
success: True
trace_id: 12988764431455967505

Partitions:

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

Schema:

attributes:

{
    "club_restriction_id": "string",
    "season_id": "string",
    "tenant": "string"
}

created: 2026-04-17 04:54:27

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_seasons`\n(\n `tenant`  string , `club_restriction_id`  string , `season_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_seasons/2026-04-17/1776419647'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclub_restriction_seasons`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclub_restriction_seasons"
}

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:37",
        "disabled": false,
        "format": "raw",
        "id": 1462,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "stellar_imsclub_restriction_seasons"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "club_restriction_id": "string",
            "season_id": "string",
            "tenant": "string"
        },
        "created": "2026-04-17 04:54:27",
        "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_seasons`\n(\n `tenant`  string , `club_restriction_id`  string , `season_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_seasons/2026-04-17/1776419647'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclub_restriction_seasons`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclub_restriction_seasons"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}