Documentation
Documentation
Analytics Query Execution Request
Close
Analytics Query Execution Request
Properties
  • 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.