Hello! I’m trying to enable sql profiling for our ...
# troubleshoot
c
Hello! I’m trying to enable sql profiling for our redshift cluster but i’m having an issue. Has anyone encountered such an error?
Copy code
ProgrammingError: (psycopg2.errors.InsufficientPrivilege) permission denied for relation campaign_retention_order_segment

[SQL: CREATE TEMPORARY TABLE "ge_tmp_61606ece" AS SELECT * 
FROM dev.campaign_retention_order_segment 
 LIMIT 10]
I’ve solved the issue- You need to be superuser in redshift