How can i specify the db objects to include?

[stephanbertl]

I am using the tap with the airbyte/source-mssql container. On run, it iterates over all objects (including functions) and throws errors. How can i limit it to specific streams? I tried specifying them in the meltano config. But it isnt working. I could not find any documentation about that.

com.microsoft.sqlserver.jdbc.SQLServerException: Parameters were not supplied for the function 'dbo.XXXXXX

To filter I tried (1) the following airbyte spec:

{
    "airbyte_spec": {
      "image": "airbyte/source-mssql"
    },
    "config": {
        "streams": [
          {
            "name": "Entry",
            "sync_mode": "full_refresh",
            "cursor_field": [],
            "primary_key": ["ID"]
          }
        ]
      }
}

and running

meltano --environment=local invoke tap-mssql--airbyte --config .\msssql.json

no success.

Also inside meltano.yaml how would i even translate this? Zero documentation.

  - name: tap-mssql--airbyte
    variant: airbyte
    namespace: tap_airbyte
    executable: tap-airbyte
    pip_url: git+https://github.com/MeltanoLabs/tap-airbyte-wrapper.git
    config:
      airbyte_spec.image: airbyte/source-mssql
      airbyte_config.host: ${DATABASE_HOST}
      airbyte_config.database: ${DATABASE}
      airbyte_config.port: 1433
      airbyte_config.username: XXXXX
      airbyte_config.password: XXXX
      airbyte_config.schemas:
      - "dbo" # this at least works
      airbyte_config.streams: #unclear how this is even configurable?
        - name: MyView
          schema: Y
          database: Y
          primary_key: ID
    # also no effect
    select:
      - dbo-MyView.*