Often when dealing with presumed large tables I want to check the size before I collect them. I may even want to try several different where clauses. Right now my only option is to modify the select statement in assemble to count(*) and then hit the view source button. it should be pretty easy to put a select (*) view around the actual SQL for my package and return the record count.
Bonus points if we could sample width and estimate then estimate avg. bites per row and estimated total landing size of the table.
I would settle for having the option available when using those technologies for which it is easier to design sooner than waiting until we have built if for all technologies.
Attachments Open full size
Hello Jeremiah - the option to check the size of a table would be very useful. We'll consider this for the future, however, since we have different extract technologies, it may not be as straightforward as it appears.
Attachments Open full size