2 Replies Latest reply on May 18, 2013 6:53 PM by Robert Morton

    Set the session character set to ASCII for a Teradata Data connection in Tableau

    Kishore Kumar Muddanuru Kalwa

      Hi,

       

      I have a business request where all the columns from a table needs to be extracted and save as Tableau datasource for analysis.

      There are more than 100 columns in the table and and when I try to extract the data, i get the below error.

       

      Database error 0x80004005: [Teradata][ODBC Teradata Driver][Teradata Database] Row size or Sort Key size overflow.

      Unable to create extract

       

      The same SQL runs fine in Teradata SQL assistant when I set the session character set to ASCII, but fails when the character set is UTF8.

      Is there anyway the character set can be defined in Tableau before the Custom SQL is firect to the DB.

      I tried Initial SQL section in Advanced section but no luck.

       

      Thanks,

      Kishore