Forum Discussion

chmurray88's avatar
chmurray88
New Contributor II
3 years ago

PostgreSQL - Bulk Load with schema provided

Hello - I am trying to provide a schema for the PostgreSQL - Bulk Load snap to use. I’m getting an error that “Expecting a schema document with a map of column names to their descriptions”. I hav...
chmurray88's avatar
chmurray88
New Contributor II
3 years ago

Thanks for responding @AleksandarAngelevski

I think I’m closer now.

I think I’ve narrowed it down to needing to pass in columns and data_type.

Now I’m getting a different error that says “Expecting object or array for wildcard path, found: col1, Resolution: Expecting a schema document with a map of column names to their descriptions.”.

So…any idea?

Aleksandar_A's avatar
Aleksandar_A
Contributor III
3 years ago

Since I haven’t used any of the PostgreSQL Snaps, could you provide a sample of the metadata from a Select Snap output and a sample of what you are passing to the Bulk Load’s second input view?