Connector Improvement: Ensure consistent columns in tables
PlannedThis is happening for Pinterest connector, and others as well.
Current behaviour:
if a column in a table has no data in the timeframe when the data is downloaded, that column will not be present in the table.
Expected behaviour:
the column is available in the table if it is always empty.
Why?
Because without consistency in schema/table/columns, it is very difficult to run data pipelines for multiple destinations.
-
Official comment
Hi Emanuele,
Luke from the Product team here. Thanks for submitting this request.We have a feature called Syncing empty tables and columns: https://fivetran.com/docs/using-fivetran/features#syncingemptytablesandcolumns. I think this feature would address your use case. However, we haven't currently enabled this on the Pinterest connector.
I've added this to our backlog. We'll prioritize it relative to the other features in the backlog based on customer demand. Any additional upvotes of this request from other Fivetran customers will increase the priority of this feature.
Thanks,
Luke
Please sign in to leave a comment.
Comments
1 comment