What is the best method to create an extract with 20million rows

Question

I am facing issue while creating an extract with 20M rows(since it is a long lasting process), I wanted to perform 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.

So I'm going to extract the data (20M rows) is there a faster way to create an Extract?

I followed these steps that did not work,

Method 1:

1.Create a extract with 10 rows

2.Publish the extract to server

3.Schedule the extract for full Incremental Extract

Method 2:

1.Create the view

2.Publish the view

3.Schedule the view for full refresh

please guide me on this?