Schema Info

Schema Name: sfdl_prod_redshift.sandbox_rosettable_stone_ds_v4_2

created: 2024-05-31 00:23:54
disabled: False
format: raw
id: 1880
is_partitioned: False
is_schema_datatyped: False

name:

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

type: redshift

Schema Versions: 15

Version 1717518

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.sandbox_rosettable_stone_ds_v4_2`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.sandbox_rosettable_stone_ds_v4_2`\n(\n `asset_id_salesforce_only`  string , `current_billing_id`  string , `current_product_status`  string , `facility_id`  string , `facility_match_method`  string , `facility_name`  string , `facility_source`  string , `invoice_label`  string , `invoice_label_agg`  string , `invoice_total`  double , `legacy_billing_id`  string , `month`  date , `next_invoice`  double , `next_invoice_agg`  double , `normalized_country`  string , `normalized_region`  string , `parent_id`  string , `parent_name`  string , `parent_source`  string , `prev_invoice`  double , `prev_invoice_agg`  double , `product`  string , `product_customer_flag`  bigint , `product_data_last_refresh`  date , `product_facility_id`  string , `product_parent_id`  string , `product_raw`  string , `product_source`  string , `site_city`  string , `site_country`  string , `site_state`  string , `site_street`  string , `site_street_city`  string , `site_zip`  string , `table_names`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-sandbox-prod/raw/rosettable_stone_ds_v4_2/2026-04-17/1776405761'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.sandbox_rosettable_stone_ds_v4_2"
]

hive_path: s3://sfdl-redshift-sandbox-prod/raw/rosettable_stone_ds_v4_2/2026-04-17/1776405761
id: 1717518
processed: 1

raw_data:

{
    "asset_id_salesforce_only": "string",
    "current_billing_id": "string",
    "current_product_status": "string",
    "facility_id": "string",
    "facility_match_method": "string",
    "facility_name": "string",
    "facility_source": "string",
    "invoice_label": "string",
    "invoice_label_agg": "string",
    "invoice_total": "double",
    "legacy_billing_id": "string",
    "month": "date32[day]",
    "next_invoice": "double",
    "next_invoice_agg": "double",
    "normalized_country": "string",
    "normalized_region": "string",
    "parent_id": "string",
    "parent_name": "string",
    "parent_source": "string",
    "prev_invoice": "double",
    "prev_invoice_agg": "double",
    "product": "string",
    "product_customer_flag": "int64",
    "product_data_last_refresh": "date32[day]",
    "product_facility_id": "string",
    "product_parent_id": "string",
    "product_raw": "string",
    "product_source": "string",
    "site_city": "string",
    "site_country": "string",
    "site_state": "string",
    "site_street": "string",
    "site_street_city": "string",
    "site_zip": "string",
    "table_names": "string"
}

schema_attributes:

{
    "asset_id_salesforce_only": "string",
    "current_billing_id": "string",
    "current_product_status": "string",
    "facility_id": "string",
    "facility_match_method": "string",
    "facility_name": "string",
    "facility_source": "string",
    "invoice_label": "string",
    "invoice_label_agg": "string",
    "invoice_total": "double",
    "legacy_billing_id": "string",
    "month": "date",
    "next_invoice": "double",
    "next_invoice_agg": "double",
    "normalized_country": "string",
    "normalized_region": "string",
    "parent_id": "string",
    "parent_name": "string",
    "parent_source": "string",
    "prev_invoice": "double",
    "prev_invoice_agg": "double",
    "product": "string",
    "product_customer_flag": "bigint",
    "product_data_last_refresh": "date",
    "product_facility_id": "string",
    "product_parent_id": "string",
    "product_raw": "string",
    "product_source": "string",
    "site_city": "string",
    "site_country": "string",
    "site_state": "string",
    "site_street": "string",
    "site_street_city": "string",
    "site_zip": "string",
    "table_names": "string"
}

schema_name_id: 1880
schema_scan_id: 162165032
updated: 2026-04-17 01:03:19

Version 1716270

created: 2026-04-16 01:04:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.sandbox_rosettable_stone_ds_v4_2`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.sandbox_rosettable_stone_ds_v4_2`\n(\n `asset_id_salesforce_only`  string , `current_billing_id`  string , `current_product_status`  string , `facility_id`  string , `facility_match_method`  string , `facility_name`  string , `facility_source`  string , `invoice_label`  string , `invoice_label_agg`  string , `invoice_total`  double , `legacy_billing_id`  string , `month`  date , `next_invoice`  double , `next_invoice_agg`  double , `normalized_country`  string , `normalized_region`  string , `parent_id`  string , `parent_name`  string , `parent_source`  string , `prev_invoice`  double , `prev_invoice_agg`  double , `product`  string , `product_customer_flag`  bigint , `product_data_last_refresh`  date , `product_facility_id`  string , `product_parent_id`  string , `product_raw`  string , `product_source`  string , `site_city`  string , `site_country`  string , `site_state`  string , `site_street`  string , `site_street_city`  string , `site_zip`  string , `table_names`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-sandbox-prod/raw/rosettable_stone_ds_v4_2/2026-04-16/1776319449'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.sandbox_rosettable_stone_ds_v4_2"
]

hive_path: s3://sfdl-redshift-sandbox-prod/raw/rosettable_stone_ds_v4_2/2026-04-16/1776319449
id: 1716270
processed: 1

raw_data:

{
    "asset_id_salesforce_only": "string",
    "current_billing_id": "string",
    "current_product_status": "string",
    "facility_id": "string",
    "facility_match_method": "string",
    "facility_name": "string",
    "facility_source": "string",
    "invoice_label": "string",
    "invoice_label_agg": "string",
    "invoice_total": "double",
    "legacy_billing_id": "string",
    "month": "date32[day]",
    "next_invoice": "double",
    "next_invoice_agg": "double",
    "normalized_country": "string",
    "normalized_region": "string",
    "parent_id": "string",
    "parent_name": "string",
    "parent_source": "string",
    "prev_invoice": "double",
    "prev_invoice_agg": "double",
    "product": "string",
    "product_customer_flag": "int64",
    "product_data_last_refresh": "date32[day]",
    "product_facility_id": "string",
    "product_parent_id": "string",
    "product_raw": "string",
    "product_source": "string",
    "site_city": "string",
    "site_country": "string",
    "site_state": "string",
    "site_street": "string",
    "site_street_city": "string",
    "site_zip": "string",
    "table_names": "string"
}

schema_attributes:

{
    "asset_id_salesforce_only": "string",
    "current_billing_id": "string",
    "current_product_status": "string",
    "facility_id": "string",
    "facility_match_method": "string",
    "facility_name": "string",
    "facility_source": "string",
    "invoice_label": "string",
    "invoice_label_agg": "string",
    "invoice_total": "double",
    "legacy_billing_id": "string",
    "month": "date",
    "next_invoice": "double",
    "next_invoice_agg": "double",
    "normalized_country": "string",
    "normalized_region": "string",
    "parent_id": "string",
    "parent_name": "string",
    "parent_source": "string",
    "prev_invoice": "double",
    "prev_invoice_agg": "double",
    "product": "string",
    "product_customer_flag": "bigint",
    "product_data_last_refresh": "date",
    "product_facility_id": "string",
    "product_parent_id": "string",
    "product_raw": "string",
    "product_source": "string",
    "site_city": "string",
    "site_country": "string",
    "site_state": "string",
    "site_street": "string",
    "site_street_city": "string",
    "site_zip": "string",
    "table_names": "string"
}

schema_name_id: 1880
schema_scan_id: 162109250
updated: 2026-04-16 01:04:43

Version 1715069

created: 2026-04-15 01:05:43

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.sandbox_rosettable_stone_ds_v4_2`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.sandbox_rosettable_stone_ds_v4_2`\n(\n `asset_id_salesforce_only`  string , `current_billing_id`  string , `current_product_status`  string , `facility_id`  string , `facility_match_method`  string , `facility_name`  string , `facility_source`  string , `invoice_label`  string , `invoice_label_agg`  string , `invoice_total`  double , `legacy_billing_id`  string , `month`  date , `next_invoice`  double , `next_invoice_agg`  double , `normalized_country`  string , `normalized_region`  string , `parent_id`  string , `parent_name`  string , `parent_source`  string , `prev_invoice`  double , `prev_invoice_agg`  double , `product`  string , `product_customer_flag`  bigint , `product_data_last_refresh`  date , `product_facility_id`  string , `product_parent_id`  string , `product_raw`  string , `product_source`  string , `site_city`  string , `site_country`  string , `site_state`  string , `site_street`  string , `site_street_city`  string , `site_zip`  string , `table_names`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-sandbox-prod/raw/rosettable_stone_ds_v4_2/2026-04-15/1776233123'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.sandbox_rosettable_stone_ds_v4_2"
]

hive_path: s3://sfdl-redshift-sandbox-prod/raw/rosettable_stone_ds_v4_2/2026-04-15/1776233123
id: 1715069
processed: 1

raw_data:

