Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I was runing into the below error when extracting data from amazon redshift tables:
I added a counter to the table, and broke up my extracts into chunks to 1M records - this seems to have fixed my problem...
For counter = 0 to 100000000 step 1000000
<connection string>
$(QVDatabaseTable):
SQL SELECT
"account_uuid",
"acctflag",
"parent_customer_size",
"named_account_flag",
"site_industry_group_name",
"site_industry_sub_segment_name",
"site_industry_segment_name",
"last_asset_purchasedate"
FROM $(DB).$(DBSchema).$(DatabaseTable) where "row" >= $(counter)+1 and "row" <= $(counter)+1000000;
DISCONNECT;
next;
store $(QVDatabaseTable) into $(vQVDFileName);
DROP tables $(QVDatabaseTable);