https://linen.dev logo
Join Slack
Powered by
I'm curious if someone can help me point out to a ...
# announcements
b
I'm curious if someone can help me point out to a resource that explains how to setup a sync that syncs the actual table content, not the 
.raw
ones? Thanks in advance!
m
Can you enable the normalization?
It will create the non-raw table
It is the last option when you configure the destination
b
Let me check!
That seems to get me a bit further, but it looks like normalization fails:
Copy code
Normalization Failed.
io.airbyte.workers.WorkerException: Normalization Failed.
I'm seeing errors like these:
Copy code
Database Error in model public.Email (models/generated/public.Email.sql) syntax error at or near "primary" LINE 60: ), '') || '-' || coalesce(cast(primary as
Database Error in model public.CommunityRole (models/generated/public.CommunityRole.sql) syntax error at or near "order" LINE 55: ), '') || '-' || coalesce(cast(order as
and 2 similar ones
Any tips on how to debug this?
c
@Chris (deprecated profile) would you mind helping out on this one?
c
Could you do the following steps? • find your workspace number: it should be some numbers in the logs, for example: 
/tmp/workspace/5/0
then YOUR_WORKSPACE=5/0 • Run 
docker cp airbyte-server:/tmp/workspace/$YOUR_WORKSPACE/normalize/ my_folder
• open your catalog.json file in 
my_folder
and share with us what is in there • Do the same with 
models/generated/public.Email.sql
could also be helpful
from the quick snippets of your logs, it seems like the columns were not properly casted to a right data type... but we need to see what the actual SQL query was
the catalog.json is used as input to generate the SQL file so it might have a clue of why datatypes were not properly recognized for the cast
b
Thanks for the tips @Chris (deprecated profile) - I'm going to check this out later today!
2 Views
Open in Slack
PreviousNext
Powered by