Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Jupiter Notebook - How to see a code behind a view


Level 1
Level 1

Hi there,


there are many views created in Jupiter notebook but i am not able to find out the most recent code if someone overwrites the view.


Does someone know the sql command to find out the code behind an existing view?

something like "show view" command in teradata


Really appreciate you help




1 Reply


Level 4

Hi @ER4 , I'm assuming you want to inspect your view definition which is created inside AEP via Jupyter notebook. This forum is for AEP and it uses PostgreSQL not Teradata. So with that assumption in order to access view definition inside AEP you can use below query which reads view definition from .Postgres 'pg_views' table.

select definition from pg_views where viewname = 'your view name'