+ New Ticket

Views on External tables

Comments

2 comments

  • Official comment
    Avatar
    Jeff Schlitt

    Sarah,

     

    Thanks for more feedback!  Couple of questions.

    1. What platform is this, Netezza?

    2. Are you referring to something like 

    create view sample_view as

    select col1, col2, col3

    from external_table_1;

    You are saying that the columns do not display in this instance?

     

    Jeff

    Comment actions Permalink
  • Avatar
    Sarah Talbot

    Hi Jeff

     
     We have some external tables created on Amazon Redshift Spectrum for viewing data in S3.   We have microservices that send data into the s3 buckets.   We then have views on the external tables to transform the data for our users to be able to serve themselves to what is essentially live data.  
     
    Yes I am referring to :-
     
    create view sample_view as

    select col1, col2, col3

    from external_table_1;

    The columns do not display but to be fair they didn't in Workbench.   I get an error in WorkBench:-

     
     
    However, in workbench I could right click and generate DDL and see what the columns are that way.  That option doesn't appear to be available in Pro yet.  This is what it looks like when I try to expand the view on Pro

    Hope that helps

     

    Sarah

    0
    Comment actions Permalink

Please sign in to leave a comment.