Schema Info

Schema Name: sfdl_prod_redshift.sandbox_rosettable_legacy_mapping

created: 2024-05-10 00:24:03
disabled: False
format: raw
id: 1877
is_partitioned: False
is_schema_datatyped: False

name:

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

type: redshift

Schema Versions: 15

Version 1717517

created: 2026-04-17 01:02:52

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.sandbox_rosettable_legacy_mapping`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.sandbox_rosettable_legacy_mapping`\n(\n `child_key`  string , `facility_id`  string , `facility_source`  string , `netsuite_internal_id`  string , `parent_key`  string , `product_skew`  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_legacy_mapping/2026-04-17/1776405761'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.sandbox_rosettable_legacy_mapping"
]

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

raw_data:

{
    "child_key": "string",
    "facility_id": "string",
    "facility_source": "string",
    "netsuite_internal_id": "string",
    "parent_key": "string",
    "product_skew": "string"
}

schema_attributes:

{
    "child_key": "string",
    "facility_id": "string",
    "facility_source": "string",
    "netsuite_internal_id": "string",
    "parent_key": "string",
    "product_skew": "string"
}

schema_name_id: 1877
schema_scan_id: 162165029
updated: 2026-04-17 01:03:06

Version 1716267

created: 2026-04-16 01:04:22

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.sandbox_rosettable_legacy_mapping`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.sandbox_rosettable_legacy_mapping`\n(\n `child_key`  string , `facility_id`  string , `facility_source`  string , `netsuite_internal_id`  string , `parent_key`  string , `product_skew`  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_legacy_mapping/2026-04-16/1776319448'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.sandbox_rosettable_legacy_mapping"
]

hive_path: s3://sfdl-redshift-sandbox-prod/raw/rosettable_legacy_mapping/2026-04-16/1776319448
id: 1716267
processed: 1

raw_data:

{
    "child_key": "string",
    "facility_id": "string",
    "facility_source": "string",
    "netsuite_internal_id": "string",
    "parent_key": "string",
    "product_skew": "string"
}

schema_attributes:

{
    "child_key": "string",
    "facility_id": "string",
    "facility_source": "string",
    "netsuite_internal_id": "string",
    "parent_key": "string",
    "product_skew": "string"
}

schema_name_id: 1877
schema_scan_id: 162109247
updated: 2026-04-16 01:04:33

Version 1715068

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.sandbox_rosettable_legacy_mapping`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.sandbox_rosettable_legacy_mapping`\n(\n `child_key`  string , `facility_id`  string , `facility_source`  string , `netsuite_internal_id`  string , `parent_key`  string , `product_skew`  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_legacy_mapping/2026-04-15/1776233123'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.sandbox_rosettable_legacy_mapping"
]

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

raw_data:

{
    "child_key": "string",
    "facility_id": "string",
    "facility_source": "string",
    "netsuite_internal_id": "string",
    "parent_key": "string",
    "product_skew": "string"
}

schema_attributes:

{
    "child_key": "string",
    "facility_id": "string",
    "facility_source": "string",
    "netsuite_internal_id": "string",
    "parent_key": "string",
    "product_skew": "string"
}

schema_name_id: 1877
schema_scan_id: 162053380
updated: 2026-04-15 01:05:42

Version 1713895

created: 2026-04-14 01:05:56

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.sandbox_rosettable_legacy_mapping`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.sandbox_rosettable_legacy_mapping`\n(\n `child_key`  string , `facility_id`  string , `facility_source`  string , `netsuite_internal_id`  string , `parent_key`  string , `product_skew`  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_legacy_mapping/2026-04-14/1776146750'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.sandbox_rosettable_legacy_mapping"
]

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

raw_data:

{
    "child_key": "string",
    "facility_id": "string",
    "facility_source": "string",
    "netsuite_internal_id": "string",
    "parent_key": "string",
    "product_skew": "string"
}

schema_attributes:

{
    "child_key": "string",
    "facility_id": "string",
    "facility_source": "string",
    "netsuite_internal_id": "string",
    "parent_key": "string",
    "product_skew": "string"
}

schema_name_id: 1877
schema_scan_id: 161997625
updated: 2026-04-14 01:06:10

Version 1712649

created: 2026-04-13 01:04:26

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.sandbox_rosettable_legacy_mapping`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.sandbox_rosettable_legacy_mapping`\n(\n `child_key`  string , `facility_id`  string , `facility_source`  string , `netsuite_internal_id`  string , `parent_key`  string , `product_skew`  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_legacy_mapping/2026-04-13/1776060258'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.sandbox_rosettable_legacy_mapping"
]

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

