tan_thiamhuat's avatar
tan_thiamhuat
Post Patron
1 year ago
Status:
Need Clarification

Create a Shortcut to Reference a SQL Server Table in Dataflow Gen 2

Every time we need to get the tables in SQL Server, we need to import them inside Dataflow Gen 2, which is both time consuming and does not make sense.

We want to do this, without importing the data, that is, a shortcut or references to SQL Server tables inside Dataflow Gen 2.

Data Factory | Dataflow

3 Comments

  • miguel's avatar
    miguel
    Community Admin
    11 months ago
    Status changed:
    New
    to
    Need Clarification

    Could you further explain your scenario and what you're trying to accomplish?

    A Dataflow Gen2 is not effectively a storage item, but rather a data processing one. It connects to data, processes it and enables you to load it to a destination, but by itself Dataflow Gen2 doesn't truly store.

    If perhaps this is more about adding multiple queries from the same source (being SQL Serve), you can do so today in many forms, but it also depends on what your needs are.

     

    Looking forward to hearing from you! 

Recent ideas