Fabric - External Delta Tables in Lakehouse

[Poweraegg]

Hello,

when I create an external delta table, and the files are saved externally in a ABFS path, I cannot find it using the default connectors. For example it does not appear in a dataflow, in Power BI when I directlake query, nor in the SQL Endpoint. It makes sense that it does not appear in these data query tools, however is there any possible way to move the external delta table data around in Fabric, other than using Notebooks in a Lakehouse? I seem to be unable to query it using a Warehouse for example. I am trying to get the data (and transform it) from a Silver Layer Lakehouse Delta Table to a Gold Layer Warehouse Table.

Thanks!

[bcdobbs]

How are you creating the table initially? Is it from a notebook? Happy to try and recreate.

Have you tried creating a shortcut in the warehouse to the external location?

[Poweraegg]

Using a Notebook in the Lakehouse:

python:

#overwrite the existing gold delta table in the gold lakehouse

df_silver.write.mode("Overwrite").format("delta").saveAsTable("Product_Gold_External", path="Files/Product_Gold_External")

These are the delta tables in the lakehouse (external and managed):

I cannot find the shortcut in the add data menu in the warehouse.

Using the Shorcut in the Lakehouse, however, seems to run into a problem. I cannot view the external table in the onelake datahub: