Is parameterized SQL not supported by Dremio?

21

@Harrini We do not have an exact date for V26 yet. Can you please check back in a month?

22

Parameterized prepared statements has already been released to Dremio Cloud and the documentation is here: JDBC Driver for Arrow Flight SQL | Dremio Documentation

The same docs should apply to v26 which is targeted for 2025.

Regarding the implementation, the primary driver was security and preventing SQL injection attacks. Parameterized SELECT statement will also benefit from the existing plan cache feature.

23

Hi @Benny_Chow ,

We agree that this is available in JDBC. But we are looking for the parametrized prepared statement option through ODBC since it allows us to use this feature directly in the Report Builder (paginated report)

@balaji.ramaswamy ,
Wanted to follow back on the same. Could you please kindly let us know if we have any update on this ?

1 Like
24

@Harrini Yes, as Benny pointed out, already on cloud and expected to be in release 26 for software

2 Likes
25

@Harrini Apologize, i got it mixed up, ODBC at this point we do not have a specific ETA

26

Hi @balaji.ramaswamy ,

Thanks for your update on this.

This feature will be valuable as it allows writing SQL format queries with parameters in Power BI report builder and optimizes performance by fetching only the intended data.

27

@balaji.ramaswamy thanks for the update. While i too am interested in odbc, noted your point it is not yet on roadmap. Meanwhile, can you advise parametrized query support over rest apiā€¦understand there is sql endpoint where sql query can ne provided, in this case of api, is parametrizarion expected to happen on client side, thanks in advance

28

@rdkworld Can you elaborate on your use case for parameterized query support through REST API? I get JDBC, ODBC and ADBC but Iā€™d like to know more about REST.

29

@Benny_Chow we have virtual data set created. End user wants to query it for a particular customer over rest api(so there is a where condition). While they can make post request to sql endpoint with query in body, there is a risk of sql injection attack

1 Like
30

Would also very much like to see parameterised SQL support in the ODBC driver.

It looks like as of today there have been no updates since July 2022 and itā€™s still in beta so some sort of ETA would be great.

1 Like
31

Same problem with new ODBC driver 0.9.4.1186 from April 2025..