Extracting Data from BigQuery

The bot uses a database to connect and export data from BigQuery. The user can read, insert, delete, and update the data of BigQuery as per requirement

Top Benefits

  • Steps are mentioned to make the BigQuery connection
  • Minimum and configurable input parameters and logic
Product video fallback

Tasks

  • Establish the connection with BigQuery
  • Perform operation like Read, Insert, Update and Delete operation
This bot will be used to establish the database connection with BigQuery using ODBC. We can execute read, insert, update, and delete operations and export the data per users' needs. All the prerequisites to make the connection with BigQuery are explained in the Readme file.

Setup process

Install

Download the Bot and follow the instructions to install it in your AAE Control Room.

Configure

Use the Bot in a bot, configure keys and other credentials the Bot will need (see the ReadMe for details.)

Run

That's it - now the Bot is ready to get going!

Requirements and Inputs

  • Enable the Big Query API on Google Cloud Console
  • Download and Install the Simba ODBC driver
  • Establish connection of ODBC driver with Big Query

Customer Reviews

0.0(0 reviews)

No reviews yet.