Connect to your database
Last updated
Was this helpful?
Last updated
Was this helpful?
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.
