my recipe is like source: type: mssql config: ...
# ingestion
a
my recipe is like source: type: mssql config: host_port: "localhost:16000" database: demo_db username: datahub password: datahub sink: type: "datahub-rest" config: server: "http://127.0.0.1:18080"
c
I had this issue at one point and it was because I had a $ in the password. To get it to read it literally, I escaped it by using a \in front of it.
💯 1
b
Thanks! just had the same issue 🙂
a
hi @clever-ocean-10572 @brave-market-65632 I am having same issue . I tried your suggestion but still facing some issues
can you please help ?
below is my recipe
source: type: redshift config: # Coordinates host_port: atlas.ctbsm6jecdy0.us-west-2.redshift.amazonaws.com:5439 database: atlas database_alias: atlas # Credentials username: datahub password: ${XXXXX_XXXXX} include_views: True # whether to include views, defaults to True include_tables: True # whether to include views, defaults to True schema_pattern: allow: ['rawdata'] sink: type: "datahub-rest" config: server: "https://datahub-gms.amer-prod.xxxx.com:8080"
b
Here are few things that helped me overcome this. 1. I let the recipe running for a long time after the timeout. I could see further output about it trying to build dependencies. After some false starts, it eventually did complete. 2. I ran the ingestion twice - first with lineage = False and then re-ran with lineage = True. 3. Maxed out the CPU and memory for my docker settings. Not sure if this helped but the ingestion did complete. The whole process took about 2-3 hours though.