Team, Could you please share some insights on how much time does it take to load a billion rows dataset, and/or how to optimise the process?

[Max]

See here

Team, Could you please share some insights on how much time does it take to load a billion rows dataset, and/or how to optimise the process

We are going to work with close to 1 billion rows. Incremental updates of the dataset, with a timestamped column in, can address in-between updates. Considering that we need to have at any point in time data from the last 12 months, would QuickSight delete older rows (based on the timestamped column) that exceed its 1 billion rows quota? …OR do we have to always do full dataset updates to keep only 12 months of data (that we know are close but always less than 1billion) ? (the table is u…