raw_data:

{
    "child_key": "string",
    "facility_id": "string",
    "facility_source": "string",
    "netsuite_internal_id": "string",
    "parent_key": "string",
    "product_skew": "string"
}

schema_attributes:

{
    "child_key": "string",
    "facility_id": "string",
    "facility_source": "string",
    "netsuite_internal_id": "string",
    "parent_key": "string",
    "product_skew": "string"
}

schema_name_id: 1877
schema_scan_id: 161940047
updated: 2026-04-13 01:04:37

Version 1711458

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.sandbox_rosettable_legacy_mapping`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.sandbox_rosettable_legacy_mapping`\n(\n `child_key`  string , `facility_id`  string , `facility_source`  string , `netsuite_internal_id`  string , `parent_key`  string , `product_skew`  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_legacy_mapping/2026-04-12/1775973937'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.sandbox_rosettable_legacy_mapping"
]

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

raw_data:

{
    "child_key": "string",
    "facility_id": "string",
    "facility_source": "string",
    "netsuite_internal_id": "string",
    "parent_key": "string",
    "product_skew": "string"
}

schema_attributes:

{
    "child_key": "string",
    "facility_id": "string",
    "facility_source": "string",
    "netsuite_internal_id": "string",
    "parent_key": "string",
    "product_skew": "string"
}

schema_name_id: 1877
schema_scan_id: 161890545
updated: 2026-04-12 01:05:52

Version 1710265

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.sandbox_rosettable_legacy_mapping`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.sandbox_rosettable_legacy_mapping`\n(\n `child_key`  string , `facility_id`  string , `facility_source`  string , `netsuite_internal_id`  string , `parent_key`  string , `product_skew`  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_legacy_mapping/2026-04-11/1775887538'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.sandbox_rosettable_legacy_mapping"
]

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

raw_data:

{
    "child_key": "string",
    "facility_id": "string",
    "facility_source": "string",
    "netsuite_internal_id": "string",
    "parent_key": "string",
    "product_skew": "string"
}

schema_attributes:

{
    "child_key": "string",
    "facility_id": "string",
    "facility_source": "string",
    "netsuite_internal_id": "string",
    "parent_key": "string",
    "product_skew": "string"
}

schema_name_id: 1877
schema_scan_id: 161838658
updated: 2026-04-11 01:06:00

Version 1709113

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.sandbox_rosettable_legacy_mapping`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.sandbox_rosettable_legacy_mapping`\n(\n `child_key`  string , `facility_id`  string , `facility_source`  string , `netsuite_internal_id`  string , `parent_key`  string , `product_skew`  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_legacy_mapping/2026-04-10/1775801121'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.sandbox_rosettable_legacy_mapping"
]

hive_path: s3://sfdl-redshift-sandbox-prod/raw/rosettable_legacy_mapping/2026-04-10/1775801121
id: 1709113
processed: 1

raw_data:

{
    "child_key": "string",
    "facility_id": "string",
    "facility_source": "string",
    "netsuite_internal_id": "string",
    "parent_key": "string",
    "product_skew": "string"
}

schema_attributes:

{
    "child_key": "string",
    "facility_id": "string",
    "facility_source": "string",
    "netsuite_internal_id": "string",
    "parent_key": "string",
    "product_skew": "string"
}

schema_name_id: 1877
schema_scan_id: 161783127
updated: 2026-04-10 01:05:43

Version 1707967

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.sandbox_rosettable_legacy_mapping`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.sandbox_rosettable_legacy_mapping`\n(\n `child_key`  string , `facility_id`  string , `facility_source`  string , `netsuite_internal_id`  string , `parent_key`  string , `product_skew`  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_legacy_mapping/2026-04-09/1775714593'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.sandbox_rosettable_legacy_mapping"
]

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

raw_data:

{
    "child_key": "string",
    "facility_id": "string",
    "facility_source": "string",
    "netsuite_internal_id": "string",
    "parent_key": "string",
    "product_skew": "string"
}

schema_attributes:

{
    "child_key": "string",
    "facility_id": "string",
    "facility_source": "string",
    "netsuite_internal_id": "string",
    "parent_key": "string",
    "product_skew": "string"
}

