Defect? New Source Columns missing in DataFusion Result until after rebuild
Hi Folks,
you might need to replicate and confirm the following before marking it as a defect.
Take two source ds, sA & sB.
sA has 3 columns, a,b,c.
sB has 3 columns, x,y,z.
In a DataFusion sA is joined to sB to create R, the result ds.
After the R is created, it contains a,b,c,x,y,z.
Next i want to extend sA, i've added a new column in sA call d.
sA now contains a,b,c,d.
After R is rebuilt, in the preview of the ds, we see a,b,c,d,x,y,z, but d is greyed out.
d also dose not appear on the cards.
To resolve this (unexpected behaviour), we need to edit our DataFusion R.
Graphically remove the to source ds, sA and sB, which in turn removes the joins.
Then add back sA, sB, and add the same join again.
Now when previewed, d is no longer greyed.
Additionally d is abailable in the cards.
Rgds,
Comments
-
Hey @Kurbz I can confirm that this is a bug that I've seen as well. If the schema is changed at all in any of the input datasets for the joins, those columns won't be made available without recreating the joins. (Also column names can't be changed after creating the fusion initially, not sure if this is a bug or more of an enhancement need.)
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'1 -
Thanks for the comment and confirmation @PodiumMason
I regard it as unexpected behaviour, just my opinion, hence i'd classify it as a bug.
If the source is changed, ie schema, it should push into relevant downstream items and refresh, can imagine this could get complex.
IDEA:
would be nice to see the push from sA down stream, with an alert stating "updating this datasource will effect the following items, 1,2,3,... We recomend you review the impacted items to ensure your items preform as you require"...
rgds,
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive