Forum Discussion
Solved
External table not available in SQL Analytics Endpoint or Power BI
Hi, I used a Notebook to create an external table (unmanaged table) in my Lakehouse based on a txt file in my Lakehouses' File folder: %%sql CREATE TABLE testtxtexternal ( name STRING,...
Hey frithjof_v ,
the reason why the table does not appear is the format of the source file. The lingua franca for everything Microsoft Fabric is the Delta Table format. If you want to shortcut to the txt file, then you need a step that reads the txt file into a dataframe and writes the dataframe as a Delta Table.
Hopefully, this helps to tackle your challenge.
Regards,
Tom
Hey frithjof_v ,
the reason why the table does not appear is the format of the source file. The lingua franca for everything Microsoft Fabric is the Delta Table format. If you want to shortcut to the txt file, then you need a step that reads the txt file into a dataframe and writes the dataframe as a Delta Table.
Hopefully, this helps to tackle your challenge.
Regards,
Tom