Hello Sourcers! Back again with new product feature updates:
1. Google Drive Integration
Using the Google Drive integration you can access any CSV, TSV or JSON that you have in your Google Drive folder in Sourcetable. Even large datasets that cannot be manipulated in Excel or Google Sheets can be analyzed with Sourcetable.
If your files exceed one million rows in length, we recommend using the sidebar to aggregate, filter or pivot your data into a manageable size (Sourcetable currently has a 1 million row max-length per tab). Using this technique, you can analyze files that are hundreds of megabytes in size, or billions or rows in length.
Keen to do a spreadsheet comparison? Try using this (450mb) COVID-19 data set inside Google Sheets, Excel and Sourcetable, and see which product you prefer 😀.
2. Row Count
Want to experiment with your data table selections faster? Now you can see the total number of rows when you select the columns on your data tables. Allowing you to do more complex analysis with less formulas and less work. Just take a peek at the bottom right of the sidebar under the update button and you will see the row count for you current selections.
If you are exploring large data sets, we recommend limiting your default row count (e.g. to 500 rows) while in exploration mode to speed up queries. Once you have the data in an acceptable format you can expand the row count back up the the default row limit of 1 million rows.
3. Google Ads Update
Google Adwords has been replaced by Google Ads. The connections are under integrations and, like always, you will only need your Google account number and login details to sync your data to Sourcetable.
4. SQL MetaData
For those of you who are familiar with SQL you can now see the background SQL query for your data tables. This will allow you to recreate the query if necessary or see if there are any changes that need to be made. Auditing or recreating a join will be much easier since you can now see how the join was made.
For the product nerds: yes, this also means you can use Sourcetable as a tool for ETL prototyping and ETL QA.
🙏 Thanks again and please keep the feedback coming. We love to hear what you need and want to use.
- Pivot Tables
The future of spreadsheets is spreadsheets!