I am attempting to use Direct Discovery for the first time.
I have a table holding 70 million rows of textual description data, which I only ever want to load into memory once I drill down to a specific record.
However, I must be doing something wrong. I have this:
DIRECT QUERY
dimension KEY_FIELD
detail DESCRIPTION
from SA.TABLE;
But whenever I refresh the report, it seems to want to load 70 million rows into memory. This seems to defeat the point, as it would take half an hour to run - how do I get this to work without it having to load all of the KEY_FIELDS into memory?
