Does anyone know what this error means? It gives me no other explanation other than: Data Stream Out (58) Error SQLPrepare: SQL compilation error: schema object identifier. I have no clue what the issue is, all the connections are correct, I have many other in-db connections on this workflow all work fine, except for this one. The query runs fine when running it on snowflake too, so I just don't see what the problem is. Anyone encounter this before?
Solved! Go to Solution.
Oh wow. it was that simple huh. makes the ETL flow more complex since I have to pull out of 3 separate tables and join/union, but I guess it works fast enough. Thanks! good to know.
If it's always 3 tables - and fairly set - I'd recommend three different in-db tools or dynamic in-db) then a Union In-DB.