Schema Info

Schema Name: sfdl_prod_redshift.analytics_dwh_dim_facility_listing_type

created: 2018-02-28 10:54:23
disabled: False
format: raw
id: 262
is_partitioned: False
is_schema_datatyped: True

name:

{
    "database": "sfdl_prod_redshift",
    "table": "analytics_dwh_dim_facility_listing_type"
}

type: redshift

Schema Versions: 15

Version 1717880

created: 2026-04-17 03:32:35

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_facility_listing_type`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_facility_listing_type`\n(\n `audit_id`  bigint , `listing_type_key`  int , `listing_type`  varchar(100) , `listing_description`  varchar(256) , `_origin`  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-redshift-analytics-prod/raw/dwh_dim_facility_listing_type/2026-04-17/1776414728'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_facility_listing_type"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_facility_listing_type/2026-04-17/1776414728
id: 1717880
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "listing_description": "3",
    "listing_type": "2",
    "listing_type_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "listing_description": "varchar(256)",
    "listing_type": "varchar(100)",
    "listing_type_key": "int"
}

schema_name_id: 262
schema_scan_id: 162167993
updated: 2026-04-17 03:32:49

Version 1716629

created: 2026-04-16 03:55:20

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_facility_listing_type`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_facility_listing_type`\n(\n `audit_id`  bigint , `listing_type_key`  int , `listing_type`  varchar(100) , `listing_description`  varchar(256) , `_origin`  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-redshift-analytics-prod/raw/dwh_dim_facility_listing_type/2026-04-16/1776329711'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_facility_listing_type"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_facility_listing_type/2026-04-16/1776329711
id: 1716629
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "listing_description": "3",
    "listing_type": "2",
    "listing_type_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "listing_description": "varchar(256)",
    "listing_type": "varchar(100)",
    "listing_type_key": "int"
}

schema_name_id: 262
schema_scan_id: 162112352
updated: 2026-04-16 03:55:32

Version 1715573

created: 2026-04-15 03:51:11

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_facility_listing_type`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_facility_listing_type`\n(\n `audit_id`  bigint , `listing_type_key`  int , `listing_type`  varchar(100) , `listing_description`  varchar(256) , `_origin`  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-redshift-analytics-prod/raw/dwh_dim_facility_listing_type/2026-04-15/1776243050'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_facility_listing_type"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_facility_listing_type/2026-04-15/1776243050
id: 1715573
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "listing_description": "3",
    "listing_type": "2",
    "listing_type_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "listing_description": "varchar(256)",
    "listing_type": "varchar(100)",
    "listing_type_key": "int"
}

schema_name_id: 262
schema_scan_id: 162056524
updated: 2026-04-15 03:51:25

Version 1714252

created: 2026-04-14 03:42:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_facility_listing_type`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_facility_listing_type`\n(\n `audit_id`  bigint , `listing_type_key`  int , `listing_type`  varchar(100) , `listing_description`  varchar(256) , `_origin`  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-redshift-analytics-prod/raw/dwh_dim_facility_listing_type/2026-04-14/1776156118'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_facility_listing_type"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_facility_listing_type/2026-04-14/1776156118
id: 1714252
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "listing_description": "3",
    "listing_type": "2",
    "listing_type_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "listing_description": "varchar(256)",
    "listing_type": "varchar(100)",
    "listing_type_key": "int"
}

schema_name_id: 262
schema_scan_id: 162000820
updated: 2026-04-14 03:42:29

Version 1713039

created: 2026-04-13 03:58:58

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_facility_listing_type`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_facility_listing_type`\n(\n `audit_id`  bigint , `listing_type_key`  int , `listing_type`  varchar(100) , `listing_description`  varchar(256) , `_origin`  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-redshift-analytics-prod/raw/dwh_dim_facility_listing_type/2026-04-13/1776070686'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_facility_listing_type"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_facility_listing_type/2026-04-13/1776070686
id: 1713039
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "listing_description": "3",
    "listing_type": "2",
    "listing_type_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "listing_description": "varchar(256)",
    "listing_type": "varchar(100)",
    "listing_type_key": "int"
}

