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
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 659 Datasets
- 116 SQL DataFlows
- 2.2K Magic ETL
- 816 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 82 App Studio
- 46 Variables
- 776 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 82 Workflows
- 23 Code Engine
- 41 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 2 AI Projects and Models
- 18 Jupyter Workspaces
- 411 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 11 Software Integrations
- 145 Manage
- 141 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 115 Community Announcements
- 4.8K Archive