[source volcano] Allow meta field to be queried in SelectQuerySpec

[burakku]

What

As we add trigger based CDC for Sap Hana, existing CDK does not support this use case.
Here is the conflict in CDK:

• we need to query trigger table to get changes, trigger table schema is in either field type or meta field type.
• we need to define cursor at discovery phase for stream. CDC cursor currently is defined as meta field type.

If we define trigger table schema using meta field type, we cannot query the table. If we define trigger table schema using field type, we cannot define the cursor at discovery phase.

How

So we either change SelectQuerySpec to support meta field type or we change MetaFieldDecorator to support field type as cursor. I have put both changes in this PR.

I would prefer to change SelectQuerySpec but open to other thoughts

Review guide

Please suggest which file to change to support trigger table schema

User Impact

No

Can this PR be safely reverted and rolled back?

• YES 💚
• NO ❌

[vercel]

The latest updates on your projects. Learn more about Vercel for Git ↗︎

Name	Status	Preview	Comments	Updated (UTC)
airbyte-docs	✅ Ready (Inspect)	Visit Preview	💬 Add feedback	Jan 31, 2025 7:00am