schema_name_id: 1877
schema_scan_id: 161727946
updated: 2026-04-09 01:03:31

Version 1706739

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.sandbox_rosettable_legacy_mapping`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.sandbox_rosettable_legacy_mapping`\n(\n `child_key`  string , `facility_id`  string , `facility_source`  string , `netsuite_internal_id`  string , `parent_key`  string , `product_skew`  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_legacy_mapping/2026-04-08/1775628442'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.sandbox_rosettable_legacy_mapping"
]

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

raw_data:

{
    "child_key": "string",
    "facility_id": "string",
    "facility_source": "string",
    "netsuite_internal_id": "string",
    "parent_key": "string",
    "product_skew": "string"
}

schema_attributes:

{
    "child_key": "string",
    "facility_id": "string",
    "facility_source": "string",
    "netsuite_internal_id": "string",
    "parent_key": "string",
    "product_skew": "string"
}

schema_name_id: 1877
schema_scan_id: 161672785
updated: 2026-04-08 01:07:56

Version 1705579

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.sandbox_rosettable_legacy_mapping`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.sandbox_rosettable_legacy_mapping`\n(\n `child_key`  string , `facility_id`  string , `facility_source`  string , `netsuite_internal_id`  string , `parent_key`  string , `product_skew`  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_legacy_mapping/2026-04-07/1775542342'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.sandbox_rosettable_legacy_mapping"
]

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

raw_data:

{
    "child_key": "string",
    "facility_id": "string",
    "facility_source": "string",
    "netsuite_internal_id": "string",
    "parent_key": "string",
    "product_skew": "string"
}

schema_attributes:

{
    "child_key": "string",
    "facility_id": "string",
    "facility_source": "string",
    "netsuite_internal_id": "string",
    "parent_key": "string",
    "product_skew": "string"
}

schema_name_id: 1877
schema_scan_id: 161616740
updated: 2026-04-07 01:12:50

Version 1704345

created: 2026-04-06 01:04:05

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.sandbox_rosettable_legacy_mapping`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.sandbox_rosettable_legacy_mapping`\n(\n `child_key`  string , `facility_id`  string , `facility_source`  string , `netsuite_internal_id`  string , `parent_key`  string , `product_skew`  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_legacy_mapping/2026-04-06/1775455369'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.sandbox_rosettable_legacy_mapping"
]

hive_path: s3://sfdl-redshift-sandbox-prod/raw/rosettable_legacy_mapping/2026-04-06/1775455369
id: 1704345
processed: 1

raw_data:

{
    "child_key": "string",
    "facility_id": "string",
    "facility_source": "string",
    "netsuite_internal_id": "string",
    "parent_key": "string",
    "product_skew": "string"
}

schema_attributes:

{
    "child_key": "string",
    "facility_id": "string",
    "facility_source": "string",
    "netsuite_internal_id": "string",
    "parent_key": "string",
    "product_skew": "string"
}

schema_name_id: 1877
schema_scan_id: 161558811
updated: 2026-04-06 01:04:19

Version 1703158

created: 2026-04-05 01:02:57

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.sandbox_rosettable_legacy_mapping`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.sandbox_rosettable_legacy_mapping`\n(\n `child_key`  string , `facility_id`  string , `facility_source`  string , `netsuite_internal_id`  string , `parent_key`  string , `product_skew`  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_legacy_mapping/2026-04-05/1775368972'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.sandbox_rosettable_legacy_mapping"
]

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

raw_data:

{
    "child_key": "string",
    "facility_id": "string",
    "facility_source": "string",
    "netsuite_internal_id": "string",
    "parent_key": "string",
    "product_skew": "string"
}

schema_attributes:

{
    "child_key": "string",
    "facility_id": "string",
    "facility_source": "string",
    "netsuite_internal_id": "string",
    "parent_key": "string",
    "product_skew": "string"
}

schema_name_id: 1877
schema_scan_id: 161512406
updated: 2026-04-05 01:03:11

Version 1701981

created: 2026-04-04 01:03:22

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.sandbox_rosettable_legacy_mapping`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.sandbox_rosettable_legacy_mapping`\n(\n `child_key`  string , `facility_id`  string , `facility_source`  string , `netsuite_internal_id`  string , `parent_key`  string , `product_skew`  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_legacy_mapping/2026-04-04/1775282595'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.sandbox_rosettable_legacy_mapping"
]

