Add Field (Column) Selection to the Terraform provider

[nataliekwong]

Currently, fieldSelectionEnabled is not exposed to the Terraform provider.

Branched from this issue: #35798

[kev-datams]

We would love to use this new capability 🙏

[jonseymour]

You can set it in the terraform provider now by adding selected_fields to each stream

For example:

        "selected_fields": [
          {
            "field_path": ["id"]
          },
          {
            "field_path": ["updated_at"]
          },
          {
            "field_path": ["email"]
          }
        ],

You do need to include the primary_key and cursor_fields in the list of selected fields.

The most glaring omission, however, is that neither the terraform provider nor the underlying SDK/API supports extracting the list of selected fields in a stream. This makes round-tripping impossible with the API alone and cumbersome otherwise,

See also: #45455

[JonsSpaghetti]

Hi @jonseymour , have you seen https://reference.airbyte.com/reference/getstreamproperties? I believe that allows you to pull the streams in the way you're describing. Not super well documented, but something we're hoping to socialize more as you're not the only person who has run into this.