Table Selected in Schema but Not Created in Destination

Issue

A table is selected in the Schema tab in Fivetran, but the table:

• Does not appear in the destination.
• Shows no columns in the Schema tab.
• Syncs without visible errors.

Environment

Connector: Adobe Analytics

Resolution

To troubleshoot this issue, review the connection logs for the table and check whether any records were written. If all processed sync windows show 0 records written, we do not create the table.

To validate that the report definition returns data:

1. In Fivetran, go to your Adobe Analytics connection page.
2. Select the Settings tab.
3. Under Configuration Table(s), click + Add Table.
4. Remove all segments and calculated metrics.
5. Select a minimal set of elements, such as one or two dimensions.
6. Include standard metrics such as Visits, Page Views, or Unique Visitors.
7. Click Save.
8. Return to your connection overview page and click Sync in the top right.

If the simplified table appears in the destination, the connection and destination are working correctly. Introduce the segments and calculated metrics you want to include one at a time, syncing after each change, to identify which component causes the report to return no rows.

If the simplified configuration also does not create a table, validate the same report slice directly in Adobe Analysis Workspace. Use the same report suite, dimensions, metrics, segments, date range, and aggregation configured in the connection.

Cause

This issue occurs when there are no records to write during any processed sync window. We only create a destination table after at least one record is successfully written. If all sync windows return 0 rows, we do not create the table, and no columns appear in the Schema tab.

Common causes include:

• Multiple segments that result in an empty intersection.
• A segment that is too restrictive for the selected date range.
• A calculated metric that references invalid or unavailable components.
• A dimension and metric combination that returns no data for the selected aggregation window.