Continuous integration and continuous deployment in DW/BI

Deployment method

In Redshift

1, Deploy Process:drop and Refresh the view, Drop table, Create an empty table using the DDL
2, Build data:insert the data to table from the view

In Netezza, when do deployment:

1, Deploy Process:drop all the existing tables, Refresh the view and create the a empty table for that view
2, Build data:create the table with data (CTAS from view), replace the empty table with the new table

When building data, the scripts would first create an a table with a incoming suffix, then does some data validation, if all P assed, then replace the empty target table with the incoming table.

Jenkins slaves is an EC2 Linux server.
In the slave, it calls shell script to run of the SQL (Refresh views and tables)
It also run shells which connect to the DMA server to run the DMA jobs
Using pipeline to get Jenkins jobs connected

Continuous integration and continuous deployment in DW/BI