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,
1.Create a extract with 10 rows
2.Publish the extract to server
3.Schedule the extract for full Incremental Extract
1.Create the view
2.Publish the view
3.Schedule the view for full refresh
please guide me on this?