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.

[Sahir Maharaj]

Hello @Trinath Sripathi

From my limited experience, integrating SQL queries with Snowflake to populate a Confluence report may require third-party apps like SQL for Confluence or manually embedding data through JSON or CSV uploads.

You could also use APIs to refresh data dynamically in a custom macro.

If this approach doesn’t meet your needs, I recommend consulting Atlassian support at https://support.atlassian.com/contact/#/.