User Defined Functions in Redshift Data Flows
Comments
-
Hi,
I went down that path once and got stuck on: The database reported a syntax error. [Amazon](500310) Invalid operation: permission denied for language plpythonu;
Maybe support or another user could be able to elaborate deeper.
Regards.
Ricardo Granada
MajorDomo@Lusiaves
**If the post solves your problem, mark it by clicking on "Accept as Solution"
**You can say "Thank you" by clicking the thumbs up in the post that helped you.0 -
Hi Richardo,
Thanks for your reply.
I also tried this approach and get the same error message.
Redshift workflow is labelled as a beta version. UDF may not be available yet.
I hope DOMO support or another experienced user can look into this case.
Regards,
Ziqi
0 -
I agree that this is important functionality to add. I have a common select statement I would like to ensure is consistent across several datasets, and a UDF would be the best way to ensure that. Right now the only way I have found to create 'object-oriented' ETL logic is to take things down to R, but that can be quite slow, untrackable, and unpracticable for large data sets.
It would be good if we could at least get a timeline on this being added.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 299 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 54 App Studio
- 40 Variables
- 680 Automate
- 175 Apps
- 451 APIs & Domo Developer
- 46 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
- 33 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive