Hey! We got a Redshift connection with Redash, we have a few connections set, however, one of the connections seems to open many transactions and we cannot really tell why this is happening. The transaction always executes the following query (part of this but you get the gist):
WITH tables AS ( SELECT DISTINCT table_name, table_schema, column_name, ordinal_position AS pos FROM svv_columns WHERE table_schema NOT IN ('pg_internal','pg_catalog','information_schema') ) SELECT table_name, table_schema, column_name FROM tables WHERE HAS_SCHEMA_PRIVILEGE(table_schema, 'USAGE') AND ( table_schema IN (SELECT schemaname FROM SVV_EXTERNAL_SCHEMAS) OR HAS_TABLE_PRIV
Is this normal behaviour? Why is this happening with one connection out of the 5 that we have?
Would appreciate help,