New to squared up here. If this is the wrong way of doing what i am asking please let me know. We have a sql database that we are using to get some data for some dashboards. However some of our tiles use the same query and then we want to filter the tile further if we need to. I want to have same base query for some tiles so if we need to change the data at the base level, we can without having to edit all of the tiles. My thought was a custom datastream for MSSQL however the documentation is lacking in this area and really have no idea how to set up a custom datastream for this. Does anyone have any samples on a custom datastream for MSSQL? Or a better way?
Hi Corey. Great question! And welcome to the SquaredUp community.
We (SquaredUp) are working on a new feature to make it possible to create parameterised custom data streams just like you describe.
Would you want to use a dashboard variable (dropdown filter at the top of the page) to dynamically change the dashboard content, or would the filter just be used to configure tiles?
In this use case it would be just to configure tiles. An example would be we have a Vulnerability Management database that stores the schedules of our vulnerability scans and penetrations tests. I would have one guage that has a list of the schedules, one gauge that would show in progress scans, one shows scans coming up in the next 30 days and then a gauge that shows late scans. All use the same dataset.
Got it. Right now you’ll have to use copies of the SQL across the tiles, but the new UI for custom data streams will let you parameterise so that you can use a shared SQL statement.
I’ve passed your feedback on internally and someone should be in touch to discuss further.
Thanks Rich,
Is there an ETA of the parameterize feature??
No specific date, but we’re working on it! This is part of a whole group of features that will make it easy to integrate with custom data sources. Expect to hear some more news on this in early 2026.