10 Replies Latest reply on May 13, 2016 4:26 AM by Andrew Pick

    csv legacy connection row limit

    Andrew Pick

      I am connecting to a csv, 900k, rows via the legacy connector as I need to use custom sql. The issue I am finding is that if I connect live, the number of rows are limited. This seems to be an arbitrary number, sometimes 100k, sometimes 350k and anything in between. If I take an extract then all the rows are included.

       

      The problem is that the sql runs before the extract so I don't get all the rows included in the sql query.

       

      Does anyone know of a limit or a way around this? I am using 9.0 but have also tried in 9.2 with the same results.

       

      Cheers