sqlmesh icon indicating copy to clipboard operation
sqlmesh copied to clipboard

Column descriptions don't pick up variables

Open enfeizhan opened this issue 6 months ago • 0 comments

sqlmesh version: 0.209.0

I am trying to use variables for column descriptions. Here is a simple example:

MODEL (
  name test.test,
  kind FULL,
  description @VAR('test_var_1'),
  column_descriptions (
    id = @VAR('test_var_2')
  )
);
SELECT 1 as id

With config.yaml:

variables:
  test_var_1: "1"
  test_var_2: "2"

The variable works well with description in the MODEL block. But it gets this error for column descriptions: 'NoneType' object has no attribute 'parts'.

If my use of variables in column names has not been the expected user behaviour, it would be great to have it for documenting columns programmatically.

By the way, it would also be great to have dot-lookups like @VAR('parent.child').

enfeizhan avatar Aug 19 '25 02:08 enfeizhan