Return Capitalized (UPPER or CamelCase) Characters in Column Names from Redshift DataFlow
Any tips or tricks to avoid the auto-lowercasing of column names in Redshift DataFlows?
The reason we need this is because of how page filters are case sensitive, and the page being filtered runs off of several datasets, some are the output from MySQL dataflows and one from Redshift (due to the size, ~4.5M rows). Would prefer to conform the naming style of the Redshift output to that of the other MySQL ones, since it is just a single dataset, and capitalized letters are more visually appealing anyway.
Best Answer
-
Options are limited unfortunately. You could run the output of the Redshift through a MySQL dataflow just to rename columns. You could try renaming all of your MySQL columns so they're all lowercase. That might be considered a best practice if you're mixing SQL engines. You could also try running through MySQL originally. 4.5m rows isn't awful; you'd just have to weight the benefit of a potentially slower dataflow versus not being able to fully use page filters.
Coming down the line also should be a feature that allows you to change column names from within the Domo data center. That's probably your best option, but it's probably at least a couple months away.
Aaron
MajorDomo @ Merit Medical
**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Answers
-
Options are limited unfortunately. You could run the output of the Redshift through a MySQL dataflow just to rename columns. You could try renaming all of your MySQL columns so they're all lowercase. That might be considered a best practice if you're mixing SQL engines. You could also try running through MySQL originally. 4.5m rows isn't awful; you'd just have to weight the benefit of a potentially slower dataflow versus not being able to fully use page filters.
Coming down the line also should be a feature that allows you to change column names from within the Domo data center. That's probably your best option, but it's probably at least a couple months away.
Aaron
MajorDomo @ Merit Medical
**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
Thanks @AS for the quick reply.
What I am currently doing as a work around is actually pumping the Redshift output through a Magic ETL and doing the renaming there, similar to what you suggest with MySQL. It is messy though having that extra step. Looking forward to the data center updates!
0 -
@AS wrote:...
Coming down the line also should be a feature that allows you to change column names from within the Domo data center. That's probably your best option, but it's probably at least a couple months away.
Is there an updated timeline for this features implementation?
0 -
The feature I saw was probably early beta but I haven't heard of any advancements since last summer.
Aaron
MajorDomo @ Merit Medical
**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
Thank you for the reply!
If you hear anything about this feature, please let me know.
0 -
Any update on this?
0 -
Hey @adam_mx , @user19223,
I did something similar when uploading to our Snowflake instance. You can use the Python tile to automatically convert all your columns names to uppercase.
Python Tile Code:
# Import the domomagic package into the script
from domomagic import *
# read data from inputs into a data frame
data = read_dataframe('Select Columns')
# changes columns to uppercase
data.columns = map(str.upper, data.columns)
# write a data frame so it's available to the next action
write_dataframe(data)Hope this helps!
-Ian
0 -
The Domo DataViews just went into beta, this would be the best/easiest way to create a VIEW of the data that renames columns without having to run it into an ETL. talk to your CSM if you're not already part of the beta program.
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive