Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Addition of SQL_ALIAS property to Dimension/Measure #8198

Open
theblinkingusb opened this issue Apr 27, 2024 · 1 comment
Open

Addition of SQL_ALIAS property to Dimension/Measure #8198

theblinkingusb opened this issue Apr 27, 2024 · 1 comment
Labels
data modeling enhancement New feature proposal

Comments

@theblinkingusb
Copy link

Is your feature request related to a problem? Please describe.
Columns with long identifiers that work in Postgres do not work in cube - cube has a feature SQL_ALIAS on the cube, which is great and can work to shorten the overall identifier, but Cube is combining the table and column identifier into one Alias, and if a column name is close to 63 chars, the query can still fail with the "You requested hidden member:" error

Describe the solution you'd like
I'd like a sql_alias property on the column (dimension/measure) as well (or maybe a backend automated md5 aliasing) - this feature might be helpful elsewhere / for other dbs as well - not certain

Describe alternatives you've considered
Shortening column names! But... things are complicated

Additional context
Add any other context or screenshots about the feature request here.
Below are the files I used to test this. With some guidance and buy-in on this request I'd be willing to take a crack at it.

sql_view_temp_column_identifier_length.txt
yml_model_test_numbers.txt

Thanks Cube team

@theblinkingusb
Copy link
Author

(related: #4727)

@igorlukanin igorlukanin added enhancement New feature proposal data modeling labels Apr 27, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
data modeling enhancement New feature proposal
Projects
None yet
Development

No branches or pull requests

2 participants