Synapse Environment query

Question

We are planning to expose the Lake Data to business users, where they will use the Production data to explore, build Apps, AI/ML models or even generate reports.

I'm pretty confused here, as the development will happen in Production environment data and how can i implement CI/CD around it, as normal process involves environment Dev, QA and then deploy to prod.

Answer 1

Hi @Anonymous ,

Thank you for posting query in Microsoft Q&A Platform.

You can consider either of below two approaches.

Approach 1: Try to have your lake data also separately for DEV environment. And In CI/CD process while deploying things to different environments make sure to have use corresponding environment related storage accounts or paths.

Approach 2: If you are okay to use PROD related lake data itself for development. Then in your CI/CD process while deploying things don't override anything related to lake data as its going to be same for all environments.

Hope this helps. Please let us know if any further queries.

---------
Please consider hitting Accept Answer button. Accepted answers help community as well.