× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
tomconrad reported 2017-08-31T21:38:47Z  · vignanpashikanti last modified 2020-04-15T12:34:49Z

Amazon Redshift - Add schema tree support for external databases. external schemas and external tables


customer request Require Automation
Priority Major
Complexity Unknown
Component DB - RedShift
Version 20.6

Currently, our schema tree doesn't support external databases, external schemas and external tables for Amazon Redshift. Extraction code needs to be modified to handle these. The external schema should not show up in the current schema tree. The attached patch filters this out. We need to create a separate area just for external databases, schemas and tables. The patch sets this up.

This is going to be the layout for the external objects in the tree. Attached is a patch to build the tree objects with extraction code. Right clicking on the objects should allow the following commands:

EXTERNAL DATABASES NODE - Create
 INDIVIDUAL NODES
   GUI OPERATIONS 
     Create  
     Properties
   SCRIPTING
     No scripting
 
EXTERNAL SCHEMAS NODE - Create
 INDIVIDUAL NODES
   GUI OPERATIONS 
     Create
     Drop 
     Properties
   SCRIPTING TO WINDOW, NEW WINDOW, FILE
     Create
     Drop 
 
EXTERNAL TABLES NODE - Create
 INDIVIDUAL NODES
   GUI OPERATIONS 
     Create
     Alter
     Drop
     Properties
   NO EDIT TABLE DATA
   SELECT TOP 1000
   SCRIPTING TO WINDOW, NEW WINDOW, FILE
     Select *
     Select
     Create
     Drop
 
EXTERNAL COLUMNS NODE - None
 INDIVIDUAL NODES
   GUI OPERATIONS 
     None
   SCRIPTING
     None
 

These commands will need to be added in the code. The underlying gui menu's will need to be created to support the features for each object (databases, schemas and tables) based on the available features found in the Amazon documentation. Additionally, we will need to provide the underlying code to support the scripting features mentioned above. This includes Schema Script Generator. Remember, that external tables are stored in Amazon s3 buckets and are read only. This therefore limit the operations available.

40 attachments

Issue #15455

Verified
Fixed
Resolved 2020-02-21T13:18:35Z
 
 
Completion
No due date
Fixed Build ADS 20.6.0-dev-32-no-ofsc
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017