Although the volumes handled by Footprint are enormous and require a very sophisticated technical solution to ensure sufficient performance in processing queries, Footprint has a relational database under the hood. Data retrieval from the relational database is done via SQL. Thus, the process of forming a data query is as follows:

  • Query is created in UI
  • Query translated to SQL
  • SQL query is executed on database
    Footprint is a easy-to-use analytics tool that the user can work with without knowledge of SQL, programming languages and other technical aspects - see No code. Nevertheless, if you prefer to keep everything as code; want to create more complex queries; want to run query optimisations or for any other reason you may skip the point 1 in the list above and create a SQL query straight away - see SQL.