Currently the only behavior is to run queries using Lakehouse Federation. Adding support for bcp and Redshift's UNLOAD requires a new column that controls the data extract behavior.
Todo
- Add a column called
extract_type with allowed values query, unload, and bcp.
- Pass this value into a notebook that extracts the data using the specified behavior
- If behavior is other than a query, data needs to then be inserted into the target table