topic Re: Fabric Shortcut based on a view in Data Engineering

Fabric Shortcut based on a view

schou — Mon, 08 Jul 2024 22:08:31 GMT

Hello,

Can I create a shortcut in worskpace A based on a view created in workspace B?

Looks like only the actual tables/files in the lakehouse can be shortcut sources but would like to see if anything I miss or workaround.

Thank you in advanced.

Re: Fabric Shortcut based on a view

NandanHegde — Tue, 09 Jul 2024 03:39:25 GMT

Your understanding is correct as only files/tables can be leveraged for shortcut creation and not the views.

You would have to materilize the views as tables for you to use that as a shortcut as of today

Re: Fabric Shortcut based on a view

Anonymous — Tue, 09 Jul 2024 03:45:05 GMT

Hi @schou,

You can create a data pipeline with 'copy data' activity from 'workspace B' data warehouse views and output destination to the lakehouse table in 'workspace A' to achieve your requirement.

Regards,

Xiaoxin Sheng

Re: Fabric Shortcut based on a view

schou — Wed, 10 Jul 2024 23:44:08 GMT

@NandanHegde thanks for confirming!

what would you suggest to do to make the views as tables?

Re: Fabric Shortcut based on a view

schou — Wed, 10 Jul 2024 23:45:57 GMT

@Anonymous Hi Xiaoxin,

I was trying to do so but found only 'table' and 'file' were available for the source (root folder)

Not sure if I am doing it right..

Re: Fabric Shortcut based on a view

Anonymous — Thu, 11 Jul 2024 06:52:43 GMT

Hi @schou,

I mean the source is data warehouse from other workspace, when you use Lakehouse as source, it only lists the table and files.
If you are not so sure how to move data, you can create a dataflow or data pipeline to move data from Lakehouse to the data warehouse which hosted in the same workspace.
Then you can create a data pipeline to move data from another workspace warehouse to the current workspace Lakehouse. (when you choose warehouse as source, it will detect the list of all the tables and views under the table option.

Sourcedestination

Regards,

Xiaoxin Sheng

Re: Fabric Shortcut based on a view

NandanHegde — Thu, 11 Jul 2024 07:22:30 GMT

There are data pipelines which can connect to lakehouses and you can map that as a table

Re: Fabric Shortcut based on a view

schou — Wed, 31 Jul 2024 17:30:22 GMT

Hello,

Apologies to reopen this thread. I am still having issue when 'Copy data from lakehouse to warehouse'. So in this step, I cannot see 'views' as an object in data source. There is only tables showing up in data source.

Not sure if I miss anything?

Thank you!!