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
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.