Is it possible to change the database name show in...
# troubleshoot
s
Is it possible to change the database name show in datahub, maybe with a custom transform? (For Redshift) The problem we have is that we just used the default database name "dev", but now that we want to expose the data in datahub, this can be confusing for end users. The dev database name is also protected from just being renamed unfortunately. For Oracle there is no database concept, it just shows the schemas, and that would be nice in our case for Redshift.
Alternativeley, would it be possible to move all metadata added to the "dev" urn, to the "dwh" urn at a later time without much work with some commands/code?
d
There is a
database_alias
at the Redshfit source which most probably is what you need: https://datahubproject.io/docs/metadata-ingestion/source_docs/redshift/
s
Oh wow! Thanks alot! To simple to even look for it there 😯
m
You could also use the
platform_instance
directive to apply the
dwh
name to that specific redshift instance.
That will make the urn look like
urn:li:dataset(urn:li:dataPlatform:redshift,dwh.dev.schema_name.table_name)
And on a search
dwh
will show up as a facet under
instance