Other: Email Notifications for the list of tables are not loaded/updated in last 24hrs
Is it possible to have feature to trigger email notifications on the connectors, to perform daily ELT/ETL checks
1) Tables that are not updated on each sync
2) list of tables(user can filter the tables) that are not updated in last 24 hrs which has impact on reports.
-
Hi Vineela Bijivemula- Thanks for the request.
For #1, can you provide me detail into what you're looking for? Is this a list of tables that we only refresh once a day due to needing to fully refresh the table, or tables that were not sync'd in a specific sync? What would this information allow you to do?
For #2, are you looking for tables that have not been updated in the last 24 hours even if that is due to no updates in the source, or are you only looking for those with no updates due to an issue with Fivetran being able to sync the data?
-
Hi Andrew,
Thanks for your response to our request.
Please find below comments.
For #2, are you looking for tables that have not been updated in the last 24 hours even if that is due to no updates in the source, or are you only looking for those with no updates due to an issue with Fivetran being able to sync the data?
Looking for the tables even that has no update in source and can include tables that has no updates due to an issue.
This is because when we generate our daily reports there would be a data mismatch in the report and we had to dive back manually to look at the source if they are loaded in last 24hrs.
For #1, can you provide me detail into what you're looking for? Is this a list of tables that we only refresh once a day due to needing to fully refresh the table, or tables that were not sync'd in a specific sync? What would this information allow you to do?
This could be the same as the above, just in short to perform regular ETL checks whether our source tables are loaded in that sync or not.
Please sign in to leave a comment.
Comments
2 comments