Schema Info

Schema Name: sfdl_prod_postgres.keplernormies_rental_type_dim

created: 2019-02-12 04:45:51
disabled: False
format: raw
id: 621
is_partitioned: False
is_schema_datatyped: True

name:

{
    "database": "sfdl_prod_postgres",
    "table": "keplernormies_rental_type_dim"
}

type: postgres

Schema Versions: 15

Version 1717502

created: 2026-04-17 00:55:25

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_rental_type_dim`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_rental_type_dim`\n(\n `rental_type_dim_id`  int , `source_rental_type`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/rental_type_dim/2026-04-17/1776405314'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_rental_type_dim"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/rental_type_dim/2026-04-17/1776405314
id: 1717502
processed: 1

raw_data:

{
    "rental_type_dim_id": 0,
    "source_rental_type": 1
}

schema_attributes:

{
    "rental_type_dim_id": "int",
    "source_rental_type": "string"
}

schema_name_id: 621
schema_scan_id: 162163982
updated: 2026-04-17 00:55:38

Version 1716268

created: 2026-04-16 01:04:29

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_rental_type_dim`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_rental_type_dim`\n(\n `rental_type_dim_id`  int , `source_rental_type`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/rental_type_dim/2026-04-16/1776319458'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_rental_type_dim"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/rental_type_dim/2026-04-16/1776319458
id: 1716268
processed: 1

raw_data:

{
    "rental_type_dim_id": 0,
    "source_rental_type": 1
}

schema_attributes:

{
    "rental_type_dim_id": "int",
    "source_rental_type": "string"
}

schema_name_id: 621
schema_scan_id: 162109249
updated: 2026-04-16 01:04:40

Version 1715076

created: 2026-04-15 01:07:13

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_rental_type_dim`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_rental_type_dim`\n(\n `rental_type_dim_id`  int , `source_rental_type`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/rental_type_dim/2026-04-15/1776233230'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_rental_type_dim"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/rental_type_dim/2026-04-15/1776233230
id: 1715076
processed: 1

raw_data:

{
    "rental_type_dim_id": 0,
    "source_rental_type": 1
}

schema_attributes:

{
    "rental_type_dim_id": "int",
    "source_rental_type": "string"
}

schema_name_id: 621
schema_scan_id: 162053393
updated: 2026-04-15 01:07:27

Version 1713873

created: 2026-04-14 01:01:51

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_rental_type_dim`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_rental_type_dim`\n(\n `rental_type_dim_id`  int , `source_rental_type`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/rental_type_dim/2026-04-14/1776146488'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_rental_type_dim"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/rental_type_dim/2026-04-14/1776146488
id: 1713873
processed: 1

raw_data:

{
    "rental_type_dim_id": 0,
    "source_rental_type": 1
}

schema_attributes:

{
    "rental_type_dim_id": "int",
    "source_rental_type": "string"
}

schema_name_id: 621
schema_scan_id: 161997552
updated: 2026-04-14 01:02:04

Version 1712659

created: 2026-04-13 01:05:11

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_rental_type_dim`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_rental_type_dim`\n(\n `rental_type_dim_id`  int , `source_rental_type`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/rental_type_dim/2026-04-13/1776060307'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_rental_type_dim"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/rental_type_dim/2026-04-13/1776060307
id: 1712659
processed: 1

raw_data:

{
    "rental_type_dim_id": 0,
    "source_rental_type": 1
}

schema_attributes:

{
    "rental_type_dim_id": "int",
    "source_rental_type": "string"
}

schema_name_id: 621
schema_scan_id: 161940057
updated: 2026-04-13 01:05:24

Version 1711452

created: 2026-04-12 01:02:47

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_rental_type_dim`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_rental_type_dim`\n(\n `rental_type_dim_id`  int , `source_rental_type`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/rental_type_dim/2026-04-12/1775973556'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_rental_type_dim"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/rental_type_dim/2026-04-12/1775973556
id: 1711452
processed: 1

raw_data:

{
    "rental_type_dim_id": 0,
    "source_rental_type": 1
}

schema_attributes:

{
    "rental_type_dim_id": "int",
    "source_rental_type": "string"
}

schema_name_id: 621
schema_scan_id: 161890387
updated: 2026-04-12 01:03:01

Version 1710251

created: 2026-04-11 01:03:46

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_rental_type_dim`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_rental_type_dim`\n(\n `rental_type_dim_id`  int , `source_rental_type`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/rental_type_dim/2026-04-11/1775887420'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_rental_type_dim"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/rental_type_dim/2026-04-11/1775887420
id: 1710251
processed: 1

raw_data:

{
    "rental_type_dim_id": 0,
    "source_rental_type": 1
}

schema_attributes:

{
    "rental_type_dim_id": "int",
    "source_rental_type": "string"
}

schema_name_id: 621
schema_scan_id: 161838642
updated: 2026-04-11 01:04:00

Version 1709105

created: 2026-04-10 01:02:53

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_rental_type_dim`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_rental_type_dim`\n(\n `rental_type_dim_id`  int , `source_rental_type`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/rental_type_dim/2026-04-10/1775800896'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_rental_type_dim"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/rental_type_dim/2026-04-10/1775800896
id: 1709105
processed: 1

raw_data:

{
    "rental_type_dim_id": 0,
    "source_rental_type": 1
}

schema_attributes:

{
    "rental_type_dim_id": "int",
    "source_rental_type": "string"
}

schema_name_id: 621
schema_scan_id: 161783065
updated: 2026-04-10 01:03:07

Version 1707952

created: 2026-04-09 00:54:50

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_rental_type_dim`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_rental_type_dim`\n(\n `rental_type_dim_id`  int , `source_rental_type`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/rental_type_dim/2026-04-09/1775714086'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_rental_type_dim"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/rental_type_dim/2026-04-09/1775714086
id: 1707952
processed: 1

raw_data:

{
    "rental_type_dim_id": 0,
    "source_rental_type": 1
}

schema_attributes:

{
    "rental_type_dim_id": "int",
    "source_rental_type": "string"
}

schema_name_id: 621
schema_scan_id: 161726751
updated: 2026-04-09 00:55:01

Version 1706747

created: 2026-04-08 01:08:39

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_rental_type_dim`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_rental_type_dim`\n(\n `rental_type_dim_id`  int , `source_rental_type`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/rental_type_dim/2026-04-08/1775628515'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_rental_type_dim"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/rental_type_dim/2026-04-08/1775628515
id: 1706747
processed: 1

raw_data:

{
    "rental_type_dim_id": 0,
    "source_rental_type": 1
}

schema_attributes:

{
    "rental_type_dim_id": "int",
    "source_rental_type": "string"
}

schema_name_id: 621
schema_scan_id: 161672795
updated: 2026-04-08 01:08:52

Version 1705566

created: 2026-04-07 01:03:29

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_rental_type_dim`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_rental_type_dim`\n(\n `rental_type_dim_id`  int , `source_rental_type`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/rental_type_dim/2026-04-07/1775541804'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_rental_type_dim"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/rental_type_dim/2026-04-07/1775541804
id: 1705566
processed: 1

raw_data:

{
    "rental_type_dim_id": 0,
    "source_rental_type": 1
}

schema_attributes:

{
    "rental_type_dim_id": "int",
    "source_rental_type": "string"
}

schema_name_id: 621
schema_scan_id: 161616694
updated: 2026-04-07 01:03:40

Version 1704326

created: 2026-04-06 01:02:48

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_rental_type_dim`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_rental_type_dim`\n(\n `rental_type_dim_id`  int , `source_rental_type`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/rental_type_dim/2026-04-06/1775455309'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_rental_type_dim"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/rental_type_dim/2026-04-06/1775455309
id: 1704326
processed: 1

raw_data:

{
    "rental_type_dim_id": 0,
    "source_rental_type": 1
}

schema_attributes:

{
    "rental_type_dim_id": "int",
    "source_rental_type": "string"
}

schema_name_id: 621
schema_scan_id: 161558687
updated: 2026-04-06 01:02:59

Version 1703149

created: 2026-04-05 00:54:38

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_rental_type_dim`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_rental_type_dim`\n(\n `rental_type_dim_id`  int , `source_rental_type`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/rental_type_dim/2026-04-05/1775368469'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_rental_type_dim"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/rental_type_dim/2026-04-05/1775368469
id: 1703149
processed: 1

raw_data:

{
    "rental_type_dim_id": 0,
    "source_rental_type": 1
}

schema_attributes:

{
    "rental_type_dim_id": "int",
    "source_rental_type": "string"
}

schema_name_id: 621
schema_scan_id: 161511136
updated: 2026-04-05 00:54:50

Version 1701967

created: 2026-04-04 00:51:29

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_rental_type_dim`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_rental_type_dim`\n(\n `rental_type_dim_id`  int , `source_rental_type`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/rental_type_dim/2026-04-04/1775281884'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_rental_type_dim"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/rental_type_dim/2026-04-04/1775281884
id: 1701967
processed: 1

raw_data:

{
    "rental_type_dim_id": 0,
    "source_rental_type": 1
}

schema_attributes:

{
    "rental_type_dim_id": "int",
    "source_rental_type": "string"
}

schema_name_id: 621
schema_scan_id: 161455886
updated: 2026-04-04 00:51:40

Version 1700766

created: 2026-04-03 01:03:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_rental_type_dim`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_rental_type_dim`\n(\n `rental_type_dim_id`  int , `source_rental_type`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/rental_type_dim/2026-04-03/1775195944'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_rental_type_dim"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/rental_type_dim/2026-04-03/1775195944
id: 1700766
processed: 1

raw_data:

{
    "rental_type_dim_id": 0,
    "source_rental_type": 1
}

schema_attributes:

{
    "rental_type_dim_id": "int",
    "source_rental_type": "string"
}

schema_name_id: 621
schema_scan_id: 161398511
updated: 2026-04-03 01:03:32

Schema Scans: 15

Last at 2026-04-17 00:55:24

Scan 162163982

duration: 0:00:14.133315

exit_message:

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

id: 162163982

payload:

{
    "datatype_dict": {
        "rental_type_dim_id": "int",
        "source_rental_type": "string"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-postgres-keplernormies-prod",
        "hive_path": "s3://sfdl-postgres-keplernormies-prod/raw/rental_type_dim/2026-04-17/1776405314",
        "key": "raw/rental_type_dim/2026-04-17/1776405314/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_rental_type_dim",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 3635281470636629873,
        "service_name": "kepler-normies",
        "span_id": 14870521101047252387,
        "trace_id": 3635281470636629873
    }
}

running: False
schema_name_id: 621
start_time: 2026-04-17 00:55:24
success: True
trace_id: 3635281470636629873

Scan 162109249

duration: 0:00:11.656333

exit_message:

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

id: 162109249

payload:

{
    "datatype_dict": {
        "rental_type_dim_id": "int",
        "source_rental_type": "string"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-postgres-keplernormies-prod",
        "hive_path": "s3://sfdl-postgres-keplernormies-prod/raw/rental_type_dim/2026-04-16/1776319458",
        "key": "raw/rental_type_dim/2026-04-16/1776319458/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_rental_type_dim",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 2466588794121776921,
        "service_name": "kepler-normies",
        "span_id": 362242719179752020,
        "trace_id": 2466588794121776921
    }
}

running: False
schema_name_id: 621
start_time: 2026-04-16 01:04:29
success: True
trace_id: 2466588794121776921

Scan 162053393

duration: 0:00:14.015006

exit_message:

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

id: 162053393

payload:

{
    "datatype_dict": {
        "rental_type_dim_id": "int",
        "source_rental_type": "string"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-postgres-keplernormies-prod",
        "hive_path": "s3://sfdl-postgres-keplernormies-prod/raw/rental_type_dim/2026-04-15/1776233230",
        "key": "raw/rental_type_dim/2026-04-15/1776233230/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_rental_type_dim",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 17711313992832938353,
        "service_name": "kepler-normies",
        "span_id": 1945036258425597435,
        "trace_id": 17711313992832938353
    }
}

running: False
schema_name_id: 621
start_time: 2026-04-15 01:07:13
success: True
trace_id: 17711313992832938353

Scan 161997552

duration: 0:00:13.955194

exit_message:

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

id: 161997552

payload:

{
    "datatype_dict": {
        "rental_type_dim_id": "int",
        "source_rental_type": "string"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-postgres-keplernormies-prod",
        "hive_path": "s3://sfdl-postgres-keplernormies-prod/raw/rental_type_dim/2026-04-14/1776146488",
        "key": "raw/rental_type_dim/2026-04-14/1776146488/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_rental_type_dim",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 11258726624565328507,
        "service_name": "kepler-normies",
        "span_id": 12545324603238051914,
        "trace_id": 11258726624565328507
    }
}

running: False
schema_name_id: 621
start_time: 2026-04-14 01:01:50
success: True
trace_id: 11258726624565328507

Scan 161940057

duration: 0:00:13.958890

exit_message:

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

id: 161940057

payload:

{
    "datatype_dict": {
        "rental_type_dim_id": "int",
        "source_rental_type": "string"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-postgres-keplernormies-prod",
        "hive_path": "s3://sfdl-postgres-keplernormies-prod/raw/rental_type_dim/2026-04-13/1776060307",
        "key": "raw/rental_type_dim/2026-04-13/1776060307/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_rental_type_dim",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 6279428510398940029,
        "service_name": "kepler-normies",
        "span_id": 12399366395188445266,
        "trace_id": 6279428510398940029
    }
}

running: False
schema_name_id: 621
start_time: 2026-04-13 01:05:10
success: True
trace_id: 6279428510398940029

Scan 161890387

duration: 0:00:14.374352

exit_message:

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

id: 161890387

payload:

{
    "datatype_dict": {
        "rental_type_dim_id": "int",
        "source_rental_type": "string"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-postgres-keplernormies-prod",
        "hive_path": "s3://sfdl-postgres-keplernormies-prod/raw/rental_type_dim/2026-04-12/1775973556",
        "key": "raw/rental_type_dim/2026-04-12/1775973556/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_rental_type_dim",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 9887029168538396262,
        "service_name": "kepler-normies",
        "span_id": 2400042951195382745,
        "trace_id": 9887029168538396262
    }
}

running: False
schema_name_id: 621
start_time: 2026-04-12 01:02:47
success: True
trace_id: 9887029168538396262

Scan 161838642

duration: 0:00:14.078699

exit_message:

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

id: 161838642

payload:

{
    "datatype_dict": {
        "rental_type_dim_id": "int",
        "source_rental_type": "string"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-postgres-keplernormies-prod",
        "hive_path": "s3://sfdl-postgres-keplernormies-prod/raw/rental_type_dim/2026-04-11/1775887420",
        "key": "raw/rental_type_dim/2026-04-11/1775887420/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_rental_type_dim",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 2630802764464202342,
        "service_name": "kepler-normies",
        "span_id": 13747687506478892706,
        "trace_id": 2630802764464202342
    }
}

running: False
schema_name_id: 621
start_time: 2026-04-11 01:03:46
success: True
trace_id: 2630802764464202342

Scan 161783065

duration: 0:00:14.098764

exit_message:

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

id: 161783065

payload:

{
    "datatype_dict": {
        "rental_type_dim_id": "int",
        "source_rental_type": "string"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-postgres-keplernormies-prod",
        "hive_path": "s3://sfdl-postgres-keplernormies-prod/raw/rental_type_dim/2026-04-10/1775800896",
        "key": "raw/rental_type_dim/2026-04-10/1775800896/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_rental_type_dim",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 9088940871447440122,
        "service_name": "kepler-normies",
        "span_id": 4503004041654331736,
        "trace_id": 9088940871447440122
    }
}

running: False
schema_name_id: 621
start_time: 2026-04-10 01:02:53
success: True
trace_id: 9088940871447440122

Scan 161726751

duration: 0:00:11.550670

exit_message:

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

id: 161726751

payload:

{
    "datatype_dict": {
        "rental_type_dim_id": "int",
        "source_rental_type": "string"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-postgres-keplernormies-prod",
        "hive_path": "s3://sfdl-postgres-keplernormies-prod/raw/rental_type_dim/2026-04-09/1775714086",
        "key": "raw/rental_type_dim/2026-04-09/1775714086/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_rental_type_dim",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 14360946883823353483,
        "service_name": "kepler-normies",
        "span_id": 8410412051851524907,
        "trace_id": 14360946883823353483
    }
}

running: False
schema_name_id: 621
start_time: 2026-04-09 00:54:50
success: True
trace_id: 14360946883823353483

Scan 161672795

duration: 0:00:14.273089

exit_message:

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

id: 161672795

payload:

{
    "datatype_dict": {
        "rental_type_dim_id": "int",
        "source_rental_type": "string"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-postgres-keplernormies-prod",
        "hive_path": "s3://sfdl-postgres-keplernormies-prod/raw/rental_type_dim/2026-04-08/1775628515",
        "key": "raw/rental_type_dim/2026-04-08/1775628515/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_rental_type_dim",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 9704562310377068649,
        "service_name": "kepler-normies",
        "span_id": 15324121137670606421,
        "trace_id": 9704562310377068649
    }
}

running: False
schema_name_id: 621
start_time: 2026-04-08 01:08:38
success: True
trace_id: 9704562310377068649

Scan 161616694

duration: 0:00:11.618284

exit_message:

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

id: 161616694

payload:

{
    "datatype_dict": {
        "rental_type_dim_id": "int",
        "source_rental_type": "string"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-postgres-keplernormies-prod",
        "hive_path": "s3://sfdl-postgres-keplernormies-prod/raw/rental_type_dim/2026-04-07/1775541804",
        "key": "raw/rental_type_dim/2026-04-07/1775541804/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_rental_type_dim",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 9205282387793737761,
        "service_name": "kepler-normies",
        "span_id": 14053459798342462952,
        "trace_id": 9205282387793737761
    }
}

running: False
schema_name_id: 621
start_time: 2026-04-07 01:03:28
success: True
trace_id: 9205282387793737761

Scan 161558687

duration: 0:00:11.484268

exit_message:

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

id: 161558687

payload:

{
    "datatype_dict": {
        "rental_type_dim_id": "int",
        "source_rental_type": "string"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-postgres-keplernormies-prod",
        "hive_path": "s3://sfdl-postgres-keplernormies-prod/raw/rental_type_dim/2026-04-06/1775455309",
        "key": "raw/rental_type_dim/2026-04-06/1775455309/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_rental_type_dim",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 2152951179309716933,
        "service_name": "kepler-normies",
        "span_id": 4603455867156563010,
        "trace_id": 2152951179309716933
    }
}

running: False
schema_name_id: 621
start_time: 2026-04-06 01:02:47
success: True
trace_id: 2152951179309716933

Scan 161511136

duration: 0:00:11.512173

exit_message:

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

id: 161511136

payload:

{
    "datatype_dict": {
        "rental_type_dim_id": "int",
        "source_rental_type": "string"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-postgres-keplernormies-prod",
        "hive_path": "s3://sfdl-postgres-keplernormies-prod/raw/rental_type_dim/2026-04-05/1775368469",
        "key": "raw/rental_type_dim/2026-04-05/1775368469/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_rental_type_dim",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 12919766479714553807,
        "service_name": "kepler-normies",
        "span_id": 17968481730816613280,
        "trace_id": 12919766479714553807
    }
}

running: False
schema_name_id: 621
start_time: 2026-04-05 00:54:38
success: True
trace_id: 12919766479714553807

Scan 161455886

duration: 0:00:11.557322

exit_message:

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

id: 161455886

payload:

{
    "datatype_dict": {
        "rental_type_dim_id": "int",
        "source_rental_type": "string"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-postgres-keplernormies-prod",
        "hive_path": "s3://sfdl-postgres-keplernormies-prod/raw/rental_type_dim/2026-04-04/1775281884",
        "key": "raw/rental_type_dim/2026-04-04/1775281884/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_rental_type_dim",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 12359121823991376450,
        "service_name": "kepler-normies",
        "span_id": 11049038836024950689,
        "trace_id": 12359121823991376450
    }
}

running: False
schema_name_id: 621
start_time: 2026-04-04 00:51:29
success: True
trace_id: 12359121823991376450

Scan 161398511

duration: 0:00:14.099858

exit_message:

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

id: 161398511

payload:

{
    "datatype_dict": {
        "rental_type_dim_id": "int",
        "source_rental_type": "string"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-postgres-keplernormies-prod",
        "hive_path": "s3://sfdl-postgres-keplernormies-prod/raw/rental_type_dim/2026-04-03/1775195944",
        "key": "raw/rental_type_dim/2026-04-03/1775195944/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_rental_type_dim",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 10355435660146559224,
        "service_name": "kepler-normies",
        "span_id": 11186045776246993258,
        "trace_id": 10355435660146559224
    }
}

running: False
schema_name_id: 621
start_time: 2026-04-03 01:03:18
success: True
trace_id: 10355435660146559224

Partitions:

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

Schema:

attributes:

{
    "rental_type_dim_id": "int",
    "source_rental_type": "string"
}

created: 2026-04-17 00:55:25

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_rental_type_dim`\n(\n `rental_type_dim_id`  int , `source_rental_type`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/rental_type_dim/2026-04-17/1776405314'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_rental_type_dim`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_rental_type_dim"
}

Server:

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

Raw:

{
    "name": {
        "created": "2019-02-12 04:45:51",
        "disabled": false,
        "format": "raw",
        "id": 621,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_postgres",
            "table": "keplernormies_rental_type_dim"
        },
        "type": "postgres"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "rental_type_dim_id": "int",
            "source_rental_type": "string"
        },
        "created": "2026-04-17 00:55:25",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_rental_type_dim`\n(\n `rental_type_dim_id`  int , `source_rental_type`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/rental_type_dim/2026-04-17/1776405314'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_rental_type_dim`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_rental_type_dim"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}