How do I use Piano Analytics data in external tools?
There are one API and export options that can be used to exploit our data in external tools:
The Reporting API, which allows you to extract advanced data sets, and is available through Data Query.
This API has some limitations which are indicated here: How does it workData Query exports, which allow, depending on the options, to export from 10 000 rows to all the rows of a query.
Data Flow (optional on the contract), allowing to extract large quantities of granular data to exploit them in a Data Lake for example, with data from other sources. These exports can be configured in the Data Flow interface.
Or the Data Sharing (optional on the contract), allowing you to query your Piano database directly in SQL. This option also allows many connections with tools through Snowflake: 3rd party connectors