How do you create a tbl object that connects to a linked server?
I love using dbplyr to work with databases and often setup table objects like this with no problem.
But I can't seem to add a linked server name.
This code works but I want to create a tbl and not pull back a dataframe.
DBI::dbGetQuery(con,'select * from linked_server.database.schema.table')
I think the issue is something to do with each object needing to be quoted but I can't quite figure out how to do this myself.
Any help would be much appreciated.