Bug: Clickhouse - split the ingestion & query tables in separate databases for better access control



In order to support our earlier use case where we wanna reduce user confusion etc for tables on grafana,

we've decided to restrict grafana (and application) access to query tables only.

in order to do this we've decided to separate the query & ingestion database names

table format - `hyperswitch_<env>_pub` for query tables & `hyperswitch_<env>` for ingestions tables

with this format we will be creating new databases with the `_pub` suffix

in this case the Kafka & MV tables would reside in the private db while the cluster & audit tables would reside in the public database...

as part of this let's also delete the dist tables and query directly from cluster tables since we don't use sharding...
in this case we'll rename the clustered tables to remove the clustered suffix
e.g `payment_attempt_clustered -> payment_attempt`

The following action items need to be taken

- [ ] Create new database with _pub suffix
- [ ] Create a replica cluster/audit table in the newer public db & backfill it from the older cluster table
- [ ] setup an mv from queue to cluster/audit tables
- [x] code changes to change the table name (instead of relying on `payment_attempt_dist` we'll rely on `payment_attempt`)
- [x] env changes to specify the newer database names
- [ ] update access for the users to have access only to their respective env public databases
diff --git a/crates/analytics/src/clickhouse.rs b/crates/analytics/src/clickhouse.rs
index f81c29c801c..00ae3b6e310 100644
--- a/crates/analytics/src/clickhouse.rs
+++ b/crates/analytics/src/clickhouse.rs
@@ -354,11 +354,11 @@ impl ToSql<ClickhouseClient> for PrimitiveDateTime {
 impl ToSql<ClickhouseClient> for AnalyticsCollection {
     fn to_sql(&self, _table_engine: &TableEngine) -> error_stack::Result<String, ParsingError> {
         match self {
-            Self::Payment => Ok("payment_attempt_dist".to_string()),
-            Self::Refund => Ok("refund_dist".to_string()),
-            Self::SdkEvents => Ok("sdk_events_dist".to_string()),
-            Self::ApiEvents => Ok("api_audit_log".to_string()),
-            Self::PaymentIntent => Ok("payment_intents_dist".to_string()),
+            Self::Payment => Ok("payment_attempts".to_string()),
+            Self::Refund => Ok("refunds".to_string()),
+            Self::SdkEvents => Ok("sdk_events_audit".to_string()),
+            Self::ApiEvents => Ok("api_events_audit".to_string()),
+            Self::PaymentIntent => Ok("payment_intents".to_string()),
             Self::ConnectorEvents => Ok("connector_events_audit".to_string()),
             Self::OutgoingWebhookEvent => Ok("outgoing_webhook_events_audit".to_string()),
         }

## Type of Change
<!-- Put an `x` in the boxes that apply -->

- [ ] Bugfix
- [ ] New feature
- [ ] Enhancement
- [x] Refactoring
- [ ] Dependency updates
- [ ] Documentation
- [ ] CI/CD

## Description
updated analytics tables of ckh source to new tables


### Additional Changes

- [ ] This PR modifies the API contract
- [ ] This PR modifies the database schema
- [ ] This PR modifies application configuration/environment variables

<!--
Provide links to the files with corresponding changes.

Following are the paths where you can find config files:
1. `config`
2. `crates/router/src/configs`
3. `loadtest/config`
-->


## Motivation and Context
Segregating tables in ckh for better access control


## How did you test it?
<!--
Did you write an integration/unit/API test to verify the code changes?
Or did you test this change manually (provide relevant screenshots)?
-->
- check the analytics tab in dashboard

## Checklist
<!-- Put an `x` in the boxes that apply -->

- [ ] I formatted the code `cargo +nightly fmt --all`
- [ ] I addressed lints thrown by `cargo clippy`
- [ ] I reviewed the submitted code
- [ ] I added unit tests for my changes where possible
- [ ] I added a [CHANGELOG](/CHANGELOG.md) entry if applicable