{
    "asset_id_salesforce_only": "string",
    "current_billing_id": "string",
    "current_product_status": "string",
    "facility_id": "string",
    "facility_match_method": "string",
    "facility_name": "string",
    "facility_source": "string",
    "invoice_label": "string",
    "invoice_label_agg": "string",
    "invoice_total": "double",
    "legacy_billing_id": "string",
    "month": "date32[day]",
    "next_invoice": "double",
    "next_invoice_agg": "double",
    "normalized_country": "string",
    "normalized_region": "string",
    "parent_id": "string",
    "parent_name": "string",
    "parent_source": "string",
    "prev_invoice": "double",
    "prev_invoice_agg": "double",
    "product": "string",
    "product_customer_flag": "int64",
    "product_data_last_refresh": "date32[day]",
    "product_facility_id": "string",
    "product_parent_id": "string",
    "product_raw": "string",
    "product_source": "string",
    "site_city": "string",
    "site_country": "string",
    "site_state": "string",
    "site_street": "string",
    "site_street_city": "string",
    "site_zip": "string",
    "table_names": "string"
}

schema_attributes:

{
    "asset_id_salesforce_only": "string",
    "current_billing_id": "string",
    "current_product_status": "string",
    "facility_id": "string",
    "facility_match_method": "string",
    "facility_name": "string",
    "facility_source": "string",
    "invoice_label": "string",
    "invoice_label_agg": "string",
    "invoice_total": "double",
    "legacy_billing_id": "string",
    "month": "date",
    "next_invoice": "double",
    "next_invoice_agg": "double",
    "normalized_country": "string",
    "normalized_region": "string",
    "parent_id": "string",
    "parent_name": "string",
    "parent_source": "string",
    "prev_invoice": "double",
    "prev_invoice_agg": "double",
    "product": "string",
    "product_customer_flag": "bigint",
    "product_data_last_refresh": "date",
    "product_facility_id": "string",
    "product_parent_id": "string",
    "product_raw": "string",
    "product_source": "string",
    "site_city": "string",
    "site_country": "string",
    "site_state": "string",
    "site_street": "string",
    "site_street_city": "string",
    "site_zip": "string",
    "table_names": "string"
}

schema_name_id: 1880
schema_scan_id: 162053381
updated: 2026-04-15 01:05:55

Version 1713896

created: 2026-04-14 01:06:23

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.sandbox_rosettable_stone_ds_v4_2`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.sandbox_rosettable_stone_ds_v4_2`\n(\n `asset_id_salesforce_only`  string , `current_billing_id`  string , `current_product_status`  string , `facility_id`  string , `facility_match_method`  string , `facility_name`  string , `facility_source`  string , `invoice_label`  string , `invoice_label_agg`  string , `invoice_total`  double , `legacy_billing_id`  string , `month`  date , `next_invoice`  double , `next_invoice_agg`  double , `normalized_country`  string , `normalized_region`  string , `parent_id`  string , `parent_name`  string , `parent_source`  string , `prev_invoice`  double , `prev_invoice_agg`  double , `product`  string , `product_customer_flag`  bigint , `product_data_last_refresh`  date , `product_facility_id`  string , `product_parent_id`  string , `product_raw`  string , `product_source`  string , `site_city`  string , `site_country`  string , `site_state`  string , `site_street`  string , `site_street_city`  string , `site_zip`  string , `table_names`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-sandbox-prod/raw/rosettable_stone_ds_v4_2/2026-04-14/1776146750'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.sandbox_rosettable_stone_ds_v4_2"
]

hive_path: s3://sfdl-redshift-sandbox-prod/raw/rosettable_stone_ds_v4_2/2026-04-14/1776146750
id: 1713896
processed: 1

raw_data:

{
    "asset_id_salesforce_only": "string",
    "current_billing_id": "string",
    "current_product_status": "string",
    "facility_id": "string",
    "facility_match_method": "string",
    "facility_name": "string",
    "facility_source": "string",
    "invoice_label": "string",
    "invoice_label_agg": "string",
    "invoice_total": "double",
    "legacy_billing_id": "string",
    "month": "date32[day]",
    "next_invoice": "double",
    "next_invoice_agg": "double",
    "normalized_country": "string",
    "normalized_region": "string",
    "parent_id": "string",
    "parent_name": "string",
    "parent_source": "string",
    "prev_invoice": "double",
    "prev_invoice_agg": "double",
    "product": "string",
    "product_customer_flag": "int64",
    "product_data_last_refresh": "date32[day]",
    "product_facility_id": "string",
    "product_parent_id": "string",
    "product_raw": "string",
    "product_source": "string",
    "site_city": "string",
    "site_country": "string",
    "site_state": "string",
    "site_street": "string",
    "site_street_city": "string",
    "site_zip": "string",
    "table_names": "string"
}

schema_attributes:

{
    "asset_id_salesforce_only": "string",
    "current_billing_id": "string",
    "current_product_status": "string",
    "facility_id": "string",
    "facility_match_method": "string",
    "facility_name": "string",
    "facility_source": "string",
    "invoice_label": "string",
    "invoice_label_agg": "string",
    "invoice_total": "double",
    "legacy_billing_id": "string",
    "month": "date",
    "next_invoice": "double",
    "next_invoice_agg": "double",
    "normalized_country": "string",
    "normalized_region": "string",
    "parent_id": "string",
    "parent_name": "string",
    "parent_source": "string",
    "prev_invoice": "double",
    "prev_invoice_agg": "double",
    "product": "string",
    "product_customer_flag": "bigint",
    "product_data_last_refresh": "date",
    "product_facility_id": "string",
    "product_parent_id": "string",
    "product_raw": "string",
    "product_source": "string",
    "site_city": "string",
    "site_country": "string",
    "site_state": "string",
    "site_street": "string",
    "site_street_city": "string",
    "site_zip": "string",
    "table_names": "string"
}

schema_name_id: 1880
schema_scan_id: 161997626
updated: 2026-04-14 01:06:37

Version 1712654

created: 2026-04-13 01:04:48

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.sandbox_rosettable_stone_ds_v4_2`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.sandbox_rosettable_stone_ds_v4_2`\n(\n `asset_id_salesforce_only`  string , `current_billing_id`  string , `current_product_status`  string , `facility_id`  string , `facility_match_method`  string , `facility_name`  string , `facility_source`  string , `invoice_label`  string , `invoice_label_agg`  string , `invoice_total`  double , `legacy_billing_id`  string , `month`  date , `next_invoice`  double , `next_invoice_agg`  double , `normalized_country`  string , `normalized_region`  string , `parent_id`  string , `parent_name`  string , `parent_source`  string , `prev_invoice`  double , `prev_invoice_agg`  double , `product`  string , `product_customer_flag`  bigint , `product_data_last_refresh`  date , `product_facility_id`  string , `product_parent_id`  string , `product_raw`  string , `product_source`  string , `site_city`  string , `site_country`  string , `site_state`  string , `site_street`  string , `site_street_city`  string , `site_zip`  string , `table_names`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-sandbox-prod/raw/rosettable_stone_ds_v4_2/2026-04-13/1776060258'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.sandbox_rosettable_stone_ds_v4_2"
]

hive_path: s3://sfdl-redshift-sandbox-prod/raw/rosettable_stone_ds_v4_2/2026-04-13/1776060258
id: 1712654
processed: 1

raw_data:

{
    "asset_id_salesforce_only": "string",
    "current_billing_id": "string",
    "current_product_status": "string",
    "facility_id": "string",
    "facility_match_method": "string",
    "facility_name": "string",
    "facility_source": "string",
    "invoice_label": "string",
    "invoice_label_agg": "string",
    "invoice_total": "double",
    "legacy_billing_id": "string",
    "month": "date32[day]",
    "next_invoice": "double",
    "next_invoice_agg": "double",
    "normalized_country": "string",
    "normalized_region": "string",
    "parent_id": "string",
    "parent_name": "string",
    "parent_source": "string",
    "prev_invoice": "double",
    "prev_invoice_agg": "double",
    "product": "string",
    "product_customer_flag": "int64",
    "product_data_last_refresh": "date32[day]",
    "product_facility_id": "string",
    "product_parent_id": "string",
    "product_raw": "string",
    "product_source": "string",
    "site_city": "string",
    "site_country": "string",
    "site_state": "string",
    "site_street": "string",
    "site_street_city": "string",
    "site_zip": "string",
    "table_names": "string"
}

schema_attributes:

{
    "asset_id_salesforce_only": "string",
    "current_billing_id": "string",
    "current_product_status": "string",
    "facility_id": "string",
    "facility_match_method": "string",
    "facility_name": "string",
    "facility_source": "string",
    "invoice_label": "string",
    "invoice_label_agg": "string",
    "invoice_total": "double",
    "legacy_billing_id": "string",
    "month": "date",
    "next_invoice": "double",
    "next_invoice_agg": "double",
    "normalized_country": "string",
    "normalized_region": "string",
    "parent_id": "string",
    "parent_name": "string",
    "parent_source": "string",
    "prev_invoice": "double",
    "prev_invoice_agg": "double",
    "product": "string",
    "product_customer_flag": "bigint",
    "product_data_last_refresh": "date",
    "product_facility_id": "string",
    "product_parent_id": "string",
    "product_raw": "string",
    "product_source": "string",
    "site_city": "string",
    "site_country": "string",
    "site_state": "string",
    "site_street": "string",
    "site_street_city": "string",
    "site_zip": "string",
    "table_names": "string"
}

