Matching Snowflake Federated RowCounts to dataset views
Hi all,
Can someone help me understand the Row Count of a Snowflake federated dataset, and when it updates? We have a table in snowflake that has recently been updated to include more rows. The Federated Connection dataset does not show the updated row count. However, dataset views built off of this dataset do show the updated row count.
For example, let's say the Snowflake table is 2500 rows. The Federated dataset is 2450 rows. The dataset view is 2500 rows.
Trying to create an ETL on top of the dataset view and receiving a row count mismatch error, so just trying to understand this better.
Thank you!
Best Answer
-
Because you’re using a federated dataset it will only update the information when you query it like in your case with the view.
what happens if you recreate the federated dataset? Does the row count then match?
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Answers
-
Because you’re using a federated dataset it will only update the information when you query it like in your case with the view.
what happens if you recreate the federated dataset? Does the row count then match?
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
Thank you for your explanation. We want to avoid recreating the federated datasets unless absolutely necessary, so I'm not currently able to answer your row count question. Will let you know if I find out anything else.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 621 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 743 Beast Mode
- 58 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 395 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 6 Software Integrations
- 124 Manage
- 121 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive