API endpoint for scripts

1

Is there an API endpoint for retrieving and executing saved scripts?

2

Hi Joe,

There isn’t currently an API endpoint for scripts. Could you describe what you’re looking to do with scripts via an API? We can take this into consideration for our roadmap.

3

I found it: /apiv2/scripts

4

Joe, that’s an internal endpoint and not supported for public use. It is subject to change at any time.

5

Thank you, Isha. Is there a public endpoint?

6

There isn’t currently an API endpoint for scripts. Could you describe what you’re looking to do with scripts via an API? We can take this into consideration for our roadmap.

7

We are thinking about possible usages for scripts. It could be useful for scripts that load data from some source into iceberg tables. I’ve tested this with a MERGE INTO statement in a script, but I have to run it from within the UI or a SQL client. Being able to kick off the script from an API call could be handy.

8

@Joe Can you not use the POST SQL API?

1 Like
9

I’m sure that will work for executing the query, but we still need to get the SQL. I’m thinking it would be a handy use of the Scripts feature to store the SQL there and use the API to execute it.

Of course, ideally, Scripts would be schedulable and we could do it all within the Dremio UI!

10

Thanks for the feedback @Joe , I will take this back to the product team