How do I debug an invalid syntax error?

[vedantroy]

I'm using the notebook editor, and I'm getting the following syntax error when trying to create a model:

ERROR: invalid input syntax for type bigint: "0.95"

How am I supposed to debug this and get broader context? Is there some way to view the underlying SQL query (which is presumably where the syntax error is?)

[kirean]

integers should not contain decimals.

More information would probably help us understand your specific problem

[shrey]

Invalid input syntax error

I keep running into this error, due to which my model is not working properly, leading to charts & dashboards also not working. Error: ERROR: invalid input syntax for type bigint: "0.384" Now, in my db table, there's only 1 column which is 'bigint', which is the the primary key: [image] I've also tried to identify the responsible record in the table, by running the query: select * from logs where "id" = 0.384; but this yields 0 results. Then why am i getting the error? I have already …