defog

/

sqlcoder-34b-alpha

like 168

Follow

Defog.ai 80

How can I pass Specific Instruction.
When i tried to give it in prompt it is not following Instruction while generating Queries

Can you Please tell What is the Prompt for 34B Model

I'm Using this Below Prompt
defog_prompt = '''

Task

Generate a MSSQL query to answer the following question:
{input_query}

special instructions

1. If the question cannot be answered given the database schema, return "Table or Column is not present."
2. Use table aliases to prevent ambiguity. For example, SELECT table1.col1, table1.col2 FROM table1.

Database Schema

The query will run on a database with the following schema:
{db_schema}

Given the database schema, here is the MSSQL query that answers {input_query}: