Python script to list tables those doesn't have primary key constraint in all postgres databases
$30-250 USD
Paid on delivery
I have around 200 postgres databases in aws rds across all accounts. I have two metadata tables which has connection info and credentials info.
Tasks:
1. Need to use these two tables to make a connection string to connect every database.
2. loop over every database, connect and list tables those doesn't have primary key. If a table doesn't have primary key, get estimated number of rows from table statistics.
3. have the script create a table in local database with columns like account,region,inst_id,schema,table,estimated_rows.
4. store the results from step 2 in step 3 table.
Project ID: #26817264
About the project
Awarded to:
I have rich experience designing database schema and Python programming. I can create write script to connect to databases an d check for primary key constraints as per given requirements. Please ping me to start with.
6 freelancers are bidding on average $138 for this job
Hope you are doing well.. An interesting task. This can be done through AWS Lambda function that executes your query against your backend database. The API Gateway REST API that invokes the Lambda function when you ac More