Hi, I’m giving Airbyte a go and am facing some issues. My destination is Greenplum DB, which is not supported on its own, so I’m using Postgres connector as they are quite similar. In the future I may even build my own connector to get more out of it.
However, when using default normalization, models fail. Because transformations include indexing (which I’m somewhat against on GP like dbs) and syntax for creating indices is different between PG and GP due to version differences. So it fails and, therefore, the whole sync fails.
I’ve tried accessing the folder that shows up in my log, but it is empty. Maybe I’m not doing it right. Regardless, my actual question is this: how does dbt default transformations build its syntax? just by looking at the destination and matching syntax to it? If I build a new connector, will it automatically resolve the issue? Or do I also have to build my own transformations? I’m not against that, but are there any templates available? I mean, exactly what Airbyte tries to do. And then just work it out from there.