topic Re: Lakehouse tutorial Step 12/13 - No SQL analyics endpoint in Data Engineering

Lakehouse tutorial Step 12/13 - No SQL analyics endpoint

Jase68 — Thu, 18 Jul 2024 16:09:00 GMT

I am trying to follow the Lakehouse tutorial...

Lakehouse tutorial - Create your first lakehouse - Microsoft Fabric | Microsoft Learn

...using the wwi sample data.

I am trying to ingest the sample data dimension_customer.csv.

I have followed steps 1 to 11 and the dataflow has refreshed and the table has been created in the lakehouse (see attachment 1) but when I follow the instruction to switch to the SQL analyics endpoint the table is not visible (see attachment 2) and I am unable to action any of the following steps of the tutorial.

I have gone through the step several times in case I have missed anything but the result is the same each time.

What could I be doing wrong? Is this tutorial out of date?

Re: Lakehouse tutorial Step 12/13 - No SQL analyics endpoint

Anonymous — Fri, 19 Jul 2024 02:20:22 GMT

HI @Jase68,

In fact these new loaded tables not syncing to the correspond SQL analytics endpoint immediately.

You may need to be waiting the backend processing for some times(this should related on the table data amounts) and do refresh the SQL analytics endpoint tables to confirm if they finish sync correctly.

Regareds,

Xiaoxin Sheng

Re: Lakehouse tutorial Step 12/13 - No SQL analyics endpoint

Jase68 — Thu, 25 Jul 2024 08:01:23 GMT

Thanks. I deleted everything and started again seemed to work after some time. Now stuck getting the files to load via spark - giving errors - but that's a different topic.