New to NEON - some questions about icons and querying views from Colab.
Hey folks - a client shared access to a database with me via Neon. In the console I can see many tables and what I believe is a view. See icons in the attached image. Is that second icon indicating a view?
I've also following the instructions at https://neon.com/docs/ai/ai-google-colab to connect to the database from colab. I don't see any of the views there but I can see and query the tables. Has anyone come across a similar issue? When I'm following the "Retrieve your database connection string" instructions is there something additional required to expose existing views?
Neon
Google Colab - Neon Docs
Google Colab is a hosted Jupyter Notebook service that requires no setup to use and provides free access to computing resources, including GPUs and TPUs. You can use Google Colab to run python code th...
1 Reply
adverse-sapphire•2mo ago
That icon does indeed indicate a view.
your inability to see Views in Colab is odd. My guess is it's either:
1. The credentials you used to access the DB from Colab don't have access to the view
or
2. Google Colab doesn't show views in the same place it shows tables
You can probably test (1) by using the same credentials you gave Colab, connecting to the database via PSQL command line, and looking for the view with
\dv
You can test (2) by making another database (like a throwaway one on google cloud SQL) creating a view there and seeing if it shows up in Colab