"Schema Pattern" Data source template

Answered

Under Data Sources and Drivers-> Schemas

I'm trying to understand the Schema pattern and if it can be leveraged or not with Teradata JDBC connection.

I found this document

https://www.jetbrains.com/help/datagrip/configuring-database-connections.html#filter_databases_and_schemas

Nothing I try seems to work - I have databases with various names such as

DATAMART_SUBJECT_V

or APPNAME_CORE_V

Teradata doesn't really have schemas. It just has databases and objects in that database (tables, procedures, views, etc).

Is it possible to use the schema pattern to match on just databases? In my two examples, I'm trying to match every database that ends in "_V" but can't seem to do it.

2 comments
Comment actions Permalink

I can see where having the schema pattern support regex would be helpful.

0
Comment actions Permalink

SideOfRanch,

Yes, it's not possible right now. There is a feature request https://youtrack.jetbrains.com/issue/DBE-5781 you can up vote and track progress.

0

Please sign in to leave a comment.