Documentation
Analytics Query Execution Request
Properties
  • Sftp Dispatch Result File Rename Pattern
    Optional. Renaming pattern for Analytics query result file (may be used when Analytics query results file is scheduled for SFTP delivery). Pattern may look like Latin alphabet string with some timestamp placeholder: "transaction_report_{YYYMMDD_hhmmss}". Supported placeholder formats are just these: 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. Active SFTP Dispatch connection settings ID (dispatch settings ID) associated with the target account. Only required if the Analytics query result file is scheduled for delivery to a remote SFTP server.
  • Sql
    The SQL query (in PrestoDB dialect) to be executed against the analytics database. This query defines the data retrieval operation.
Staging 2.168.6