I am using atlas for lineage and data governance and all integrations with hive,spark and sqoop are up and running. But I want to know if there is a way to automate the process of adding all the missing tables to atlas at the end of every day in order to make sure that no data is missing.
I wrote a script that gets the list of all tables from hive metastore and got the list of missing table from atlas by hitting its api.
The plan was to call "import-hive.sh"(Inbuilt hive bridge of atlas) over the missing tables but the script gets stuck at an intermediate phase asking for input of username and password.so i am unable to automate it.
I even tried things like these and nothing worked.
printf "admin\nadmin" | sh import-hive.sh --database dummydb --table final
can someone help me with this?