Description

This macro has similar parameters as the SQL Macro and behaves similarly in most cases. There are 2 primary reasons for using sql-file:

Security - it can be secured separately from the other SQL macros.
1. Using Macro Security for Confluence, more general users can be authorized to use this macro since the administrator controls what queries can be accessed.
2. When not using Macro Security for Confluence, the administrator can disable the sql and sql-query macros and still allow the sql-file macro since it has a fixed set of queries that can be run.
Simplified file access parameter.

Parameters

Parameter

Required

Default

Macro Browser Label

Description

file

File

File path in the configured Confluence server home directory under the script directory.

Unable to render {include} The included page could not be found.

 {sql-file:dataSource=testDS|file=authorized.sql}