Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
sahubibhuti45
Frequent Visitor

Dynamic Parameter input in python query

Hi Team,

I am taking data from a simple query like "Select * from table limit 10 in my python script;

I want to make the limit 10 number to be dynamic so that whenever user enters a number in front it should show the number of rows.

 

I have created a parameter and then I have created a table with a list of numbers and trying to embed the parameter with the number table but i am nit getting the option for embedding the parameter. Please help.

 

I am using vertica as database.

1 REPLY 1
v-yifanw-msft
Community Support
Community Support

Hi @sahubibhuti45 ,

To enable dynamic data retrieval based on user input, you can use the parameterisation feature of Python in SQL query execution. This approach not only makes the query dynamic, but also enhances security by preventing SQL injection. Here is a brief step-by-step guide to help you solve the problem:

1. First, make sure there is a mechanism to capture the input of the number of rows the user wishes to retrieve. This can be done with a simple input function in Python.

 

user_limit = input("10")

 

2. Next, parameterise the SQL query using this input.

 

cursor = conn.cursor()
query = "SELECT * FROM table LIMIT ?"
cursor.execute(query, (user_limit,))
rows = cursor.fetchall()

for row in rows:
    print(row)

 

By performing these steps, you can make restrictions in SQL queries dynamic based on user input.

 

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.