Forum Discussion
Event stream source(Azure SQL CDC) cannot take tables with underscore(_) in the name.
Hi SauravRajJoshi ，
Thank you for reaching out. I’ve tested adding an underscore in the table names, and it appears to be possible.
To better understand and assist with your issue, could you please provide more details? Specifically:
Error Messages: Are you encountering any specific error messages when trying to connect the tables with underscores? If so, could you share the exact error message?
Data Flow: Is the issue that data is not being ingested from the tables with underscores, or is it that the connection fails altogether?
CDC Enabled: Could you also check if the Change Data Capture (CDC) is enabled for these specific tables with underscores in their names?
These details will help us identify the root cause and suggest an appropriate solution.
Looking forward to your response.
Best regards,
Wenyang
Hi SauravRajJoshi ，
Thank you for reaching out. I’ve tested adding an underscore in the table names, and it appears to be possible.
To better understand and assist with your issue, could you please provide more details? Specifically:
Error Messages: Are you encountering any specific error messages when trying to connect the tables with underscores? If so, could you share the exact error message?
Data Flow: Is the issue that data is not being ingested from the tables with underscores, or is it that the connection fails altogether?
CDC Enabled: Could you also check if the Change Data Capture (CDC) is enabled for these specific tables with underscores in their names?
These details will help us identify the root cause and suggest an appropriate solution.
Looking forward to your response.
Best regards,
Wenyang
Hi Wenyang
So the issue was when creating the connection, what you're showing is after creating the connection, going to edit mode and adding tables. Yes this solution works for now, it's more like a loophole than a solution I think. I don't know if they will update it, hopefully they wont.
Thank you