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

  • PMLeema
    PMLeema Coach

    @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.

  • Polky82
    Polky82 Member

    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!

Categories