Count number of rows in a table

I’m trying to integrate a self hosted seatable into a combined interactive and analytics workflow. I am using the python API (wrapped via R+reticulate). So far I am pretty happy, but there are still some things that I find surprisingly hard to figure out. One is to count the number of rows in a table. It seems that SQL COUNT() does not work when using the query method. Is there a quick way to count the number of rows in a table?
With many thanks,

Greg Jefferis.

You can use count(*) like

select count(*) from table_name

Thank you very much. I can confirm this now works. I think SQL COUNT() did not work on earlier versions of the developer edition.

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.