PG_TABLE_DEF doesn't work

baroncurtin
Member
in Archive
I recently came across some websites that have guided me to a solution to perform a transpose function in RedShift. We currenltly have dataflows in MySQL that perform transpose functions with the use of stored procedures, however we would like to be able to convert those to RedShift. In any event, part of the solution relies on the use of PG_TABLE_DEF. When I try to use it, I get an error message saying "column [x] has unsupported type 'name'". If anyone knows how to avoid this/fix it let me know.
Thanks,
0
Comments
-
Any updates on this? I like how Domo is getting more "pretty" with redesigning all the icons and all, but such basic functionalities are still missing ?
0 -
+1 to this question. Anyone? Bueller?
0
Categories
- All Categories
- Product Ideas
- 2K Ideas Exchange
- Connect
- 1.3K Connectors
- 308 Workbench
- 7 Cloud Amplifier
- 10 Federated
- Transform
- 661 Datasets
- 117 SQL DataFlows
- 2.2K Magic ETL
- 819 Beast Mode
- Visualize
- 2.6K Charting
- 85 App Studio
- 46 Variables
- Automate
- 193 Apps
- 483 APIs & Domo Developer
- 85 Workflows
- 23 Code Engine
- AI and Machine Learning
- 22 AI Chat
- 3 AI Projects and Models
- 18 Jupyter Workspaces
- Distribute
- 116 Domo Everywhere
- 282 Scheduled Reports
- 11 Software Integrations
- Manage
- 142 Governance & Security
- 9 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 115 Community Announcements
- 5K Archive