Skip to content

External schema/table(s) are not visible on RedShift #3880

Description

@oliviertassinari

Description

SELECT schemaname as table_schema, tablename as table_name, 'TABLE' FROM svv_external_tables;

Return results:

etl	analytical_ledger	TABLE
etl	bank_accounts	TABLE
etl	bank_transactions	TABLE
etl	companies	TABLE
etl	company_users	TABLE
etl	customer_invoices	TABLE
etl	customers	TABLE
etl	fiscal_years	TABLE
etl	general_ledger	TABLE
etl	supplier_invoices	TABLE
etl	suppliers	TABLE
etl	tax_declarations	TABLE
pennylane	analytical_ledger	TABLE
pennylane	bank_accounts	TABLE
pennylane	bank_transactions	TABLE
pennylane	companies	TABLE
pennylane	company_users	TABLE
pennylane	customer_invoices	TABLE
pennylane	customers	TABLE
pennylane	fiscal_years	TABLE
pennylane	general_ledger	TABLE
pennylane	supplier_invoices	TABLE
pennylane	suppliers	TABLE
pennylane	tax_declarations	TABLE
pennylane	trial_balance	TABLE
pennylane	vat_declarations	TABLE

It's consistent with https://data-sharing.pennylane.com/docs/en/home.html

Current Behavior

However, no table shows:

Image

Expected Behavior

It shows.

Environment

  • TablePlus 7.1.1
  • Reshift PostgreSQL 8.0.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.4.2 20041017 (Red Hat 3.4.2-6.fc3), Redshift 1.0.323213

The bug seems equivalent to #1297.

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Fields

    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions