Analytics Query Execution Request

Documentation

Propriétés

Sftp Dispatch Result File Rename Pattern

Optional. Renaming pattern used for the result file during SFTP delivery. You can use a combination of fixed Latin text and timestamp variables (e.g., "transaction_report_{YYYMMDD_hhmmss}"). Supported variable formats: DDMMYY, MMDDYY, YYYYMMDD, DD_MM_YY, DD-MM-YY, YYYY-MM-DD, YYYY_MM_DD, YYYYMMDD_hhmmss, YYYY-MM-DD_hh-mm-ss.
Sftp Dispatch Settings Id

Optional. ID of the active SFTP configuration to use (associated with the target account). This is only required if the result file is scheduled for delivery to a remote SFTP server.
Sql

The SQL query (in PrestoDB dialect) to execute on the analytics database. This query defines exactly which data should be retrieved.