Hi, I am trying to connect a specific schema from a SQL mirror which is on Amazon Redshift. I don’t have admin access/permissions to the whole SQL mirror, just one specific schema. I have connected the database using the details provided to me but no tables or schemas are showing up - I suspect because of these admin issues. Is there a way to specify access to just one schema?
Please post “Diagnostic Info” from Admin > Troubleshooting.
And post any errors during the sync process from Admin > Troubleshooting > Logs.
The schemas that are available should be shown in the interface. Can you query the schema manually in Metabase with a Native/SQL query?