CODEWITHSUNDEEP
amazon-web-servicesamazon-athenaalchemy
Della
Della

Reputation: 1614

Can I Create Table in AWS Athena with SQL Alchemy ORM?

I have been made to understand that Athena is different from normal SQL as it basically reads and queries data from an s3 backend. However, I am very much used to the SQL Alchemy ORM interface for querying databases as well as upserting data, creating tables etc. I already tried querying my company athena database with pyathena and it is working fine. However, does creating table work the same way as in other MySQL databases (such as RDS), so that I can reflect the existing tables and create a new one using my python code? Or is there some athena specific pitfall I should be aware of?

Upvotes: 0

Views: 224

Answers (0)

Related Questions