search

cloudmesh / cloudmesh-redshift

Shirish Joshi - Experimental
Other
0 stars 1 forks source link

queries and use #6

Open laszewsk opened 5 years ago

laszewsk commented 5 years ago

There is more to redshift than just using and implementing access to it

https://docs.aws.amazon.com/code-samples/latest/catalog/code-catalog-python-example_code-redshift.html

what about defining things and a query ....

there are even examples in python on how to do that on the web

joshish-iu commented 5 years ago

Yes, I was writing some example programs in python (separately) It requires installation of psycopg2. If I list that in my project requirements.txt, should that be fine ?

laszewsk commented 5 years ago

There are two aspects to it

A) the cms command should be able to Devine a database this can naturally use internally psycopg2 which I also looked at

B) as query command needs also to be added to the cos command so I can issue queries

C) naturally a small example for psycopg2 is also needed, but it needs to use Config() and cloudmesh4.yaml to specify cloud, which you seem to understand very well

D) just as with the cms you need to demonstrate this also with OpenAPI

So the issue is not just setting up a redshift cluster but how you define, put data into the db and query it all from cms and openapi

On Apr 27, 2019, at 8:56 AM, joshish-iu notifications@github.com wrote:

Yes, I was writing some example programs in python (separately) It requires installation of psycopg2. If I list that in my project requirements.txt, should that be fine ?

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/cloudmesh-community/sp19-616-112/issues/6#issuecomment-487284004, or mute the thread https://github.com/notifications/unsubscribe-auth/AADHYVJMKYGZ44MS2D3HIBTPSREQRANCNFSM4HI3OTFQ.

joshish-iu commented 5 years ago

Modified redshift draft code with ability to create tables, issues queries.