For modified analyses:
- If it modifies the output columns, updates the analysis version
- Has tests to validate the result is the expected one.
For new analysis use the following checklist:
- Uses
the_geom geometry(Geometry, 4326)column for all geospatial operations. - Outputs a
the_geom geometry(Geometry, 4326)column. - Outputs a
cartodb_id numericcolumn. - Uses
{cache: true}option when it needs full knowledge of the table it. Hints: aggregations, window functions. - Uses
{cache: true}if it access external services. - Naming uses a-z lowercase and hyphens.
- All mandatory params cannot be made optional.
- Avoids using CTEs for join operations when result is not cached.
- Has tests to validate the result is the expected one.