schema_name_id: 1880
schema_scan_id: 161940052
updated: 2026-04-13 01:04:59

Version 1711459

created: 2026-04-12 01:05:59

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.sandbox_rosettable_stone_ds_v4_2`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.sandbox_rosettable_stone_ds_v4_2`\n(\n `asset_id_salesforce_only`  string , `current_billing_id`  string , `current_product_status`  string , `facility_id`  string , `facility_match_method`  string , `facility_name`  string , `facility_source`  string , `invoice_label`  string , `invoice_label_agg`  string , `invoice_total`  double , `legacy_billing_id`  string , `month`  date , `next_invoice`  double , `next_invoice_agg`  double , `normalized_country`  string , `normalized_region`  string , `parent_id`  string , `parent_name`  string , `parent_source`  string , `prev_invoice`  double , `prev_invoice_agg`  double , `product`  string , `product_customer_flag`  bigint , `product_data_last_refresh`  date , `product_facility_id`  string , `product_parent_id`  string , `product_raw`  string , `product_source`  string , `site_city`  string , `site_country`  string , `site_state`  string , `site_street`  string , `site_street_city`  string , `site_zip`  string , `table_names`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-sandbox-prod/raw/rosettable_stone_ds_v4_2/2026-04-12/1775973937'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.sandbox_rosettable_stone_ds_v4_2"
]

hive_path: s3://sfdl-redshift-sandbox-prod/raw/rosettable_stone_ds_v4_2/2026-04-12/1775973937
id: 1711459
processed: 1

raw_data:

{
    "asset_id_salesforce_only": "string",
    "current_billing_id": "string",
    "current_product_status": "string",
    "facility_id": "string",
    "facility_match_method": "string",
    "facility_name": "string",
    "facility_source": "string",
    "invoice_label": "string",
    "invoice_label_agg": "string",
    "invoice_total": "double",
    "legacy_billing_id": "string",
    "month": "date32[day]",
    "next_invoice": "double",
    "next_invoice_agg": "double",
    "normalized_country": "string",
    "normalized_region": "string",
    "parent_id": "string",
    "parent_name": "string",
    "parent_source": "string",
    "prev_invoice": "double",
    "prev_invoice_agg": "double",
    "product": "string",
    "product_customer_flag": "int64",
    "product_data_last_refresh": "date32[day]",
    "product_facility_id": "string",
    "product_parent_id": "string",
    "product_raw": "string",
    "product_source": "string",
    "site_city": "string",
    "site_country": "string",
    "site_state": "string",
    "site_street": "string",
    "site_street_city": "string",
    "site_zip": "string",
    "table_names": "string"
}

schema_attributes:

{
    "asset_id_salesforce_only": "string",
    "current_billing_id": "string",
    "current_product_status": "string",
    "facility_id": "string",
    "facility_match_method": "string",
    "facility_name": "string",
    "facility_source": "string",
    "invoice_label": "string",
    "invoice_label_agg": "string",
    "invoice_total": "double",
    "legacy_billing_id": "string",
    "month": "date",
    "next_invoice": "double",
    "next_invoice_agg": "double",
    "normalized_country": "string",
    "normalized_region": "string",
    "parent_id": "string",
    "parent_name": "string",
    "parent_source": "string",
    "prev_invoice": "double",
    "prev_invoice_agg": "double",
    "product": "string",
    "product_customer_flag": "bigint",
    "product_data_last_refresh": "date",
    "product_facility_id": "string",
    "product_parent_id": "string",
    "product_raw": "string",
    "product_source": "string",
    "site_city": "string",
    "site_country": "string",
    "site_state": "string",
    "site_street": "string",
    "site_street_city": "string",
    "site_zip": "string",
    "table_names": "string"
}

schema_name_id: 1880
schema_scan_id: 161890546
updated: 2026-04-12 01:06:10

Version 1710266

created: 2026-04-11 01:06:01

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.sandbox_rosettable_stone_ds_v4_2`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.sandbox_rosettable_stone_ds_v4_2`\n(\n `asset_id_salesforce_only`  string , `current_billing_id`  string , `current_product_status`  string , `facility_id`  string , `facility_match_method`  string , `facility_name`  string , `facility_source`  string , `invoice_label`  string , `invoice_label_agg`  string , `invoice_total`  double , `legacy_billing_id`  string , `month`  date , `next_invoice`  double , `next_invoice_agg`  double , `normalized_country`  string , `normalized_region`  string , `parent_id`  string , `parent_name`  string , `parent_source`  string , `prev_invoice`  double , `prev_invoice_agg`  double , `product`  string , `product_customer_flag`  bigint , `product_data_last_refresh`  date , `product_facility_id`  string , `product_parent_id`  string , `product_raw`  string , `product_source`  string , `site_city`  string , `site_country`  string , `site_state`  string , `site_street`  string , `site_street_city`  string , `site_zip`  string , `table_names`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-sandbox-prod/raw/rosettable_stone_ds_v4_2/2026-04-11/1775887538'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.sandbox_rosettable_stone_ds_v4_2"
]

hive_path: s3://sfdl-redshift-sandbox-prod/raw/rosettable_stone_ds_v4_2/2026-04-11/1775887538
id: 1710266
processed: 1

raw_data:

{
    "asset_id_salesforce_only": "string",
    "current_billing_id": "string",
    "current_product_status": "string",
    "facility_id": "string",
    "facility_match_method": "string",
    "facility_name": "string",
    "facility_source": "string",
    "invoice_label": "string",
    "invoice_label_agg": "string",
    "invoice_total": "double",
    "legacy_billing_id": "string",
    "month": "date32[day]",
    "next_invoice": "double",
    "next_invoice_agg": "double",
    "normalized_country": "string",
    "normalized_region": "string",
    "parent_id": "string",
    "parent_name": "string",
    "parent_source": "string",
    "prev_invoice": "double",
    "prev_invoice_agg": "double",
    "product": "string",
    "product_customer_flag": "int64",
    "product_data_last_refresh": "date32[day]",
    "product_facility_id": "string",
    "product_parent_id": "string",
    "product_raw": "string",
    "product_source": "string",
    "site_city": "string",
    "site_country": "string",
    "site_state": "string",
    "site_street": "string",
    "site_street_city": "string",
    "site_zip": "string",
    "table_names": "string"
}

schema_attributes:

{
    "asset_id_salesforce_only": "string",
    "current_billing_id": "string",
    "current_product_status": "string",
    "facility_id": "string",
    "facility_match_method": "string",
    "facility_name": "string",
    "facility_source": "string",
    "invoice_label": "string",
    "invoice_label_agg": "string",
    "invoice_total": "double",
    "legacy_billing_id": "string",
    "month": "date",
    "next_invoice": "double",
    "next_invoice_agg": "double",
    "normalized_country": "string",
    "normalized_region": "string",
    "parent_id": "string",
    "parent_name": "string",
    "parent_source": "string",
    "prev_invoice": "double",
    "prev_invoice_agg": "double",
    "product": "string",
    "product_customer_flag": "bigint",
    "product_data_last_refresh": "date",
    "product_facility_id": "string",
    "product_parent_id": "string",
    "product_raw": "string",
    "product_source": "string",
    "site_city": "string",
    "site_country": "string",
    "site_state": "string",
    "site_street": "string",
    "site_street_city": "string",
    "site_zip": "string",
    "table_names": "string"
}

schema_name_id: 1880
schema_scan_id: 161838659
updated: 2026-04-11 01:06:15

Version 1709114

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.sandbox_rosettable_stone_ds_v4_2`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.sandbox_rosettable_stone_ds_v4_2`\n(\n `asset_id_salesforce_only`  string , `current_billing_id`  string , `current_product_status`  string , `facility_id`  string , `facility_match_method`  string , `facility_name`  string , `facility_source`  string , `invoice_label`  string , `invoice_label_agg`  string , `invoice_total`  double , `legacy_billing_id`  string , `month`  date , `next_invoice`  double , `next_invoice_agg`  double , `normalized_country`  string , `normalized_region`  string , `parent_id`  string , `parent_name`  string , `parent_source`  string , `prev_invoice`  double , `prev_invoice_agg`  double , `product`  string , `product_customer_flag`  bigint , `product_data_last_refresh`  date , `product_facility_id`  string , `product_parent_id`  string , `product_raw`  string , `product_source`  string , `site_city`  string , `site_country`  string , `site_state`  string , `site_street`  string , `site_street_city`  string , `site_zip`  string , `table_names`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-sandbox-prod/raw/rosettable_stone_ds_v4_2/2026-04-10/1775801122'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.sandbox_rosettable_stone_ds_v4_2"
]

