Python script to list tables those doesn't have primary key constraint in all postgres databases
$30-250 USD
Pagado a la entrega
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.
Nº del proyecto: #26817264
Sobre el proyecto
Adjudicado a:
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 están ofertando un promedio de $138 por este trabajo
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 Más