#AAIllustrates: Integrating with Google BigQuery with Micah Smith

Google BigQuery is a serverless data warehouse for data analysis and insights – Automation 360 is a Cloud RPA platform for automating repetitive, manual tasks. In this episode, we take a deep dive into some of the new capabilities of the Automation Anywhere .21 release specifically focusing on the expanded ODBC capabilities of the Database package to see how Automation 360 and Google BigQuery come together. Developer Evangelist Micah Smith takes everyone through a brief explanation of Google’s BigQuery data warehouse, followed by a BigQuery setup/explanation. With a new dataset established on GCP, we then look at how we can build a bot that’s able to write to Google BigQuery as well as execute SQL queries to read data from the same data repository. Even if you’ve never used Google BigQuery before, this is a practical intro with hands on integration in Automation Anywhere.

Reference Links:
Enable the BigQuery API: https://cloud.google.com/bigquery/docs/quickstarts/quickstart-web-ui?authuser=1
Download the Sample Dataset: http://eforexcel.com/wp/downloads-18-sample-csv-files-data-sets-for-testing-sales/
Download and Install the Simba ODBC driver: https://cloud.google.com/bigquery/docs/reference/odbc-jdbc-drivers

Subscribe to Automation Anywhere for more great RPA (robotic process automation) tutorials, advice on getting started with RPA, product insights, and more.
Visit our site: http://www.automationanywhere.com
Subscribe on YouTube: http://www.youtube.com/c/automationanywhere
LinkedIn: https://www.linkedin.com/company/automation-anywhere/
Our blog: https://www.automationanywhere.com/blog
Facebook: https://www.facebook.com/automationanywhereSoftware
Twitter: https://twitter.com/automationanywh

#AAIllustrates #BigQuery #RPA #AutomationAnywhere

Видео #AAIllustrates: Integrating with Google BigQuery with Micah Smith канала Automation Anywhere