Bug: feat(analytics): add card_network as a field in clickhouse payment_attempts table



Add `card_network` as a field in clickhosue `payment_attempts.sql` file.
diff --git a/crates/analytics/docs/clickhouse/scripts/payment_attempts.sql b/crates/analytics/docs/clickhouse/scripts/payment_attempts.sql
index 5c1ee8754c9..f5d0ca51fd7 100644
--- a/crates/analytics/docs/clickhouse/scripts/payment_attempts.sql
+++ b/crates/analytics/docs/clickhouse/scripts/payment_attempts.sql
@@ -42,6 +42,7 @@ CREATE TABLE payment_attempt_queue (
     `client_version` LowCardinality(Nullable(String)),
     `organization_id` String,
     `profile_id` String,
+    `card_network` Nullable(String),
     `sign_flag` Int8
 ) ENGINE = Kafka SETTINGS kafka_broker_list = 'kafka0:29092',
 kafka_topic_list = 'hyperswitch-payment-attempt-events',
@@ -94,6 +95,7 @@ CREATE TABLE payment_attempts (
     `client_version` LowCardinality(Nullable(String)),
     `organization_id` String,
     `profile_id` String,
+    `card_network` Nullable(String),
     `sign_flag` Int8,
     INDEX connectorIndex connector TYPE bloom_filter GRANULARITY 1,
     INDEX paymentMethodIndex payment_method TYPE bloom_filter GRANULARITY 1,
@@ -149,6 +151,7 @@ CREATE MATERIALIZED VIEW payment_attempt_mv TO payment_attempts (
     `client_version` LowCardinality(Nullable(String)),
     `organization_id` String,
     `profile_id` String,
+    `card_network` Nullable(String),
     `sign_flag` Int8
 ) AS
 SELECT
@@ -196,8 +199,9 @@ SELECT
     client_version,
     organization_id,
     profile_id,
+    card_network,
     sign_flag
 FROM
     payment_attempt_queue
 WHERE
-    length(_error) = 0;
\ No newline at end of file
+    length(_error) = 0;

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

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

## Description
<!-- Describe your changes in detail -->
Added card_network as a field in payment_attempts clickhouse table

### 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
<!--
Why is this change required? What problem does it solve?
If it fixes an open issue, please link to the issue here.

If you don't have an issue, we'd recommend starting with one first so the PR
can focus on the implementation (unless it is an obvious bug or documentation fix
that will have little conversation).
-->


## 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)?
-->
Made sample payments on sandbox dashboard and confirmed the data for card_network on clickhouse sandbox
![image](https://github.com/user-attachments/assets/e7c955ed-c331-4563-ad8d-32ab5fd605e4)
![image](https://github.com/user-attachments/assets/ce351d3d-9091-4f97-91fc-d77531e1d45a)


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

- [x] I formatted the code `cargo +nightly fmt --all`
- [x] I addressed lints thrown by `cargo clippy`
- [x] I reviewed the submitted code
- [ ] I added unit tests for my changes where possible
