USE or search_path as a way to select a pool or Provider schema.
The
x-tenant request metadata selects the Workspace. Do not place a Workspace
slug into a SQL address.
Provider table names
The address uses technical identifiers from the Provider Plugin:- The Provider’s connector slug identifies its schema.
- The projected stream name identifies its table.
-in a connector slug is registered as_for SQL identifiers.
schemaName and logicalName values rather than deriving an
address from a display name.
Column names
Projected Provider fields use predictable logical names:- Source field names are lowercased:
primaryEmailbecomesprimaryemail. - Flattened object paths use
__:assignee.emailbecomesassignee__email. - Exploded arrays use a child table named
{table}__{path}.