SQL Writeback - Importing to Existing Schema

Polky82
Polky82 Member
edited March 2023 in SQL DataFlows

Is there a way to specify a specific SQL schema the SQL Writeback connector uses? The documentation mentions it's possible, but doesn't mention the syntax. I can easily import to dbo, but would like to import existing schema.

Answers

  • Tasleema
    Tasleema Domo Product Manager

    @Polky82 Are you talking about the Microsoft SQL Server Writeback connector? If so, then the ability to select a schema was recently added to it. You select the schema in a drop down in the connector settings.

  • Hi @PMLeema,

    There was a bug in the connector where the schema dropdown was missing. We worked with Domo Support to get added back last week. Everything works as expected now.

    Thanks!