none
Automated Unit testing RRS feed

All replies

  • Do you want to test the database only or do you want to test an entire solution that uses Azure SQL Data Warehouse, by testing individual procedures against the database?

    I have found Silk Test to be the best testing platform (link). This is not a Microsoft nor Azure hosted solution. Just speaking from experience. Please let us know if you have additional questions.

    Regards,

    Mike

    Friday, June 28, 2019 12:06 AM
    Moderator
  • Hello Mike,

    Thank you for you response.I will definitely try the Silk test part.

    I want to perform both the scenarios wherein:

    1)  The schema validation (DW should have a certain # of tables with certain columns with certain data types) : we would have a metadata table w.r.t the schemas and would like to validate the DACPAC every time before deploying

    2) The data load logics (the stored procedures)

    Friday, June 28, 2019 3:09 AM