Error trying to create a Vectorstore table

[gitsathish]

Not able to create a vectorstore,
from langchain_google_alloydb_pg import AlloyDBEngine

engine = await AlloyDBEngine.afrom_instance(
project_id=PROJECT_ID,
region=REGION,
cluster=CLUSTER,
instance=INSTANCE,
database=DATABASE,
)

await engine.ainit_vectorstore_table(
table_name=TABLE_NAME,
vector_size=768, # Vector size for VertexAI model(textembedding-gecko@latest)
)

My params are correct for project,region,cluster,instance and database.

I am getting a 404 back, appreciate any insights.

ClientResponseError: 404, message='Not Found', url=URL('https://alloydb.googleapis.com/v1beta/projects/XXXX/locations/us-east4/clusters/XXXXX/instances/XXXX/connectionInfo')

[averikitsch]

Hi @gitsathish, Is your AlloyDB Cluster have a public or private IP address? To be able to connect from outside a VPC network you need to enable Public IP, see instructions https://cloud.google.com/alloydb/docs/connect-public-ip. The integration defaults to using public IP. If you are using private IP from that is deploy into your VPC network, then you will need to pass in ip_type="PRIVATE" into the AlloyDBEngine.

[gitsathish]

Trying to connect from a user managed notebook in the using the same VPC as alloydb. Still getting the same error,

engine = await AlloyDBEngine.afrom_instance(
project_id=PROJECT_ID,
region=REGION,
cluster=CLUSTER,
instance=INSTANCE,
database=DATABASE,
ip_type="PRIVATE"
)

[averikitsch]

I can reproduce the 404 error if the database or cluster fields are incorrect. Can you use the code snippet https://gist.github.com/jackwotherspoon/8a9af3ac1e60e493d32364b3931c6feb to test if you can connect to the Private IP address from your notebook?

[averikitsch]

Please reopen this issue if you continue to experience this issue. Thanks!