Destinations and warehouse
Every account includes the Sfere Data Warehouse, powered by ClickHouse, with nothing to buy or provision
Sfere Data Warehouse#
The warehouse is where your customer activity lands. It is created when you connect your first website or store source, and its cost is covered by your Sfere account. It appears in Destinations like any other destination, ready for your pipes.
Open a destination#
Open Destinations and select one to see:
| Tab | What it shows |
|---|---|
| Overview | Status, the pipes delivering into it, and its details. |
| Pipes | Every inbound pipe and whether it is running. |
| Configuration | The connection settings. Credentials are stored by Sfere and always masked. |
| Tables | The tables your events are written to. |
| SQL console | Run queries against the warehouse from the dashboard. |
Select Test connection to check the stored configuration against the warehouse. It reads and writes nothing.
Query your events#
Every distinct property name you send becomes a column. Keep property names consistent across sources, for example always transaction_id, never a mix of orderId and order_id, so your queries stay simple.
Route events to a destination#
Events reach a destination through a pipe. One source can feed several destinations through several pipes.