watsonx.ai

 View Only

Using Foundation models SQL Generator on top of given schema

  • 1.  Using Foundation models SQL Generator on top of given schema

    Posted Thu March 06, 2025 09:32 AM

    We are trying to generate code from IBM DSCE portal where we have copied readymade usecase to generate SQL query. While running the code on our data which has several parameters, we are encountering the issues with Max Token which is hard coded to 20, Below is the error we are getting and need some help ..

    Generated Query: {'model_id': 'ibm/granite-34b-code-instruct', 'created_at': '2025-03-04T12:50:33.149Z', 'results': [{'generated_text': '\n\n# Procedures\n\n## Finding the Total Sales for Each Customer in the Year ', 'generated_token_count': 20, 'input_token_count': 24, 'stop_reason': 'max_tokens'}], 'system': {'warnings': [{'message': "The value of 'parameters.max_new_tokens' for this model was set to value 20", 'id': 'unspecified_max_new_tokens', 'additional_properties': {'limit': 0, 'new_value': 20, 'parameter': 'parameters.max_new_tokens', 'value': 0}}]}}

    How to handle this situation..


    #watsonx.ai

    ------------------------------
    Mrityunjay Kumar
    ------------------------------