Do we need a separate license for Anaplan Cloudworks or is it part of our existing package? Also can we use cloudworks to directly integrate with Big query?
No, you don't have to pay extra if your organization has Professional or Enterprise edition license. Big query Indeed is supported by Anaplan CloudWorks. Read more here