Wednesday 6 September 2017

Amazon RedShift now supports SQL Scalar User Defined Functions

Amazon Web Service has announced that Amazon RedShift has now added SQL Scalar User Defined Functions. By utilizing the PostgreSQL syntax you can build the custom SQL scalar functions and perform them at the parallel on the clusters. Replacing the SQL Function name with the SQL Function code on the leader note you increase the performance and running this as a regular SQL parallel on every node of the cluster. Once you have created and customised you can then rename or name such scalar UDFs in any SQL Statement. 

No comments:

Post a Comment

Maximizing Content Delivery Efficiency: Optimizing Performance in AWS CloudFront

  Unleash Blazing-Fast Content Delivery: Your Guide to CloudFront Optimization Introduction: AWS CloudFront stands as a cornerstone of moder...