3 Replies Latest reply on Apr 15, 2015 3:04 AM by Vipin Gopinath

    Incremental refresh of MySQL database not recognizing primary key and integer column

      Basically, I have a MySQL query that I use to create a data extract directly from the MySQL server. I would like to run incremental refresh on this data set based on the "id" column, which is set as: bigint(20) UN-PK AI in MySQL… however, when I try to do incremental refresh in Tableau, it doesn't list this columns as one of the columns that I can select in the drop down box.

       

      When I do "describe" on this column, it reads: "Remote type: Double-precision floating-point number", which isn't correct.

       

      How can I get tableau to recognize this column correctly so I can perform incremental refresh?