Schema Info

Schema Name: sfdl_prod_redshift.analytics_bi_account_overview_monthly

created: 2020-09-23 14:42:04
disabled: False
format: raw
id: 808
is_partitioned: False
is_schema_datatyped: True

name:

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

type: redshift

Schema Versions: 15

Version 1717836

created: 2026-04-17 03:15:33

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_bi_account_overview_monthly`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_bi_account_overview_monthly`\n(\n `account_id`  int , `facility_id`  int , `month_key`  int , `title`  varchar(128) , `company_code`  varchar(128) , `bid_type`  varchar(10) , `views`  int , `bid_amount`  varchar(10) , `min_bid`  decimal(6,2) , `integration_type`  varchar(100) , `active`  int , `_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/bi_account_overview_monthly/2026-04-17/1776413722'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_bi_account_overview_monthly"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/bi_account_overview_monthly/2026-04-17/1776413722
id: 1717836
processed: 1

raw_data:

{
    "_origin": "11",
    "account_id": "0",
    "active": "10",
    "bid_amount": "7",
    "bid_type": "5",
    "company_code": "4",
    "facility_id": "1",
    "integration_type": "9",
    "min_bid": "8",
    "month_key": "2",
    "title": "3",
    "views": "6"
}

schema_attributes:

{
    "_origin": "string",
    "account_id": "int",
    "active": "int",
    "bid_amount": "varchar(10)",
    "bid_type": "varchar(10)",
    "company_code": "varchar(128)",
    "facility_id": "int",
    "integration_type": "varchar(100)",
    "min_bid": "decimal(6,2)",
    "month_key": "int",
    "title": "varchar(128)",
    "views": "int"
}

schema_name_id: 808
schema_scan_id: 162167876
updated: 2026-04-17 03:15:47

Version 1716601

created: 2026-04-16 03:16:03

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_bi_account_overview_monthly`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_bi_account_overview_monthly`\n(\n `account_id`  int , `facility_id`  int , `month_key`  int , `title`  varchar(128) , `company_code`  varchar(128) , `bid_type`  varchar(10) , `views`  int , `bid_amount`  varchar(10) , `min_bid`  decimal(6,2) , `integration_type`  varchar(100) , `active`  int , `_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/bi_account_overview_monthly/2026-04-16/1776327355'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_bi_account_overview_monthly"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/bi_account_overview_monthly/2026-04-16/1776327355
id: 1716601
processed: 1

raw_data:

{
    "_origin": "11",
    "account_id": "0",
    "active": "10",
    "bid_amount": "7",
    "bid_type": "5",
    "company_code": "4",
    "facility_id": "1",
    "integration_type": "9",
    "min_bid": "8",
    "month_key": "2",
    "title": "3",
    "views": "6"
}

schema_attributes:

{
    "_origin": "string",
    "account_id": "int",
    "active": "int",
    "bid_amount": "varchar(10)",
    "bid_type": "varchar(10)",
    "company_code": "varchar(128)",
    "facility_id": "int",
    "integration_type": "varchar(100)",
    "min_bid": "decimal(6,2)",
    "month_key": "int",
    "title": "varchar(128)",
    "views": "int"
}

schema_name_id: 808
schema_scan_id: 162112078
updated: 2026-04-16 03:16:17

Version 1715562

created: 2026-04-15 03:44:56

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_bi_account_overview_monthly`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_bi_account_overview_monthly`\n(\n `account_id`  int , `facility_id`  int , `month_key`  int , `title`  varchar(128) , `company_code`  varchar(128) , `bid_type`  varchar(10) , `views`  int , `bid_amount`  varchar(10) , `min_bid`  decimal(6,2) , `integration_type`  varchar(100) , `active`  int , `_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/bi_account_overview_monthly/2026-04-15/1776242680'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_bi_account_overview_monthly"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/bi_account_overview_monthly/2026-04-15/1776242680
id: 1715562
processed: 1

raw_data:

{
    "_origin": "11",
    "account_id": "0",
    "active": "10",
    "bid_amount": "7",
    "bid_type": "5",
    "company_code": "4",
    "facility_id": "1",
    "integration_type": "9",
    "min_bid": "8",
    "month_key": "2",
    "title": "3",
    "views": "6"
}

schema_attributes:

{
    "_origin": "string",
    "account_id": "int",
    "active": "int",
    "bid_amount": "varchar(10)",
    "bid_type": "varchar(10)",
    "company_code": "varchar(128)",
    "facility_id": "int",
    "integration_type": "varchar(100)",
    "min_bid": "decimal(6,2)",
    "month_key": "int",
    "title": "varchar(128)",
    "views": "int"
}

schema_name_id: 808
schema_scan_id: 162056455
updated: 2026-04-15 03:45:07

Version 1714219

created: 2026-04-14 03:21:46

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_bi_account_overview_monthly`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_bi_account_overview_monthly`\n(\n `account_id`  int , `facility_id`  int , `month_key`  int , `title`  varchar(128) , `company_code`  varchar(128) , `bid_type`  varchar(10) , `views`  int , `bid_amount`  varchar(10) , `min_bid`  decimal(6,2) , `integration_type`  varchar(100) , `active`  int , `_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/bi_account_overview_monthly/2026-04-14/1776154878'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_bi_account_overview_monthly"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/bi_account_overview_monthly/2026-04-14/1776154878
id: 1714219
processed: 1

raw_data:

{
    "_origin": "11",
    "account_id": "0",
    "active": "10",
    "bid_amount": "7",
    "bid_type": "5",
    "company_code": "4",
    "facility_id": "1",
    "integration_type": "9",
    "min_bid": "8",
    "month_key": "2",
    "title": "3",
    "views": "6"
}

schema_attributes:

{
    "_origin": "string",
    "account_id": "int",
    "active": "int",
    "bid_amount": "varchar(10)",
    "bid_type": "varchar(10)",
    "company_code": "varchar(128)",
    "facility_id": "int",
    "integration_type": "varchar(100)",
    "min_bid": "decimal(6,2)",
    "month_key": "int",
    "title": "varchar(128)",
    "views": "int"
}

schema_name_id: 808
schema_scan_id: 162000760
updated: 2026-04-14 03:21:57

Version 1712984

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_bi_account_overview_monthly`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_bi_account_overview_monthly`\n(\n `account_id`  int , `facility_id`  int , `month_key`  int , `title`  varchar(128) , `company_code`  varchar(128) , `bid_type`  varchar(10) , `views`  int , `bid_amount`  varchar(10) , `min_bid`  decimal(6,2) , `integration_type`  varchar(100) , `active`  int , `_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/bi_account_overview_monthly/2026-04-13/1776068745'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_bi_account_overview_monthly"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/bi_account_overview_monthly/2026-04-13/1776068745
id: 1712984
processed: 1

raw_data:

{
    "_origin": "11",
    "account_id": "0",
    "active": "10",
    "bid_amount": "7",
    "bid_type": "5",
    "company_code": "4",
    "facility_id": "1",
    "integration_type": "9",
    "min_bid": "8",
    "month_key": "2",
    "title": "3",
    "views": "6"
}

schema_attributes:

{
    "_origin": "string",
    "account_id": "int",
    "active": "int",
    "bid_amount": "varchar(10)",
    "bid_type": "varchar(10)",
    "company_code": "varchar(128)",
    "facility_id": "int",
    "integration_type": "varchar(100)",
    "min_bid": "decimal(6,2)",
    "month_key": "int",
    "title": "varchar(128)",
    "views": "int"
}

schema_name_id: 808
schema_scan_id: 161942899
updated: 2026-04-13 03:26:12

Version 1711787

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_bi_account_overview_monthly`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_bi_account_overview_monthly`\n(\n `account_id`  int , `facility_id`  int , `month_key`  int , `title`  varchar(128) , `company_code`  varchar(128) , `bid_type`  varchar(10) , `views`  int , `bid_amount`  varchar(10) , `min_bid`  decimal(6,2) , `integration_type`  varchar(100) , `active`  int , `_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/bi_account_overview_monthly/2026-04-12/1775981770'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_bi_account_overview_monthly"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/bi_account_overview_monthly/2026-04-12/1775981770
id: 1711787
processed: 1

raw_data:

{
    "_origin": "11",
    "account_id": "0",
    "active": "10",
    "bid_amount": "7",
    "bid_type": "5",
    "company_code": "4",
    "facility_id": "1",
    "integration_type": "9",
    "min_bid": "8",
    "month_key": "2",
    "title": "3",
    "views": "6"
}

schema_attributes:

{
    "_origin": "string",
    "account_id": "int",
    "active": "int",
    "bid_amount": "varchar(10)",
    "bid_type": "varchar(10)",
    "company_code": "varchar(128)",
    "facility_id": "int",
    "integration_type": "varchar(100)",
    "min_bid": "decimal(6,2)",
    "month_key": "int",
    "title": "varchar(128)",
    "views": "int"
}

schema_name_id: 808
schema_scan_id: 161893545
updated: 2026-04-12 03:21:31

Version 1710528

created: 2026-04-11 03:09:33

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_bi_account_overview_monthly`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_bi_account_overview_monthly`\n(\n `account_id`  int , `facility_id`  int , `month_key`  int , `title`  varchar(128) , `company_code`  varchar(128) , `bid_type`  varchar(10) , `views`  int , `bid_amount`  varchar(10) , `min_bid`  decimal(6,2) , `integration_type`  varchar(100) , `active`  int , `_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/bi_account_overview_monthly/2026-04-11/1775894955'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_bi_account_overview_monthly"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/bi_account_overview_monthly/2026-04-11/1775894955
id: 1710528
processed: 1

raw_data:

{
    "_origin": "11",
    "account_id": "0",
    "active": "10",
    "bid_amount": "7",
    "bid_type": "5",
    "company_code": "4",
    "facility_id": "1",
    "integration_type": "9",
    "min_bid": "8",
    "month_key": "2",
    "title": "3",
    "views": "6"
}

schema_attributes:

{
    "_origin": "string",
    "account_id": "int",
    "active": "int",
    "bid_amount": "varchar(10)",
    "bid_type": "varchar(10)",
    "company_code": "varchar(128)",
    "facility_id": "int",
    "integration_type": "varchar(100)",
    "min_bid": "decimal(6,2)",
    "month_key": "int",
    "title": "varchar(128)",
    "views": "int"
}

schema_name_id: 808
schema_scan_id: 161841325
updated: 2026-04-11 03:09:44

Version 1709428

created: 2026-04-10 03:21:09

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_bi_account_overview_monthly`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_bi_account_overview_monthly`\n(\n `account_id`  int , `facility_id`  int , `month_key`  int , `title`  varchar(128) , `company_code`  varchar(128) , `bid_type`  varchar(10) , `views`  int , `bid_amount`  varchar(10) , `min_bid`  decimal(6,2) , `integration_type`  varchar(100) , `active`  int , `_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/bi_account_overview_monthly/2026-04-10/1775809256'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_bi_account_overview_monthly"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/bi_account_overview_monthly/2026-04-10/1775809256
id: 1709428
processed: 1

raw_data:

{
    "_origin": "11",
    "account_id": "0",
    "active": "10",
    "bid_amount": "7",
    "bid_type": "5",
    "company_code": "4",
    "facility_id": "1",
    "integration_type": "9",
    "min_bid": "8",
    "month_key": "2",
    "title": "3",
    "views": "6"
}

schema_attributes:

{
    "_origin": "string",
    "account_id": "int",
    "active": "int",
    "bid_amount": "varchar(10)",
    "bid_type": "varchar(10)",
    "company_code": "varchar(128)",
    "facility_id": "int",
    "integration_type": "varchar(100)",
    "min_bid": "decimal(6,2)",
    "month_key": "int",
    "title": "varchar(128)",
    "views": "int"
}

schema_name_id: 808
schema_scan_id: 161786162
updated: 2026-04-10 03:21:20

Version 1708288

created: 2026-04-09 03:18:44

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_bi_account_overview_monthly`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_bi_account_overview_monthly`\n(\n `account_id`  int , `facility_id`  int , `month_key`  int , `title`  varchar(128) , `company_code`  varchar(128) , `bid_type`  varchar(10) , `views`  int , `bid_amount`  varchar(10) , `min_bid`  decimal(6,2) , `integration_type`  varchar(100) , `active`  int , `_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/bi_account_overview_monthly/2026-04-09/1775722714'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_bi_account_overview_monthly"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/bi_account_overview_monthly/2026-04-09/1775722714
id: 1708288
processed: 1

raw_data:

{
    "_origin": "11",
    "account_id": "0",
    "active": "10",
    "bid_amount": "7",
    "bid_type": "5",
    "company_code": "4",
    "facility_id": "1",
    "integration_type": "9",
    "min_bid": "8",
    "month_key": "2",
    "title": "3",
    "views": "6"
}

schema_attributes:

{
    "_origin": "string",
    "account_id": "int",
    "active": "int",
    "bid_amount": "varchar(10)",
    "bid_type": "varchar(10)",
    "company_code": "varchar(128)",
    "facility_id": "int",
    "integration_type": "varchar(100)",
    "min_bid": "decimal(6,2)",
    "month_key": "int",
    "title": "varchar(128)",
    "views": "int"
}

schema_name_id: 808
schema_scan_id: 161730596
updated: 2026-04-09 03:18:55

Version 1707122

created: 2026-04-08 03:43:00

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_bi_account_overview_monthly`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_bi_account_overview_monthly`\n(\n `account_id`  int , `facility_id`  int , `month_key`  int , `title`  varchar(128) , `company_code`  varchar(128) , `bid_type`  varchar(10) , `views`  int , `bid_amount`  varchar(10) , `min_bid`  decimal(6,2) , `integration_type`  varchar(100) , `active`  int , `_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/bi_account_overview_monthly/2026-04-08/1775637765'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_bi_account_overview_monthly"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/bi_account_overview_monthly/2026-04-08/1775637765
id: 1707122
processed: 1

raw_data:

{
    "_origin": "11",
    "account_id": "0",
    "active": "10",
    "bid_amount": "7",
    "bid_type": "5",
    "company_code": "4",
    "facility_id": "1",
    "integration_type": "9",
    "min_bid": "8",
    "month_key": "2",
    "title": "3",
    "views": "6"
}

schema_attributes:

{
    "_origin": "string",
    "account_id": "int",
    "active": "int",
    "bid_amount": "varchar(10)",
    "bid_type": "varchar(10)",
    "company_code": "varchar(128)",
    "facility_id": "int",
    "integration_type": "varchar(100)",
    "min_bid": "decimal(6,2)",
    "month_key": "int",
    "title": "varchar(128)",
    "views": "int"
}

schema_name_id: 808
schema_scan_id: 161675837
updated: 2026-04-08 03:43:11

Version 1705899

created: 2026-04-07 03:15:17

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_bi_account_overview_monthly`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_bi_account_overview_monthly`\n(\n `account_id`  int , `facility_id`  int , `month_key`  int , `title`  varchar(128) , `company_code`  varchar(128) , `bid_type`  varchar(10) , `views`  int , `bid_amount`  varchar(10) , `min_bid`  decimal(6,2) , `integration_type`  varchar(100) , `active`  int , `_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/bi_account_overview_monthly/2026-04-07/1775549711'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_bi_account_overview_monthly"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/bi_account_overview_monthly/2026-04-07/1775549711
id: 1705899
processed: 1

raw_data:

{
    "_origin": "11",
    "account_id": "0",
    "active": "10",
    "bid_amount": "7",
    "bid_type": "5",
    "company_code": "4",
    "facility_id": "1",
    "integration_type": "9",
    "min_bid": "8",
    "month_key": "2",
    "title": "3",
    "views": "6"
}

schema_attributes:

{
    "_origin": "string",
    "account_id": "int",
    "active": "int",
    "bid_amount": "varchar(10)",
    "bid_type": "varchar(10)",
    "company_code": "varchar(128)",
    "facility_id": "int",
    "integration_type": "varchar(100)",
    "min_bid": "decimal(6,2)",
    "month_key": "int",
    "title": "varchar(128)",
    "views": "int"
}

schema_name_id: 808
schema_scan_id: 161619640
updated: 2026-04-07 03:15:31

Version 1704670

created: 2026-04-06 03:15:43

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_bi_account_overview_monthly`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_bi_account_overview_monthly`\n(\n `account_id`  int , `facility_id`  int , `month_key`  int , `title`  varchar(128) , `company_code`  varchar(128) , `bid_type`  varchar(10) , `views`  int , `bid_amount`  varchar(10) , `min_bid`  decimal(6,2) , `integration_type`  varchar(100) , `active`  int , `_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/bi_account_overview_monthly/2026-04-06/1775463337'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_bi_account_overview_monthly"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/bi_account_overview_monthly/2026-04-06/1775463337
id: 1704670
processed: 1

raw_data:

{
    "_origin": "11",
    "account_id": "0",
    "active": "10",
    "bid_amount": "7",
    "bid_type": "5",
    "company_code": "4",
    "facility_id": "1",
    "integration_type": "9",
    "min_bid": "8",
    "month_key": "2",
    "title": "3",
    "views": "6"
}

schema_attributes:

{
    "_origin": "string",
    "account_id": "int",
    "active": "int",
    "bid_amount": "varchar(10)",
    "bid_type": "varchar(10)",
    "company_code": "varchar(128)",
    "facility_id": "int",
    "integration_type": "varchar(100)",
    "min_bid": "decimal(6,2)",
    "month_key": "int",
    "title": "varchar(128)",
    "views": "int"
}

schema_name_id: 808
schema_scan_id: 161561835
updated: 2026-04-06 03:15:54

Version 1703464

created: 2026-04-05 03:22:02

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_bi_account_overview_monthly`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_bi_account_overview_monthly`\n(\n `account_id`  int , `facility_id`  int , `month_key`  int , `title`  varchar(128) , `company_code`  varchar(128) , `bid_type`  varchar(10) , `views`  int , `bid_amount`  varchar(10) , `min_bid`  decimal(6,2) , `integration_type`  varchar(100) , `active`  int , `_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/bi_account_overview_monthly/2026-04-05/1775377315'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_bi_account_overview_monthly"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/bi_account_overview_monthly/2026-04-05/1775377315
id: 1703464
processed: 1

raw_data:

{
    "_origin": "11",
    "account_id": "0",
    "active": "10",
    "bid_amount": "7",
    "bid_type": "5",
    "company_code": "4",
    "facility_id": "1",
    "integration_type": "9",
    "min_bid": "8",
    "month_key": "2",
    "title": "3",
    "views": "6"
}

schema_attributes:

{
    "_origin": "string",
    "account_id": "int",
    "active": "int",
    "bid_amount": "varchar(10)",
    "bid_type": "varchar(10)",
    "company_code": "varchar(128)",
    "facility_id": "int",
    "integration_type": "varchar(100)",
    "min_bid": "decimal(6,2)",
    "month_key": "int",
    "title": "varchar(128)",
    "views": "int"
}

schema_name_id: 808
schema_scan_id: 161515069
updated: 2026-04-05 03:22:13

Version 1702344

created: 2026-04-04 03:36:49

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_bi_account_overview_monthly`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_bi_account_overview_monthly`\n(\n `account_id`  int , `facility_id`  int , `month_key`  int , `title`  varchar(128) , `company_code`  varchar(128) , `bid_type`  varchar(10) , `views`  int , `bid_amount`  varchar(10) , `min_bid`  decimal(6,2) , `integration_type`  varchar(100) , `active`  int , `_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/bi_account_overview_monthly/2026-04-04/1775291792'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_bi_account_overview_monthly"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/bi_account_overview_monthly/2026-04-04/1775291792
id: 1702344
processed: 1

raw_data:

{
    "_origin": "11",
    "account_id": "0",
    "active": "10",
    "bid_amount": "7",
    "bid_type": "5",
    "company_code": "4",
    "facility_id": "1",
    "integration_type": "9",
    "min_bid": "8",
    "month_key": "2",
    "title": "3",
    "views": "6"
}

schema_attributes:

{
    "_origin": "string",
    "account_id": "int",
    "active": "int",
    "bid_amount": "varchar(10)",
    "bid_type": "varchar(10)",
    "company_code": "varchar(128)",
    "facility_id": "int",
    "integration_type": "varchar(100)",
    "min_bid": "decimal(6,2)",
    "month_key": "int",
    "title": "varchar(128)",
    "views": "int"
}

schema_name_id: 808
schema_scan_id: 161460721
updated: 2026-04-04 03:37:02

Version 1701103

created: 2026-04-03 03:21:59

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_bi_account_overview_monthly`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_bi_account_overview_monthly`\n(\n `account_id`  int , `facility_id`  int , `month_key`  int , `title`  varchar(128) , `company_code`  varchar(128) , `bid_type`  varchar(10) , `views`  int , `bid_amount`  varchar(10) , `min_bid`  decimal(6,2) , `integration_type`  varchar(100) , `active`  int , `_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/bi_account_overview_monthly/2026-04-03/1775204416'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_bi_account_overview_monthly"
]

hive_path: s3://sfdl-redshift-analytics-prod/raw/bi_account_overview_monthly/2026-04-03/1775204416
id: 1701103
processed: 1

raw_data:

{
    "_origin": "11",
    "account_id": "0",
    "active": "10",
    "bid_amount": "7",
    "bid_type": "5",
    "company_code": "4",
    "facility_id": "1",
    "integration_type": "9",
    "min_bid": "8",
    "month_key": "2",
    "title": "3",
    "views": "6"
}

schema_attributes:

{
    "_origin": "string",
    "account_id": "int",
    "active": "int",
    "bid_amount": "varchar(10)",
    "bid_type": "varchar(10)",
    "company_code": "varchar(128)",
    "facility_id": "int",
    "integration_type": "varchar(100)",
    "min_bid": "decimal(6,2)",
    "month_key": "int",
    "title": "varchar(128)",
    "views": "int"
}

schema_name_id: 808
schema_scan_id: 161402113
updated: 2026-04-03 03:22:10

Schema Scans: 15

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

Scan 162167876

duration: 0:00:14.461629

exit_message:

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

id: 162167876

payload:

{
    "datatype_dict": {
        "account_id": "int",
        "active": "int",
        "bid_amount": "varchar(10)",
        "bid_type": "varchar(10)",
        "company_code": "varchar(128)",
        "facility_id": "int",
        "integration_type": "varchar(100)",
        "min_bid": "decimal(6,2)",
        "month_key": "int",
        "origin_key": "varchar",
        "title": "varchar(128)",
        "views": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/bi_account_overview_monthly/2026-04-17/1776413722/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/bi_account_overview_monthly/2026-04-17/1776413722",
        "key": "raw/bi_account_overview_monthly/2026-04-17/1776413722/account_overview_monthly.dat0000_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_bi_account_overview_monthly",
        "type": "redshift"
    }
}

running: False
schema_name_id: 808
start_time: 2026-04-17 03:15:32
success: True
trace_id: 8421044628778654538

Scan 162112078

duration: 0:00:14.507021

exit_message:

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

id: 162112078

payload:

{
    "datatype_dict": {
        "account_id": "int",
        "active": "int",
        "bid_amount": "varchar(10)",
        "bid_type": "varchar(10)",
        "company_code": "varchar(128)",
        "facility_id": "int",
        "integration_type": "varchar(100)",
        "min_bid": "decimal(6,2)",
        "month_key": "int",
        "origin_key": "varchar",
        "title": "varchar(128)",
        "views": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/bi_account_overview_monthly/2026-04-16/1776327355/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/bi_account_overview_monthly/2026-04-16/1776327355",
        "key": "raw/bi_account_overview_monthly/2026-04-16/1776327355/account_overview_monthly.dat0000_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_bi_account_overview_monthly",
        "type": "redshift"
    }
}

running: False
schema_name_id: 808
start_time: 2026-04-16 03:16:03
success: True
trace_id: 13479738473724070033

Scan 162056455

duration: 0:00:11.721334

exit_message:

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

id: 162056455

payload:

{
    "datatype_dict": {
        "account_id": "int",
        "active": "int",
        "bid_amount": "varchar(10)",
        "bid_type": "varchar(10)",
        "company_code": "varchar(128)",
        "facility_id": "int",
        "integration_type": "varchar(100)",
        "min_bid": "decimal(6,2)",
        "month_key": "int",
        "origin_key": "varchar",
        "title": "varchar(128)",
        "views": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/bi_account_overview_monthly/2026-04-15/1776242680/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/bi_account_overview_monthly/2026-04-15/1776242680",
        "key": "raw/bi_account_overview_monthly/2026-04-15/1776242680/account_overview_monthly.dat0000_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_bi_account_overview_monthly",
        "type": "redshift"
    }
}

running: False
schema_name_id: 808
start_time: 2026-04-15 03:44:55
success: True
trace_id: 1105276823104863711

Scan 162000760

duration: 0:00:11.878736

exit_message:

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

id: 162000760

payload:

{
    "datatype_dict": {
        "account_id": "int",
        "active": "int",
        "bid_amount": "varchar(10)",
        "bid_type": "varchar(10)",
        "company_code": "varchar(128)",
        "facility_id": "int",
        "integration_type": "varchar(100)",
        "min_bid": "decimal(6,2)",
        "month_key": "int",
        "origin_key": "varchar",
        "title": "varchar(128)",
        "views": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/bi_account_overview_monthly/2026-04-14/1776154878/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/bi_account_overview_monthly/2026-04-14/1776154878",
        "key": "raw/bi_account_overview_monthly/2026-04-14/1776154878/account_overview_monthly.dat0000_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_bi_account_overview_monthly",
        "type": "redshift"
    }
}

running: False
schema_name_id: 808
start_time: 2026-04-14 03:21:45
success: True
trace_id: 7163794772745449481

Scan 161942899

duration: 0:00:14.354742

exit_message:

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

id: 161942899

payload:

{
    "datatype_dict": {
        "account_id": "int",
        "active": "int",
        "bid_amount": "varchar(10)",
        "bid_type": "varchar(10)",
        "company_code": "varchar(128)",
        "facility_id": "int",
        "integration_type": "varchar(100)",
        "min_bid": "decimal(6,2)",
        "month_key": "int",
        "origin_key": "varchar",
        "title": "varchar(128)",
        "views": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/bi_account_overview_monthly/2026-04-13/1776068745/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/bi_account_overview_monthly/2026-04-13/1776068745",
        "key": "raw/bi_account_overview_monthly/2026-04-13/1776068745/account_overview_monthly.dat0000_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_bi_account_overview_monthly",
        "type": "redshift"
    }
}

running: False
schema_name_id: 808
start_time: 2026-04-13 03:25:58
success: True
trace_id: 7744290604630751181

Scan 161893545

duration: 0:04:51.270686

exit_message:

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

id: 161893545

payload:

{
    "datatype_dict": {
        "account_id": "int",
        "active": "int",
        "bid_amount": "varchar(10)",
        "bid_type": "varchar(10)",
        "company_code": "varchar(128)",
        "facility_id": "int",
        "integration_type": "varchar(100)",
        "min_bid": "decimal(6,2)",
        "month_key": "int",
        "origin_key": "varchar",
        "title": "varchar(128)",
        "views": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/bi_account_overview_monthly/2026-04-12/1775981770/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/bi_account_overview_monthly/2026-04-12/1775981770",
        "key": "raw/bi_account_overview_monthly/2026-04-12/1775981770/account_overview_monthly.dat0000_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_bi_account_overview_monthly",
        "type": "redshift"
    }
}

running: False
schema_name_id: 808
start_time: 2026-04-12 03:16:40
success: True
trace_id: 2115016916493487719

Scan 161841325

duration: 0:00:11.732152

exit_message:

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

id: 161841325

payload:

{
    "datatype_dict": {
        "account_id": "int",
        "active": "int",
        "bid_amount": "varchar(10)",
        "bid_type": "varchar(10)",
        "company_code": "varchar(128)",
        "facility_id": "int",
        "integration_type": "varchar(100)",
        "min_bid": "decimal(6,2)",
        "month_key": "int",
        "origin_key": "varchar",
        "title": "varchar(128)",
        "views": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/bi_account_overview_monthly/2026-04-11/1775894955/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/bi_account_overview_monthly/2026-04-11/1775894955",
        "key": "raw/bi_account_overview_monthly/2026-04-11/1775894955/account_overview_monthly.dat0000_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_bi_account_overview_monthly",
        "type": "redshift"
    }
}

running: False
schema_name_id: 808
start_time: 2026-04-11 03:09:32
success: True
trace_id: 6354448428856044613

Scan 161786162

duration: 0:00:11.894414

exit_message:

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

id: 161786162

payload:

{
    "datatype_dict": {
        "account_id": "int",
        "active": "int",
        "bid_amount": "varchar(10)",
        "bid_type": "varchar(10)",
        "company_code": "varchar(128)",
        "facility_id": "int",
        "integration_type": "varchar(100)",
        "min_bid": "decimal(6,2)",
        "month_key": "int",
        "origin_key": "varchar",
        "title": "varchar(128)",
        "views": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/bi_account_overview_monthly/2026-04-10/1775809256/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/bi_account_overview_monthly/2026-04-10/1775809256",
        "key": "raw/bi_account_overview_monthly/2026-04-10/1775809256/account_overview_monthly.dat0000_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_bi_account_overview_monthly",
        "type": "redshift"
    }
}

running: False
schema_name_id: 808
start_time: 2026-04-10 03:21:08
success: True
trace_id: 182792162188604380

Scan 161730596

duration: 0:00:12.069816

exit_message:

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

id: 161730596

payload:

{
    "datatype_dict": {
        "account_id": "int",
        "active": "int",
        "bid_amount": "varchar(10)",
        "bid_type": "varchar(10)",
        "company_code": "varchar(128)",
        "facility_id": "int",
        "integration_type": "varchar(100)",
        "min_bid": "decimal(6,2)",
        "month_key": "int",
        "origin_key": "varchar",
        "title": "varchar(128)",
        "views": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/bi_account_overview_monthly/2026-04-09/1775722714/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/bi_account_overview_monthly/2026-04-09/1775722714",
        "key": "raw/bi_account_overview_monthly/2026-04-09/1775722714/account_overview_monthly.dat0000_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_bi_account_overview_monthly",
        "type": "redshift"
    }
}

running: False
schema_name_id: 808
start_time: 2026-04-09 03:18:43
success: True
trace_id: 1479712698155838920

Scan 161675837

duration: 0:00:12.060899

exit_message:

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

id: 161675837

payload:

{
    "datatype_dict": {
        "account_id": "int",
        "active": "int",
        "bid_amount": "varchar(10)",
        "bid_type": "varchar(10)",
        "company_code": "varchar(128)",
        "facility_id": "int",
        "integration_type": "varchar(100)",
        "min_bid": "decimal(6,2)",
        "month_key": "int",
        "origin_key": "varchar",
        "title": "varchar(128)",
        "views": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/bi_account_overview_monthly/2026-04-08/1775637765/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/bi_account_overview_monthly/2026-04-08/1775637765",
        "key": "raw/bi_account_overview_monthly/2026-04-08/1775637765/account_overview_monthly.dat0000_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_bi_account_overview_monthly",
        "type": "redshift"
    }
}

running: False
schema_name_id: 808
start_time: 2026-04-08 03:42:59
success: True
trace_id: 4691963749359231882

Scan 161619640

duration: 0:00:14.509728

exit_message:

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

id: 161619640

payload:

{
    "datatype_dict": {
        "account_id": "int",
        "active": "int",
        "bid_amount": "varchar(10)",
        "bid_type": "varchar(10)",
        "company_code": "varchar(128)",
        "facility_id": "int",
        "integration_type": "varchar(100)",
        "min_bid": "decimal(6,2)",
        "month_key": "int",
        "origin_key": "varchar",
        "title": "varchar(128)",
        "views": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/bi_account_overview_monthly/2026-04-07/1775549711/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/bi_account_overview_monthly/2026-04-07/1775549711",
        "key": "raw/bi_account_overview_monthly/2026-04-07/1775549711/account_overview_monthly.dat0000_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_bi_account_overview_monthly",
        "type": "redshift"
    }
}

running: False
schema_name_id: 808
start_time: 2026-04-07 03:15:17
success: True
trace_id: 4984349349764588129

Scan 161561835

duration: 0:00:11.809020

exit_message:

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

id: 161561835

payload:

{
    "datatype_dict": {
        "account_id": "int",
        "active": "int",
        "bid_amount": "varchar(10)",
        "bid_type": "varchar(10)",
        "company_code": "varchar(128)",
        "facility_id": "int",
        "integration_type": "varchar(100)",
        "min_bid": "decimal(6,2)",
        "month_key": "int",
        "origin_key": "varchar",
        "title": "varchar(128)",
        "views": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/bi_account_overview_monthly/2026-04-06/1775463337/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/bi_account_overview_monthly/2026-04-06/1775463337",
        "key": "raw/bi_account_overview_monthly/2026-04-06/1775463337/account_overview_monthly.dat0000_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_bi_account_overview_monthly",
        "type": "redshift"
    }
}

running: False
schema_name_id: 808
start_time: 2026-04-06 03:15:42
success: True
trace_id: 4823190818215477833

Scan 161515069

duration: 0:00:11.755162

exit_message:

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

id: 161515069

payload:

{
    "datatype_dict": {
        "account_id": "int",
        "active": "int",
        "bid_amount": "varchar(10)",
        "bid_type": "varchar(10)",
        "company_code": "varchar(128)",
        "facility_id": "int",
        "integration_type": "varchar(100)",
        "min_bid": "decimal(6,2)",
        "month_key": "int",
        "origin_key": "varchar",
        "title": "varchar(128)",
        "views": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/bi_account_overview_monthly/2026-04-05/1775377315/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/bi_account_overview_monthly/2026-04-05/1775377315",
        "key": "raw/bi_account_overview_monthly/2026-04-05/1775377315/account_overview_monthly.dat0000_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_bi_account_overview_monthly",
        "type": "redshift"
    }
}

running: False
schema_name_id: 808
start_time: 2026-04-05 03:22:01
success: True
trace_id: 10242374854979686560

Scan 161460721

duration: 0:00:14.314693

exit_message:

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

id: 161460721

payload:

{
    "datatype_dict": {
        "account_id": "int",
        "active": "int",
        "bid_amount": "varchar(10)",
        "bid_type": "varchar(10)",
        "company_code": "varchar(128)",
        "facility_id": "int",
        "integration_type": "varchar(100)",
        "min_bid": "decimal(6,2)",
        "month_key": "int",
        "origin_key": "varchar",
        "title": "varchar(128)",
        "views": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/bi_account_overview_monthly/2026-04-04/1775291792/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/bi_account_overview_monthly/2026-04-04/1775291792",
        "key": "raw/bi_account_overview_monthly/2026-04-04/1775291792/account_overview_monthly.dat0000_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_bi_account_overview_monthly",
        "type": "redshift"
    }
}

running: False
schema_name_id: 808
start_time: 2026-04-04 03:36:48
success: True
trace_id: 16340599317952523011

Scan 161402113

duration: 0:00:11.791038

exit_message:

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

id: 161402113

payload:

{
    "datatype_dict": {
        "account_id": "int",
        "active": "int",
        "bid_amount": "varchar(10)",
        "bid_type": "varchar(10)",
        "company_code": "varchar(128)",
        "facility_id": "int",
        "integration_type": "varchar(100)",
        "min_bid": "decimal(6,2)",
        "month_key": "int",
        "origin_key": "varchar",
        "title": "varchar(128)",
        "views": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-prod",
            "key": "meta/bi_account_overview_monthly/2026-04-03/1775204416/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-prod",
        "hive_path": "s3://sfdl-redshift-analytics-prod/raw/bi_account_overview_monthly/2026-04-03/1775204416",
        "key": "raw/bi_account_overview_monthly/2026-04-03/1775204416/account_overview_monthly.dat0000_part_00.gz"
    },
    "schema": {
        "name": "sfdl_prod_redshift.analytics_bi_account_overview_monthly",
        "type": "redshift"
    }
}

running: False
schema_name_id: 808
start_time: 2026-04-03 03:21:58
success: True
trace_id: 2027571351550966754

Partitions:

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

Schema:

attributes:

{
    "_origin": "string",
    "account_id": "int",
    "active": "int",
    "bid_amount": "varchar(10)",
    "bid_type": "varchar(10)",
    "company_code": "varchar(128)",
    "facility_id": "int",
    "integration_type": "varchar(100)",
    "min_bid": "decimal(6,2)",
    "month_key": "int",
    "title": "varchar(128)",
    "views": "int"
}

created: 2026-04-17 03:15:33

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_bi_account_overview_monthly`\n(\n `account_id`  int , `facility_id`  int , `month_key`  int , `title`  varchar(128) , `company_code`  varchar(128) , `bid_type`  varchar(10) , `views`  int , `bid_amount`  varchar(10) , `min_bid`  decimal(6,2) , `integration_type`  varchar(100) , `active`  int , `_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/bi_account_overview_monthly/2026-04-17/1776413722'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_bi_account_overview_monthly`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_bi_account_overview_monthly"
}

Server:

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

Raw:

{
    "name": {
        "created": "2020-09-23 14:42:04",
        "disabled": false,
        "format": "raw",
        "id": 808,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_redshift",
            "table": "analytics_bi_account_overview_monthly"
        },
        "type": "redshift"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "_origin": "string",
            "account_id": "int",
            "active": "int",
            "bid_amount": "varchar(10)",
            "bid_type": "varchar(10)",
            "company_code": "varchar(128)",
            "facility_id": "int",
            "integration_type": "varchar(100)",
            "min_bid": "decimal(6,2)",
            "month_key": "int",
            "title": "varchar(128)",
            "views": "int"
        },
        "created": "2026-04-17 03:15:33",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_bi_account_overview_monthly`\n(\n `account_id`  int , `facility_id`  int , `month_key`  int , `title`  varchar(128) , `company_code`  varchar(128) , `bid_type`  varchar(10) , `views`  int , `bid_amount`  varchar(10) , `min_bid`  decimal(6,2) , `integration_type`  varchar(100) , `active`  int , `_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/bi_account_overview_monthly/2026-04-17/1776413722'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_bi_account_overview_monthly`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_bi_account_overview_monthly"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}