Hello, A cal for help on a data normalization iss...
# ask-community-for-troubleshooting
c
Hello, A cal for help on a data normalization issue. I selected Normalized tabular data for my destination (Redshift) (see first image) However, my data still inserts as a json blob (please see the second image) How can I ensure it inserts to my redshift warehouse as different rows and columns (as in my source)
1
m
Hello @Chukwuebuka Akwiwu-Uzoma Airbyte transfer the raw data to keep historical data, you must check for a table called product.
c
I do not understand, if it does not allow for a column insertion, what does the normalization option do ? Also, please what do you mean by, 'you must check for a table called product'? Does airbyte insert two tables? One a json blob and the other a nornal columnar table?
m
Does airbyte insert two tables? One a json blob and the other a nornal columnar table?
yes
First airbyte transfer data to the raw table with json data and after execute the normalization process.
c
I have checked over and over and even reviewed all my schemas, but I only see the json blob table, there isn't a second normalized table...How do I find this?
Resolved, thanks