title: Python and Snowflake error on appending into existing table on the cloud
body: <p>I am trying to upload a dataframe into an existing table in snowflake cloud. Here is the dataframe:</p>
  <pre><code>columns_df.head()
  </code></pre>
  <p><a href="https://i.stack.imgur.com/c1q10.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/c1q10.png" alt="enter image description here" /></a></p>
  <p>Now when using the <code>to_sql()</code> from pandas to append data into existing table:</p>
  <pre><code>columns_df.to_sql('survey_metadata_column_names', index=False,  index_label=None, con=conn, schema='PUBLIC', if_exists='append', chunksize=300)
  </code></pre>
  <p>I received the following error:</p>
  <blockquote>
  <p>DatabaseError: Execution failed on sql 'SELECT name FROM sqlite_master
  WHERE type='table' AND name=?;': not all arguments converted during
  string formatting</p>
  <p>TypeError: not all arguments converted during string formatting</p>
  </blockquote>
  <p>Some of the column names contains dashes and underscores.</p>