Forum Discussion

DavidPi's avatar
DavidPi
Icon for Advocate II rankAdvocate II
3 years ago
Solved

I do not see existing table in dataflow gen2 destination warehouse

I created table in Warehouse.

Then I created dataflow gen2 and tryed to set destination to this existing table. 

But I do not see any tables under my warehouse.

Where do I make the miskate?

 

 

 

Dataflows
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi DavidPi ,
    Thanks for creating a Support Ticket. 
    It would be a great help if you can provide the details of the Support Ticket so we can track it for further information. 
    Thank you

11 Replies

  • mllopis's avatar
    mllopis
    Icon for Community Admin rankCommunity Admin
    3 years ago

    Hi DavidPi,

     

    Creation of a new table in an output destination will happen only as part of dataflow refresh/execution - To confirm, after configuring your output destination, were you able to Publish your dataflow (and have it complete a successful Refresh operation - note that the initial refresh of a dataflow will be kicked off automatically upon succesfully publishing it)?

     

    You can check in the Refresh History (via "..." menu for your dataflow in the workspace view) to understand whether the refresh happened and its success/failure status.

     

    Hope that helps

  • mllopis's avatar
    mllopis
    Icon for Community Admin rankCommunity Admin
    3 years ago

    Oh, my bad - I think I got this the other way around and you started by creating the table in DW directly, not via the Dataflows Output Destination UI.

     

    Sometimes there can be a lag between creation of tables in the DW Editor experience and the table being visible in other clients - Did the issue persist after a few minutes and refreshing/re-entering the Output Destinations UI in Dataflows? Were you able to query this table using other SQL clients?

     

    Thanks,
    M.

    • DavidPi's avatar
      DavidPi
      Icon for Advocate II rankAdvocate II
      3 years ago

      Unfortunately, the situation is the same today. I see table in DatawarehouseTest1, I can select from this empty table. But I don't see it in Dataflow under Warehouse destination.

      Warehouse and Dataflow are in the same workspace. I am admin of this workspace.

       

       

  • romankorchak's avatar
    romankorchak
    Frequent Visitor
    2 years ago

    Having the same issue - I created a dataflow gen 2 with Datalake destination (creating new table), which worked fine.
    Then I wanted to have data added to the table on each refresh so I went to change destionation to "Existing Table", but itsnot finding the table that was created on initial refresh (which was done with "New table" option).
    If this issue was resolved - may I know how
    Thanks