Add source path field in table created from Cloud based source (S3/GCS)

### Feature Description

**What the feature achieves:**

Add an option to include source/input file path as a column in the table created from Cloud based source (disabled by default)

**Why this feature is needed:**

### User Experience

**How users will use this feature:**
- Configuration changes needed
- API changes
- Usage examples

### Hudi RFC Requirements

**RFC PR link:** (if applicable)

**Why RFC is/isn't needed:**
- Does this change public interfaces/APIs? (Yes/No)
- Does this change storage format? (Yes/No)
- Justification: