Description
For access to clickhouse we will use chproxy as proxy service
Links for proxy requests and Credentials for read-only user
Production:
URL: https://chproxy.production.almightypush.com USER_NAME: statistics_user PASSWORD: aejah<foa8Ji6lae
Staging:
URL: https://chproxy.staging.almightypush.com USER_NAME: chproxy_ro_user PASSWORD: fhjR7peecoh>He9
Example of get statistics request
Prod:
echo "select toDate(datetime), sum(sent_count), sum(delivered_count), sum(unique_click_count), sum(subscribe_count), sum(unsubscribe_count) from channels_stat_daily where toDate(datetime) >= '2024-03-01' group by toDate(datetime);" | curl 'https://statistics_user:aejah<foa8Ji6lae@chproxy.production.almightypush.com/?database=statistics' --data-binary @-Stage:
echo "select toDate(datetime), sum(sent_count), sum(delivered_count), sum(unique_click_count), sum(subscribe_count), sum(unsubscribe_count) from channels_stat_daily where toDate(datetime) >= '2024-03-01' group by toDate(datetime);" | curl 'https://chproxy_ro_user:fhjR7peecoh>He9@chproxy.staging.almightypush.com/?database=statistics' --data-binary @-