Is there a query I can write in Suiteanalytics connect to find all tables with row counts?

AI generated answer (using internal Slack threads):

In SuiteAnalytics Connect, you can write SQL queries to retrieve data from the views that represent the NetSuite tables. However, there isn't a direct way to get the row counts of all tables. You would need to write individual SQL queries for each table to get the row count. Here is an example of how you can get the row count for a specific table:

sql
SELECT COUNT(*) FROM [TableName]

Replace

[TableName]

with the name of the table you want to get the row count for. You would need to repeat this for each table you are interested in. Please note that SuiteAnalytics Connect is a paid module and you would need to have it enabled in your account to use it. Also, keep in mind that the 'tables' in SuiteAnalytics are actually 'views' projected as tables, and some of these views have a large number of joins which can affect performance. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******