hive_path: s3://sfdl-redshift-sandbox-prod/raw/rosettable_legacy_mapping/2026-04-04/1775282595
id: 1701981
processed: 1

raw_data:

{
    "child_key": "string",
    "facility_id": "string",
    "facility_source": "string",
    "netsuite_internal_id": "string",
    "parent_key": "string",
    "product_skew": "string"
}

schema_attributes:

{
    "child_key": "string",
    "facility_id": "string",
    "facility_source": "string",
    "netsuite_internal_id": "string",
    "parent_key": "string",
    "product_skew": "string"
}

schema_name_id: 1877
schema_scan_id: 161457424
updated: 2026-04-04 01:03:34

Version 1700773

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
    "DROP TABLE IF EXISTS `sfdl_prod_redshift.sandbox_rosettable_legacy_mapping`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.sandbox_rosettable_legacy_mapping`\n(\n `child_key`  string , `facility_id`  string , `facility_source`  string , `netsuite_internal_id`  string , `parent_key`  string , `product_skew`  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_legacy_mapping/2026-04-03/1775196349'\n",
    "MSCK REPAIR TABLE sfdl_prod_redshift.sandbox_rosettable_legacy_mapping"
]

hive_path: s3://sfdl-redshift-sandbox-prod/raw/rosettable_legacy_mapping/2026-04-03/1775196349
id: 1700773
processed: 1

raw_data:

{
    "child_key": "string",
    "facility_id": "string",
    "facility_source": "string",
    "netsuite_internal_id": "string",
    "parent_key": "string",
    "product_skew": "string"
}

schema_attributes:

{
    "child_key": "string",
    "facility_id": "string",
    "facility_source": "string",
    "netsuite_internal_id": "string",
    "parent_key": "string",
    "product_skew": "string"
}

schema_name_id: 1877
schema_scan_id: 161398678
updated: 2026-04-03 01:06:08

Schema Scans: 15

Last at 2026-04-17 01:02:52

Scan 162165029

duration: 0:00:14.323300

exit_message:

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

id: 162165029

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_legacy_mapping/2026-04-17/1776405761",
        "key": "raw/rosettable_legacy_mapping/2026-04-17/1776405761/0007_part_00.parquet"
    },
    "schema": {
        "name": "sfdl_prod_redshift.sandbox_rosettable_legacy_mapping",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 4572090638217616235,
        "service_name": "drive-thru",
        "span_id": 12574019503855611145,
        "trace_id": 14306583000984593078
    }
}

running: False
schema_name_id: 1877
start_time: 2026-04-17 01:02:52
success: True
trace_id: 14306583000984593078

Scan 162109247

duration: 0:00:11.606216

exit_message:

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

id: 162109247

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_legacy_mapping/2026-04-16/1776319448",
        "key": "raw/rosettable_legacy_mapping/2026-04-16/1776319448/0007_part_00.parquet"
    },
    "schema": {
        "name": "sfdl_prod_redshift.sandbox_rosettable_legacy_mapping",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 2493674046253555756,
        "service_name": "drive-thru",
        "span_id": 11513261067075932887,
        "trace_id": 6068955026544728401
    }
}

running: False
schema_name_id: 1877
start_time: 2026-04-16 01:04:22
success: True
trace_id: 6068955026544728401

Scan 162053380

duration: 0:00:11.714825

exit_message:

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

id: 162053380

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_legacy_mapping/2026-04-15/1776233123",
        "key": "raw/rosettable_legacy_mapping/2026-04-15/1776233123/0007_part_00.parquet"
    },
    "schema": {
        "name": "sfdl_prod_redshift.sandbox_rosettable_legacy_mapping",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 14565352445802255012,
        "service_name": "drive-thru",
        "span_id": 15868623257622046494,
        "trace_id": 14719839932425699498
    }
}

running: False
schema_name_id: 1877
start_time: 2026-04-15 01:05:30
success: True
trace_id: 14719839932425699498

Scan 161997625

duration: 0:00:14.273397

exit_message:

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

id: 161997625

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_legacy_mapping/2026-04-14/1776146750",
        "key": "raw/rosettable_legacy_mapping/2026-04-14/1776146750/0007_part_00.parquet"
    },
    "schema": {
        "name": "sfdl_prod_redshift.sandbox_rosettable_legacy_mapping",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 15867780983616591974,
        "service_name": "drive-thru",
        "span_id": 6023344752921473444,
        "trace_id": 13238731156783222185
    }
}

