This section provides information about data warehouse pricing in Base. Prices below are shown in BIC/hr for each of the virtual warehouse sizes. Prices vary for each region.
Actual cost depends on usage duration, runtime intervals, and requested resources. For example, when using Snowflake, two warehouses are created. One for query handling and the other for data handling to prevent large data uploads from interfering with queries. Starting a warehouse typically takes only a few seconds, although it may take longer while Snowflake provisions compute resources. To reduce latency, Snowflake keeps a warehouse running for a configurable interval so subsequent actions do not need to wait for a warehouse to start. In BioInsight Platform Core, this interval set to 5 minutes. After a query or data action completes, the warehouse is kept running for and additional 5 minutes. For this reason, it is most economical to perform related actions within a short time interval rather than allowing more than 5 minutes between actions. In addition, Snowflake applies a one-minute minimum charge. For more information, see the Snowflake documentation.
In the example below, you can see which charges are incurred. Query 1 and 2 can both be completed within the same running warehouse. For Query 3, a new warehouse must be spun up. The total cost in this example is running a warehouse for Queries 1 and 2 (10s + 120s idle + 90s + 5 min idle) and a separate warehouse for Query 3 (1 min + 5 min idle). This illustrates why it is more economical to run queries within the same time interval. In that case, you would incur only the query runtime plus 5 minutes of keeping the warehouse runtime after the final query. Additionally, load warehouses can run in parallel following the same principle.
Prices in the table are shown in BIC per hour. Tables in Base also incur a storage cost of 23 BIC/TB/month.
| Region |
XS |
S |
M |
L |
XL |
2XL |
3XL |
4XL |
|---|
| US (use1) |
3.94 |
7.87 |
15.74 |
31.49 |
62.98 |
125.95 |
251.90 |
503.81 |
| Japan (apn1) |
5.60 |
11.21 |
22.42 |
44.83 |
89.66 |
179.33 |
358.66 |
717.31 |
| South Korea (apn2) |
5.41 |
10.82 |
21.65 |
43.30 |
86.59 |
173.18 |
346.37 |
692.74 |
| Singapore (aps1) |
4.92 |
9.84 |
19.68 |
39.36 |
78.72 |
157.44 |
314.88 |
629.76 |
| Australia (aps2) |
5.41 |
10.82 |
21.65 |
43.30 |
86.59 |
173.18 |
346.37 |
692.74 |
| India (aps3) |
5.41 |
10.82 |
21.65 |
43.30 |
86.59 |
173.18 |
346.37 |
692.74 |
| Europe (euc1) |
5.11 |
10.22 |
20.45 |
40.90 |
81.79 |
163.58 |
327.17 |
654.34 |
| Canada (cac1) |
4.43 |
8.86 |
17.71 |
35.42 |
70.85 |
141.70 |
283.39 |
566.78 |
| UK (euw2) |
5.32 |
10.63 |
21.26 |
42.53 |
85.06 |
170.11 |
340.22 |
680.45 |