DB Picker¶
The Pick Resource Instances dialog opens when clicking Pick from Database inside the Primary Key Values panel of a database-imported resource. It provides a live browser of the actual records in the datasource table linked to this environment, allowing you to remap the resource to a different database record.
A shared tool with two selection modes
The DB Picker Tool is also used when importing Resources from a Database. The dialog layout is the same in both cases, but the selection mode changes depending on where it was opened from:
- Editing a Resource (this page): single selection — you're picking one replacement record to remap this resource's primary key.
- Importing Resources: multiple selection, up to 1024 records — you're picking a batch of records to import as new resources.
The rest of this page documents the single-selection behavior used when editing a resource. See Importing Resources from a Database for the multi-selection flow.
When to Use It¶
Use the DB Picker when:
- The resource was mapped to the wrong record during import
- The underlying primary key value changed in the source database
- You want to reassign the resource instance to a different entity in the same table
- You want to import multiple resources in a batch
Dialog Layout¶
Header¶
The dialog header shows:
| Element | Description |
|---|---|
| Title | "Pick Resource Instances" |
| Subtitle | Environment name and table path (e.g., SIT · banking.account) |
| Selection counter | An N / M badge, always visible in the header, where N is the number of records currently selected and M is the maximum allowed. When editing a resource, M is always 1 (e.g. 1 / 1). When importing resources, M is the overall selection cap of 1024 (e.g. 3 / 1024), regardless of how many records the table actually contains. |
| Clear | Button to deselect the current selection without closing the dialog |
| × | Closes the dialog without making changes |
Select All
A Select All button is also available in the header, but only applies in the multi-selection import flow — it is not shown when editing a resource, since only one record can be picked.
Datasource Info Bar¶
Below the header, a summary bar shows the datasource context for the current query:
| Pill | Description |
|---|---|
| DATASOURCE | The datasource name linked to this environment (e.g., SIT-DS) |
| TABLE | The specific table being browsed (e.g., banking.account) |
| STATUS | Connectivity status of the datasource — Online (green) or offline |
Search Bar¶
A full-width search field filters records across all visible columns. The search is applied as you type.
Record Table¶
The table displays the actual records from the datasource with columns corresponding to the resource type's attributes. Columns are color-coded by their role:
| Color | Role | Description |
|---|---|---|
| Orange header | Primary Key | The attribute marked as PK — uniquely identifies each record |
| Green header | Resource Name | The attribute marked as RN — the human-readable name extracted from each record |
| Blue header | Description | The attribute marked as RD — the descriptive field extracted from each record |
| Light green | Already Imported | Records that are already mapped to another resource in this profile |
| Red | Sensitive | Attributes marked as sensitive — values are obfuscated |
The color legend is shown at the bottom of the dialog.
Already Imported records
In the multi-selection import flow, records flagged as Already Imported appear disabled and cannot be selected, since they already exist as a Resource. In the single-selection edit flow, they remain informational — you can still pick an already-imported record if that's the intended remapping.
Pagination¶
| Control | Description |
|---|---|
| Jump to first page | |
| / | Previous / next page |
| Page number buttons | Direct navigation to a specific page |
| Show N rows | Dropdown to control how many records are displayed per page |
| X–Y of Z | Shows the current range and total record count |
Selecting a Record¶
Click anywhere on a record row to select it. The row highlights and the checkbox on the left becomes checked. The N / M selection counter in the header updates immediately to reflect the current selection.
Single selection
When editing a resource, only one record can be selected at a time. Selecting a new row automatically deselects the previous one, so the counter never goes above 1 / 1.
Confirming the Selection¶
Click Confirm N Record(s) to apply the selection. The dialog closes and the PK input field in the Environments tab is updated with the primary key value of the selected record.
Click Cancel to close the dialog without making any changes.
Remapping impact
Confirming a new record updates the PK value for this environment. Save Changes must still be clicked in the Edit Resource dialog to persist the remapping.