...
Parameter | Mandatory | Description | Comments |
|---|---|---|---|
report_name | Yes | Name of the report | |
query_engine | Yes | Data Source | DRUID, CASSANDRA, ELASTICSEARCH |
execution_frequency | Yes | Report generation frequency | DAILY, WEEKLY, MONTHLY |
channel_id | No | ChannelId for filtering | |
report_interval | Yes | Date range for queries |
|
query | Yes | Query to be executed | |
output_format | Yes | Output format of the report | json, csv |
output_file_pattern | No | Report output filename pattern | report_id and end_date from the interval is are used by default {report_id}-{end_date}.{output_format} Other Supported Placeholders are:
|
...
| Code Block | ||||
|---|---|---|---|---|
| ||||
# Schema of table
TABLE platform_db.druid_reports_configuration (
report_id text, // hash of report_id, channel_id and report_interval
report_name text,
report_interval text,
query_engine text,
cron_expression text,
status text,
report_query_location text,
report_output_format text,
report_output_location text,
report_output_filename text,
report_output_file_pattern list<text>text,
report_last_generated timestamp,
PRIMARY KEY (report_id) );
)
|
...