1 Reply Latest reply on Apr 24, 2013 5:43 AM by Jeff Pressman

    Are there any limits on Data Extract with BigQuery???

    g saama

      I mean is there a limit on how many rows i can extract for example extracting over 150 million rows????

        • 1. Re: Are there any limits on Data Extract with BigQuery???
          Jeff Pressman

          I don't believe there are any hard limits on rows so you should be able to extract 150 million +. Here are some things you may want to consider:

           

          1. How wide is your data set?  The more columns, the larger the extract and the longer it will take to process.
          2. How 'heavy' are your data types? Larger types will again result in a larger size on disc and increase extract times.
          3. Are you processing the extract using the Tableau desktop client or in Tableau server? If you have server in your environment you may see performance gains running/refreshing the extract server side.
          4. Where is your temp directory? See here

           

          Good luck!

          1 of 1 people found this helpful