title: Can Stream Analytics write to an Azure SQL table having integer data types?
body: <p>One of our developers is using Azure Stream Analytics to pull data out of Azure blob storage and then insert it into an Azure SQL Database table. The target SQL table has columns which are integer data types. Azure Stream Analytics doesn't support integer types, only bigint types. So when SA attempts to insert a row into our table we get a data type mismatch error.</p>
  
  <p>When writing rows to the SQL table, is there a way we can have Stream Analytics write the data as integers and not bigints (CASTing doesn't work since the INT type isn't recognized)?</p>