title: What is the best method to create a extract with 20M rows?
body: <p>I am having the problem of creating an extract with 20M rows(since it is a long lasting process),
  I wanted todo a Live Connection but since the problem is with Amazon Redshift or Data Base design Issue The reports takes a long time to preview on the server.</p>
  
  <p>So I'm going to extract the data (20M rows) is there as fastest way to create an Extract?</p>
  
  <p>I followed these steps that did not work,</p>
  
  <p><code>Method 1:</code></p>
  
  <p>1.Create  a extract with 10 rows</p>
  
  <p>2.Publish the extract to server</p>
  
  <p>3.Schedule the extract for full Incremental Extract</p>
  
  <p><code>Method 2:</code></p>
  
  <p>1.Create the view</p>
  
  <p>2.Publish the view</p>
  
  <p>3.Schedule the view for full refresh</p>
  
  <p>please guide me on this?</p>