Label*

Default Value: Snowflake Vector Search
Example: Snowflake 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

Snaps 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.

Similarity

function*

Default Value: L2
Example: COSINE

Dropdown

list

Select the similarity functions

for comparing vectors. The available options are:

• L2: Computes the L2 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.

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.

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.

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 the 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

• .