Forum Discussion

amaaiia's avatar
amaaiia
Skilled Sharer
2 years ago

Overwrite a table with different schema in Dataflow Gen2

I have a T1 table in Lakehouse L1 that I have ingested with Dataflow Gen2. I have another Lakehouse L2 with a shortcut to T1 (S2). My T1 table in source now has one more column, so I redo the ingest...
Dataflows
General Question
Need Help
rubayatyasmin's avatar
rubayatyasmin
Community Champion
2 years ago

Hi, 

 

You should be able to change the schema in the destination settings. 

 

 

This what I get in f64 capacity. In f2 capacity you should be able to refresh your schema. 

 

 

Hope this helps. 

 

  • amaaiia's avatar
    amaaiia
    Skilled Sharer
    2 years ago

    I'm using Premium F64 capacity.

    I can see Dynamic Schema option when I create a NEW table, but not for Existing table:

    For Existing table I can only see Refresh destination schema option, but is not working, because I click on it and the destination schema keeps the same. My source new schema has one more column, and it's not being added to destination schema:

     

     

    • rubayatyasmin's avatar
      rubayatyasmin
      Community Champion
      2 years ago

      You should be able to see the option. The screenshot I gave you was from existing table. From transform environment. 

      • amaaiia's avatar
        amaaiia
        Skilled Sharer
        2 years ago

        rubayatyasmin As you can see here, I'm also in Transform environment, I'm on Exisiting table and I can't select Dynamic Schema.

        Why may be this happening?