Question 19675 in Amazon Web Sevices Question posted in
The official Amazon Web Services documentation can be found here.

How can I save SQL script from AWS Athena view with boto3/python

I have been working with AWS Athena for a while and need to do create a backup and version control of the views. I’m trying to build an automation for the backup to run daily and get all the views.
I tried to find a way to copy all the views created in Athena using boto3, but I couldn’t find a way to do that. With Dbeaver I can see and export the views SQL script but from what I’ve seen only one at a time which not serve the goal.
I’m open for any way.

I try to find answer to my question in boto3 documentation and Dbeaver documentation. read thread on stack over flow and some google search did not took me so far.

Tags:

2

Answers


  1. 0

    Have you tried using get_query_results in boto3? get_query_results

    Login or Signup to reply.
  2. 0

    Views and Tables are stored in the AWS Glue Data Catalog.

    You can Query the AWS Glue Data Catalog – Amazon Athena to obtain information about tables, partitions, columns, etc.

    However, if you want to obtain the DDL that was used to create the views, you will probably need to use SHOW CREATE TABLE [db_name.]table_name:

    Analyzes an existing table named table_name to generate the query that created it.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search