Forum Discussion
Advocate IIIOne Table is erroring out (while parsing data) when I try to query it in the SQL Analytics end point
Hi 12angrymentiger
There might be an issue with a value in the EndDate column. Please review the data values, especially if you have other datetime columns working like StartDate.
Hope this helps. Please let me know if you have any further questions.Hi Anonymous I was able to fix this issue by setting the EndDate column as a StringType(). I also had to do the same thing with another date field which is weird as the data looks fine.
I'm now able to query the table in the sql endpoint.
Thanks again
Advocate IIIHi Anonymous I'm creating a landing/bronze/silver table and then a merge to gold just like all 50+ other tables I have.
This is the only table that is having a problem querying and it appears to be on one field only (EndDate).
Hi 12angrymentiger
There might be an issue with a value in the EndDate column. Please review the data values, especially if you have other datetime columns working like StartDate.
Hope this helps. Please let me know if you have any further questions.
- 12angrymentiger
Hi Anonymous I was able to fix this issue by setting the EndDate column as a StringType(). I also had to do the same thing with another date field which is weird as the data looks fine.
I'm now able to query the table in the sql endpoint.
Thanks again
Hi 12angrymentiger
Glad that your query got resolved. Please continue using Fabric Community for any help regarding your queries.