LogoLogo
Log InSign UpHomepage
  • 👋Welcome
  • Account and Team Setup
    • Sign up
    • Subscription Plans
    • Profile information
    • Account information
    • Roles
    • Users
    • Tags
  • FAQ
  • UNDERSTANDING MACHINE LEARNING
    • What is Graphite Note
      • Graphite Note Insights Lifecycle
    • Introduction to Machine Learning
      • What is Machine Learning
      • Data Analitycs Maturity
    • Machine Learning concepts
      • Key Drivers
      • Confusion Matrix
      • Supervised vs Unsupervised ML
  • Demo datasets
    • Demo Datasets
      • Ads
      • Churn
      • CO2 Emission
      • Diamonds
      • eCommerce Orders
      • Housing Prices
      • Lead Scoring
      • Mall Customers
      • Marketing Mix
      • Car Sales
      • Store Item Demand
      • Upsell
    • What Dataset do I need for my use case?
      • Predict Cross Selling: Dataset
      • Predict Customer Churn: Dataset
      • Predictive Lead Scoring: Dataset
      • Predict Revenue : Dataset
      • Product Demand Forecast: Dataset
      • Predictive Ads Performance: Dataset
      • Media Mix Modeling (MMM): Dataset
      • Customer Lifetime Value Prediction : Dataset
      • RFM Customer Segmentation : Dataset
    • Dataset examples - from online sources
      • Free datasets for Machine Learning
  • Datasets
    • Introduction
    • Prepare your Data
      • Data Labeling
      • Expanding datasets
      • Merging datasets
      • CSV File creating and formatting
    • Data sources in Graphite Note
      • Import data from CSV file
        • Re-upload or append CSV
        • CSV upload troubleshooting tips
      • MySQL Connector
      • MariaDB Connector
      • PostgreSQL Connector
      • Redshift Connector
      • Big Query Connector
      • MS SQL Connector
      • Oracle Connector
  • Models
    • Introduction
    • Preprocessing Data
    • Machine Learning Models
      • Timeseries Forecast
      • Binary Classification
      • Multiclass Classification
      • Regression
      • General Segmentation
      • RFM Customer Segmentation
      • Customer Lifetime Value
      • Customer Cohort Analysis
      • ABC Pareto Analysis
      • New vs Returning Customers
    • Predict with ML Models
    • Overview and Model Health Check
    • Advanced parameters in ML Models
    • Actionable insights in ML Models
    • Improve your ML Models
  • Notebooks
    • What is Notebook?
    • My first Notebook
    • Data Visualization
  • REST API
    • API Introduction
    • Dataset API
      • Create
      • Fill
      • Complete
    • Prediction API
      • Quickstart
      • Request
        • Headers
        • Payload
        • Data
      • Response
        • Response Structure
      • API Limits
    • Model Results API
      • Quickstart
      • Request
        • Headers
        • Body
      • Response
      • Usage Notes
      • Code Examples
Powered by GitBook
On this page

Was this helpful?

Export as PDF
  1. Datasets
  2. Data sources in Graphite Note

Big Query Connector

PreviousRedshift ConnectorNextMS SQL Connector

Last updated 9 months ago

Was this helpful?

Overview

The Big Query connector in Graphite Note allows you to import your data from a BigQuery data warehouse.

Prerequisites

Before starting, ensure your firewall allows incoming requests from the following IP addresses:

  • 99.81.63.220

Steps to Import Data

1. Create a New Dataset

  • Option 1: Go to the homepage and click on "Create" under Datasets.

  • Option 2: From the datasets list, click on "New Dataset."

2. Select Big Query

  • Choose "Big Query" as your dataset source and click "Next".

3. Enter Dataset Information

  • Name: Provide a name for the dataset.

  • Description: Add a short description of the data.

  • Tags: Add tags for better organization.

  • Click "Next" to proceed.

4. Configure Big Query Connection

  • Project ID: Enter your Google Cloud project ID.

  • Dataset ID: Enter the Big Query dataset ID.

  • Table ID: Enter the table ID if you want to import data from a specific table.

5. Download JSON Key from BigQuery

To enable Graphite Note to access your BigQuery data, you'll need to provide a service account key in JSON format:

  1. Create a Service Account:

    • Navigate to the Google Cloud Console.

    • Select your project or create a new one.

    • Go to IAM & Admin > Service Accounts.

    • Click on + CREATE SERVICE ACCOUNT.

    • Provide a name and description for the service account, then click CREATE.

  2. Grant Permissions:

    • Assign the necessary roles, such as BigQuery Data Viewer and BigQuery Job User. These roles allow the service account to view datasets and execute queries.

  3. Create Key:

    • In the service account list, click on the created service account.

    • Go to the Keys tab and click ADD KEY > Create new key.

    • Select JSON as the key type and click Create. This will download the JSON key file to your computer.

6. Upload JSON Key to Graphite Note

  1. Access the Dataset Creation Page:

    • Return to the Graphite Note platform where you left off at the "Create a New Dataset" step.

  2. Upload JSON Key:

    • You will be prompted to upload the JSON key file. Click on Upload JSON Key and select the file you downloaded from the Google Cloud Console.

  3. Check Connection:

    • After uploading the JSON key, click Check Connection to ensure that Graphite Note can successfully connect to your BigQuery instance.

7. Review data

Review the data and make any necessary adjustments:

  • Rename Columns: Change column names if needed.

  • Change Data Types: Adjust the data types of your columns as required.

  • Click on the "Create" button to finalize and create your dataset.

Next Steps

Now that your data is imported and prepared, you can proceed to create a model without writing any code. Simply go to the and follow the steps to build and deploy your model using Graphite Note's intuitive interface.

Models
Option 1: Create Dataset using homepage
Option 2: Create Dataset from the Dataset List page