Forum Discussion

pmscorca's avatar
pmscorca
Kudo Kingpin
8 months ago
Solved

Writing to a specific warehouse schema using a dataflow gen2

Hi, I've a warehouse having some schemas for the tables to ingest. I need to write some data into a specific table of a specific schema using a dataflow gen2 (I need to use a dataflow gen2), but it ...
Dataflow
General Question
  • anros's avatar
    anros
    8 months ago

    tayloramy pmscorca we implemented the capability of writing to a given schema in Azure Sql, Lakehouse, Warehouse and Fabric Sql quite some time ago already.

    As mentioned by miguel you need to ensure that you expand Advanced option when selecting the connector and set "Navigate using full hierarchy" to True.

    Once done, on the next stage you'll be able to see the list of schema you can write to

     

    Best regards,

    Antoine

     

tayloramy's avatar
tayloramy
Super User
8 months ago

Hi pmscorca, 

 

As far as I know this is not possible. Dataflow Gen 2 automatically writes to DBO schema and there is no way to change that. 

 

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution. 

  • pmscorca's avatar
    pmscorca
    Kudo Kingpin
    8 months ago

    Hi tayloramy , thanks for your reply.

    So, the status of the above idea is wrong!

    • anros's avatar
      anros
      Microsoft Employee
      8 months ago

      tayloramy pmscorca we implemented the capability of writing to a given schema in Azure Sql, Lakehouse, Warehouse and Fabric Sql quite some time ago already.

      As mentioned by miguel you need to ensure that you expand Advanced option when selecting the connector and set "Navigate using full hierarchy" to True.

      Once done, on the next stage you'll be able to see the list of schema you can write to

       

      Best regards,

      Antoine

       

      • pmscorca's avatar
        pmscorca
        Kudo Kingpin
        8 months ago

        Hi anros 

        I'm referring when it occurs creating a new table (also if the "Navigate using full hierarchy" option is set to True): it isn't possible to specify any destination schemas. For me, this issue isn't solved!