# BI tools and SQL Queries

**URL:** <https://community.stardog.com/t/bi-tools-and-sql-queries/1967>\
**Category:** Support\
**Created:** [October 3, 2019, 1:05pm UTC](https://community.stardog.com/t/bi-tools-and-sql-queries/1967 "2019-10-03T13:05:16Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![zachary.whitley](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/zachary.whitley/32/94_2.png) [@zachary.whitley](https://community.stardog.com/u/zachary.whitley)\
**Post date:** [October 3, 2019, 1:05pm UTC](https://community.stardog.com/t/bi-tools-and-sql-queries/1967/1 "2019-10-03T13:05:16Z")

</div>

So I see there's a new version of Stardog out, 7.0.2. Just a little minor bump. Maybe some bug fixes and then this little nugget "SQL query support for BI/viz tools (#7886)" Boom!

> **[Home](https://docs.stardog.com/)**
>
> Documentation for Stardog, the world’s leading Knowledge Graph Platform for the Enterprise

You might want to be all modest and nonchalant about it but I'm going to jump up and down about it like it's my birthday. This is awesome. I see you mention Tableau but I'm going to give Apache Superset a try with this. [https://superset.incubator.apache.org/](https://superset.incubator.apache.org/)

Beyond just business reporting tools this opens up the field to a ton of tools and apps that are built for SQL. I love SPARQL but sometimes I either don't need the flexibility or I don't have the time to rewrite the world so that I can do some prototyping. Maybe hook this up to geoserver to serve some mapping data. This is going to be fun.

Thanks for the new play toy.

---

<div class="post-metadata">

**Author:** ![evren](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/evren/32/1515_2.png) [@evren](https://community.stardog.com/u/evren)\
**Post date:** [October 3, 2019, 1:34pm UTC](https://community.stardog.com/t/bi-tools-and-sql-queries/1967/2 "2019-10-03T13:34:32Z")

</div>

Hi Zachary,

We are very excited about this new feature too and it is good to see others share the same enthusiasm. We have a blog post coming out about this new feature very soon and we will be talking about it more going forward.

This feature is in beta state right now so some bumps along the way are possible. As you mentioned we tested several BI tools and some other SQL systems but there are many others we have not tested yet. We would love to hear your experience with Apache Superset and any feedback you might have about this feature.

Best,  
Evren

---

<div class="post-metadata">

**Author:** ![zachary.whitley](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/zachary.whitley/32/94_2.png) [@zachary.whitley](https://community.stardog.com/u/zachary.whitley)\
**Post date:** [October 3, 2019, 3:10pm UTC](https://community.stardog.com/t/bi-tools-and-sql-queries/1967/3 "2019-10-03T15:10:01Z")

</div>

"In addition to table mappings, stored queries can be treated as tables. They will automatically be added to the schema if visible from the database."

![](https://media.giphy.com/media/26xBENWdka2DSvvag/giphy.gif)

---

<div class="post-metadata">

**Author:** ![evren](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/evren/32/1515_2.png) [@evren](https://community.stardog.com/u/evren)\
**Post date:** [October 11, 2019, 5:20pm UTC](https://community.stardog.com/t/bi-tools-and-sql-queries/1967/4 "2019-10-11T17:20:17Z")

</div>

Hi Zachary,

We looked into Apache Superset and discovered some minor compatibility issues mostly due to the underlying SQLAlchemy python library that is being used. So this is not going to work out-of-the-box with Stardog 7.0.2 but we are looking into these issues and hopefully we will fix them for the next release.

Best,  
Evren

---

<div class="post-metadata">

**Author:** ![zachary.whitley](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/zachary.whitley/32/94_2.png) [@zachary.whitley](https://community.stardog.com/u/zachary.whitley)\
**Post date:** [October 25, 2019, 5:20pm UTC](https://community.stardog.com/t/bi-tools-and-sql-queries/1967/5 "2019-10-25T17:20:26Z")

</div>

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.
