Acho Studio is the data warehouse we build for you to access data automatically from different production systems. It has essentially 3 fundamental pieces to it:
Data source integration
Build projects with data resources
Share and publish projects
1. Data Source Integration
The first thing you would do on Acho Studio is to connect it to your database. We have built a connector that will help you verify database connections instantly. See this list of data sources that we currently support.
Applications (Salesforce, HubSpot, Shopify, Google Analytics, Google Sheets, etc.)
Each integration is connected to Acho Studio slightly. Check out our Data Connector for more info on pulling data into Acho.
2. Build projects with data resources
A project on Acho Studio is where you can access your data resource and build on top of it. Each project contains many "tabs". Similar to your browser, you may use these tabs to access your data feed. On each tab, you will find many "actions" on the toolkit bar. These actions such as filter, join, replace and etc are similar to a SQL query. When you apply one of these actions, we will send in a query and change your table according to the action and values that you have input. You may apply as many actions as you want, and reset/undo them in sequence. Also, don't worry about losing tables in the process. All tables will be saved every step along the way.
3. Share and publish projects
After you have finished building the table, you can either share it with a teammate or publish it to a site or application. To share the project, all you need is your teammate's email. After sending the invitation, she/he will be able to access your project with the privileges that you have granted.
Another way to export your data is through a downloader (CSV, Excel, Google Sheet, Tableau, Metabase, etc.). For free trials, there is a 1 GB limit for each download. The best way to utilize the downloader is to control the range of your data table through actions and only download the part you want.
To publish your data on an application or a site. We have a solution that is still under development.