Canvas Data 2 - Get Row Count in a Table without fetching all the data

[ZahidIlkal]

When using CD2, is there a way to retrieve the total rows in a specific CD2 table? I am using CD2 to load data in a visualization tool. After pulling data using a full snapshot, i periodically pull incremental snapshot for changes

I also collect quality metrics like row count. Since the incremental snapshots only provide upserts, it is hard for me to keep track of total row count at any given point in time.

Is there a 'metadata' only API in CD2 that allows me to pull some retrieve table specfic metadata?

Thanks

[LeventeHunyadi]

Unfortunately, no such metadata-only API exists today.

[ZahidIlkal]

Thank you for your reply,

Do you have any other suggestion on how to get the row count for individual tables without fetching the full data (using standard apis perhaps)?

[jsimon3]

I highly doubt there is one. I have a variable for incremental time that is based on the last success pull per table, so if a table was unsuccessful the time increases on the incrementalSnapshot parameter to ensure that I am getting everything...
I agree that a count or even better a checksum would be awesome...

[kdoherty2]

I also agree that there needs to be a way for us to validate row counts by table.