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
- 10.6K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 474 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 478 Datasets
- 214 Visualize
- 259 Beast Mode
- 2.1K Charting
- 12 Variables
- 19 Automate
- 356 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 249 Distribute
- 65 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 189 Product Ideas
- 1.2K Ideas Exchange
- 11 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive