Hello,
I’m currently trying to add a new data source using the PostgreSQL connector. The database I want to connect to is accessed via a bastion host EC2 instance on AWS. I’m able to access the database from my computer using different clients (psql, DBeaver, etc.). However, when using the same credentials on Looker, I’m not able to create a connection.
I’ve tried connecting with SSL enabled by uploading to Looker a global certificate downloaded from AWS, but that doesn’t seem to work either. Are SSL certificates always required in this case?
I know that this same database is being used in another Looker project. Does looker not allow multiple dashboards from different projects connecting to a single data source?