Data Transformation and Harmonization

You can use our platform’s SQL editor section to clean data or make changes in the datasets using SQL queries.

For security, external users can only query the sandbox or google sheets database.

For example, you can replace the values in a column of the dataset using the code below:

UPDATE 
    table_name
SET
    column_name = REPLACE(column_name, old_value,new_value)
WHERE
    column_name = old_value;