The solution generates complex SQL queries using bedrock models given a question prompt. The solution also validates the generated queries by testing them with sample data to ensure a smooth run without any errors. The solution requires only two input files containing questions in the English language and a data schema with metadata in JSON format. The output file contains the SQL queries perfectly ready to run. If the asked question is to complex the suggested changes will also get generated along with the query.
- The solution can be useful to analyze the multi-tabular data without giving the actual data. It generates complex SQL queries given appropriate prompts on one table schema at a time and up to 4 questions in a single inference. It also validates the queries for a smooth run and also returns the error or warning if any.
- It can be used for data analysis tasks, to extract information from tabular data, and does not require any expertise in SQL. The users required only the AWS credentials of an account that has a bedrock anthropic-claude-instant-v1 model subscription.
- Mphasis DeepInsights is a cloud-based cognitive computing platform that offers data extraction & predictive analytics capabilities. Need customized Machine Learning and Deep Learning solutions? Get in touch!
The product can be found here