title: disable column store in azure sql dataware house
body: <p>I am writing a dataframe from Azure Databricks onto a sql dataware house with</p>
  
  <pre><code>res.write \
      .format("jdbc") \
      .option("url", url) \
      .option("dbtable", table) \
      .option("user", user) \
      .option("password", password) \
      .save()
  </code></pre>
  
  <p>with this I am getting an error <code>Column &amp;apos;username&amp;apos; has a data type that cannot participate in a columnstore index.</code></p>
  
  <p>How can I either eliminate the column store completely, or change the data type of the columns to fit in  the column store?</p>
  
  <p>I have a few columns that will be considered as integer and some that will be varchar.</p>