How can I populate report on confluence based on SQL query and connecting to Snowflake

[Trinath Sripathi]

How can I populate report on confluence based on SQL query and connecting other databases like Snowflake ?
I am maintaining table manually in Confluence and I want to populate one of the column on that table (with last refresh date/time) which brings information from Snowflake Database.
Is that something doable with Confluence ?
Appreciate if you could help me further on it.

[Aron Gombas _Midori_]

There are multiple apps to connect external databases (and other data sources like REST API, e.g.) to Confluence.

Note that the popular PocketQuery explicitly mentions the support for Snowflake!

[Trinath Sripathi]

Thank you Aron. Will explore further.

[Shawn Doyle - ReleaseTEAM]

Hi @Trinath Sripathi 

You would need a 3rd party Marketplace app to connect to Snowflake.  Doing a quick search there is at least one available.  It offers a trial, you could test if it meets your needs.

[Trinath Sripathi]

Thank you Shawn, we already have Snowflake account and I am not sure what 3rd party tool I need to use. Any inputs are greatly appreciated.

[Shawn Doyle - ReleaseTEAM]

You can look in the Marketplace.  I don't like recommending one Marketplace vendor over another, as I partner with many.  

Here is a search link.

https://marketplace.atlassian.com/search?query=snowflake&product=confluence