Warning: PK-Less Tables Cannot Be Supported Because This Is a Shared Database

Issue

It's not possible to select a table in the Schema tab. The following warning appears:

Cannot select - PK-less tables cannot be supported on schema because this is a shared database (read-only). Set up a workspace in the connector setup form to make these tables sync-able.

Environment

Connectors: Snowflake

Resolution

To resolve this issue, configure your connection to use a separate workspace for temporary tables:

In Fivetran, go to your Snowflake connection page.
Select the Setup tab.
Click Edit connection.
Set the Use working dataset for queries toggle to ON.
Enter a database and schema name for your query results tables.
Click Save & Test.

To use this feature, you must have SELECT, CREATE, and OWNERSHIP privileges on the database you want to create for the query results.

Cause

To sync source tables without a primary key, we create temporary tables in the source database. However, we can't create these in shared, read-only databases. As a result, this issue occurs when you try to sync a primary key-less table from a shared database without configuring a separate workspace. For more information, see our Workspace for temporary Snowflake tables documentation.