Data Hub connector limitations

The Data Hub connector can only read from entities in the model. It cannot read from relationships.
You must specify the column name in the count aggregate function as count(column_name). You cannot use the wildcard as count(*).