schema_name_id: 262
schema_scan_id: 161943687
updated: 2026-04-13 03:59:09

Version 1711829

created: 2026-04-12 03:50:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_facility_listing_type`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_facility_listing_type`\n(\n `audit_id`  bigint , `listing_type_key`  int , `listing_type`  varchar(100) , `listing_description`  varchar(256) , `_origin`  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-redshift-analytics-prod/raw/dwh_dim_facility_listing_type/2026-04-12/1775983822'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_facility_listing_type"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_facility_listing_type/2026-04-12/1775983822
id: 1711829
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "listing_description": "3",
    "listing_type": "2",
    "listing_type_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "listing_description": "varchar(256)",
    "listing_type": "varchar(100)",
    "listing_type_key": "int"
}

schema_name_id: 262
schema_scan_id: 161893651
updated: 2026-04-12 03:50:48

Version 1710614

created: 2026-04-11 03:41:29

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_facility_listing_type`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_facility_listing_type`\n(\n `audit_id`  bigint , `listing_type_key`  int , `listing_type`  varchar(100) , `listing_description`  varchar(256) , `_origin`  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-redshift-analytics-prod/raw/dwh_dim_facility_listing_type/2026-04-11/1775896880'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_facility_listing_type"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_facility_listing_type/2026-04-11/1775896880
id: 1710614
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "listing_description": "3",
    "listing_type": "2",
    "listing_type_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "listing_description": "varchar(256)",
    "listing_type": "varchar(100)",
    "listing_type_key": "int"
}

schema_name_id: 262
schema_scan_id: 161841457
updated: 2026-04-11 03:41:40

Version 1709444

created: 2026-04-10 03:30:38

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_facility_listing_type`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_facility_listing_type`\n(\n `audit_id`  bigint , `listing_type_key`  int , `listing_type`  varchar(100) , `listing_description`  varchar(256) , `_origin`  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-redshift-analytics-prod/raw/dwh_dim_facility_listing_type/2026-04-10/1775809828'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_facility_listing_type"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_facility_listing_type/2026-04-10/1775809828
id: 1709444
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "listing_description": "3",
    "listing_type": "2",
    "listing_type_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "listing_description": "varchar(256)",
    "listing_type": "varchar(100)",
    "listing_type_key": "int"
}

schema_name_id: 262
schema_scan_id: 161786194
updated: 2026-04-10 03:30:52

Version 1708312

created: 2026-04-09 03:30:05

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_facility_listing_type`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_facility_listing_type`\n(\n `audit_id`  bigint , `listing_type_key`  int , `listing_type`  varchar(100) , `listing_description`  varchar(256) , `_origin`  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-redshift-analytics-prod/raw/dwh_dim_facility_listing_type/2026-04-09/1775723397'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_facility_listing_type"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_facility_listing_type/2026-04-09/1775723397
id: 1708312
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "listing_description": "3",
    "listing_type": "2",
    "listing_type_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "listing_description": "varchar(256)",
    "listing_type": "varchar(100)",
    "listing_type_key": "int"
}

schema_name_id: 262
schema_scan_id: 161730630
updated: 2026-04-09 03:30:16

Version 1707139

created: 2026-04-08 04:02:12

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_facility_listing_type`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_facility_listing_type`\n(\n `audit_id`  bigint , `listing_type_key`  int , `listing_type`  varchar(100) , `listing_description`  varchar(256) , `_origin`  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-redshift-analytics-prod/raw/dwh_dim_facility_listing_type/2026-04-08/1775638850'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_facility_listing_type"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_facility_listing_type/2026-04-08/1775638850
id: 1707139
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "listing_description": "3",
    "listing_type": "2",
    "listing_type_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "listing_description": "varchar(256)",
    "listing_type": "varchar(100)",
    "listing_type_key": "int"
}

schema_name_id: 262
schema_scan_id: 161676916
updated: 2026-04-08 04:02:26

Version 1705948

