Building a solar production datalake in autonomous database with native JSON and REST enabled support | Part one

The idea here is to create an open community to share solar production data for machine learning research purposes that will be used later to help in automation of solar production facilities.

The architecture of the solution is pretty simple, an autonomous database with a raw table to store JSON data and REST enabled to allow data ingestion easily.

In coming posts we’ll add a couple more components to the picture in order to api-enable the solution, but for the moment let’s keep it simple.

STEP 1: CREATE DATABASE

You can create the database in less than 5 minutes, just google for how to do it

STEP 2: CREATE RAW TABLE

Open database actions web tool and execute:

create table rawsolardata (id number primary key,  jdoc JSON);

STEP 3: REST ENABLE THE TABLE

STEP4: TEST

curl --location --request POST \
'https://g41b847d6ef1298-db202109081829.adb.eu-frankfurt-1.oraclecloudapps.com/ords/admin/rawsolardata/' \
--header 'Content-Type: application/json' \
--data-binary '{
  "id": "3",
  "jdoc": "{\"d\":\"2012-04-23T18:25:43.511UTC\",\"pv\": 300,\"m\": -500}",
  "sys_ime_oson_9ff246e3ae1e4f05bf27dc09ca615308": "3"
}'

To be continued