beam icon indicating copy to clipboard operation
beam copied to clipboard

[Task]: Add more info on setting up alloy db instance in notebook

Open damccorm opened this issue 6 months ago • 0 comments

What needs to happen?

I was going through https://cloud.google.com/dataflow/docs/notebooks/alloydb_product_catalog_embeddings and couldn't quite get my DB set up correctly - I was getting:

An SQLAlchemy error occurred during setup: (pg8000.exceptions.DatabaseError) {'S': 'FATAL', 'V': 'FATAL', 'C': '3D000', 'M': 'database "dannytestdbfordemo" does not exist', 'F': 'postinit.c', 'L': '1148', 'R': 'InitPostgres'}
(Background on this error at: https://sqlalche.me/e/20/4xp6)

I'm not 100% sure what was wrong, but I think we would benefit from having a little more info on setting up the alloy instance in the prerequisites (or if we can script this, it would be even better).

Issue Priority

Priority: 2 (default / most normal work should be filed as P2)

Issue Components

  • [x] Component: Python SDK
  • [ ] Component: Java SDK
  • [ ] Component: Go SDK
  • [ ] Component: Typescript SDK
  • [ ] Component: IO connector
  • [ ] Component: Beam YAML
  • [x] Component: Beam examples
  • [ ] Component: Beam playground
  • [ ] Component: Beam katas
  • [ ] Component: Website
  • [ ] Component: Infrastructure
  • [ ] Component: Spark Runner
  • [ ] Component: Flink Runner
  • [ ] Component: Samza Runner
  • [ ] Component: Twister2 Runner
  • [ ] Component: Hazelcast Jet Runner
  • [ ] Component: Google Cloud Dataflow Runner

damccorm avatar Jun 12 '25 15:06 damccorm