Extracting ~28 million rows, loading zero, schema shows 28M rows in table, analyzer zero
I don't have direct access to the CMC, so I'm a bit limited in my troubleshooting, but what should I be looking at if a table isn't loading. As in the title, it extracts ~28 million rows ( takes ~ 40 minutes ), loads zero, and analyzer returns zero rows. The schema page shows it has 28M at 4.33 GB. It's a straight select w/ a where clause, no formulae, no joins, no runtime filters, no security filters.
I replicated the schema and table and it runs and loads successfully which isn't a very good long term plan ;-)
I can get CMC access if needed, the environment is Incorta cloud.
Ideas welcome and thank you!
It is not ( was not ) optimized by design since I won't be using this to analyze - just as a source for a MV.
I did switch it to Optimized and am testing it now.
I understand that "optimized" just means read into memory at the conclusion of processing though, so I'm not sure that should impact the load process. ( also understand that sometimes "should" doesn't indicate "does" !! )