Hoping someone may be able to assist me in understanding why this case statement will work when in a SELECT query but not in a REPLACE View query.
Could you show the full script for the REPLACE VIEW? It looks like a syntax error
You are using the SUBSTR syntax with the SUBSTRING function.
You must use :
SUBSTRING(ROLLOUT_REGION_IDENTIFIER FROM 1 FOR 15)
SUBSTR(ROLLOUT_REGION_IDENTIFIER, 1, 15)