Thread
#secoda-support
    e

    elegant-house-93198

    5 days ago
    Hey @adamant-forest-45768 this is the query that we run on Redshift to get the schemas. If you run it with the same user that’s connected to Secoda and you get different results than what you’re seeing in the UI let me know.
    SELECT DISTINCT
                t.table_catalog       AS cluster,
                t.table_schema        AS schema
            FROM svv_tables t
            WHERE schema != 'pg_catalog'
                AND schema != 'information_schema'
                AND schema != 'pg_internal'
                AND schema NOT LIKE 'pg_temp_%%'
            ORDER BY cluster, schema;
    a

    adamant-forest-45768

    5 days ago
    Hey @elegant-house-93198 yeah, I get 25 schemas when I run that query from within my SQL client using the credentials that Secoda uses to connect to our RS cluster
    e

    elegant-house-93198

    5 days ago
    @adamant-forest-45768 you are correct, it’s an issue on our end. We’ve pushed a fix that should be available in ~10 minutes to fix your issue. Please let us know if it’s resolved
    a

    adamant-forest-45768

    5 days ago
    @elegant-house-93198 thank you sir! Happy to report I can see them all now. Y'all are lightning fast with those hotfixes. 🙏