How to query first row of attribute in all tables of an SDE database

Assuming the FeatureReader is the bottleneck I would use two SQLExecutors and only request the column you need.

First SQLExecutor to get the TableName of all tables.

select table_name as TableName from dbo.[SDE_table_registry]

Then a second SQLExecutor to get the ColumnName from the first row of each table

select top 1 OBJECTID from @Value(TableName)

If I run this on my test db, which is slow, it performs quite well.

Thanks @nielsgerrits​ that's worked perfectly.

Just for anyone that has a similar problem.

I used a second SQLExecutor to run nielgerrits SQL query, using the 'name' attribute from the first SQLExecutor in my workbench.

Probably not the most elegant or efficient solutions but gets the job done.