title: snowflake, get a list of mismatching columns between two tables (SQL)
body: <p>I have been doing some reseach but didn't find much. I need to compare two tables to get a list of which columns are in table 1, but not in table 2. I am using Snowflake.
  Now, I've found this answer: <a href="https://stackoverflow.com/questions/36733941/postgresql-get-a-list-of-columns-difference-between-2-tables">postgresql - get a list of columns difference between 2 tables</a></p>
  
  <p>The problem is that when I run the code I get this error:</p>
  
  <pre><code>SQL compilation error: invalid identifier TRANSIENT_STAGE_TABLE
  </code></pre>
  
  <p>The code works fine if I run it separately, so if I run:</p>
  
  <pre><code>SELECT column_name
  FROM information_schema.columns 
  WHERE table_schema = 'your_schema' AND table_name = 'table2'
  </code></pre>
  
  <p>I actually get a list of column names, but when I chain it to the second expression, the above error is returned.
  Any hint on what's going on?
  Thank you</p>