It's similar to this thread https://www.googlecloudcommunity.com/gc/Modeling/Using-LIKE-operator-and-wildcards-with-Parameters/t... but the solution in this thread is not applicable to creating a derived_table (unquoted is not available for derived table)
Basically, what I want to do is:
view: view_1 {
derived_table: {
sql:
SELECT *
FROM `model_1`
WHERE column_1 LIKE {% parameter parameter_name %}
;;
}