Also wanted to check if elementary package can be used in dbt cloud, without any hassle as we dont have dedicated cli to work with

Hey @Rashmi Auradkar! Absolutely. Read here for more information on our integration with dbt Cloud.