What’s the best practice for forcing a particular column type on load. for example: • MySQL json column -> super type Redshift column My cluster isn’t set up quite yet (just planning things out) so I can’t test what happens. I’m guessing that the target will create a

text

column. My initial thought is that I might have to build the table manually in Redshift first and then run a full-table refresh. If there’s a better way to do this, I’d be super curious.