Hello, is it possible to cast a field extracted as

VARCHAR

from

tap-oracle

to be loaded as a

CLOB

in

target-oracle

, using Meltano? If so, what’s the correct way to do it? Through stream_maps, dbt? Or another method? I'm using the

s7clarke10

tap-oracle fork and hitting issues trying to get large text fields (like

photo

) into

CLOB

format. Any suggestions would be much appreciated!

The first thing to determine is whether

target-oracle

can actually create

CLOB

columns. Which variant are you using?

Hi Edgar thanks for your help in this issue, I'm using the radbrt variant. Its not necessary that it needs to be a

CLOB

but I need to transform the column somehow because the

VARCHAR

field was unbound and the target could not bring the field in because of that

This seems relevant: https://github.com/radbrt/target-oracle/issues/11

Thank you. that was helpful