hive_path: s3://sfdl-redshift-sandbox-prod/raw/rosettable_stone_ds_v4_2/2026-04-10/1775801122
id: 1709114
processed: 1

raw_data:

{
    "asset_id_salesforce_only": "string",
    "current_billing_id": "string",
    "current_product_status": "string",
    "facility_id": "string",
    "facility_match_method": "string",
    "facility_name": "string",
    "facility_source": "string",
    "invoice_label": "string",
    "invoice_label_agg": "string",
    "invoice_total": "double",
    "legacy_billing_id": "string",
    "month": "date32[day]",
    "next_invoice": "double",
    "next_invoice_agg": "double",
    "normalized_country": "string",
    "normalized_region": "string",
    "parent_id": "string",
    "parent_name": "string",
    "parent_source": "string",
    "prev_invoice": "double",
    "prev_invoice_agg": "double",
    "product": "string",
    "product_customer_flag": "int64",
    "product_data_last_refresh": "date32[day]",
    "product_facility_id": "string",
    "product_parent_id": "string",
    "product_raw": "string",
    "product_source": "string",
    "site_city": "string",
    "site_country": "string",
    "site_state": "string",
    "site_street": "string",
    "site_street_city": "string",
    "site_zip": "string",
    "table_names": "string"
}

schema_attributes:

{
    "asset_id_salesforce_only": "string",
    "current_billing_id": "string",
    "current_product_status": "string",
    "facility_id": "string",
    "facility_match_method": "string",
    "facility_name": "string",
    "facility_source": "string",
    "invoice_label": "string",
    "invoice_label_agg": "string",
    "invoice_total": "double",
    "legacy_billing_id": "string",
    "month": "date",
    "next_invoice": "double",
    "next_invoice_agg": "double",
    "normalized_country": "string",
    "normalized_region": "string",
    "parent_id": "string",
    "parent_name": "string",
    "parent_source": "string",
    "prev_invoice": "double",
    "prev_invoice_agg": "double",
    "product": "string",
    "product_customer_flag": "bigint",
    "product_data_last_refresh": "date",
    "product_facility_id": "string",
    "product_parent_id": "string",
    "product_raw": "string",
    "product_source": "string",
    "site_city": "string",
    "site_country": "string",
    "site_state": "string",
    "site_street": "string",
    "site_street_city": "string",
    "site_zip": "string",
    "table_names": "string"
}

schema_name_id: 1880
schema_scan_id: 161783128
updated: 2026-04-10 01:05:56

Version 1707968

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.sandbox_rosettable_stone_ds_v4_2`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.sandbox_rosettable_stone_ds_v4_2`\n(\n `asset_id_salesforce_only`  string , `current_billing_id`  string , `current_product_status`  string , `facility_id`  string , `facility_match_method`  string , `facility_name`  string , `facility_source`  string , `invoice_label`  string , `invoice_label_agg`  string , `invoice_total`  double , `legacy_billing_id`  string , `month`  date , `next_invoice`  double , `next_invoice_agg`  double , `normalized_country`  string , `normalized_region`  string , `parent_id`  string , `parent_name`  string , `parent_source`  string , `prev_invoice`  double , `prev_invoice_agg`  double , `product`  string , `product_customer_flag`  bigint , `product_data_last_refresh`  date , `product_facility_id`  string , `product_parent_id`  string , `product_raw`  string , `product_source`  string , `site_city`  string , `site_country`  string , `site_state`  string , `site_street`  string , `site_street_city`  string , `site_zip`  string , `table_names`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-sandbox-prod/raw/rosettable_stone_ds_v4_2/2026-04-09/1775714593'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.sandbox_rosettable_stone_ds_v4_2"
]

hive_path: s3://sfdl-redshift-sandbox-prod/raw/rosettable_stone_ds_v4_2/2026-04-09/1775714593
id: 1707968
processed: 1

raw_data:

{
    "asset_id_salesforce_only": "string",
    "current_billing_id": "string",
    "current_product_status": "string",
    "facility_id": "string",
    "facility_match_method": "string",
    "facility_name": "string",
    "facility_source": "string",
    "invoice_label": "string",
    "invoice_label_agg": "string",
    "invoice_total": "double",
    "legacy_billing_id": "string",
    "month": "date32[day]",
    "next_invoice": "double",
    "next_invoice_agg": "double",
    "normalized_country": "string",
    "normalized_region": "string",
    "parent_id": "string",
    "parent_name": "string",
    "parent_source": "string",
    "prev_invoice": "double",
    "prev_invoice_agg": "double",
    "product": "string",
    "product_customer_flag": "int64",
    "product_data_last_refresh": "date32[day]",
    "product_facility_id": "string",
    "product_parent_id": "string",
    "product_raw": "string",
    "product_source": "string",
    "site_city": "string",
    "site_country": "string",
    "site_state": "string",
    "site_street": "string",
    "site_street_city": "string",
    "site_zip": "string",
    "table_names": "string"
}

schema_attributes:

{
    "asset_id_salesforce_only": "string",
    "current_billing_id": "string",
    "current_product_status": "string",
    "facility_id": "string",
    "facility_match_method": "string",
    "facility_name": "string",
    "facility_source": "string",
    "invoice_label": "string",
    "invoice_label_agg": "string",
    "invoice_total": "double",
    "legacy_billing_id": "string",
    "month": "date",
    "next_invoice": "double",
    "next_invoice_agg": "double",
    "normalized_country": "string",
    "normalized_region": "string",
    "parent_id": "string",
    "parent_name": "string",
    "parent_source": "string",
    "prev_invoice": "double",
    "prev_invoice_agg": "double",
    "product": "string",
    "product_customer_flag": "bigint",
    "product_data_last_refresh": "date",
    "product_facility_id": "string",
    "product_parent_id": "string",
    "product_raw": "string",
    "product_source": "string",
    "site_city": "string",
    "site_country": "string",
    "site_state": "string",
    "site_street": "string",
    "site_street_city": "string",
    "site_zip": "string",
    "table_names": "string"
}

schema_name_id: 1880
schema_scan_id: 161727947
updated: 2026-04-09 01:03:47

Version 1706740

created: 2026-04-08 01:07:47

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.sandbox_rosettable_stone_ds_v4_2`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.sandbox_rosettable_stone_ds_v4_2`\n(\n `asset_id_salesforce_only`  string , `current_billing_id`  string , `current_product_status`  string , `facility_id`  string , `facility_match_method`  string , `facility_name`  string , `facility_source`  string , `invoice_label`  string , `invoice_label_agg`  string , `invoice_total`  double , `legacy_billing_id`  string , `month`  date , `next_invoice`  double , `next_invoice_agg`  double , `normalized_country`  string , `normalized_region`  string , `parent_id`  string , `parent_name`  string , `parent_source`  string , `prev_invoice`  double , `prev_invoice_agg`  double , `product`  string , `product_customer_flag`  bigint , `product_data_last_refresh`  date , `product_facility_id`  string , `product_parent_id`  string , `product_raw`  string , `product_source`  string , `site_city`  string , `site_country`  string , `site_state`  string , `site_street`  string , `site_street_city`  string , `site_zip`  string , `table_names`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-sandbox-prod/raw/rosettable_stone_ds_v4_2/2026-04-08/1775628442'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.sandbox_rosettable_stone_ds_v4_2"
]

hive_path: s3://sfdl-redshift-sandbox-prod/raw/rosettable_stone_ds_v4_2/2026-04-08/1775628442
id: 1706740
processed: 1

raw_data:

{
    "asset_id_salesforce_only": "string",
    "current_billing_id": "string",
    "current_product_status": "string",
    "facility_id": "string",
    "facility_match_method": "string",
    "facility_name": "string",
    "facility_source": "string",
    "invoice_label": "string",
    "invoice_label_agg": "string",
    "invoice_total": "double",
    "legacy_billing_id": "string",
    "month": "date32[day]",
    "next_invoice": "double",
    "next_invoice_agg": "double",
    "normalized_country": "string",
    "normalized_region": "string",
    "parent_id": "string",
    "parent_name": "string",
    "parent_source": "string",
    "prev_invoice": "double",
    "prev_invoice_agg": "double",
    "product": "string",
    "product_customer_flag": "int64",
    "product_data_last_refresh": "date32[day]",
    "product_facility_id": "string",
    "product_parent_id": "string",
    "product_raw": "string",
    "product_source": "string",
    "site_city": "string",
    "site_country": "string",
    "site_state": "string",
    "site_street": "string",
    "site_street_city": "string",
    "site_zip": "string",
    "table_names": "string"
}

schema_attributes:

