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
**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
- 10.5K All Categories
- 3 Connect
- 913 Connectors
- 250 Workbench
- 458 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 183 Visualize
- 249 Beast Mode
- 2.1K Charting
- 11 Variables
- 16 Automate
- 354 APIs & Domo Developer
- 88 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 245 Distribute
- 62 Domo Everywhere
- 242 Scheduled Reports
- 20 Manage
- 41 Governance & Security
- 168 Product Ideas
- 1.2K Ideas Exchange
- 9 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive