Is there any way to list out the tables/views from other gcp projects using a particular view in a source project(context – data engineering).

Neither the service accounts nor individual’s, rather finding the tables/views itself from other counter gcp projects.

If the query driven ETL flow is run by a wrapper(python/shell), we can manually find them travelling through the jobs/scripts. I am interested in the ways of finding them through sql query or bq command if exists.