Forum Discussion

schou's avatar
schou
Frequent Visitor
2 years ago
Solved

Fabric Shortcut based on a view

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 an...
data engineering
lakehouse
  • Anonymous's avatar
    Anonymous
    2 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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

schou's avatar
schou
Frequent Visitor
2 years ago

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!!