Can we automate dwh data test scenarios with robot framework? When I check the videos related with robot framework, i always see related with web automations. Are there any videos or tutorial for data test automations?
i mean i have dwh tables. and i want to run some test scenarios automatically anomaly tests, duplication tests etc.
Short answer: yes, can be done.
Longer answer; if you need to ask “can we write”, it might be bit harder. But essentially, you might need to do a wrapper in python that talks to your database and can fetch data via SQL and verify o robot end or just run the tests in pure SQL.
Wrote something like this for databricks few years ago and essentially, databricks provided python driver to connect to it and then i had 3 keywords written in in python:
- Open Connection To Databricks
- Close Connection To Databricks
- Execute SQL On Databricks
Last keyword returned row counts for the query passed in as argument and that was enough of integratation and rest was just logic implemented in RF ..
And if your particular DWH provider does not provide python library to connect to it, using remote library can be used to write the keywords in what ever language you might have those drivers.