Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Oracle Connector for Graphite Note will soon be available for public use. This connector will enable seamless integration with Oracle databases, enhancing data accessibility and supporting advanced analysis within the Graphite Note platform. Stay tuned for its release to unlock efficient Oracle data connectivity.
If you've collected additional data related to your previously uploaded CSV file or there have been changes to the existing data, you can use the re-upload option. This allows you to update or append new data to your existing dataset. Expanding your dataset with more records can benefit your machine learning model, but the impact depends on the quality and relevance of the new data. Learn more about the benefits of dataset expansion here.
Go to the Datasets List:
Navigate to the list of datasets.
Select the Dataset:
Choose the dataset you wish to re-upload.
Select Re-upload:
Click on the 'Re-upload' option.
Choose Options and upload:
Decide on data append:
Depending on your needs, you can choose 'Append data' to add new records to the existing dataset. If 'Append data' is turned off, the new dataset will overwrite the existing
Upload Your File:
Select or drag and drop your CSV file. Ensure the file has the same column structure as the previously uploaded file.
Click Update to complete the re-upload process.
Overview
The PostgreSQL connector in Graphite Note allows you to import your data from a PostgreSQL database or run custom SQL queries directly within the platform.
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 PostgreSQL
Choose "PostgreSQL" 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 PostgreSQL instance.
Database Port: Enter the port number for your database (typically 5432).
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 PostgreSQL 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 addresses mentioned above. This is crucial for establishing a successful connection between Graphite Note and your PostgreSQL database.
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 Models and follow the steps to build and deploy your model using Graphite Note's intuitive interface.
Overview
Graphite Note’s CSV integration allows you to import your data from CSV files. This guide will walk you through the steps to import your CSV data into Graphite Note.
Steps to Import Data
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."
Select CSV file
Choose "CSV" as your data source and click "Next".
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.
Choose Parsing Options
Configure your parsing options to properly interpret the CSV file.
Delimiter: Choose the character that separates values in your CSV (e.g., comma, semicolon).
Header: Indicate whether your CSV file has a header row.
Convert Empty Values to Null: Convert 'empty string' values to null. By default, this is turned on.
File Encoding: Select the file character encoding. The default is Unicode (UTF-8).
Skip Empty Rows: Skip empty rows at the beginning or end of the file. By default, Graphite Note will ignore those lines.
Click on "Parse file" to process the file.
Review parsed data
Review the parsed 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.
Graphite Note limits the file size for CSV uploads to 50 MB. This restriction ensures that the platform maintains optimal performance, prevents excessive resource consumption, and ensures fast processing times for data uploads. If users need to work with larger datasets, alternative methods such as connecting directly to a database (Postgres, MySQL, BigQuery) can be used.
Now that your data is imported and prepared, you can proceed to create a model without writing any code. Simply go to the Models and follow the steps to build and deploy your model using Graphite Note's intuitive interface.
Overview
The MySQL connector in Graphite Note allows you to import your data from a MySQL database 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 MySQL
Choose "MySQL" 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 MySQL 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 MySQL 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 MySQL database.
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 Models and follow the steps to build and deploy your model using Graphite Note's intuitive interface.
Overview
The MS SQL connector in Graphite Note allows you to import your data from a MS SQL 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 MS SQL
Choose "MS SQL" 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 MS SQL instance.
Database Port: Enter the port number for your database (typically 1433).
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 MS SQL 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 MS SQL 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 Models and follow the steps to build and deploy your model using Graphite Note's intuitive interface.
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 Models and follow the steps to build and deploy your model using Graphite Note's intuitive interface.
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.
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.
To enable Graphite Note to access your BigQuery data, you'll need to provide a service account key in JSON format:
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.
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.
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.
Access the Dataset Creation Page:
Return to the Graphite Note platform where you left off at the "Create a New Dataset" step.
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.
Check Connection:
After uploading the JSON key, click Check Connection to ensure that Graphite Note can successfully connect to your BigQuery instance.
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.
Overview
The Redshift connector in Graphite Note allows you to import your data from a Redshift database or run custom SQL queries directly within the platform.
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 Redshift
Choose "Redshift" 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 Redshift instance.
Database Port: Enter the port number for your database (typically 5432).
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 Redshift 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 addresses mentioned above. This is crucial for establishing a successful connection between Graphite Note and your Redshift data warehouse.
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.
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.
