The 2nd feature of the Data Flow "SQL & Data Sharing" is based on the processing technology we use in the new data model - Snowflake. This technology allows us to give you access to your Piano Analytics data in two different ways and in real time:
SQL & Data Sharing Data Flow functioning
- Scenario 1 - you use Snowflake: We can give you access to Piano Analytics data directly from your own Snowflake account. The data related to your organisation is available in real time. This functionality is based on your own Snowflake Warehouses, so the cost of data consumption will be passed on to your Snowflake subscription (credit consumption).
- Scenario 2 - you do not use Snowflake: We can give you access to the Piano Analytics data available in our Snowflake, via any SQL client on the market (JDBC connection). This means that if you use the Piano Analytics Warehouses, we will invoice you for the data consumption (credit consumption).