Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Hello, Dataiku Team
I made a connection between a Postgres RDS and Dataiku. It worked ok.
I decided to make a backup in a new virtual machine (ubuntu) in a EC2 of the RDS. I restored it on the installed Postgres in this virtual machine. Before restoring, I created a new user and bd to restore it. I made the new connection between the postgres virtual machine and Dataiku, it worked well. But when I wanted to run a recipe on one of those tables that become from the backup, it shows, for example: Job failed: ERROR: relation "my_table" already exists.
I already executed the next commands in psql:
GRANT ALL PRIVILEGES ON DATABASE <bd_name> TO <user_name>;
GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA <schema_name> TO <user_name>;
When I create a complete new table with a recipe, it works well.
Why does it happen?
Thank you!!!!
Operating system used: Ubuntu
Hi,
The error suggests the table already exists; this can happen if the table name is too long > 63 characters(postgres limitation).
You should change the table name in the settings tab of the shorter name to resolve this.
Thanks