The number of rows isn't that easy, I would guess, since isn't the data columnar? While there are X number of rows pulled in, that doesn't necessarily mean that is exactly the number of rows in the columnar extract (is that even possible?).
# of total full refresh rows is not recorded anywhere within the internal PG. I have looked numerous times. But after the extract is done, within a workbook connected to the extract, you can drag # of rows to the column shelf and it will show you how many rows are in there. Interestingly though, is that if you run an incremental refresh, as part of the backgrounder refresh notes recorded within PG, the # of rows inserted are part of here and can be queried.
Jeff, as you mentioned I'm doing the same now to get the number of records for full extract. If it is full extract this approach works well. Wondering if you could let me know the table name to query for incremental refresh.
1 of 1 people found this helpful
try something like this:
select job_type, notes
from _background_tasks where job_type like '%increment%'
Awesome... I never noticed this. Thanks
glad it helped!