Hello eveyone! I'm trying to use the newly added loader target-vertica. For test purposes i'm trying to load a csv file to vertica db. it creates the table with all the columns and datatypes under my schema, but for some reason it wants to create the temp_table (buffer where it ingest the data) under public schema. However i do not have the privileges to write under public schema...hence, is there any workaround for this? I don't seem to find the place in code where it's defined where the temp objects are written. Here's the screenshot from error message:

Hi @rasmus_bobkov! I think this is the part of the code where the table name for the tmp table is created: https://github.com/full360/pipelinewise-target-vertica/blob/d8f6516a41a3634f32c2f2c4fc2986a385ebd55d/target_vertica/db_sync.py#L236-L239 I don't think there's any workaround, really. Some targets use temp tables to hold the result of a COPY-like operation and later merge it with the stream table.