Overview
This section outlines the recommended methods for deploying the SQL code generated by Stream2Vault (S2V).
The primary approach, Deployment via Makefile, leverages Makefiles and SnowSQL for a structured and configurable deployment process. This method is detailed with examples, covering the orchestration of SQL script execution, environment configuration through .ini files, and variable substitution. It's designed for consistency and manageability across different deployment environments (dev, test, prod).
For scenarios requiring more flexibility or integration with existing CI/CD pipelines, a Custom Deployment approach can be adopted. This allows for on-demand execution of generated SQL files using various tools or processes.