Correct Database Pattern Configuration for Snowflake Ingestion Source

ingestion
1

Original Slack Thread

<@U06TM7M40RK> is database_pattern:
allow:
- /hello/ a correct database pattern in snowflake config to get only that db name?

2

In the context of configuring a Snowflake ingestion source in DataHub, the database_pattern is used to specify which databases should be included or excluded during ingestion. The pattern you provided, \/hello\/, is not a valid regex pattern for matching a database name in Snowflake.

According to the <https://datahubproject.io/docs/0.13.1/generated/ingestion/sources/snowflake#config-details|Snowflake ingestion configuration details>, the database_pattern uses regular expressions to filter databases. The correct way to specify a pattern to match a specific database name, such as “hello”, would be to use a regex pattern without slashes, like this:

database_pattern:
  allow:
    - "^hello$"

This pattern uses ^ to indicate the start of the string and $ to indicate the end of the string, ensuring that only the database named “hello” is matched exactly.

Would you like more detail on how to configure this pattern or any other aspect of Snowflake ingestion?

Sources:

3

Hi <@U05LX5J582Z>, how did my answer work out for you? Need any more assistance? You can also tag <@U07FV3UHE4D> to let your fellow community members know you’re still looking for guidance.

4

Hi :slight_smile: ! Did this interaction resolve your issue or do you still require assistance ?

Please tag @ RunLLM if you still need further assistance !

Or tag @Datahub Community Support if you require a person to take a look :slight_smile:

Hope this helps ! ><