Convert query for count and updated date
Starting point, mostly unchanged:
SELECT count(*), min(last_updated_date), max(last_updated_date)
FROM   schema.table;


Be aware of (not) case sensitive behavior of identifiers in Postgres. If in doubt use legal, unquoted, lower-case names exclusively. See:

Are PostgreSQL column names case-sensitive?


A table can optionally be schema-qualified (schema.table), but not database-qualified. A name like from &quot;SOURCE&quot;.&quot;SCHEMA&quot;.&quot;TABLE&quot; would raise:



ERROR:  cross-database references are not implemented: &quot;SOURCE.SCHEMA.TABLE&quot;



Table names without schema-qualification are resolved according to the current search_path. See:

How does the search_path influence identifier resolution and the “current schema”


count(*) is a bit faster than count(1).

Min and max can be read from a matching index in next-to-no time. Only the count can be slow. If your count does not have to be exact, consider:

Fast way to discover the row count of a table in PostgreSQL