running: False
schema_name_id: 1877
start_time: 2026-04-14 01:05:55
success: True
trace_id: 13238731156783222185

Scan 161940047

duration: 0:00:11.617790

exit_message:

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

id: 161940047

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_legacy_mapping/2026-04-13/1776060258",
        "key": "raw/rosettable_legacy_mapping/2026-04-13/1776060258/0007_part_00.parquet"
    },
    "schema": {
        "name": "sfdl_prod_redshift.sandbox_rosettable_legacy_mapping",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 13589384104559261580,
        "service_name": "drive-thru",
        "span_id": 8519011834987166660,
        "trace_id": 15832124539348782853
    }
}

running: False
schema_name_id: 1877
start_time: 2026-04-13 01:04:26
success: True
trace_id: 15832124539348782853

Scan 161890545

duration: 0:00:11.592404

exit_message:

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

id: 161890545

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_legacy_mapping/2026-04-12/1775973937",
        "key": "raw/rosettable_legacy_mapping/2026-04-12/1775973937/0007_part_00.parquet"
    },
    "schema": {
        "name": "sfdl_prod_redshift.sandbox_rosettable_legacy_mapping",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 1337524082882123902,
        "service_name": "drive-thru",
        "span_id": 15346971208014088555,
        "trace_id": 4610193723666083909
    }
}

running: False
schema_name_id: 1877
start_time: 2026-04-12 01:05:41
success: True
trace_id: 4610193723666083909

Scan 161838658

duration: 0:00:11.667350

exit_message:

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

id: 161838658

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_legacy_mapping/2026-04-11/1775887538",
        "key": "raw/rosettable_legacy_mapping/2026-04-11/1775887538/0007_part_00.parquet"
    },
    "schema": {
        "name": "sfdl_prod_redshift.sandbox_rosettable_legacy_mapping",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 5604906122365001966,
        "service_name": "drive-thru",
        "span_id": 18210210355558203204,
        "trace_id": 10513216623751822354
    }
}

running: False
schema_name_id: 1877
start_time: 2026-04-11 01:05:48
success: True
trace_id: 10513216623751822354

Scan 161783127

duration: 0:00:14.268897

exit_message:

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

id: 161783127

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_legacy_mapping/2026-04-10/1775801121",
        "key": "raw/rosettable_legacy_mapping/2026-04-10/1775801121/0007_part_00.parquet"
    },
    "schema": {
        "name": "sfdl_prod_redshift.sandbox_rosettable_legacy_mapping",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 1185241031039797728,
        "service_name": "drive-thru",
        "span_id": 12404722178069322848,
        "trace_id": 5959183814674322390
    }
}

running: False
schema_name_id: 1877
start_time: 2026-04-10 01:05:28
success: True
trace_id: 5959183814674322390

Scan 161727946

duration: 0:00:14.255321

exit_message:

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

id: 161727946

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_legacy_mapping/2026-04-09/1775714593",
        "key": "raw/rosettable_legacy_mapping/2026-04-09/1775714593/0007_part_00.parquet"
    },
    "schema": {
        "name": "sfdl_prod_redshift.sandbox_rosettable_legacy_mapping",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 8111174989518865112,
        "service_name": "drive-thru",
        "span_id": 12348477278923973492,
        "trace_id": 7893167918718794735
    }
}

running: False
schema_name_id: 1877
start_time: 2026-04-09 01:03:17
success: True
trace_id: 7893167918718794735

Scan 161672785

duration: 0:00:14.298184

exit_message:

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

id: 161672785

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_legacy_mapping/2026-04-08/1775628442",
        "key": "raw/rosettable_legacy_mapping/2026-04-08/1775628442/0007_part_00.parquet"
    },
    "schema": {
        "name": "sfdl_prod_redshift.sandbox_rosettable_legacy_mapping",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 6272500565020919149,
        "service_name": "drive-thru",
        "span_id": 6380868141115992182,
        "trace_id": 17326065691369787183
    }
}

running: False
schema_name_id: 1877
start_time: 2026-04-08 01:07:42
success: True
trace_id: 17326065691369787183

Scan 161616740

duration: 0:00:14.340976

exit_message:

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

id: 161616740

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_legacy_mapping/2026-04-07/1775542342",
        "key": "raw/rosettable_legacy_mapping/2026-04-07/1775542342/0007_part_00.parquet"
    },
    "schema": {
        "name": "sfdl_prod_redshift.sandbox_rosettable_legacy_mapping",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 16107632078577097100,
        "service_name": "drive-thru",
        "span_id": 10993832734280050900,
        "trace_id": 12140633221239297303
    }
}

