Connectors are tools that enable seamless data integrations from various marketing platforms directly into BigQuery.
Here are some key points about the connectors:
Data quality: The data quality provided by the connectors is top-notch, often surpassing similar services.
Data storage: All data fetched by the connectors is stored in the data lake, allowing for reuse across different products in Alvie and ensuring data integrity.
Credentials management: To fetch and load data, the connectors require credentials. If there are issues such as expired or missing credentials, you can always update them.
Notifications: If a connector fails, notifications are sent to the relevant team to address the issue.
Error handling: The connectors are designed to handle unexpected errors by retrying the job up to eight times. This is to manage temporary issues with upstream APIs, such as those from Facebook and Google, which are beyond our control.