I'm trying to make a connection between a MS SQL database and an S3 bucket. Both source and destination test perfect but when I try to make the connection it errors out. I think this is because there are too many tables in the source for it to parse the schema in the allowed time and so it is timing out... Any way around this?

Hi @Justin Cole, you may try to create a user with permissions to read only the tables you'd like to replicate. I'm not sure it's working for MS SQL though, but I know that the postgres connector we have only lists the table it can read.

That's a good point. Unfortunately I don't have access to the server directly to make such changes. I can suggest it to the person who does, though.

Could you please share the error you have? Is it a timeout error?

It just says "an unknown error has occured" on the screen. Let me try to grab the logs and find what the logs say

You can download server logs from the settings page

Yep. Got them. Trying to find the relevant entires now 🙂

Feel free to send me the full logs.

It does. I have the destination set up and working with a different database on that same server.

Maybe one suggestion here: if you’re trying to only sync a few tables from your database you can create views in a different schema reducing the number of streams to sync 🙂