created: 2026-04-07 03:53:45

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_facility_listing_type`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_facility_listing_type`\n(\n `audit_id`  bigint , `listing_type_key`  int , `listing_type`  varchar(100) , `listing_description`  varchar(256) , `_origin`  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-redshift-analytics-prod/raw/dwh_dim_facility_listing_type/2026-04-07/1775552017'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_facility_listing_type"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_facility_listing_type/2026-04-07/1775552017
id: 1705948
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "listing_description": "3",
    "listing_type": "2",
    "listing_type_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "listing_description": "varchar(256)",
    "listing_type": "varchar(100)",
    "listing_type_key": "int"
}

schema_name_id: 262
schema_scan_id: 161619841
updated: 2026-04-07 03:53:59

Version 1704712

created: 2026-04-06 03:59:53

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_facility_listing_type`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_facility_listing_type`\n(\n `audit_id`  bigint , `listing_type_key`  int , `listing_type`  varchar(100) , `listing_description`  varchar(256) , `_origin`  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-redshift-analytics-prod/raw/dwh_dim_facility_listing_type/2026-04-06/1775465982'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_facility_listing_type"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_facility_listing_type/2026-04-06/1775465982
id: 1704712
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "listing_description": "3",
    "listing_type": "2",
    "listing_type_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "listing_description": "varchar(256)",
    "listing_type": "varchar(100)",
    "listing_type_key": "int"
}

schema_name_id: 262
schema_scan_id: 161562812
updated: 2026-04-06 04:00:06

Version 1703477

created: 2026-04-05 03:33:46

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_facility_listing_type`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_facility_listing_type`\n(\n `audit_id`  bigint , `listing_type_key`  int , `listing_type`  varchar(100) , `listing_description`  varchar(256) , `_origin`  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-redshift-analytics-prod/raw/dwh_dim_facility_listing_type/2026-04-05/1775378014'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_facility_listing_type"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_facility_listing_type/2026-04-05/1775378014
id: 1703477
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "listing_description": "3",
    "listing_type": "2",
    "listing_type_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "listing_description": "varchar(256)",
    "listing_type": "varchar(100)",
    "listing_type_key": "int"
}

schema_name_id: 262
schema_scan_id: 161515090
updated: 2026-04-05 03:33:57

Version 1702327

created: 2026-04-04 03:32:21

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_facility_listing_type`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_facility_listing_type`\n(\n `audit_id`  bigint , `listing_type_key`  int , `listing_type`  varchar(100) , `listing_description`  varchar(256) , `_origin`  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-redshift-analytics-prod/raw/dwh_dim_facility_listing_type/2026-04-04/1775291527'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_facility_listing_type"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_facility_listing_type/2026-04-04/1775291527
id: 1702327
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "listing_description": "3",
    "listing_type": "2",
    "listing_type_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "listing_description": "varchar(256)",
    "listing_type": "varchar(100)",
    "listing_type_key": "int"
}

schema_name_id: 262
schema_scan_id: 161460698
updated: 2026-04-04 03:32:33

Version 1701165

created: 2026-04-03 03:52:39

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_facility_listing_type`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_facility_listing_type`\n(\n `audit_id`  bigint , `listing_type_key`  int , `listing_type`  varchar(100) , `listing_description`  varchar(256) , `_origin`  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-redshift-analytics-prod/raw/dwh_dim_facility_listing_type/2026-04-03/1775206326'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_facility_listing_type"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/dwh_dim_facility_listing_type/2026-04-03/1775206326
id: 1701165
processed: 1

raw_data:

{
    "_origin": "4",
    "audit_id": "0",
    "listing_description": "3",
    "listing_type": "2",
    "listing_type_key": "1"
}

schema_attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "listing_description": "varchar(256)",
    "listing_type": "varchar(100)",
    "listing_type_key": "int"
}

schema_name_id: 262
schema_scan_id: 161402359
updated: 2026-04-03 03:52:53

Schema Scans: 15

Last at 2026-04-17 03:32:35

Scan 162167993

duration: 0:00:14.319588

exit_message:

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

