i have an issue linking my data lab to a different database in Teradata?

Teradata Studio
Enthusiast

i have an issue linking my data lab to a different database in Teradata?

so i uploaded an excel file called client into my data lab. the excel file has client id. i linked the client id in my client table in my data lab to a different table that is contained in Teradata in a different database. i cant get results. any idea on whats goin on? see below the query. my data lab called G. the other database called L. the table in database L called customer. i am joiing on client id in the client table to the customer id in customer table

 

select "G"."client"."client id from "G"."client" join L.customers on "G"."client".client id=L.customers.customer id

1 REPLY 1
Teradata Employee

Re: i have an issue linking my data lab to a different database in Teradata?

 Hi mikefiorelli,

 

When you say you can't get any result, does your query give you a 0 rows answers or an error message ?

I'd say it's probably a permission issue.