https://datahubproject.io logo
Join Slack
Powered by
hello, i am completely new to DataHub. I am trying...
# ingestion
c
hello, i am completely new to DataHub. I am trying to run that mssql ingestion etl, with 
URL = '<mssql+pytds://user>:password@sqlhost/database:1433'
, but getting error below. Is my mssql URL in bad format? Any help is appreciated.
Copy code
sqlalchemy.exc.ArgumentError: Could not parse rfc1738 URL from string ''
e
Could you try 
<mysql+pymysql://username>:password@hostname:port
as suggested here? https://github.com/linkedin/datahub/blob/master/metadata-ingestion/sql-etl/mysql_etl.py
c
thanks. but I am trying to ingest from MS SQL server tho, not mysql
e
oops my bad 🙂 last time I tested this script against a MS SQL server running in docker it worked: https://github.com/linkedin/datahub/blob/master/metadata-ingestion/sql-etl/mssql_etl.py
c
yes, installed common.txt and mssql_etl.txt
seems like it complains about url, but not sure where my url is wrong. also tried below without database, same err, 😞
Copy code
URL = '<mssql+pytds://user:password@sqlhost:1433>'
l
In your original question you had the URL as 
<mssql+pytds://user>:password@sqlhost/database:1433'
can you try putting the port number after the sql host?
i.e mssql+pytds://user:password@sqlhost:1433/database'
c
yeah, i did. but same err
well, let me try again
thanks. now I am getting a diff error
Copy code
No such file or directory: '../../metadata-events/mxe-schemas/src/renamed/avro/com/linkedin/mxe/MetadataChangeEvent.avsc'
b
@curved-magazine-23582 have you run a build of the project?
Copy code
./gradlew build
In in this case you may just need to do:
Copy code
./gradlew metadata-events:build
from the root project directory
c
i have not. thanks for the pointer.
b
apologies Ming, this command
Copy code
./gradlew metadata-events:mxe-schemas:build
c
gotcha, thanks
e
➕ 1
👍 1
c
this is working, thanks all for the help!
👍 1
🙌 1
Open in Slack
PreviousNext
Powered by