psycopg2.errors.FeatureNotSupported: Specified types or functions (one per INFO message) not supported on Redshift tables

Solution 1:

This error is generated by Redshift and in most cases it is when your query uses a leader-node only function (such as generater_series() - there are a number of these). Look at your select_query code and check if the functions called are valid on compute nodes (run the query in a workbench). Happy to help if you post the query. The issue is the SQL, not the code you posted.

The root of the issue is that leader node information is needed by the compute nodes during execution and this route isn't supported. There can be several causes for this and each has work-arounds.