Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
andyemiller
Frequent Visitor

Warehouse Parquet Format

I utilized a data pipeline to copy a lakehouse into a warehouse. Everything transferred properly, but within 30 minutes, the transferred tables were converted into a Parquet format. 

 

When you view the cloud-based warehouse, you see standard tables from the lakehouse. See the first image. 

 

andyemiller_0-1700135982846.png

 

I can also see the stored procedures and views that were created within the warehouse. However, PowerBI and any SQL endpoint is not able to reference the aforementioned tables. Here are the tables on the SQL endpoint. 

 

andyemiller_1-1700136098611.png

 

Even the earlier pipeline cannot find the stored procedures, tables, and views that are available in the warehouse. Here is the error message on the copy activity. 

 

andyemiller_2-1700136245340.png

 

Would someone be able to assist me with this issue? I need to retain the original file structure, views, and stored procedures within the view.

 

 

 

 

4 REPLIES 4
andyemiller
Frequent Visitor

Once again, the issue noted above has reemerged. 

The cloud-based warehouse has the correct table structure. 

andyemiller_0-1700154973445.png

However, the SQL endpoint has the Parquet file structure. 

andyemiller_1-1700155068616.png

Once again, this breaks the reporting tools. Is anyone able to assist me? 

Hi @andyemiller ,

Thanks for using Fabric Community.

Apologies for the issue you have been facing. I would like to check are you still facing this issue?
As we know currently Fabric is in preview it is difficult to tell what could be the reason for this performance. I would request you to wait for sometime and try again as it may be due to some outage issue.

If the issue still persists, please reach out to our support team so they can do a more thorough investigation on why this it is happening: Link

After creating a Support ticket please provide the ticket number as it would help us to track for more information.

Hope this helps. Please let us know if you have any other queries.

@v-gchenna-msft, yes, I am still experiencing the issue. The timing is intermittent and inconsistent.  I have submitted a ticket (2311160040010477) with the related information. 

andyemiller
Frequent Visitor

I cannot explain it, but the issue was corrected this morning within minutes of posting this message. There was, however, a real issue between 12:00 pm EST yesterday and 5:00 am EST today. 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

AugFabric_Carousel

Fabric Monthly Update - August 2024

Check out the August 2024 Fabric update to learn about new features.

August Carousel

Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.