i am trying to connect to supabase from palantir foundry, but running into some connection issues --
has anyone dealt with this before?
37 Replies
these are the fields i need to fill out, and an ingress/ egress policy
still stuck on this would love some help
You get the connection info from the connection tab at the top of the dashboard. Pay attention to the IPv4 and IPv6 options depending on how palantir connects to the db. No one has ever mentioned palantir here before so you are on your own as far as the specifics for it.
@garyaustin might i need to whitelist the connection. I pulled those creentials but am still getting some connection error, im connecting via hostname, database name, user,pass
There is no whitelist for supabase.
What connection method are you using? Show some info but mask instance id.
can i pm?
Just the link. I don't solve issues in PM's.
im connecting via direct connection, i dont mind sending a screencap because the info is not sensitive on the database. its data pulled from a public api
So the direct connection is IPv6 only. Are you sure you have an IPv6 compatible computer/router/network or the palantir server (if that is what it is) supports it.
Also 6543 is normally used for pooling. 5432 would be for the direct DB connection.
yeah i was using that before just tinkering.
Try the session pooler info which is IPv4 compatible.
so on foundry (palantir) i can connect via hostname or ipv4
Ok still in the hostname option from the screencap correct?
or switch to ipv4
No there is a different host name and user name
see the connection tab.
im looking at it, i see
ok, moment
I don't know what palantir IPv4 means... It could be use the REST API which is different.
Stay on hostname setting
Palantir
Palantir
Connect Foundry to PostgreSQL ↗ to read and sync data between PostgreSQL databases and Foundry. This connector uses the official PostgreSQL driver...
kk
crap, its still not working, if you'd be able to join voice I could screen share
You want to use this info:
But with hostname settings not the IPv4 one
so the hostname text box, i would enter the long postgres string?
The host string
aws....com
i see
and just match the values accordingly, database name = postgres , etc
user is the tricky one but if you copy it with the instance id part that is what is needed.
damnit im still getting an error, let me double check my database pw
this is so frustrating :/
ooh i got a differet error this time
Not sure what magrittesourcestore means.
me neither, looking closer.
Not sure if it is related to the connection or not.
let me whitelist this on foundry real quick
ok still same error - i might just put this on a different hosted db for the moment
is there anyway to see if these are foundry?
eh foundry is still being a pain, different error though
i got it! @garyaustin '
i just had to disable ssl mode on foundry - I guess it wasn't able to create a handshake
There are settings in SB for that too, but if it is working....
https://supabase.com/dashboard/project/_/database/settings
thank you! @garyaustin