Problem: ETL jobs fail or do not pull data as expected.
Steps to troubleshoot:
- Verify that ETL jobs are scheduled properly under Admin > Configuration > ETL.
- Ensure correct API keys or OAuth tokens are configured for API connections.
- Confirm that the REST API connections and job settings (e.g., pagination, query parameters) are correctly defined. Incorrect query parameters or pagination could result in incomplete data imports.
- Review the ETL logs under the Logs section to identify specific job failures.
- Check the staging tables to ensure data is being ingested properly. If data isn’t appearing in staging tables, check the underlying REST API call or database query.