Hello all, please I need some help, and clarity on this. When using Airbyte data platform to transfer data from MSSQL to Redshift... Is it better to transfer data directly from the SQL base tables into Redshift, or Is it rather better to create SQL Views off of those base tables in MSSQL before transferring data based on the SQL views into Redshift ?
I tried transferring data from a particular SQL table into Redshift, but the table was short(data loss) of a good chunk of data upon reaching Redshift. However, when I created a SQL view from the same base table... and referenced the SQL view in Airbyte to load into Redshift, it actually worked...
Can anyone shed some more light on this ? SQL Views Versus SQL Base Tables, any of them better for transfers via Airbyte ?