Getting Started with Quills.ai

Establishing Database Connection with Quills.ai

Google BigQuery Service Account

In order to connect to Google BigQuery and chat with it, you must first create a Service Account. Follow these steps:
  1. Go to the Google Cloud Console:

    Click on the project drop-down and select "New Project."  Follow the prompts to create a new project and give it a name.

  2. Enable the BigQuery API: Make sure the BigQuery API is enabled for your project. You can enable it in the Google Cloud Console under "APIs & Services" > "Library."


  3. Create a Service Account: In the Google Cloud Console, go to "APIs & Services" > "Credentials."
    Click "Create credentials" and choose "Service Account".

    Fill in the necessary information, such as the name and roles. 
    Under "Role," assign the following roles: "BigQuery User," "BigQuery Viewer," and "BigQuery  
    Job User." Choose "JSON" as the key type and click "Create" to create the service account.

  4. Download JSON Key File:
    After creating the service account, a JSON key file will be generated. Download this JSON key file to your computer. This file contains the credentials needed to authenticate with BigQuery.

  5. Find the Dataset Name:
    To find the dataset name, you need to navigate to the BigQuery section in the Google Cloud Console.
    Here's how

    1. Go to the Google Cloud Console.

    2. In the left navigation pane, click on "BigQuery" to access BigQuery.

    3. In the BigQuery console, you will see a list of your datasets under your project. The dataset name will be listed there

Once you have all these ready, come on to the Quills.ai website and log in with your credentials. Click on Add Sources and select Connect Database.

After that, from the drop down menu, select BigQuery, and fill in the details. Test the connection and save it.

Once you saved the connection, you can start chatting and generating SQL queries! You can even bookmark important questions, create charts, look at the grid, connect to the integrations and much more!



    • Related Articles

    • About Quills

      What is Quills.ai? Quills.ai is an AI-powered data assistant designed to transform the way we interact with data. It enables users to access, analyze, and visualize information from various sources like databases, CSV files, and Excel sheets through ...

    • MariaDB

      To connect to MariaDB on Quills and start chatting, you need a few credentials. Firstly, connect to the database using MYSQL command-line. After that, enter this command for the connection details: SELECT CURRENT_USER(), CURRENT_CONNECTION(); This ...

    • MYSQL

      To connect to MYSQL Database and start chatting, you need a few credentials. Connect to your database on MYSQL Workbench, and click on Databases, then select Manage Connections. You can now see all the required credentials – username, password, ...

    • Collections

      Quills.ai Collections are a place where data collaboration is enhanced beyond recognition. Organizing, collaborating, and deriving insights from your datasets is made easier with this functionality. Quills.ai Collections creates a centralized area ...