Standardizing Naming Conventions - Can we change Redshift columns to proper format?
We're attempting to standardize our naming conventions and would prefer to use a Proper format. However I can't find a way to modify the column headers with Redshift datasets as they automatically get convered into lower case format. Is there a way to do this? I've attempted using Alter Table in Redshift with no luck so far.
I would hate to have to be forced into using lower case format for all my data sets (so we can use page filters effectively) and then rely on labels for every single field in our cards to make them more professional looking.
Comments
-
At this point in time, labels are the workaround, but at Domopalooza, a feature which will allow column header name changes at the dataset level was announced.
There wasn't an ETA on the feature, but this would be a potential workaround in the hopefully near future.
Another possible workaround would be to use mysql or magic ETL for your ETL processes, but since you're using Redshift I'm assuming that's not possible for your datasets.
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'1
Categories
- All Categories
- 1.1K Product Ideas
- 1.1K Ideas Exchange
- 1.2K Connect
- 969 Connectors
- 256 Workbench
- Cloud Amplifier
- 1 Federated
- 2.4K Transform
- 76 SQL DataFlows
- 500 Datasets
- 1.8K Magic ETL
- 2.7K Visualize
- 2.2K Charting
- 369 Beast Mode
- 19 Variables
- 483 Automate
- 101 Apps
- 378 APIs & Domo Developer
- 6 Workflows
- 22 Predict
- 6 Jupyter Workspaces
- 16 R & Python Tiles
- 316 Distribute
- 64 Domo Everywhere
- 252 Scheduled Reports
- 59 Manage
- 59 Governance & Security
- 1 Product Release Questions
- 5K Community Forums
- 37 Getting Started
- 23 Community Member Introductions
- 63 Community Announcements
- 4.8K Archive