I am new to Tableau. My question is around if Tableau 10 supports SQL_Variant Datatype? I am connected to SQL server and while viewing a particular table I am unable to find few fields in Tableau and figured out that it is omitting the fields with SQL_Variant data type. Is there a work around for that?
There's no native support for this type so your way out is to use Custom SQL and cast/convert the field into consistent type Tableau can read.
You might need to add some logic to your cast in case your column does truly contain different types.