maodag Member

Comments

  • Yes, I have a PostgreSQL SSH connector set up, and it does allow me to write arbitrary queries (including `EXPLAIN`). However, it's more of a workaround than a full-fledged solution for running exploratory queries in real-time. The query editor is a simple textarea Editing the query and re-running take multiple steps (the…
    in Is there a way to run ad-hoc SQL queries against arbitrary PostgreSQL tables? Comment by maodag November 2022
  • I believe the connector is "PostgreSQL Federated Query" or "postgres-federated". I can only seem to choose which table to connect it to and there's no option to enter a raw SQL query. You could also use MySQL dataflows, though that requires having a dataset created for each input table. This wouldn't allow me to run…
    in Is there a way to run ad-hoc SQL queries against arbitrary PostgreSQL tables? Comment by maodag November 2022
  • Resolved: enabling debug-level logging on the ssh server revealed that Domo's SSH client requires some old algorithms to be enabled. KexAlgorithms +diffie-hellman-group14-sha1 HostKeyAlgorithms +ssh-rsa PubkeyAcceptedAlgorithms +ssh-rsa Also, the private key needs to be in PKCS1 format, i.e. the first line of the key…
    in SSH postgres Comment by maodag November 2022
  • @Beach Pardon me for the ping - I'm curious if you were able to resolve the issue. I'm hitting the exact same error trying to set up the PostgreSQL SSH connector, and I've also confirmed that I can connect to my RDS instance through a bastion SSH server using a public-private key pair. @GrantSmith Any further insights?
    in SSH postgres Comment by maodag November 2022
Default Avatar