How do you ignore certain tables to be added to th...
# replication-ask-ai
y
How do you ignore certain tables to be added to the connector?
k
There are two main approaches to ignore/exclude certain tables in Airbyte: 1. Connector-Level Table Filtering (Source Configuration) Some connectors support table filtering directly in their configuration. For example, the MS SQL Server connector supports a
filters
field where you can specify inclusion patterns per schema: • Schema Name: The schema to apply the filter to. • Table Filter Patterns: A list of SQL
LIKE
patterns for table names to include from that schema. If no filters are specified for a schema, all tables in that schema will be synced. [Github Issue] 2. Connection-Level Stream Selection (UI) After a connection is set up, you can disable specific streams (tables) from syncing via the Airbyte UI: 1. Go to Connections and select your connection. 2. Click the Schema tab — all discovered streams will appear. 3. Toggle off the checkbox for any stream/table you want to exclude. 4. Use the summary toggle to deselect all streams at once, then selectively enable only the ones you want. 5. Click Save changes. [Configuring Schemas] > Note: Airbyte reads data at the source level based on what the connector discovers. Deselecting a stream in the UI prevents it from being written to the destination, but the connector may still read it depending on the source implementation. For true source-level filtering (to avoid reading unnecessary tables entirely), use connector-level table filters where supported. šŸ‘ 0 button šŸ‘Ž 0 button ā„¹ļø Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.