Other: fivetran_connector_schema_config
Answered
Hi,
We have a sqlserver connector established. Our configuration is to allow all tables with the exception of those containing specific titles eg beginning with "it", this could be uppercase or lowercase and followed by any alphanumeric characters, so we would like to be able to specify regex in the Terraform code for the resource "fivetran_connector_schema_config" to be able to exclude these. The names are not predictable and vary per environment.
As this seems possible via the web UI, it would be useful to be able to do this via code.
Regards
Adam
-
Official comment
Hi Adam,
I have added your request to our feature improvements backlog. I'm curious to learn more about your specific use case—are there dynamic patterns for table naming beyond variants of "it"? Are there any edge cases or operational scenarios that would help us prioritize and design this feature effectively?
This would be a pretty deep and fundamental change, as it would affect source extraction and configuration at a core level, so understanding the need in depth is useful.
Thanks,
Jimmy -
We're trying to use Terraform to programmatically exclude database tables in Fivetran. It would be good to have the ability to specify specific tables to exclude, a selection of tables based on wildcards, and in some cases individual columns in a table (we have a table that may not update any data, however the date changes each week on 80 million rows - we need the sync any data changes but not interested in the date on this table so it's an unnecessary cost).
Please sign in to leave a comment.
Comments
2 comments