id: 162167993

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "listing_description": "varchar(256)",
        "listing_type": "varchar(100)",
        "listing_type_key": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_facility_listing_type/2026-04-17/1776414728/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_facility_listing_type/2026-04-17/1776414728",
        "key": "raw/dwh_dim_facility_listing_type/2026-04-17/1776414728/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_facility_listing_type",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 15736846868187169359,
        "service_name": "redshift_unloads",
        "span_id": 13707034265019660073,
        "trace_id": 5758628860139694297
    }
}

running: False
schema_name_id: 262
start_time: 2026-04-17 03:32:35
success: True
trace_id: 5758628860139694297

Scan 162112352

duration: 0:00:11.578236

exit_message:

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

id: 162112352

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "listing_description": "varchar(256)",
        "listing_type": "varchar(100)",
        "listing_type_key": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_facility_listing_type/2026-04-16/1776329711/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_facility_listing_type/2026-04-16/1776329711",
        "key": "raw/dwh_dim_facility_listing_type/2026-04-16/1776329711/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_facility_listing_type",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 9458491961770644061,
        "service_name": "redshift_unloads",
        "span_id": 5399580650514424075,
        "trace_id": 12061512268778952681
    }
}

running: False
schema_name_id: 262
start_time: 2026-04-16 03:55:20
success: True
trace_id: 12061512268778952681

Scan 162056524

duration: 0:00:14.147684

exit_message:

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

id: 162056524

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "listing_description": "varchar(256)",
        "listing_type": "varchar(100)",
        "listing_type_key": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_facility_listing_type/2026-04-15/1776243050/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_facility_listing_type/2026-04-15/1776243050",
        "key": "raw/dwh_dim_facility_listing_type/2026-04-15/1776243050/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_facility_listing_type",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 4879643867128631291,
        "service_name": "redshift_unloads",
        "span_id": 9242581887069362812,
        "trace_id": 7088471592852921013
    }
}

running: False
schema_name_id: 262
start_time: 2026-04-15 03:51:11
success: True
trace_id: 7088471592852921013

Scan 162000820

duration: 0:00:11.625380

exit_message:

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

id: 162000820

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "listing_description": "varchar(256)",
        "listing_type": "varchar(100)",
        "listing_type_key": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_facility_listing_type/2026-04-14/1776156118/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_facility_listing_type/2026-04-14/1776156118",
        "key": "raw/dwh_dim_facility_listing_type/2026-04-14/1776156118/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_facility_listing_type",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 4944142769378056179,
        "service_name": "redshift_unloads",
        "span_id": 11787148500338138434,
        "trace_id": 16950611027963570814
    }
}

running: False
schema_name_id: 262
start_time: 2026-04-14 03:42:17
success: True
trace_id: 16950611027963570814

Scan 161943687

duration: 0:00:11.579883

exit_message:

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

id: 161943687

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "listing_description": "varchar(256)",
        "listing_type": "varchar(100)",
        "listing_type_key": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_facility_listing_type/2026-04-13/1776070686/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_facility_listing_type/2026-04-13/1776070686",
        "key": "raw/dwh_dim_facility_listing_type/2026-04-13/1776070686/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_facility_listing_type",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 9212586178369137291,
        "service_name": "redshift_unloads",
        "span_id": 18408363914138108877,
        "trace_id": 8444458072445961390
    }
}

running: False
schema_name_id: 262
start_time: 2026-04-13 03:58:58
success: True
trace_id: 8444458072445961390

Scan 161893651

duration: 0:00:14.209533

exit_message:

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

id: 161893651

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "listing_description": "varchar(256)",
        "listing_type": "varchar(100)",
        "listing_type_key": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_facility_listing_type/2026-04-12/1775983822/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_facility_listing_type/2026-04-12/1775983822",
        "key": "raw/dwh_dim_facility_listing_type/2026-04-12/1775983822/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_facility_listing_type",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 15038032995316513572,
        "service_name": "redshift_unloads",
        "span_id": 14168029429166230296,
        "trace_id": 15173523099889909355
    }
}

