How to download FortiAnalyzer clickhouse schema file

Forum|Forum|1 month ago
July 10, 2026
2 replies
65 views

Where I can find click house schema file for FortiAnalyzer ?

According to docs.fortinet.com:

Each log table stored in an SQL database contains log fields that can be used in datasets.

You can view a full list of the fields available for each log type in the FortiAnalyzer ClickHouse Schema file available from the FortiCloud Support page.

But I cannot find it.

abelio

SuperUser

Hi pawels

search inside downloads/firmware images, since 7.6.4+ you'll find a markdown file with the schema

I.e: FortiAnalyzer-build0105-clickhouse.schema.md file (8.0)

regards

abr

Staff

Hi pawels,

1. Log in to the Fortinet Support Portal.
2. Navigate to Downloads.
3. Select Firmware Images.
4. From the product list, choose FortiAnalyzer.
5. Select the required firmware version.
6. Scroll to the bottom of the page and locate the ClickHouse Schema File entry.
7. Click the HTTPS download link. The schema file download will begin automatically.

Reference:
https://community.fortinet.com/fortianalyzer-6/technical-tip-download-the-postgres-schema-database-file-in-the-support-portal-141669?tid=141669&fid=6

Sign up

Login with SSO

Login to the community

Login with SSO