Deltia.ai develops computer vision solutions for shop floor analytics and insights. The company employs a combination of station-mounted and bird-view camera cameras to generate millions of data points daily, providing valuable insights for optimizing production processes. Deltia.ai's technology tracks material and work steps through continuous video stream analysis, detecting workpiece movements, cycle times, and work step sequencing. This fully automated solution eliminates the need for manual labeling, monitoring, or input, allowing manufacturing, and logistics companies to gather extensive data for process performance improvement efficiently.

Deltia.ai faced a significant challenge in meeting the needs of its primary customers, typically plant managers. While Deltia.ai's dashboard provided comprehensive data and analytics, plant managers often lacked the competency to effectively ingest Business Intelligence dashboard information and query SQL databases effectively to extract the specific business insights required. This gap in skillset made it difficult for Deltia.ai’s customers to leverage the full potential of the data available to optimize and enhance efficiency in their operations. Without addressing this challenge, plant managers would continue to struggle with extracting actionable insights from the data, potentially missing opportunities for process improvements and efficiency gains.

Deltia.ai and SnapSoft chose AWS for its extensive range of cloud services, reliability, and scalability. AWS offers essential services such as AWS Lambda for serverless computing, Amazon DynamoDB for scalable database management, and Amazon RDS for reliable relational databases. AWS's robust security features, including AWS Secrets Manager and Amazon Cognito, ensure data safety and compliance. AWS's continuous innovation in AI and machine learning with services like AWS Bedrock and Amazon Transcribe enables Deltia.ai to integrate advanced technologies seamlessly. By leveraging AWS, Deltia.ai and SnapSoft deliver efficient, scalable solutions that enhance operational efficiencies and provide valuable insights to their clients.

SnapSoft, an advanced-tier AWS partner, developed text-to-SQL functionality integrated into Deltia.ai's existing solutions. This innovation allows plant managers to type their queries in natural language into a chat modal. Leveraging AWS Bedrock, the system uses a large language model (LLM) to convert these natural language queries into SQL queries, which are then executed against the database to retrieve the necessary data. The results are presented back to the user in plain text, making it easy for plant managers to understand and act upon the insights.

• AWS Lambda: Executes backend functions for processing text inputs and generating SQL queries.
• AWS Secrets Manager: Securely manages credentials and secrets needed to access databases.
• Amazon DynamoDB: Stores intermediate data and user sessions efficiently.
• Amazon Cognito: Manages user authentication and access control.
• Amazon API Gateway: Facilitates the creation and management of APIs for communication between the frontend and backend.
• Amazon S3: Stores and retrieves data, especially for logging and analysis.
• Amazon SQS: Ensures reliable message queuing between system components.
• Amazon Bedrock: Provides the LLM capabilities for natural language processing and query generation.
• Amazon Transcribe: Converts voice queries to text for processing by the LLM.
• Amazon OpenSearch Service: Enables advanced search capabilities within the data.
• Amazon RDS: Manages relational database services to store and query production data.

This solution enables plant managers to simply ask questions in plain language and receive comprehensible business insights without needing to interact directly with the SQL database.

The integration of SnapSoft's text-to-SQL functionality into Deltia.ai's solutions has significantly enhanced the usability and accessibility of the data for plant managers. They can now easily query the database and receive actionable insights, leading to more informed decision-making. This advancement has reduced the time spent on data extraction and analysis.