querying across Teradata installations?

Analytics
Enthusiast

querying across Teradata installations?

Is it possible to query across two Teradata installations (instances?). I'd like to create a table in Teradata installation 01 from a view I've created in Teradata installation 02.

TIA,
Nolan
2 REPLIES
Enthusiast

Re: querying across Teradata installations?

Hi,
No, It is not possible in teradata.
Check whether third party tools are available for this.

Regds,
sachin
Enthusiast

Re: querying across Teradata installations?

Hi,
It is not possible to directly query across instances. But you could use the BTEQ or UNIX scripting techniques to easily sketch the appropriate DDL statements required to create the Table in instance 2 based on DDLs from instance 1. This would be one work around or suggestion you could follow.