When I run the following :
with CTE_A as (
select * from Teradata_ODBC.[schema].[table]
select * from CTE_A ;
in a single connection query, it runs successfully. However, in a cross connection editor, I get the following error: ERROR: line 4, column 17, ending line 4, column 21: Found 'CTE_A': Not a Heterogeneous Query extension.
I am attempting to join two tables together from different databases. Is this possible?
- Yes, I am able to union all the two tables together (although anything like a join does not work, unsure if related). I am also able to query them separately in the cross connect editor.
- To my knowledge, I think the syntax might be the same between the two platforms as I am just doing a select * from one table
- Got it! That makes sense - when I try to join them together (not in a CTE) i get the following: The remote data object does not exist: "[schema_name]"."[table_name]"; however, again, I am able to union all the tables together
Any help would be appreciated!