Hello How can we replace the env key with a value...
# ingestion
r
Hello How can we replace the env key with a value other than Prod https://github.com/linkedin/datahub/blob/master/metadata-ingestion/src/datahub/ingestion/source/sql_common.py#L51 I have tried setting it in the config section of the sqlalchemy recipe but i get error: Invalid URN Parameter: no enum constant
g
The fabrictype env is an enum, which is defined in https://github.com/linkedin/datahub/blob/master/li-utils/src/main/pegasus/com/linkedin/common/FabricType.pdl, so try to use one of “DEV”, “EI”, “PROD”, or “CORP”
r
Thanks for the reply 🙂 can you please guide me on one more Thing: Can we use the file source to read the metadata from a xlsx file This xlsx file contains metadata exported from an oracle database We can't connect directly to the database due to restrictions as DBA privilege can not be granted to all users.
g
If you want to ingest from an xlsx file, you’ll need to write a custom source
The file source is for ingesting from our metadata json files, which can also be produced by the file sink
I would recommend adding a db user with broad permissions for the ingestion source