Running Query over SPICE Datasets

Question & Answer
1

I wanted to know if there is a way to run SQL queries over the SPICE Dataset for adhoc analysis which get refreshed occasionally. Any APIs to solve the problem is also fine.

Thanks in advance

2

Can you explain more of what you are trying to do?

Are you trying to run queries on information of SPICE dataset (size etc.) or run a query on the data in the dataset?

3

I am trying to run queries over the data in the dataset.

4

There is no way to run a custom sql query on the dataset itself.

Are you using SQL for the dataset originally? Can you wrap that in a subquery and then perform you SQL operations on top of the sub query?