{
    "asset_id_salesforce_only": "string",
    "current_billing_id": "string",
    "current_product_status": "string",
    "facility_id": "string",
    "facility_match_method": "string",
    "facility_name": "string",
    "facility_source": "string",
    "invoice_label": "string",
    "invoice_label_agg": "string",
    "invoice_total": "double",
    "legacy_billing_id": "string",
    "month": "date",
    "next_invoice": "double",
    "next_invoice_agg": "double",
    "normalized_country": "string",
    "normalized_region": "string",
    "parent_id": "string",
    "parent_name": "string",
    "parent_source": "string",
    "prev_invoice": "double",
    "prev_invoice_agg": "double",
    "product": "string",
    "product_customer_flag": "bigint",
    "product_data_last_refresh": "date",
    "product_facility_id": "string",
    "product_parent_id": "string",
    "product_raw": "string",
    "product_source": "string",
    "site_city": "string",
    "site_country": "string",
    "site_state": "string",
    "site_street": "string",
    "site_street_city": "string",
    "site_zip": "string",
    "table_names": "string"
}

schema_name_id: 1880
schema_scan_id: 161672786
updated: 2026-04-08 01:08:01

Version 1705580

created: 2026-04-07 01:12:43

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.sandbox_rosettable_stone_ds_v4_2`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.sandbox_rosettable_stone_ds_v4_2`\n(\n `asset_id_salesforce_only`  string , `current_billing_id`  string , `current_product_status`  string , `facility_id`  string , `facility_match_method`  string , `facility_name`  string , `facility_source`  string , `invoice_label`  string , `invoice_label_agg`  string , `invoice_total`  double , `legacy_billing_id`  string , `month`  date , `next_invoice`  double , `next_invoice_agg`  double , `normalized_country`  string , `normalized_region`  string , `parent_id`  string , `parent_name`  string , `parent_source`  string , `prev_invoice`  double , `prev_invoice_agg`  double , `product`  string , `product_customer_flag`  bigint , `product_data_last_refresh`  date , `product_facility_id`  string , `product_parent_id`  string , `product_raw`  string , `product_source`  string , `site_city`  string , `site_country`  string , `site_state`  string , `site_street`  string , `site_street_city`  string , `site_zip`  string , `table_names`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-sandbox-prod/raw/rosettable_stone_ds_v4_2/2026-04-07/1775542342'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.sandbox_rosettable_stone_ds_v4_2"
]

hive_path: s3://sfdl-redshift-sandbox-prod/raw/rosettable_stone_ds_v4_2/2026-04-07/1775542342
id: 1705580
processed: 1

raw_data:

{
    "asset_id_salesforce_only": "string",
    "current_billing_id": "string",
    "current_product_status": "string",
    "facility_id": "string",
    "facility_match_method": "string",
    "facility_name": "string",
    "facility_source": "string",
    "invoice_label": "string",
    "invoice_label_agg": "string",
    "invoice_total": "double",
    "legacy_billing_id": "string",
    "month": "date32[day]",
    "next_invoice": "double",
    "next_invoice_agg": "double",
    "normalized_country": "string",
    "normalized_region": "string",
    "parent_id": "string",
    "parent_name": "string",
    "parent_source": "string",
    "prev_invoice": "double",
    "prev_invoice_agg": "double",
    "product": "string",
    "product_customer_flag": "int64",
    "product_data_last_refresh": "date32[day]",
    "product_facility_id": "string",
    "product_parent_id": "string",
    "product_raw": "string",
    "product_source": "string",
    "site_city": "string",
    "site_country": "string",
    "site_state": "string",
    "site_street": "string",
    "site_street_city": "string",
    "site_zip": "string",
    "table_names": "string"
}

schema_attributes:

{
    "asset_id_salesforce_only": "string",
    "current_billing_id": "string",
    "current_product_status": "string",
    "facility_id": "string",
    "facility_match_method": "string",
    "facility_name": "string",
    "facility_source": "string",
    "invoice_label": "string",
    "invoice_label_agg": "string",
    "invoice_total": "double",
    "legacy_billing_id": "string",
    "month": "date",
    "next_invoice": "double",
    "next_invoice_agg": "double",
    "normalized_country": "string",
    "normalized_region": "string",
    "parent_id": "string",
    "parent_name": "string",
    "parent_source": "string",
    "prev_invoice": "double",
    "prev_invoice_agg": "double",
    "product": "string",
    "product_customer_flag": "bigint",
    "product_data_last_refresh": "date",
    "product_facility_id": "string",
    "product_parent_id": "string",
    "product_raw": "string",
    "product_source": "string",
    "site_city": "string",
    "site_country": "string",
    "site_state": "string",
    "site_street": "string",
    "site_street_city": "string",
    "site_zip": "string",
    "table_names": "string"
}

schema_name_id: 1880
schema_scan_id: 161616741
updated: 2026-04-07 01:12:57

Version 1704335

created: 2026-04-06 01:03:30

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.sandbox_rosettable_stone_ds_v4_2`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.sandbox_rosettable_stone_ds_v4_2`\n(\n `asset_id_salesforce_only`  string , `current_billing_id`  string , `current_product_status`  string , `facility_id`  string , `facility_match_method`  string , `facility_name`  string , `facility_source`  string , `invoice_label`  string , `invoice_label_agg`  string , `invoice_total`  double , `legacy_billing_id`  string , `month`  date , `next_invoice`  double , `next_invoice_agg`  double , `normalized_country`  string , `normalized_region`  string , `parent_id`  string , `parent_name`  string , `parent_source`  string , `prev_invoice`  double , `prev_invoice_agg`  double , `product`  string , `product_customer_flag`  bigint , `product_data_last_refresh`  date , `product_facility_id`  string , `product_parent_id`  string , `product_raw`  string , `product_source`  string , `site_city`  string , `site_country`  string , `site_state`  string , `site_street`  string , `site_street_city`  string , `site_zip`  string , `table_names`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-sandbox-prod/raw/rosettable_stone_ds_v4_2/2026-04-06/1775455370'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.sandbox_rosettable_stone_ds_v4_2"
]

hive_path: s3://sfdl-redshift-sandbox-prod/raw/rosettable_stone_ds_v4_2/2026-04-06/1775455370
id: 1704335
processed: 1

raw_data:

{
    "asset_id_salesforce_only": "string",
    "current_billing_id": "string",
    "current_product_status": "string",
    "facility_id": "string",
    "facility_match_method": "string",
    "facility_name": "string",
    "facility_source": "string",
    "invoice_label": "string",
    "invoice_label_agg": "string",
    "invoice_total": "double",
    "legacy_billing_id": "string",
    "month": "date32[day]",
    "next_invoice": "double",
    "next_invoice_agg": "double",
    "normalized_country": "string",
    "normalized_region": "string",
    "parent_id": "string",
    "parent_name": "string",
    "parent_source": "string",
    "prev_invoice": "double",
    "prev_invoice_agg": "double",
    "product": "string",
    "product_customer_flag": "int64",
    "product_data_last_refresh": "date32[day]",
    "product_facility_id": "string",
    "product_parent_id": "string",
    "product_raw": "string",
    "product_source": "string",
    "site_city": "string",
    "site_country": "string",
    "site_state": "string",
    "site_street": "string",
    "site_street_city": "string",
    "site_zip": "string",
    "table_names": "string"
}

schema_attributes:

{
    "asset_id_salesforce_only": "string",
    "current_billing_id": "string",
    "current_product_status": "string",
    "facility_id": "string",
    "facility_match_method": "string",
    "facility_name": "string",
    "facility_source": "string",
    "invoice_label": "string",
    "invoice_label_agg": "string",
    "invoice_total": "double",
    "legacy_billing_id": "string",
    "month": "date",
    "next_invoice": "double",
    "next_invoice_agg": "double",
    "normalized_country": "string",
    "normalized_region": "string",
    "parent_id": "string",
    "parent_name": "string",
    "parent_source": "string",
    "prev_invoice": "double",
    "prev_invoice_agg": "double",
    "product": "string",
    "product_customer_flag": "bigint",
    "product_data_last_refresh": "date",
    "product_facility_id": "string",
    "product_parent_id": "string",
    "product_raw": "string",
    "product_source": "string",
    "site_city": "string",
    "site_country": "string",
    "site_state": "string",
    "site_street": "string",
    "site_street_city": "string",
    "site_zip": "string",
    "table_names": "string"
}

schema_name_id: 1880
schema_scan_id: 161558764
updated: 2026-04-06 01:03:41

Version 1703159

created: 2026-04-05 01:03:16

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.sandbox_rosettable_stone_ds_v4_2`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.sandbox_rosettable_stone_ds_v4_2`\n(\n `asset_id_salesforce_only`  string , `current_billing_id`  string , `current_product_status`  string , `facility_id`  string , `facility_match_method`  string , `facility_name`  string , `facility_source`  string , `invoice_label`  string , `invoice_label_agg`  string , `invoice_total`  double , `legacy_billing_id`  string , `month`  date , `next_invoice`  double , `next_invoice_agg`  double , `normalized_country`  string , `normalized_region`  string , `parent_id`  string , `parent_name`  string , `parent_source`  string , `prev_invoice`  double , `prev_invoice_agg`  double , `product`  string , `product_customer_flag`  bigint , `product_data_last_refresh`  date , `product_facility_id`  string , `product_parent_id`  string , `product_raw`  string , `product_source`  string , `site_city`  string , `site_country`  string , `site_state`  string , `site_street`  string , `site_street_city`  string , `site_zip`  string , `table_names`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-sandbox-prod/raw/rosettable_stone_ds_v4_2/2026-04-05/1775368972'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.sandbox_rosettable_stone_ds_v4_2"
]

