Discover your community to learn, get support, and discuss on different topics within data management and analytics.
This is your platform to ask questions, post answers and share your experience with other customers and experts from SAP.
Is there a way to see how many rows loaded in each table in DWC? Maybe in Data Builder?
@Jerry Platz : You could use the "sql view" editor as a sql console and execute there "SELECT count(*) FROM table" via data preview.
Yes, I did create a "sql view" that creates a count table...such as:
SELECT 'Table_01' AS name,
count(*) AS rows
[etc. etc. etc.]
and this produces an Interim (manual) solution.
@Jerry Platz : great to hear and good idea to make a union over all tables. I also think its safe to assume that there will be better methods in the future for that task.
The roadmap shows an item that could solve this issue:
@Sven Knoepfler and @Jerry Platz The databases explorer connection already available.
Although I was able to count records or display data in a view but direct records count is not available.
To connect SAP HANA Database Explorer use Open SQL Schema with option "Consume Space Schema Data"
In your view also enable "Allow Consumption" option.