title: Snowflake invalid identifier when performin a join
body: <p>I have been trying to do an outer join across two different tables in two different schemas. I am trying to filter out before from the table variants the character that are smaller than 4 and bigger than 5 digits. The join was not working with a simply where clause in the end, hence this decision.</p>
  
  <p>The problem is if I do not put the quotes, Snowflake will say that I put invalid identifiers. However, when I run this with the quotes, it works but I get as values in the fields of the column <code>raw.stitch_heroku.spree_variants.SKU</code> only named as the column name, all across the table!</p>
  
  <pre><code>SELECT
      analytics.dbt_lcasucci.product_category.product_description,
      'raw.stitch_heroku.spree_variants.SKU'
  FROM analytics.dbt_lcasucci.product_category
  LEFT JOIN (
      SELECT * FROM raw.stitch_heroku.spree_variants
      WHERE LENGTH('raw.stitch_heroku.spree_variants.SKU')&lt;=5
        and LENGTH('raw.stitch_heroku.spree_variants.SKU')&gt;=4
  ) ON 'analytics.dbt_lcasucci.product_category.product_id'
        = 'raw.stitch_heroku.spree_variants.SKU'
  </code></pre>
  
  <p>Is there a way to work this around? I am confused and have not found this issue on forums yet!</p>
  
  <p>thx in advance</p>