Getting Data from ODBC using SQL statement

[Anonymous]

I'm receiving this error when I try to use a SQL statement to parse the data by date. (Using ODBC connection)

Here's my current SQL Statement: 

SELECT fv_v_allocated_time_view_all_modules_lem_filtered.timesheet_fmt_dt, fv_v_allocated_time_view_all_modules_lem_filtered.last_name, fv_v_allocated_time_view_all_modules_lem_filtered.first_name, fv_v_allocated_time_view_all_modules_lem_filtered.skill_type, fv_v_allocated_time_view_all_modules_lem_filtered.rate_1_rate, fv_v_allocated_time_view_all_modules_lem_filtered.project_id, fv_v_allocated_time_view_all_modules_lem_filtered.work_unit_id, fv_v_allocated_time_view_all_modules_lem_filtered.company_code,fv_v_allocated_time_view_all_modules_lem_filtered.employee_or_equipment_id, fv_v_allocated_time_view_all_modules_lem_filtered.equipment_ind, fv_v_allocated_time_view_all_modules_lem_filtered.rate_1_hours, fv_v_allocated_time_view_all_modules_lem_filtered.company_name, fv_v_allocated_time_view_all_modules_lem_filtered.net_billable_time, fv_v_allocated_time_view_all_modules_lem_filtered.last_modified_by, fv_v_allocated_time_view_all_modules_lem_filtered.extra_charges
FROM vdb_track.fv_v_allocated_time_view_all_modules_lem_filtered
WHERE timesheet_fmt_dt > '12/31/2017'

[dax]

Hi JakeRyan11,

You said when you use SQL, it will cause this problem, if you write "select *  from table", will this work ? Or if you don't write sql query, will this work? In addition, I am not sure whether this is caused by sql query or other  factors. And whicy type file you are using in ODBC? And you also could check which step will cause error in Edit Queries.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

The table or view name was too long, so I tried to give it an alias like below:

SELECT v.timesheet_fmt_dt

FROM vdb_fv_v_allocated_time_view_all_modules_lem_filtered v

WHERE v.timesheet_fmt_dt > '12/31/2017'

This worked for me.

[Anonymous]

Thanks dax, 

The ODBC is connecting to our data lake through Denodo. 

I've added "SELECT * FROM TABLE" but now receive this error: 

If I do not type in the word "TABLE", then it runs this error: