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

MariaDB Connector

PreviousMySQL ConnectorNextPostgreSQL Connector

Last updated 9 months ago

Was this helpful?

Overview

The MariaDB connector in Graphite Note allows you to import your data from a MariaDB or run custom SQL queries directly within the platform.

Prerequisites

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

  • 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 MariaDB

  • Choose "MariaDB" 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. Establish a Connection

Fill in the following connection details:

  • Server Name: Enter the hostname or IP address of your MariaDB instance.

  • Database Port: Enter the port number for your database (typically 3306).

  • Database User: Provide the username for the database.

  • Database Password: Enter the password for the database user.

  • Database Name: Specify the name of the database you wish to connect to.

  • SSL (Secure Sockets Layer): SSL is a protocol for encrypting information over the internet. If your MariaDB instance requires SSL, ensure you enable this option.

5. Check the Connection

  • Click on "Check Connection" to validate the connection details.

6. Write and Run SQL

  • Write the desired SQL query to fetch your data.

  • Click on the "Run SQL" button to execute the query and retrieve the data.

7. Review and Adjust Data

  • You should see all the columns from the selected dataset appearing.

  • If necessary, you can change column names, data types, or data formats.

8. Create the Dataset

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

Troubleshooting Connection Issues

Ensure your firewall settings are configured to accept incoming requests from the IP address mentioned above. This is crucial for establishing a successful connection between Graphite Note and your MariaDB Server.

Import Process

Once the connection is validated:

  • Graphite Note will initiate the data import process.

  • The duration of this process depends on the size of your dataset. Small datasets will import in a few minutes, while larger datasets may take longer.

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
Select MariaDB as your dataset source
Name and Description for the dataset