-
Goal: I want to return some data from a linked sql server
-
Query: select top 10 * from [linkedServer].[database].[schema].[table]
I've simplified this drastically for ease of understanding.
I am trying to run a SQL query that accesses a linked server. My resource (database_a) has a linked server of (server_1) in SQL and in MSSQL, my query works fine and returns the top 10 rows.
In Retool, I want to run my query using my 'database_a' resource and access data inside 'server_1' to pull back some data. I do not get an error but I do get no results returned, even though data is returned when running the same thing in a SQL manager.
I was curious if this is something Retool does not allow, or if this is something that needs special attention further than I am attempting