Is your feature request related to a problem? Please describe.
Redshift Serverless users do not have access to tables with STL or SVV prefix. Redshift ingestion requires information in STL and SVV tables.
(psycopg2.errors.InsufficientPrivilege) permission denied for relation stl_insert

Official AWS information can be found here.

Describe the solution you'd like
Queries need to fetch the information from the tables below when redshift is serverless.
SYS_QUERY_HISTORY • SYS_QUERY_DETAIL • SYS_EXTERNAL_QUERY_DETAIL • SYS_LOAD_HISTORY • SYS_LOAD_ERROR_DETAIL • SYS_UNLOAD_HISTORY • SYS_SERVERLESS_USAGE

Describe alternatives you've considered
Should the detection of redshift serverless be done within the original connector? or do we create a new redshift serverless connector?