running: False
schema_name_id: 1877
start_time: 2026-04-07 01:12:36
success: True
trace_id: 12140633221239297303

Scan 161558811

duration: 0:00:14.194871

exit_message:

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

id: 161558811

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_legacy_mapping/2026-04-06/1775455369",
        "key": "raw/rosettable_legacy_mapping/2026-04-06/1775455369/0007_part_00.parquet"
    },
    "schema": {
        "name": "sfdl_prod_redshift.sandbox_rosettable_legacy_mapping",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 5973075904331171517,
        "service_name": "drive-thru",
        "span_id": 17811671531867592618,
        "trace_id": 7558631658474855985
    }
}

running: False
schema_name_id: 1877
start_time: 2026-04-06 01:04:05
success: True
trace_id: 7558631658474855985

Scan 161512406

duration: 0:00:14.279668

exit_message:

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

id: 161512406

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_legacy_mapping/2026-04-05/1775368972",
        "key": "raw/rosettable_legacy_mapping/2026-04-05/1775368972/0007_part_00.parquet"
    },
    "schema": {
        "name": "sfdl_prod_redshift.sandbox_rosettable_legacy_mapping",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 6286129992459703123,
        "service_name": "drive-thru",
        "span_id": 18019781184140042442,
        "trace_id": 2121968146710265344
    }
}

running: False
schema_name_id: 1877
start_time: 2026-04-05 01:02:56
success: True
trace_id: 2121968146710265344

Scan 161457424

duration: 0:00:11.719598

exit_message:

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

id: 161457424

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_legacy_mapping/2026-04-04/1775282595",
        "key": "raw/rosettable_legacy_mapping/2026-04-04/1775282595/0007_part_00.parquet"
    },
    "schema": {
        "name": "sfdl_prod_redshift.sandbox_rosettable_legacy_mapping",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 7219014964051293387,
        "service_name": "drive-thru",
        "span_id": 16113068739403639581,
        "trace_id": 11016579174041652053
    }
}

running: False
schema_name_id: 1877
start_time: 2026-04-04 01:03:22
success: True
trace_id: 11016579174041652053

Scan 161398678

duration: 0:00:14.214035

exit_message:

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

id: 161398678

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_legacy_mapping/2026-04-03/1775196349",
        "key": "raw/rosettable_legacy_mapping/2026-04-03/1775196349/0007_part_00.parquet"
    },
    "schema": {
        "name": "sfdl_prod_redshift.sandbox_rosettable_legacy_mapping",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 8538966982342402421,
        "service_name": "drive-thru",
        "span_id": 17766039776693349987,
        "trace_id": 11594745407332696915
    }
}

running: False
schema_name_id: 1877
start_time: 2026-04-03 01:05:54
success: True
trace_id: 11594745407332696915

Partitions:

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

Schema:

attributes:

{
    "child_key": "string",
    "facility_id": "string",
    "facility_source": "string",
    "netsuite_internal_id": "string",
    "parent_key": "string",
    "product_skew": "string"
}

created: 2026-04-17 01:02:52

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_legacy_mapping`\n(\n `child_key`  string , `facility_id`  string , `facility_source`  string , `netsuite_internal_id`  string , `parent_key`  string , `product_skew`  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_legacy_mapping/2026-04-17/1776405761'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_redshift.sandbox_rosettable_legacy_mapping`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_redshift.sandbox_rosettable_legacy_mapping"
}

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-10 00:24:03",
        "disabled": false,
        "format": "raw",
        "id": 1877,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_prod_redshift",
            "table": "sandbox_rosettable_legacy_mapping"
        },
        "type": "redshift"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "child_key": "string",
            "facility_id": "string",
            "facility_source": "string",
            "netsuite_internal_id": "string",
            "parent_key": "string",
            "product_skew": "string"
        },
        "created": "2026-04-17 01:02:52",
        "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_legacy_mapping`\n(\n `child_key`  string , `facility_id`  string , `facility_source`  string , `netsuite_internal_id`  string , `parent_key`  string , `product_skew`  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_legacy_mapping/2026-04-17/1776405761'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_redshift.sandbox_rosettable_legacy_mapping`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_redshift.sandbox_rosettable_legacy_mapping"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}