If you are using SQL for your database, you can connect to it and write your own SQL.
To connect to your database:
Go to Create New on Datasets, or New Dataset when you are in the datasets list
Chose MySQL/MariaDB or PostgreSQL
If you want, you can name the dataset, write down a short description of the data and add a tag
Establish a connection
Enter your server hostname/IP address, database port, database user, database password, and database name
Select Check Connection
Ensure that your firewall accepts incoming requests from the following two IP addresses: 99.81.63.220 and 68.183.64.54
Write the desired SQL and click on the Run SQL button to get your data
You should see all the columns from the selected dataset appearing. If necessary, you can change column names, data types, or data formats
Click on the Create button to create your dataset
It's much easier to get data from databases using SQL - you can adjust the dataset to your needs! By repeating the above steps, you can easily get your data and start running various models without writing down any line of code.
First things first, you have to upload you CSV file(s) into Graphite.
To upload a CSV file:
Go to Create New on Datasets, or New Dataset when you are in the datasets list
Select the CSV file
Select or drop your CSV file
If you want, you can name the dataset, write down a short description of the data and add a tag
Choose your parsing options
Select Parse file (you can rename or change the data type of your columns)
Select Create
If you have you collected more data related to your uploaded CSV or there has been a change in the data you have uploaded you can use the re-uploading option.
To understand, if you have a new file with new data, you can re-upload to append it to the previous dataset. Just keep in mind that the file you select must have the same column structure as the previously uploaded file.
To re-upload a CSV file :
Go to Datasets list
Select the dataset you want to re-upload
Select Re-upload
Depending on your needs, you can select Append data
Select or drop your CSV file
Select Update
For example, it can be useful for monthly data. If every month you are getting new data in a CSV file and you need to merge the data for all the months into one CSV file. Instead of repeating the copy and paste commands, you can use the re-upload option on every month, which is easier and faster.