How do I use SQL to build and join tables in confluence?

[Sam Frank]

Hi there - I am new here, and I seeking a way to not only use SQL to build tables in confluence, but then how to I join tables from multiple confluence instances? Is there anyone else who has done this task - and if so, how did you do it? 

Thank you.

-Sam

[Igor Kosarev]

Hi, @Sam Frank 

You can’t do that natively. 
To use SQL on tables you can use Table Transform Macro.

But if you want to do that across different Confluence instances you should have some third party backend to transfer table data between instances.

[Stiltsoft support]

Hi @Sam Frank ,

Indeed as @Igor Kosarev has kindly mentioned, you can join and transform Confluence tables using the Table Transformer macro that belongs to our Table Filter, Charts & Spreadsheets for Confluence app.

What concerns tables from different Confluence instances, you may try to download the required tables in CSV format (our macros allow to do it) and then recreate them in the required instance using the Table from CSV macro that is also provided by the app. Further these recreated tables can be also processed with the Table Transformer macro as regular tables.

If you have any further questions, please refer to our support directly.

[Laura Campbell]

Hi @Sam Frank , Igor is right that you can't do that out of the box.

Confluence has a native database content with a wysiwyg experience, but if you need complex and robust SQL databases, you might be better off building them outside Confluence, and then using something like https://marketplace.atlassian.com/apps/1211199/pocketquery-connect-sql-databases-rest-in-confluence?hosting=cloud&tab=overview to display them.

Can you describe a bit more what your overall goal is? Why do you need to build and combine tables across multiple Confluence instances?

[Sam Frank]

Thank you everybody for all your answers. I see now that for me to combine these tables. I will have to download a CSV file and do it manually. There is no macro that will take tables from other confluence pages and combine them into one. The other idea is to create a dashboard and pull in data from different tables or Jira pages that might be my only option. Thank you.