Asset Schema Child Tables Are Missing From the Destination

Issue

Asset-related child tables are missing from the destination. When enabling ASSET_SCHEMA in the Schema tab in Fivetran, no columns appear to be associated with the table.

Environment

Connector: Jira

Resolution

Child tables are missing from the destination

To sync asset-related child tables, make sure ASSET_SCHEMA is included in your connection schema and that your Jira source contains data for the child tables you want to sync.

To include the ASSET_SCHEMA table in your connection schema:

1. In Fivetran, go to your Jira connection page.
2. Select the Schema tab.
3. Select the checkbox next to the ASSET_SCHEMA table.
4. Click Save changes.

No columns appear for ASSET_SCHEMA

ASSET_SCHEMA is a parent grouping for asset-related child tables. It is not an actual table and does not contain columns or records, so it does not appear as a table in the destination. It is expected that no columns appear for ASSET_SCHEMA in the Schema tab in Fivetran.

Cause

This issue occurs when ASSET_SCHEMA is not included in your connection schema, or when the Jira source does not contain data for the asset-related child tables.

Fivetran does not create empty tables for Jira connections. If the source does not contain data for a child table, that table is not created in the destination. For more information, see our Jira sync overview.