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
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.