In my plugin recipe i'm using the SQL Executor and passing overwrite_output_schema and I'm getting this error.
Error in Python process: At line 512: <class 'Exception'>: Query failed: b'ERROR: column "index" is of type bigint but expression is of type character varying\n Hint: You will need to rewrite or cast the expression.'
I've also tried casting the column as varchar to no avail.
Here is the index column
rank() over(partition by customer_id, index_period order by date asc) as index
In the past I've resorted to going to the dataset schema and overriding the column there, but it only saved when changing the length not the type.