Forum Discussion
Redshift DirectQuery locate() error
I'm trying to connect to AWS Redshift, with built-in connector, in DirectQuery mode. I'm using a custom SQL code (simple SELECT * FROM ... ) due to performance reasons. Everything is working fin...
Solved with a user defined function on Redshift side:
CREATE OR REPLACE FUNCTION public.locate(varchar, varchar)
RETURNS integer
IMMUTABLE
AS $$ SELECT POSITION($1 IN $2) $$
LANGUAGE sql;
But I'm still wondering if this was the offical way to solve this... ?!