Rationale for MAX_TABLE_COMMENT_LENGTH=1024 for BigQuery (official quota 16,384)

[mustafaburny]

Hi team,

While reviewing the codebase, I noticed that for the BigQuery engine adapter, the MAX_TABLE_COMMENT_LENGTH is set to 1024 characters:

MAX_TABLE_COMMENT_LENGTH = 1024

However, according to the official BigQuery documentation, the supported maximum table description/comment length is 16,384 characters.

Is there a specific rationale for restricting this limit to 1024 in SQLMesh? If not, would you consider increasing it to match the official quota so that longer table descriptions can be supported when deploying models?

Thanks!