running: False
schema_name_id: 262
start_time: 2026-04-12 03:50:34
success: True
trace_id: 15173523099889909355

Scan 161841457

duration: 0:00:11.631211

exit_message:

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

id: 161841457

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "listing_description": "varchar(256)",
        "listing_type": "varchar(100)",
        "listing_type_key": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_facility_listing_type/2026-04-11/1775896880/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_facility_listing_type/2026-04-11/1775896880",
        "key": "raw/dwh_dim_facility_listing_type/2026-04-11/1775896880/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_facility_listing_type",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 11045675558776622761,
        "service_name": "redshift_unloads",
        "span_id": 5934270302611516487,
        "trace_id": 16030240860566103337
    }
}

running: False
schema_name_id: 262
start_time: 2026-04-11 03:41:29
success: True
trace_id: 16030240860566103337

Scan 161786194

duration: 0:00:14.330207

exit_message:

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

id: 161786194

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "listing_description": "varchar(256)",
        "listing_type": "varchar(100)",
        "listing_type_key": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_facility_listing_type/2026-04-10/1775809828/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_facility_listing_type/2026-04-10/1775809828",
        "key": "raw/dwh_dim_facility_listing_type/2026-04-10/1775809828/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_facility_listing_type",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 8284407906055232973,
        "service_name": "redshift_unloads",
        "span_id": 15779653939276708255,
        "trace_id": 16227377816510345573
    }
}

running: False
schema_name_id: 262
start_time: 2026-04-10 03:30:37
success: True
trace_id: 16227377816510345573

Scan 161730630

duration: 0:00:11.617576

exit_message:

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

id: 161730630

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "listing_description": "varchar(256)",
        "listing_type": "varchar(100)",
        "listing_type_key": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_facility_listing_type/2026-04-09/1775723397/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_facility_listing_type/2026-04-09/1775723397",
        "key": "raw/dwh_dim_facility_listing_type/2026-04-09/1775723397/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_facility_listing_type",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 8065403601902612957,
        "service_name": "redshift_unloads",
        "span_id": 3195444739200069621,
        "trace_id": 1971608477242123765
    }
}

running: False
schema_name_id: 262
start_time: 2026-04-09 03:30:04
success: True
trace_id: 1971608477242123765

Scan 161676916

duration: 0:00:14.125842

exit_message:

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

id: 161676916

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "listing_description": "varchar(256)",
        "listing_type": "varchar(100)",
        "listing_type_key": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_facility_listing_type/2026-04-08/1775638850/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_facility_listing_type/2026-04-08/1775638850",
        "key": "raw/dwh_dim_facility_listing_type/2026-04-08/1775638850/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_facility_listing_type",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 9058731275046773260,
        "service_name": "redshift_unloads",
        "span_id": 16307636857473818471,
        "trace_id": 17371319211153152853
    }
}

running: False
schema_name_id: 262
start_time: 2026-04-08 04:02:12
success: True
trace_id: 17371319211153152853

Scan 161619841

duration: 0:00:14.186399

exit_message:

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

id: 161619841

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "listing_description": "varchar(256)",
        "listing_type": "varchar(100)",
        "listing_type_key": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_facility_listing_type/2026-04-07/1775552017/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_facility_listing_type/2026-04-07/1775552017",
        "key": "raw/dwh_dim_facility_listing_type/2026-04-07/1775552017/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_facility_listing_type",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 5869010253706567771,
        "service_name": "redshift_unloads",
        "span_id": 16935848337947856206,
        "trace_id": 8366681145998345298
    }
}

running: False
schema_name_id: 262
start_time: 2026-04-07 03:53:45
success: True
trace_id: 8366681145998345298

Scan 161562812

duration: 0:00:14.130773

exit_message:

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

id: 161562812

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "listing_description": "varchar(256)",
        "listing_type": "varchar(100)",
        "listing_type_key": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_facility_listing_type/2026-04-06/1775465982/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_facility_listing_type/2026-04-06/1775465982",
        "key": "raw/dwh_dim_facility_listing_type/2026-04-06/1775465982/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_facility_listing_type",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 15902224163734792840,
        "service_name": "redshift_unloads",
        "span_id": 14068118365217344663,
        "trace_id": 2150428822262301254
    }
}

