Hi, Do the upstream and downstream datasets need to be specified manually, or will it take automatically when we connect and load the database schema to datahub?

Hi - this really depends on the data source, you can check the data sources that supports automatic lineage extraction here ; https://datahubproject.io/docs/next/generated/lineage/lineage-feature-guide#lineage-support