How to Configure Foreign Keys

Scroll to the Array Foreign Keys section in the Pipeline Designer

Select an attribute to create foreign key(s)

Enter a parent attribute name

(Optional) Enter a foreign key column alias

(Optional) Add the foreign key to the row access policy

Save the foreign key(s)

Extra Steps for the JSON Tutorial

If you are following the JSON Tutorial, create the following foreign keys. It may help to use the bulk update feature for foreign keys.

ARRAY_NAME	PARENT_ATTRIBUTE_NAME
batch_labels_array_primitive	plant_code_work_order_id_pk
batch_tags_pipe_array_primitive	plant_code_work_order_id_pk
measurement_metric_value_array_primitive	plant_code_work_order_id_pk
operation_logs_array_object	plant_code_work_order_id_pk
process_steps_array_object	plant_code_work_order_id_pk
product_specifications_array_primitive	plant_code_work_order_id_pk
quality_notes_array_primitive	plant_code_work_order_id_pk
shipments_array_object	plant_code_work_order_id_pk
special_tags_pipe_array_primitive	plant_code_work_order_id_pk
suppliers_array_object	plant_code_work_order_id_pk
flags_array_primitive	plant_code_work_order_id_pk
nested_array_primitive	plant_code_work_order_id_pk
text_array_primitive	plant_code_work_order_id_pk
equipment_array_object	process_step_id_str
items_array_primitive	shipment_id_str
batch_labels_array_primitive	plant_code_work_order_id_pk
measurement_metric_value_array_primitive	plant_code_work_order_id_pk
product_specifications_array_primitive	plant_code_work_order_id_pk
quality_notes_array_primitive	plant_code_work_order_id_pk
flags_array_primitive	plant_code_work_order_id_pk
text_array_primitive	plant_code_work_order_id_pk
instruments_array_object	equipment_id_str
configuration_notes_array_primitive	equipment_id_str
calibration_config_array_primitive	instrument_id_str
measurements_array_object	instrument_id_str
qc_results_array_object	measurement_id_str
defect_codes_array_primitive	qc_id_str
details_array_primitive	qc_id_str