What is best practice to exclude columns currently?
a
Annika Maybin
01/05/2023, 4:53 PM
Creating a view in your Source...
Annika Maybin
01/05/2023, 4:53 PM
at least that's what I will be doing. 😄
r
Robert Put
01/05/2023, 4:55 PM
yeah.... was looking for ways to handle it in the tool....
1. I know the api can select/exclude columns.... but each schema change forces a refresh of all the data with the api
2. UI doesn't let you exclude
3. I know there have been api/ui changes merged in the last few versions to support this in the UI but i wonder how close to being deployed it is
a
Annika Maybin
01/05/2023, 4:58 PM
Yeah no idea. Maybe you could tackle it with dbt? But I am new to this, so from what I have been understanding that should be an option, but creating a view is just easier for now.
n
Nataly Merezhuk (Airbyte)
01/09/2023, 4:43 PM
Hey Robert! Thanks for your patience - I was out last week for the holidays and am catching up with messages now.
Annika is correct - currently the best and only way to handle this is by creating views in the source!