Troubleshoot the Reddit Ads connector

Important

This feature is in Beta. Workspace admins can control access to this feature from the Previews page. See Manage Azure Databricks previews.

Learn how to troubleshoot common errors with the managed Reddit Ads connector in Lakeflow Connect.

General pipeline troubleshooting

If a pipeline fails while executing, click on the step that failed and confirm whether the error message provides sufficient information about the nature of the error.

You can also check and download the cluster logs from the pipeline details page by clicking Update details in the right-hand panel, then Logs. Scan the logs for errors or exceptions.

I've authenticated, but I can't see my Reddit Ads data

Cause: You might be authenticating with the wrong Reddit account, or the account might not have access to the Reddit Ads business you're trying to ingest from.

Solution:

  1. Confirm that you signed in with the correct Reddit account. You can edit the connection and reauthenticate, or recreate the connection to redo the OAuth flow.
  2. Confirm that the account has access to the Reddit Ads account you're trying to ingest.

Redirect URI error during OAuth setup

Cause: The redirect URI configured in your Reddit developer application doesn't match the Azure Databricks workspace URL.

Solution:

  1. In Reddit Ads Business Manager (https://ads.reddit.com), under Business, open Developer Portal.

  2. Click Developer Applications and select your app.

  3. Confirm that the app's Redirect uri matches the following pattern:

    https://<your_databricks_workspace_URL>/login/oauth/lakehousefederation.html

    Replace <your_databricks_workspace_URL> with your workspace URL.

  4. Save the changes and try authenticating again.

My report tables are missing older data

Cause: The Reddit Ads reporting API only serves data from approximately the last 24 months. Requests for older data are rejected by Reddit.

Solution: There is no workaround for this limit. For more information, see Report data retention.

My custom report fails at pipeline planning time

Cause: The breakdowns or fields values are not in the supported lists, or the breakdowns list does not include at least one time dimension (DATE or HOUR).

Solution:

  1. Confirm that all breakdown and field values are in the supported lists. See Custom report breakdowns and fields.
  2. Confirm that the breakdowns list includes at least one time dimension (DATE or HOUR).
  3. To test without moving data, use validate_only in the pipeline API.

Additional resources

  • Last updated on