To extract the value associated with 'val2' from the JSON-like string in your column1, you can utilize amazon Redshift's REGEXP_SUBSTR function.

SELECT
  column1,
  REGEXP_SUBSTR(column1, '''val2'':\s*''([^'']*)''', 1, 1, 'e') AS extracted_val2
FROM
  your_table_name;