Max Exclude Length Catalog Ingestion

Does anyone know what the maximum character length for excluding tables using the Catalog ingestion? I tried finding this in the documentation, but couldn’t find it.

We are using bring your own driver. And using Cloudera Hive, MS SQL Server and Oracle. I’m assuming the exclude field is the same length for all.

Former User

Posted 5 years ago · Edited 1 year ago·Last reply 5 years ago

3 comments

arvindsingh

·5 years ago · Edited

For SQL Server, you have to mention schema name and that will exclude system tables which lives under sys schema or you can exclude table based on their naming patterns.

Former User

OP5 years ago · Edited

I created a ticket and was told: “The max length for Table Exclusion is 400 (character varying)”. This doesn’t seem to be enough to even exclude system tables. Has anyone else had issue with this and what are you doing if you aren’t ingesting via the OOTB connectors? What are the plans give more options to these OOTB connectors?

arvindsingh

·5 years ago · Edited

I had the same question and didn’t find anything related to this in any documentation. Best case will be to reach out to support.

In one of our connection, we are excluding close to 50 different patterns and can add more. It seems like exclude field length is same for all.