troubleshooting
Can changes to a UDF referenced in a materialized view be applied to the view automatically?
:wave: Hey! Possibly daft question, but if a UDF is referenced in a materialized view, is there a procedure to make changes to that UDF and have those changes be applied to the view? Thanks!
Al
Alex C
Asked on Aug 02, 2023
- Changes to a UDF referenced in a materialized view cannot be automatically applied to the view.
- The materialized view needs to be recreated manually after making changes to the UDF.
- The UDF will be rerun for each argument provided, regardless of whether the arguments are the same or different.
- The UDF will be called for every row in the underlying table when the materialized view is queried, without caching the results.
Aug 02, 2023Edited by