1 of 1 people found this helpful
Don't think so - even opening the tde in a text editor doesn't show anywhere where that is stored as ascii
I'm curious why you want to find out the number of rows. What is your usage scenario?
Thanks for the quick response Alex!
One of my new users to Tableau Server was recently getting familiar with the setup. After logging on and viewing some of the workbooks that we currently have published to server, he asked if there was a way to see which of the workbooks were using an extract vs a live connection? And for the workbooks using an extract, is there a way to tell how many rows are in the extract?
Based on Alex's response, it sounds like the answer is no.
Do you concur?
I agree, there is no way to tell. Might be a worthwhile feature to add.
One way I've set up workbooks is to have a worksheet that just has SUM(Number of Records) in a text table, it's a hack but a quick way to get a sense of the extract. You could get fancy with it an include the last updated date, and if there are any timestamps on the records then use some aggregate calcs to break down how many records were added.
Thanks for the tip. I think I'll set something like this up today. We've been trying to troubleshoot issues around extracts not refreshing the complete data set (due to problems on the source data side) and needed a quick way to see how many rows per refresh were being updated. Nice and simple.