Hello - I am trying to get SQL datasets to work, but every query I try returns a failure. In this case here, I even tried converting an existing (working) dataset to SQL, and that fails as well.
Best answer by Moises Morales
View originalSQL dataset query failure
Userlevel 3
Hi Erik,
The query is failing because the table “organizations” cannot be found. Note that data source managers (Drill and Dremio) utilize multi-element paths to database objects, requiring the use of fully qualified paths when creating SQL-based datasets. For example:
SELECT employee_id, employee_name
FROM dremio_default.public.employee_table;
-Moises
I cleared the whole LDM and started over with just one dataset, but I am still seeing this issue.
Userlevel 3
Sorry to hear that, are you using a fully qualified path as exemplified in my previous comment? If so, could you please send over the new Trace ID?
Reply
Login to the community
Sign in with your community account. This is different than your login to your GoodData account. Don't have a community login? Create an account
Social Login
or
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.