Data Source "SQL Table" can't access tables outside of the CiviCRM database
I can use a SQL Table source to connect the Contact source to the civicrm_uf_match table (they are of course in the same database). I cannot connect the civicrm_uf_match to the drupal users tables in a different database.
I entered the table name as d9.users_field_data (entering without the leading database name doesn't change the outcome). The database user has access to both civi and drupal databases (of course). When I then try to complete "Join on Field" there are no fields available (on the d9.users_field_data side ... the other side has the full field list for the other data sources). The drupal log records this as a civicrm Error with message "Table d9.users_field_data does not exist!"
I looked through the DataSpecification.php code ... I don't see anything about database definition or selection (but ... I'm pretty blind when reading these files).
so .. is there a way to access other databases? Will this resolve if I just place all the civicrm tables in the same database as drupal?