hive_path: s3://sfdl-redshift-sandbox-prod/raw/rosettable_stone_ds_v4_2/2026-04-05/1775368972
id: 1703159
processed: 1

raw_data:

{
    "asset_id_salesforce_only": "string",
    "current_billing_id": "string",
    "current_product_status": "string",
    "facility_id": "string",
    "facility_match_method": "string",
    "facility_name": "string",
    "facility_source": "string",
    "invoice_label": "string",
    "invoice_label_agg": "string",
    "invoice_total": "double",
    "legacy_billing_id": "string",
    "month": "date32[day]",
    "next_invoice": "double",
    "next_invoice_agg": "double",
    "normalized_country": "string",
    "normalized_region": "string",
    "parent_id": "string",
    "parent_name": "string",
    "parent_source": "string",
    "prev_invoice": "double",
    "prev_invoice_agg": "double",
    "product": "string",
    "product_customer_flag": "int64",
    "product_data_last_refresh": "date32[day]",
    "product_facility_id": "string",
    "product_parent_id": "string",
    "product_raw": "string",
    "product_source": "string",
    "site_city": "string",
    "site_country": "string",
    "site_state": "string",
    "site_street": "string",
    "site_street_city": "string",
    "site_zip": "string",
    "table_names": "string"
}

schema_attributes:

{
    "asset_id_salesforce_only": "string",
    "current_billing_id": "string",
    "current_product_status": "string",
    "facility_id": "string",
    "facility_match_method": "string",
    "facility_name": "string",
    "facility_source": "string",
    "invoice_label": "string",
    "invoice_label_agg": "string",
    "invoice_total": "double",
    "legacy_billing_id": "string",
    "month": "date",
    "next_invoice": "double",
    "next_invoice_agg": "double",
    "normalized_country": "string",
    "normalized_region": "string",
    "parent_id": "string",
    "parent_name": "string",
    "parent_source": "string",
    "prev_invoice": "double",
    "prev_invoice_agg": "double",
    "product": "string",
    "product_customer_flag": "bigint",
    "product_data_last_refresh": "date",
    "product_facility_id": "string",
    "product_parent_id": "string",
    "product_raw": "string",
    "product_source": "string",
    "site_city": "string",
    "site_country": "string",
    "site_state": "string",
    "site_street": "string",
    "site_street_city": "string",
    "site_zip": "string",
    "table_names": "string"
}

schema_name_id: 1880
schema_scan_id: 161512407
updated: 2026-04-05 01:03:30

Version 1701982

created: 2026-04-04 01:03:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.sandbox_rosettable_stone_ds_v4_2`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.sandbox_rosettable_stone_ds_v4_2`\n(\n `asset_id_salesforce_only`  string , `current_billing_id`  string , `current_product_status`  string , `facility_id`  string , `facility_match_method`  string , `facility_name`  string , `facility_source`  string , `invoice_label`  string , `invoice_label_agg`  string , `invoice_total`  double , `legacy_billing_id`  string , `month`  date , `next_invoice`  double , `next_invoice_agg`  double , `normalized_country`  string , `normalized_region`  string , `parent_id`  string , `parent_name`  string , `parent_source`  string , `prev_invoice`  double , `prev_invoice_agg`  double , `product`  string , `product_customer_flag`  bigint , `product_data_last_refresh`  date , `product_facility_id`  string , `product_parent_id`  string , `product_raw`  string , `product_source`  string , `site_city`  string , `site_country`  string , `site_state`  string , `site_street`  string , `site_street_city`  string , `site_zip`  string , `table_names`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-sandbox-prod/raw/rosettable_stone_ds_v4_2/2026-04-04/1775282594'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.sandbox_rosettable_stone_ds_v4_2"
]

hive_path: s3://sfdl-redshift-sandbox-prod/raw/rosettable_stone_ds_v4_2/2026-04-04/1775282594
id: 1701982
processed: 1

raw_data:

{
    "asset_id_salesforce_only": "string",
    "current_billing_id": "string",
    "current_product_status": "string",
    "facility_id": "string",
    "facility_match_method": "string",
    "facility_name": "string",
    "facility_source": "string",
    "invoice_label": "string",
    "invoice_label_agg": "string",
    "invoice_total": "double",
    "legacy_billing_id": "string",
    "month": "date32[day]",
    "next_invoice": "double",
    "next_invoice_agg": "double",
    "normalized_country": "string",
    "normalized_region": "string",
    "parent_id": "string",
    "parent_name": "string",
    "parent_source": "string",
    "prev_invoice": "double",
    "prev_invoice_agg": "double",
    "product": "string",
    "product_customer_flag": "int64",
    "product_data_last_refresh": "date32[day]",
    "product_facility_id": "string",
    "product_parent_id": "string",
    "product_raw": "string",
    "product_source": "string",
    "site_city": "string",
    "site_country": "string",
    "site_state": "string",
    "site_street": "string",
    "site_street_city": "string",
    "site_zip": "string",
    "table_names": "string"
}

schema_attributes:

{
    "asset_id_salesforce_only": "string",
    "current_billing_id": "string",
    "current_product_status": "string",
    "facility_id": "string",
    "facility_match_method": "string",
    "facility_name": "string",
    "facility_source": "string",
    "invoice_label": "string",
    "invoice_label_agg": "string",
    "invoice_total": "double",
    "legacy_billing_id": "string",
    "month": "date",
    "next_invoice": "double",
    "next_invoice_agg": "double",
    "normalized_country": "string",
    "normalized_region": "string",
    "parent_id": "string",
    "parent_name": "string",
    "parent_source": "string",
    "prev_invoice": "double",
    "prev_invoice_agg": "double",
    "product": "string",
    "product_customer_flag": "bigint",
    "product_data_last_refresh": "date",
    "product_facility_id": "string",
    "product_parent_id": "string",
    "product_raw": "string",
    "product_source": "string",
    "site_city": "string",
    "site_country": "string",
    "site_state": "string",
    "site_street": "string",
    "site_street_city": "string",
    "site_zip": "string",
    "table_names": "string"
}

schema_name_id: 1880
schema_scan_id: 161457425
updated: 2026-04-04 01:03:46

Version 1700774

created: 2026-04-03 01:06:10

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.sandbox_rosettable_stone_ds_v4_2`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.sandbox_rosettable_stone_ds_v4_2`\n(\n `asset_id_salesforce_only`  string , `current_billing_id`  string , `current_product_status`  string , `facility_id`  string , `facility_match_method`  string , `facility_name`  string , `facility_source`  string , `invoice_label`  string , `invoice_label_agg`  string , `invoice_total`  double , `legacy_billing_id`  string , `month`  date , `next_invoice`  double , `next_invoice_agg`  double , `normalized_country`  string , `normalized_region`  string , `parent_id`  string , `parent_name`  string , `parent_source`  string , `prev_invoice`  double , `prev_invoice_agg`  double , `product`  string , `product_customer_flag`  bigint , `product_data_last_refresh`  date , `product_facility_id`  string , `product_parent_id`  string , `product_raw`  string , `product_source`  string , `site_city`  string , `site_country`  string , `site_state`  string , `site_street`  string , `site_street_city`  string , `site_zip`  string , `table_names`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-sandbox-prod/raw/rosettable_stone_ds_v4_2/2026-04-03/1775196350'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.sandbox_rosettable_stone_ds_v4_2"
]

hive_path: s3://sfdl-redshift-sandbox-prod/raw/rosettable_stone_ds_v4_2/2026-04-03/1775196350
id: 1700774
processed: 1

raw_data:

{
    "asset_id_salesforce_only": "string",
    "current_billing_id": "string",
    "current_product_status": "string",
    "facility_id": "string",
    "facility_match_method": "string",
    "facility_name": "string",
    "facility_source": "string",
    "invoice_label": "string",
    "invoice_label_agg": "string",
    "invoice_total": "double",
    "legacy_billing_id": "string",
    "month": "date32[day]",
    "next_invoice": "double",
    "next_invoice_agg": "double",
    "normalized_country": "string",
    "normalized_region": "string",
    "parent_id": "string",
    "parent_name": "string",
    "parent_source": "string",
    "prev_invoice": "double",
    "prev_invoice_agg": "double",
    "product": "string",
    "product_customer_flag": "int64",
    "product_data_last_refresh": "date32[day]",
    "product_facility_id": "string",
    "product_parent_id": "string",
    "product_raw": "string",
    "product_source": "string",
    "site_city": "string",
    "site_country": "string",
    "site_state": "string",
    "site_street": "string",
    "site_street_city": "string",
    "site_zip": "string",
    "table_names": "string"
}

