Teradata Connection running out of Spool Space

[Paulo1]

Hi,

Just wondering if anyone has any experience using Teradata database connections and might be able to give me some advice on how to get around the Spool space issues.

I am trying to find a way to potentially join a table before query imports the table to cut down the amount of lines that Excel tries to bring in?

At the moment the answer is beyond me

Any help would be greatly appreciated.

Thanks

 

[Paulo1]

Sorry New here and not yet sure how to edit posts....I am not sure my question is clear

I have a very large database connected by Teradata Database to Power Query.
I have a list of Products by week and this pulls in fine (around 7-8m Data lines)

When i then try a different table with by Product by location by week around (7-8M *1400 Locations) I am getting the following error:

DataSource.Error: Teradata: [Teradata Database] [2646] No more spool space
ErrorCode=-2147467259


I am wondering if there is a way to filter the data by a select number of Locations/Product numbers/dates which may make it easier on the database to be able to output into my query for me?

 

[sandy666]

maybe it will help: spool space

 

[Paulo1]

Unfortunately not the answer I was looking for.