What If You Need More to Select More Than 1,000 Rows from Redshift/Postgres?
Hello,
I see that with SQL SELECT step there is a 1,000 row limit. What the best way to handle a situation where I might have more than 1,000 rows to select?
Thank you!
Best Answer
P
Patricia Guevarra
said
over 6 years ago
Hi Matt,
Thanks for reaching out! You can do multiple SQL SELECT steps and use a SKIP statement to skip the first 1000, 2000, etc, as needed. Let us know if you need assistance with this!
Answer
Patricia Guevarra
said
over 6 years ago
Hi Matt,
Thanks for reaching out! You can do multiple SQL SELECT steps and use a SKIP statement to skip the first 1000, 2000, etc, as needed. Let us know if you need assistance with this!
Matt McKenna
What If You Need More to Select More Than 1,000 Rows from Redshift/Postgres?
Hello,
I see that with SQL SELECT step there is a 1,000 row limit. What the best way to handle a situation where I might have more than 1,000 rows to select?
Thank you!
Hi Matt,
Thanks for reaching out! You can do multiple SQL SELECT steps and use a SKIP statement to skip the first 1000, 2000, etc, as needed. Let us know if you need assistance with this!
Patricia Guevarra
Hi Matt,
Thanks for reaching out! You can do multiple SQL SELECT steps and use a SKIP statement to skip the first 1000, 2000, etc, as needed. Let us know if you need assistance with this!