schema_attributes:

{
    "asset_id_salesforce_only": "string",
    "current_billing_id": "string",
    "current_product_status": "string",
    "facility_id": "string",
    "facility_match_method": "string",
    "facility_name": "string",
    "facility_source": "string",
    "invoice_label": "string",
    "invoice_label_agg": "string",
    "invoice_total": "double",
    "legacy_billing_id": "string",
    "month": "date",
    "next_invoice": "double",
    "next_invoice_agg": "double",
    "normalized_country": "string",
    "normalized_region": "string",
    "parent_id": "string",
    "parent_name": "string",
    "parent_source": "string",
    "prev_invoice": "double",
    "prev_invoice_agg": "double",
    "product": "string",
    "product_customer_flag": "bigint",
    "product_data_last_refresh": "date",
    "product_facility_id": "string",
    "product_parent_id": "string",
    "product_raw": "string",
    "product_source": "string",
    "site_city": "string",
    "site_country": "string",
    "site_state": "string",
    "site_street": "string",
    "site_street_city": "string",
    "site_zip": "string",
    "table_names": "string"
}

schema_name_id: 1880
schema_scan_id: 161398679
updated: 2026-04-03 01:06:21

Schema Scans: 15

Last at 2026-04-17 01:03:06

Scan 162165032

duration: 0:00:12.618514

exit_message:

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

id: 162165032

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-redshift-sandbox-prod",
        "hive_path": "s3://sfdl-redshift-sandbox-prod/raw/rosettable_stone_ds_v4_2/2026-04-17/1776405761",
        "key": "raw/rosettable_stone_ds_v4_2/2026-04-17/1776405761/0007_part_00.parquet"
    },
    "schema": {
        "name": "sfdl_prod_redshift.sandbox_rosettable_stone_ds_v4_2",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 8413813567423463069,
        "service_name": "drive-thru",
        "span_id": 5666496659437920020,
        "trace_id": 10676930606731251658
    }
}

running: False
schema_name_id: 1880
start_time: 2026-04-17 01:03:06
success: True
trace_id: 10676930606731251658

Scan 162109250

duration: 0:00:12.693726

exit_message:

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

id: 162109250

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-redshift-sandbox-prod",
        "hive_path": "s3://sfdl-redshift-sandbox-prod/raw/rosettable_stone_ds_v4_2/2026-04-16/1776319449",
        "key": "raw/rosettable_stone_ds_v4_2/2026-04-16/1776319449/0007_part_00.parquet"
    },
    "schema": {
        "name": "sfdl_prod_redshift.sandbox_rosettable_stone_ds_v4_2",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 11655782647805901307,
        "service_name": "drive-thru",
        "span_id": 3624206507157219969,
        "trace_id": 4560292079449587107
    }
}

running: False
schema_name_id: 1880
start_time: 2026-04-16 01:04:30
success: True
trace_id: 4560292079449587107

Scan 162053381

duration: 0:00:12.543451

exit_message:

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

id: 162053381

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-redshift-sandbox-prod",
        "hive_path": "s3://sfdl-redshift-sandbox-prod/raw/rosettable_stone_ds_v4_2/2026-04-15/1776233123",
        "key": "raw/rosettable_stone_ds_v4_2/2026-04-15/1776233123/0007_part_00.parquet"
    },
    "schema": {
        "name": "sfdl_prod_redshift.sandbox_rosettable_stone_ds_v4_2",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 11642820156400405937,
        "service_name": "drive-thru",
        "span_id": 6812630813782965449,
        "trace_id": 14725328272837539575
    }
}

running: False
schema_name_id: 1880
start_time: 2026-04-15 01:05:42
success: True
trace_id: 14725328272837539575

Scan 161997626

duration: 0:00:15.055865

exit_message:

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

id: 161997626

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-redshift-sandbox-prod",
        "hive_path": "s3://sfdl-redshift-sandbox-prod/raw/rosettable_stone_ds_v4_2/2026-04-14/1776146750",
        "key": "raw/rosettable_stone_ds_v4_2/2026-04-14/1776146750/0007_part_00.parquet"
    },
    "schema": {
        "name": "sfdl_prod_redshift.sandbox_rosettable_stone_ds_v4_2",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 12090258099534070595,
        "service_name": "drive-thru",
        "span_id": 18182771374530586524,
        "trace_id": 1051853742734846133
    }
}

running: False
schema_name_id: 1880
start_time: 2026-04-14 01:06:22
success: True
trace_id: 1051853742734846133

Scan 161940052

duration: 0:00:12.588600

exit_message:

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

id: 161940052

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-redshift-sandbox-prod",
        "hive_path": "s3://sfdl-redshift-sandbox-prod/raw/rosettable_stone_ds_v4_2/2026-04-13/1776060258",
        "key": "raw/rosettable_stone_ds_v4_2/2026-04-13/1776060258/0007_part_00.parquet"
    },
    "schema": {
        "name": "sfdl_prod_redshift.sandbox_rosettable_stone_ds_v4_2",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 17834776631065031969,
        "service_name": "drive-thru",
        "span_id": 2195319450935793079,
        "trace_id": 14818747367729938360
    }
}

running: False
schema_name_id: 1880
start_time: 2026-04-13 01:04:46
success: True
trace_id: 14818747367729938360

Scan 161890546

duration: 0:00:12.506316

exit_message:

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

id: 161890546

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-redshift-sandbox-prod",
        "hive_path": "s3://sfdl-redshift-sandbox-prod/raw/rosettable_stone_ds_v4_2/2026-04-12/1775973937",
        "key": "raw/rosettable_stone_ds_v4_2/2026-04-12/1775973937/0007_part_00.parquet"
    },
    "schema": {
        "name": "sfdl_prod_redshift.sandbox_rosettable_stone_ds_v4_2",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 10440185962508542376,
        "service_name": "drive-thru",
        "span_id": 343091111177872152,
        "trace_id": 17566810864964763231
    }
}

running: False
schema_name_id: 1880
start_time: 2026-04-12 01:05:58
success: True
trace_id: 17566810864964763231

Scan 161838659

duration: 0:00:15.113236

exit_message:

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

id: 161838659

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-redshift-sandbox-prod",
        "hive_path": "s3://sfdl-redshift-sandbox-prod/raw/rosettable_stone_ds_v4_2/2026-04-11/1775887538",
        "key": "raw/rosettable_stone_ds_v4_2/2026-04-11/1775887538/0007_part_00.parquet"
    },
    "schema": {
        "name": "sfdl_prod_redshift.sandbox_rosettable_stone_ds_v4_2",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 11551637901823579552,
        "service_name": "drive-thru",
        "span_id": 14966264443750819495,
        "trace_id": 13732600224801359648
    }
}

running: False
schema_name_id: 1880
start_time: 2026-04-11 01:06:00
success: True
trace_id: 13732600224801359648

Scan 161783128

duration: 0:00:12.623058

exit_message:

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

id: 161783128

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-redshift-sandbox-prod",
        "hive_path": "s3://sfdl-redshift-sandbox-prod/raw/rosettable_stone_ds_v4_2/2026-04-10/1775801122",
        "key": "raw/rosettable_stone_ds_v4_2/2026-04-10/1775801122/0007_part_00.parquet"
    },
    "schema": {
        "name": "sfdl_prod_redshift.sandbox_rosettable_stone_ds_v4_2",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 15798180662024284198,
        "service_name": "drive-thru",
        "span_id": 160428480941807820,
        "trace_id": 16142472560553357249
    }
}

running: False
schema_name_id: 1880
start_time: 2026-04-10 01:05:43
success: True
trace_id: 16142472560553357249

Scan 161727947

duration: 0:00:15.066194

exit_message:

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

id: 161727947

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-redshift-sandbox-prod",
        "hive_path": "s3://sfdl-redshift-sandbox-prod/raw/rosettable_stone_ds_v4_2/2026-04-09/1775714593",
        "key": "raw/rosettable_stone_ds_v4_2/2026-04-09/1775714593/0007_part_00.parquet"
    },
    "schema": {
        "name": "sfdl_prod_redshift.sandbox_rosettable_stone_ds_v4_2",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 18011988380455669082,
        "service_name": "drive-thru",
        "span_id": 8924042566237997385,
        "trace_id": 16426430002036722401
    }
}

running: False
schema_name_id: 1880
start_time: 2026-04-09 01:03:32
success: True
trace_id: 16426430002036722401

Scan 161672786

duration: 0:00:14.984079

exit_message:

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

id: 161672786

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-redshift-sandbox-prod",
        "hive_path": "s3://sfdl-redshift-sandbox-prod/raw/rosettable_stone_ds_v4_2/2026-04-08/1775628442",
        "key": "raw/rosettable_stone_ds_v4_2/2026-04-08/1775628442/0007_part_00.parquet"
    },
    "schema": {
        "name": "sfdl_prod_redshift.sandbox_rosettable_stone_ds_v4_2",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 17329754797448644636,
        "service_name": "drive-thru",
        "span_id": 7528983321233869129,
        "trace_id": 1624955812411348243
    }
}

