Page Comparison

Label*

Default Value: AlloyDB Vector Search
Example: AlloyDB VS

String

Specify a name for the Snap. You can modify this to be more specific, especially if you have more than one of the same Snap in your pipeline.

Schema name

Default Value: N/A
Example: VECTOR_DEMO

String/Expression/Suggestion

Specify the schema name for searching for a vector.

Table name*

Default Value: N/A 
Example: VECTOR_DEMO.BOOKS

String/Expression/Suggestion

Specify the table name for searching for a vector.

Vector column*

Default Value: N/A
Example: INT_VEC

String/Expression/Suggestion

Specify the vector column name to search.

Where clause

Default Value: N/A
Example: ID > '001i0000007FVjpAAG'

String/Expression/Suggestion

Specify the where clause to use in the vector search query statement.

Limit rows

Default Value: 4
Example: 3
Min Value: 1

Integer/Expression/Suggestion

Specify the number of results to return for each query.

Distance function*

Default Value: L2
Example: COSINE

Dropdown List

Select the similarity functions used for comparing vectors. The available options are:

• L2: Computes the Euclidean distance between two vectors. The similarity scores are sorted in ascending order.

• L1: Computes the Manhattan distance between two vectors. The similarity scores are sorted in ascending order.

• COSINE: Computes the cosine similarity between two vectors. The similarity scores are sorted in descending order.

• INNER PRODUCT: Computes the inner product of two vectors.The similarity scores are sorted in descending order.

Learn more about the Vector Similarity Functions.

Include values

Default Value: Deselected

Checkbox/Expression

Select this checkbox to include vector values in the response.

Include scores

Default Value: Selected

Checkbox/Expression

Select this checkbox to include similarity scores in the response.

Ignore Empty Result

Default Value: Deselected

Checkbox

Select this checkbox if you want the Snap to produce no output when there is no matching vector is found. Otherwise, the Snap outputs a blank document when there are no matching vectors.

Number of retries

Default Value: 0
Example: 3

Integer/Expression

Specify the maximum number of attempts to be made to receive a response.

Retry interval (seconds)

Default Value: 0
Example: 3

Integer/Expression

Specify the minimum number of seconds the Snap must wait before each retry attempt.

Handle timestamp and date time data

Default Value: Default Date Time format in UTC Time Zone
Example: SnapLogic Date Time format in Regional Time Zone

Dropdown List

Select how you want the Snap to handle timestamp and date time data. The available options are:

• Default Date Time format in UTC Time Zone

• SnapLogic Date Time format in Regional Time Zone

Snap execution

Default Value: Validate & Execute
Example: Execute only

Dropdown list

Select one of the following three modes in which the Snap executes:

• Validate & Execute: Performs limited execution of the Snap and generates a data preview during pipeline validation. Subsequently, performs full execution of the Snap (unlimited records) during pipeline runtime.

• Execute only: Performs full execution of the Snap during Pipeline execution without generating preview data.

• Disabled: Disables the Snap and all Snaps that are downstream from it.