add vertica implementation for BI workflow