running: False
schema_name_id: 262
start_time: 2026-04-06 03:59:52
success: True
trace_id: 2150428822262301254

Scan 161515090

duration: 0:00:11.536934

exit_message:

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

id: 161515090

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "listing_description": "varchar(256)",
        "listing_type": "varchar(100)",
        "listing_type_key": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_facility_listing_type/2026-04-05/1775378014/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_facility_listing_type/2026-04-05/1775378014",
        "key": "raw/dwh_dim_facility_listing_type/2026-04-05/1775378014/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_facility_listing_type",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 17060279429925633740,
        "service_name": "redshift_unloads",
        "span_id": 11062089876882115140,
        "trace_id": 4405846086614941619
    }
}

running: False
schema_name_id: 262
start_time: 2026-04-05 03:33:45
success: True
trace_id: 4405846086614941619

Scan 161460698

duration: 0:00:11.822461

exit_message:

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

id: 161460698

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "listing_description": "varchar(256)",
        "listing_type": "varchar(100)",
        "listing_type_key": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_facility_listing_type/2026-04-04/1775291527/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_facility_listing_type/2026-04-04/1775291527",
        "key": "raw/dwh_dim_facility_listing_type/2026-04-04/1775291527/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_facility_listing_type",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 8499052534193040402,
        "service_name": "redshift_unloads",
        "span_id": 8927500675736927189,
        "trace_id": 9003015355576603344
    }
}

running: False
schema_name_id: 262
start_time: 2026-04-04 03:32:21
success: True
trace_id: 9003015355576603344

Scan 161402359

duration: 0:00:14.100757

exit_message:

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

id: 161402359

payload:

{
    "datatype_dict": {
        "audit_id": "bigint",
        "listing_description": "varchar(256)",
        "listing_type": "varchar(100)",
        "listing_type_key": "int",
        "origin_key": "varchar"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/dwh_dim_facility_listing_type/2026-04-03/1775206326/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/dwh_dim_facility_listing_type/2026-04-03/1775206326",
        "key": "raw/dwh_dim_facility_listing_type/2026-04-03/1775206326/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_dwh_dim_facility_listing_type",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 17392670620529274973,
        "service_name": "redshift_unloads",
        "span_id": 557189091405932774,
        "trace_id": 13679092196503345824
    }
}

running: False
schema_name_id: 262
start_time: 2026-04-03 03:52:39
success: True
trace_id: 13679092196503345824

Partitions:

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

Schema:

attributes:

{
    "_origin": "string",
    "audit_id": "bigint",
    "listing_description": "varchar(256)",
    "listing_type": "varchar(100)",
    "listing_type_key": "int"
}

created: 2026-04-17 03:32:35

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_facility_listing_type`\n(\n `audit_id`  bigint , `listing_type_key`  int , `listing_type`  varchar(100) , `listing_description`  varchar(256) , `_origin`  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-redshift-analytics-prod/raw/dwh_dim_facility_listing_type/2026-04-17/1776414728'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_facility_listing_type`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_facility_listing_type"
}

Server:

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

Raw:

{
    "name": {
        "created": "2018-02-28 10:54:23",
        "disabled": false,
        "format": "raw",
        "id": 262,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_redshift",
            "table": "analytics_dwh_dim_facility_listing_type"
        },
        "type": "redshift"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "_origin": "string",
            "audit_id": "bigint",
            "listing_description": "varchar(256)",
            "listing_type": "varchar(100)",
            "listing_type_key": "int"
        },
        "created": "2026-04-17 03:32:35",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_dim_facility_listing_type`\n(\n `audit_id`  bigint , `listing_type_key`  int , `listing_type`  varchar(100) , `listing_description`  varchar(256) , `_origin`  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-redshift-analytics-prod/raw/dwh_dim_facility_listing_type/2026-04-17/1776414728'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_dim_facility_listing_type`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_dim_facility_listing_type"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}