Hello Everyone,
As the tittle says im curious if its possible to read data from a secondary database.
On my use case, im trying to read data from a database that i only have read access and on the test module i created i have set the connection to the secondary database and the name of the table.
As for the module fields i have set them to Alias and wrote the name of the column on the secondary database.
For the system fields i have turned off all of them except the record ID which i cant turn off and set it as alias and wrote the primary Key of that table.
But even after this, i get an issue saying that the model cant be created because of an issue:
cannot create model 473376949838872577 on connection 471453232083238913: connection has issues
Now, i dont know if the connection is actually the issue because no issue shows up on the admin page but i know that i have tried before with a different connection where i had permissions to create things and this issue didnt show up on the module.
If someone could help me and tell me if its possible or not to do this i would appreciate it.
Thanks.