Forum Discussion

alfBI's avatar
alfBI
Icon for Responsive Resident rankResponsive Resident
8 months ago
Solved

How to copy data into a Lakehouse specifying table schema

Hi,   I am trying to copy a table into a Lakehouse but I have no way to specify the schema name   In the old data copya field wxisted to place the name of the schema       but in the ne...
data engineering
  • alfBI's avatar
    alfBI
    8 months ago

    Well, believe me or not I have just found the solution (or at least a workaround) to what to seems to be a bug in the more stupid way. I have saved the pipeline (save as) to create a copy of it and when I opened it,

     

    Surprise!

     

    The schema option has appeared 🙂

     

    Just in case it helps you alkready know.

     

    Alfons

spencer_sa's avatar
spencer_sa
Icon for Impactful Individual rankImpactful Individual
8 months ago

Given that you're using parameters to drive the connection including the lakehouse, it's possible took a short while to look up the lakehouse based on the value in the parameter, discover it was schema enabled, and change the UI to the schema enabled one.
The UI does depend on the lakehouse type.