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

Cue the extraordinary. Show-stopping experiences that raise the digital bar. Apply now for the 2023 Adobe Experience Maker Awards.
SOLVED

Jupiter Notebook - How to see a code behind a view

Avatar

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

 

Regards

ER

1 Accepted Solution

Avatar

Correct answer by
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'


      

View solution in original post

2 Replies

Avatar

Correct answer by
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'


      

Avatar

Level 1
Level 1

Hi there

So sorry to reply so in late i was expecting an email to alert someone has replied.

Anyway your solution is what i was looking for and really made my Day

 

thank you very much for your help

Ettore

The ultimate experience is back.

Join us in Vegas to build skills, learn from the world's top brands, and be inspired.

Register Now