Embedding Pipelines
Secure embedding infrastructure with row-level security and flexible technology choice.
About the Project
Embedding pipelines form the foundation for RAG applications and semantic search. As part of various projects, numerous pipelines were developed – each adapted to the specific requirements and preferences of customers.
Security-by-Design
Security-by-Design: A central principle in development is the consistent consideration of access controls. Row-Level Security (RLS) and Field-Level Security are conceptually integrated from the start. Embeddings inherit the permissions of their source documents – this ensures that semantic search only finds content the respective user has access to.
Vector Stores
Flexible Vector Stores: Different vector databases are used depending on requirements – Milvus for high-performance, scalable deployments, Azure AI Search for integrated search pipelines with hybrid search, Azure SQL Database with Vector Extension for scenarios with existing SQL infrastructure and RLS requirements.
Orchestration
Orchestration: Document embedding is done via various pipeline technologies – N8N for rapid, visual development, Azure Durable Functions for scalable, event-driven pipelines, Fabric Data Pipelines for integration into Microsoft Fabric ecosystems.
Embedding Models
Embedding Models: Depending on use case and data protection requirements – OpenAI API for state-of-the-art embeddings, Microsoft Foundry for Azure-native deployments, Ollama for local, privacy-compliant processing.
Highlights
- Security-by-design with RLS and field-level security
- Flexible technology choice (cloud/on-premises)
- Support for various vector stores and embedding models
- Reusable pipeline patterns
Challenges
Consistent permission inheritance across different vector stores. Performance with large document collections.
Results
Secure, flexible embedding infrastructure for diverse customer requirements. Reusable patterns for RAG applications.
Interested?
Are you interested in a similar project or want to learn more? Get in touch – we look forward to hearing from you!
Get in touch