Elasticsearch Index Manager
Indexes
Create Index
Data Sync
Incremental Sync
SQL-to-SQL Sync
Search
API Docs
Swagger UI
ReDoc
Edit Data Sync Configuration: flyeroffersflat_master_v1
Configuration Name
*
Batch Size
Number of records to process per batch
SQL Server Connection String
*
Test Connection
Schema
Source Table
*
Load Tables
Elasticsearch Index Name
*
WHERE Clause (Optional)
SQL WHERE clause to filter source data
Data Change Detection Column (Optional)
-- Select Change Detection Column --
ID
OfferId
CategoryIds
SubCategoryIds
ItemIds
BrandIds
GeneratedOn
CategoryIdsJson
SubCategoryIdsJson
ItemIdsJson
BrandIdsJson
TagTypeJson
TagIdsJson
Tag_Search_En_Json
Tag_Search_Local_Json
Tag_Click_Json
Tag_Click_Action_Json
Tag_Display_En_Json
Tag_Display_Local_Json
CollectionViewTags1
DetailedViewTags1
RetailerId
Logo
TimeZone
Name_en
Name_local
Description_en
Description_local
SearchText
Description_en2
Description_local2
Description_en3
Description_local3
IsBuyNow
BuyNowUrl
BuyNowUrlLocal
Buynow_Value_en
Buynow_Value_local
CityIds
CityIdsJson
Currency
ProductIdsJson
Image
ImageWidth
ImageHeight
PromoPrice
RegularPrice
PromoTypeId
PromoQuantity
MaxQuantity
PackSize
PackUnit
OfferStartDate
OfferEndDate
CreatedOn
OfferCount
IsCustomText
Custom_en
Custom_local
IsPublish
IsActive
IsDeleted
OfferStartDateUTC
OfferEndDateUTC
Discount
SearchText_En
SearchText_Local
FlyerPageId
OfferImageId
OfferStatus
x1Width
x2Width
y1Height
y2Height
OfferImageTypeId
CouponCode
CouponType
Buynowid
IsPrimaryOffer
CountryId
FlyerName
Promo_Zone
TotalStores
ValidStores
Regioninjson
IndexCreatedOn
PopularityCount
Packsizeid
PackSizeIdsJson
RetailerName
CountryName
Pageno
FlyerId
PromoMechanicJsonFacet
PromoMachanicJson
Productid
Productidsinjson
BrandIdsJsonFacet
PromoPriceFacet
TagId
TagIdsJsonFacet
AttributeId
AttributeIdsJson
AttributeIdsJsonFacet
DiscountPriceFacet
isupdateindex
AttributeJsonFacetOB
IsReview
IsMemberOnly
IsParent
yearmonth
Assorted
voucher_cashback
FlyerCreatedOn
flyer_yearmonth
SearchText_new
SearchText_EN_new
SearchText_Local_new
RetailerIdsJsonFacet
CategoryIdsJsonFacet
SubCategoryIdsJsonFacet
ImageText
BrandNamesJson
PackSizeNamesJson
GPT_Suggested_Brand
GPT_Suggested_PackSize
GPT_Suggested_Promoquantity
Cashback_Amount
Select a column (e.g., ModifiedDate, UpdatedAt, LastModified) to track data changes for incremental syncs. This column should be updated whenever a record is modified. If not specified, the system will attempt to auto-detect a suitable column.
Auto-increment / ID Column (Optional)
-- None (sync by offset) --
ID
OfferId
CategoryIds
SubCategoryIds
ItemIds
BrandIds
GeneratedOn
CategoryIdsJson
SubCategoryIdsJson
ItemIdsJson
BrandIdsJson
TagTypeJson
TagIdsJson
Tag_Search_En_Json
Tag_Search_Local_Json
Tag_Click_Json
Tag_Click_Action_Json
Tag_Display_En_Json
Tag_Display_Local_Json
CollectionViewTags1
DetailedViewTags1
RetailerId
Logo
TimeZone
Name_en
Name_local
Description_en
Description_local
SearchText
Description_en2
Description_local2
Description_en3
Description_local3
IsBuyNow
BuyNowUrl
BuyNowUrlLocal
Buynow_Value_en
Buynow_Value_local
CityIds
CityIdsJson
Currency
ProductIdsJson
Image
ImageWidth
ImageHeight
PromoPrice
RegularPrice
PromoTypeId
PromoQuantity
MaxQuantity
PackSize
PackUnit
OfferStartDate
OfferEndDate
CreatedOn
OfferCount
IsCustomText
Custom_en
Custom_local
IsPublish
IsActive
IsDeleted
OfferStartDateUTC
OfferEndDateUTC
Discount
SearchText_En
SearchText_Local
FlyerPageId
OfferImageId
OfferStatus
x1Width
x2Width
y1Height
y2Height
OfferImageTypeId
CouponCode
CouponType
Buynowid
IsPrimaryOffer
CountryId
FlyerName
Promo_Zone
TotalStores
ValidStores
Regioninjson
IndexCreatedOn
PopularityCount
Packsizeid
PackSizeIdsJson
RetailerName
CountryName
Pageno
FlyerId
PromoMechanicJsonFacet
PromoMachanicJson
Productid
Productidsinjson
BrandIdsJsonFacet
PromoPriceFacet
TagId
TagIdsJsonFacet
AttributeId
AttributeIdsJson
AttributeIdsJsonFacet
DiscountPriceFacet
isupdateindex
AttributeJsonFacetOB
IsReview
IsMemberOnly
IsParent
yearmonth
Assorted
voucher_cashback
FlyerCreatedOn
flyer_yearmonth
SearchText_new
SearchText_EN_new
SearchText_Local_new
RetailerIdsJsonFacet
CategoryIdsJsonFacet
SubCategoryIdsJsonFacet
ImageText
BrandNamesJson
PackSizeNamesJson
GPT_Suggested_Brand
GPT_Suggested_PackSize
GPT_Suggested_Promoquantity
Cashback_Amount
Identity/auto-increment column. Re-run sync fetches only rows where this column > last synced ID.
Last Synced ID
Updated after each batch. Re-run fetches records where ID > this value. Clear and save to re-sync from start.
Field Mappings
Load Columns
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model
Similarity
Cosine
Dot Product
L2 Norm
Ollama Embeddings & Vector Search
Enable Ollama Embeddings for Vector Fields
Ollama URL
Ollama server URL
Embedding Model
Ollama embedding model name
Vector Column Mappings
Add Mapping
Map SQL columns to vector fields. The source column text will be embedded using Ollama and stored in the target vector field.
Back to List
Update Configuration