Friendly Column names not shown anymore

[gvisniuc]

Hi there,

I’m currently running Metabase v0.33.1 and have noticed that the column names declared as aliases in SQL (i.e. “my_column”) are not following the FRIENDLY TABLE AND FIELD NAMES setting anymore, and do not replace underscores with spaces.

I tried finding any issues or traces of this change as well, so I’m not sure if this is a bug or intended behaviour.

Your browser and the version: Chrome 76.x
Your operating system: macOS Mojave
Your databases: Redshift
Metabase version: 0.33.1
Metabase hosting environment: Official Metabase Docker image running in Kubernetes.
Metabase internal database: AWS RDS Postgres

⬇️ Please click the 👍 reaction instead of leaving a +1 or 👍 comment

[flamber]

Pinging @camsaul because of PR #10196, but I cannot find the reason behind it.

[gvisniuc]

Also just a small note even when declaring a title case alias such as select field as "My Alias" the column names will be transformed to lowercase as well "my alias".

[salsakran]

The intended behavior is that we respect your aliases and don't mess with them, since the friendly names was misfiring more often than not with raw sql.

The lowercasing is a bug and marking it as such

[ismayil22]

Guys Hi,

I have related question regarding column names, but not sure is it bug or should work like intended. Since you removed "friendly column names", as I see in v0.33.3, I had to fix all column names using "Settings->Table options->Column title.

Thus adjusted column names as needed. Problem is that they do not reflect on Pulses now (see second screenshot). It seems it is bug , and they should be adjusted on Pulses too. Am I right?

Second screenshot:

[ismayil22]

@flamber Hi, can you please give me approx. time when above issue will be fixed (I hope).
1 week? 1 month? 1 year?

Or maybe easier just revert above mentioned by you PR :) #10819 (comment)

All Pulses now looks weird, and it will take eternity to fix all these column names manually in all existing pulses.

[flamber]

@ismayil22 Did you see the comment by @salsakran? I don't think this will be reverted. The lower-casing is a bug, but cannot give you a time-frame, there's 2000 other open issues.
Pulses doesn't read the formatting from the visualization, which is why the column name doesn't change in the pulse, when you edit it in table options - there's an issue open on that #8258.

[walterl]

I'm not seeing the lower-casing issue on current master (0.35.0-RC @ fb1ed0d):

Closing, since it appears to have been fixed already.