RJ•2y ago

Airbyte sync failing as of 8/24 6:27pm

2023-08-24 22:28:57 INFO i.a.w.g.DefaultCheckConnectionWorker(run):115 - Check connection job received output: io.airbyte.config.StandardCheckConnectionOutput@7cc931b3[status=failed,message='Connection to Convex via json_schemas endpoint failed: 400: UnsupportedTableForExport: The table "salesRepRelationships" has a shape that is not currently supported for export.',additionalProperties={}]

2023-08-24 22:28:57 INFO i.a.w.g.DefaultCheckConnectionWorker(run):115 - Check connection job received output: io.airbyte.config.StandardCheckConnectionOutput@7cc931b3[status=failed,message='Connection to Convex via json_schemas endpoint failed: 400: UnsupportedTableForExport: The table "salesRepRelationships" has a shape that is not currently supported for export.',additionalProperties={}]

Nothing changed on my end around this time. This table was in fact not even being synced! So it seems like a change in the Convex API occurred around this time which caused this failure. I tried refreshing the schema and saw the following error in the Airbyte UI, in the Replication tab of my Convex -> Snowflake connection:

Internal Server Error: Cannot invoke "io.airbyte.api.model.generated.AirbyteCatalog.getStreams()" because "discovered" is null

Internal Server Error: Cannot invoke "io.airbyte.api.model.generated.AirbyteCatalog.getStreams()" because "discovered" is null

5 Replies

lee•2y ago

hi! sorry about that. looks like airbyte export is unhappy with empty tables. should be a quick fix, which we're working on now. thanks for reporting!

jamwt•2y ago

@RJ are you interested in trying out the new fivetran connector? not sure if the team has reached out to you yet @nipunn and another engineer just got that project ready for use

RJOP•2y ago

@nipunn did reach out! I’m absolutely interested but don’t think I have time to set it up right now. Specifically, I assume I’ll need to do some re-mapping of the data in my destination (Snowflake) or else in Metabase (which is ultimately what I’m currently using Airbyte for) in order to get things back to parity, which seems like it may take a bit of time and effort to do Unless I’m wrong about that, in which case I am down to test it out!

jamwt•2y ago

I would think the types would be pretty 1:1, but yeah. there might be some small changes

RJOP•2y ago

I suppose I could give it a shot then I see this is working now, thanks @lee!

Airbyte sync failing as of 8/24 6:27pm

Did you find this page helpful?