Redshift Column Remarks not showing in Datashare

When using Amazon Redshift data sharing between producer and consumer accounts, there is a known limitation with column comments (remarks) not being fully propagated through the datashare. Currently, while table-level comments and some column comments may be visible, not all column comments are consistently shared with the consumer.

The behavior you're experiencing where only the first column shows the associated comment while others appear blank is consistent with this limitation. Unfortunately, there isn't a direct way to make all column comments automatically appear for the consumer within the current implementation of Redshift data sharing.

As a workaround, you could consider:

1. Documenting the column descriptions separately and sharing this documentation with the consumer team
2. Creating views in the consumer cluster that include column comments specific to the consumer's context
3. Using a data catalog solution like Amazon DataZone which provides more comprehensive metadata management capabilities across accounts

Amazon Redshift data sharing is primarily focused on sharing the data itself rather than all metadata elements. While it effectively shares tables, views, schemas and the actual data, some metadata elements like column comments have limitations in how they propagate across the sharing boundary.
Sources
COMMENT - Amazon Redshift
Understanding Amazon Redshift Data Sharing Solutions: A Comprehensive Comparison | AWS re:Post
Redshift data share | AWS re:Post
Getting started with data sharing with AWS CloudFormation in Amazon Redshift - Amazon Redshift