Note
Read-only support means that the database can optimize for read-only statements. For some databases (PostgreSQL, for instance) the read-only condition is enforced while in others, it is a suggestion for improving performance.

Click any of the following links to know more about the macro:

...

Basic use

Parameters

...

To add an SQL Query macro to a Confluence page, use either of the following methods:
...
Parameters
The following parameters are available in the macro editor:
Macro editor tab Macro editor label Default value Description Macro parameter
Main panel Data source profile

Select SQL as an attachment

SQL statement

Settings > Runtime Transaction isolation level

Maximum number of rows to retrieve and display

Maximum number of seconds for query to run

Settings > Rendering Table ID

Display data filter

Insert auto number column

Enable pagination

Number of rows to be displayed on one page

Show error if there are no rows

Text to display when there are no rows

Show SQL

Macro editor tab	Macro editor label	Default value	Description	Macro parameter
Main panel	Data source profile
	Select SQL as an attachment
	SQL statement
Settings > Runtime	Transaction isolation level
	Maximum number of rows to retrieve and display
	Maximum number of seconds for query to run
Settings > Rendering	Table ID
	Display data filter
	Insert auto number column
	Enable pagination
	Number of rows to be displayed on one page
	Show error if there are no rows
	Text to display when there are no rows
	Show SQL