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.8K All Categories
- 3 Private Company Board
- 1 APAC User Group
- 12 Welcome
- 38 Domo News
- 9.7K Using Domo
- 1.9K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 343 Workbench
- 259 Domo Best Practices
- 11 Domo Certification
- 464 Domo Developer
- 50 Domo Everywhere
- 105 Apps
- 714 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 26 お知らせ
- 64 Kowaza
- 299 仲間に相談
- 653 ひらめき共有