running: False
schema_name_id: 1880
start_time: 2026-04-08 01:07:46
success: True
trace_id: 1624955812411348243

Scan 161616741

duration: 0:00:15.088909

exit_message:

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

id: 161616741

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-redshift-sandbox-prod",
        "hive_path": "s3://sfdl-redshift-sandbox-prod/raw/rosettable_stone_ds_v4_2/2026-04-07/1775542342",
        "key": "raw/rosettable_stone_ds_v4_2/2026-04-07/1775542342/0007_part_00.parquet"
    },
    "schema": {
        "name": "sfdl_prod_redshift.sandbox_rosettable_stone_ds_v4_2",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 370940404641212722,
        "service_name": "drive-thru",
        "span_id": 1029947086756463818,
        "trace_id": 11883530405624989966
    }
}

running: False
schema_name_id: 1880
start_time: 2026-04-07 01:12:42
success: True
trace_id: 11883530405624989966

Scan 161558764

duration: 0:00:12.722493

exit_message:

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

id: 161558764

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-redshift-sandbox-prod",
        "hive_path": "s3://sfdl-redshift-sandbox-prod/raw/rosettable_stone_ds_v4_2/2026-04-06/1775455370",
        "key": "raw/rosettable_stone_ds_v4_2/2026-04-06/1775455370/0007_part_00.parquet"
    },
    "schema": {
        "name": "sfdl_prod_redshift.sandbox_rosettable_stone_ds_v4_2",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 12707536820891468226,
        "service_name": "drive-thru",
        "span_id": 16613647918960557140,
        "trace_id": 14693139723599048924
    }
}

running: False
schema_name_id: 1880
start_time: 2026-04-06 01:03:29
success: True
trace_id: 14693139723599048924

Scan 161512407

duration: 0:00:15.121731

exit_message:

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

id: 161512407

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-redshift-sandbox-prod",
        "hive_path": "s3://sfdl-redshift-sandbox-prod/raw/rosettable_stone_ds_v4_2/2026-04-05/1775368972",
        "key": "raw/rosettable_stone_ds_v4_2/2026-04-05/1775368972/0007_part_00.parquet"
    },
    "schema": {
        "name": "sfdl_prod_redshift.sandbox_rosettable_stone_ds_v4_2",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 18404129487166845365,
        "service_name": "drive-thru",
        "span_id": 3445810679471961503,
        "trace_id": 1791672164445066346
    }
}

running: False
schema_name_id: 1880
start_time: 2026-04-05 01:03:15
success: True
trace_id: 1791672164445066346

Scan 161457425

duration: 0:00:15.064922

exit_message:

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

id: 161457425

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-redshift-sandbox-prod",
        "hive_path": "s3://sfdl-redshift-sandbox-prod/raw/rosettable_stone_ds_v4_2/2026-04-04/1775282594",
        "key": "raw/rosettable_stone_ds_v4_2/2026-04-04/1775282594/0007_part_00.parquet"
    },
    "schema": {
        "name": "sfdl_prod_redshift.sandbox_rosettable_stone_ds_v4_2",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 5498474283881637814,
        "service_name": "drive-thru",
        "span_id": 4259725126514379765,
        "trace_id": 1205033902002178768
    }
}

running: False
schema_name_id: 1880
start_time: 2026-04-04 01:03:31
success: True
trace_id: 1205033902002178768

Scan 161398679

duration: 0:00:12.637775

exit_message:

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

id: 161398679

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-redshift-sandbox-prod",
        "hive_path": "s3://sfdl-redshift-sandbox-prod/raw/rosettable_stone_ds_v4_2/2026-04-03/1775196350",
        "key": "raw/rosettable_stone_ds_v4_2/2026-04-03/1775196350/0007_part_00.parquet"
    },
    "schema": {
        "name": "sfdl_prod_redshift.sandbox_rosettable_stone_ds_v4_2",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 12406144005271693975,
        "service_name": "drive-thru",
        "span_id": 7891135249724686212,
        "trace_id": 13155619986310062753
    }
}

running: False
schema_name_id: 1880
start_time: 2026-04-03 01:06:09
success: True
trace_id: 13155619986310062753

Partitions:

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

Schema:

attributes:

{
    "asset_id_salesforce_only": "string",
    "current_billing_id": "string",
    "current_product_status": "string",
    "facility_id": "string",
    "facility_match_method": "string",
    "facility_name": "string",
    "facility_source": "string",
    "invoice_label": "string",
    "invoice_label_agg": "string",
    "invoice_total": "double",
    "legacy_billing_id": "string",
    "month": "date",
    "next_invoice": "double",
    "next_invoice_agg": "double",
    "normalized_country": "string",
    "normalized_region": "string",
    "parent_id": "string",
    "parent_name": "string",
    "parent_source": "string",
    "prev_invoice": "double",
    "prev_invoice_agg": "double",
    "product": "string",
    "product_customer_flag": "bigint",
    "product_data_last_refresh": "date",
    "product_facility_id": "string",
    "product_parent_id": "string",
    "product_raw": "string",
    "product_source": "string",
    "site_city": "string",
    "site_country": "string",
    "site_state": "string",
    "site_street": "string",
    "site_street_city": "string",
    "site_zip": "string",
    "table_names": "string"
}

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.sandbox_rosettable_stone_ds_v4_2`\n(\n `asset_id_salesforce_only`  string , `current_billing_id`  string , `current_product_status`  string , `facility_id`  string , `facility_match_method`  string , `facility_name`  string , `facility_source`  string , `invoice_label`  string , `invoice_label_agg`  string , `invoice_total`  double , `legacy_billing_id`  string , `month`  date , `next_invoice`  double , `next_invoice_agg`  double , `normalized_country`  string , `normalized_region`  string , `parent_id`  string , `parent_name`  string , `parent_source`  string , `prev_invoice`  double , `prev_invoice_agg`  double , `product`  string , `product_customer_flag`  bigint , `product_data_last_refresh`  date , `product_facility_id`  string , `product_parent_id`  string , `product_raw`  string , `product_source`  string , `site_city`  string , `site_country`  string , `site_state`  string , `site_street`  string , `site_street_city`  string , `site_zip`  string , `table_names`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-sandbox-prod/raw/rosettable_stone_ds_v4_2/2026-04-17/1776405761'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_redshift.sandbox_rosettable_stone_ds_v4_2`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_redshift.sandbox_rosettable_stone_ds_v4_2"
}

Server:

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

Raw:

{
    "name": {
        "created": "2024-05-31 00:23:54",
        "disabled": false,
        "format": "raw",
        "id": 1880,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_prod_redshift",
            "table": "sandbox_rosettable_stone_ds_v4_2"
        },
        "type": "redshift"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "asset_id_salesforce_only": "string",
            "current_billing_id": "string",
            "current_product_status": "string",
            "facility_id": "string",
            "facility_match_method": "string",
            "facility_name": "string",
            "facility_source": "string",
            "invoice_label": "string",
            "invoice_label_agg": "string",
            "invoice_total": "double",
            "legacy_billing_id": "string",
            "month": "date",
            "next_invoice": "double",
            "next_invoice_agg": "double",
            "normalized_country": "string",
            "normalized_region": "string",
            "parent_id": "string",
            "parent_name": "string",
            "parent_source": "string",
            "prev_invoice": "double",
            "prev_invoice_agg": "double",
            "product": "string",
            "product_customer_flag": "bigint",
            "product_data_last_refresh": "date",
            "product_facility_id": "string",
            "product_parent_id": "string",
            "product_raw": "string",
            "product_source": "string",
            "site_city": "string",
            "site_country": "string",
            "site_state": "string",
            "site_street": "string",
            "site_street_city": "string",
            "site_zip": "string",
            "table_names": "string"
        },
        "created": "2026-04-17 01:03:07",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.sandbox_rosettable_stone_ds_v4_2`\n(\n `asset_id_salesforce_only`  string , `current_billing_id`  string , `current_product_status`  string , `facility_id`  string , `facility_match_method`  string , `facility_name`  string , `facility_source`  string , `invoice_label`  string , `invoice_label_agg`  string , `invoice_total`  double , `legacy_billing_id`  string , `month`  date , `next_invoice`  double , `next_invoice_agg`  double , `normalized_country`  string , `normalized_region`  string , `parent_id`  string , `parent_name`  string , `parent_source`  string , `prev_invoice`  double , `prev_invoice_agg`  double , `product`  string , `product_customer_flag`  bigint , `product_data_last_refresh`  date , `product_facility_id`  string , `product_parent_id`  string , `product_raw`  string , `product_source`  string , `site_city`  string , `site_country`  string , `site_state`  string , `site_street`  string , `site_street_city`  string , `site_zip`  string , `table_names`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-sandbox-prod/raw/rosettable_stone_ds_v4_2/2026-04-17/1776405761'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_redshift.sandbox_rosettable_stone_ds_v4_2`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_redshift.sandbox_rosettable_stone_ds_v4_2"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}