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 work - Data 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