Connector Improvement: Fivetran Log Connector - adding sync schedules and MAR type
Answered
For better reporting leveraging the Fivetran log connector I would like to have two additional data sets added:
1. I would like to see data about the connector sync schedule, e.g. connector x syncs every 6 hours.
2. Since Fivetran introduced the trial period of 14 days for new connectors, I would like to be able to distinguish between free and paid MAR in the data of the log connector as well.
-
Official comment
Hi Marco - thank you for submitting. We have added your suggestions to our product backlog so that we can prioritize them against our other work. Especially #2 has already been on our radar
-
I agree; especially on point (2); I don't know if anyone else is having difficulty (and I have opened a support ticket for this already) but using the native SQL connector shows buginess as well -- I would expect the second table to the information (signed_up) so that I could compute it myself at least, but it doesn't :/
SELECT
b.connector_id IS NOT NULL,
COUNT(*)
FROM (
SELECT DISTINCT
connector_id
FROM
fivetran_log.active_volume
)
a
LEFT OUTER JOIN (
SELECT
connector_id,
signed_up
FROM
fivetran_log.connector
) b
ON
a.connector_id = b.connector_id
GROUP BY
1;
?column? | count
----------+-------
f | 63
(1 row)
Please sign in to leave a comment.
Comments
2 comments