Anonymous
Not applicable

The underscore in the column name might be problematic, so try to put the column name in back ticks like `homepage_url`.

Would it be easier to use a regexp_extract https://docs.databricks.com/sql/language-manual/functions/regexp_extract.html instead of a cross join?