Want to Stop Rebuilding "Expensive" Parts of your Flow? Explicit Builds are the Answer!READ MORE

Query failed: ERROR: relation "events_complete" does not exist Position: 91

Solved!
Apoorva_K
Level 1
Query failed: ERROR: relation "events_complete" does not exist Position: 91

Hello,

I'm facing an error in the Churn prediction Use cases. Below is the SS of the same. Kindly help me on this.

0 Kudos
1 Solution
ShobanaM
Dataiker
Dataiker

Hi Apoorva,

Can you please try to convert the "event_timestamp" to a timestamp format? It looks like it is being read as text. You could try it in the Prepare recipe or a SQL function like TO_TIMESTAMP(). 

View solution in original post

0 Kudos
4 Replies
ShobanaM
Dataiker
Dataiker
Apoorva_K
Level 1
Author

Hi Shobana,

Thanks for the help.

I did changes as per your instruction and there is another error I am facing. Attaching SS for the same.

 

Thanks in advance.

0 Kudos
ShobanaM
Dataiker
Dataiker

Hi Apoorva,

Can you please try to convert the "event_timestamp" to a timestamp format? It looks like it is being read as text. You could try it in the Prepare recipe or a SQL function like TO_TIMESTAMP(). 

0 Kudos
Apoorva_K
Level 1
Author

Hi Shobana,

It worked!! Thank you so much for your help.

0 Kudos