Can I Sync a Report That Doesn't Have a Suitable Primary Key?

Question

Can I sync a Workday report that doesn't have a suitable primary key in the source?

Environment

Connector: Workday RaaS

Answer

To sync reports where no single column or combination of columns can be used to form a primary key, do the following:

1. In Fivetran, go to your Workday RaaS connector page.
2. Select the Setup tab.
3. Click Edit connection.
4. Set the Use Fivetran Generated Primary Key toggle to ON.
5. Click Save & Test.

When you enable the Use Fivetran Generated Primary Key option, we populate the _fivetran_id column with a primary key, which we generate for each record by hashing all column values.