Enable Holistics Canal
The first version of Holistics Canal has been completed and will be released very soon!
If you are interested, please fill in this form and we will try to notify you with our new updates and Beta release! P.S. Make sure to mention the Database type that you would like Canal to support next. 😉
To learn about Holistics Canal, please head to this doc.
Supported Databases
Feature | PostgreSQL | Redshift | BigQuery | Snowflake | |
---|---|---|---|---|---|
Supported | ✅ Yes PostgreSQL >= 12 (not end-of-life) | ✅ Yes | ✅ Yes | ✅ Yes | |
Connection Pooling | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | |
Parallel Download | ❌ No | ❌ No | ❌ No | ✅ Yes |
Sub-features
Connection Pooling
When a "canal" (or connection) has been constructed between Holistics and your Data Warehouse, Holistics will try to re-use that same connection for multiple queries. Learn more
Parallel Download
Some databases provide a mechanism to download the result of a single query in multiple parts in parallel.
Note that this feature typically only makes a difference when your resultset has more than 5,000 rows.
Notes
Please make sure to read through these notes before enabling Holistics Canal.
Data Type Handling
Goals
The Goals of Canal Data Type Handling are:
- Precise: Data precision should be preserved as much as possible.
- Consumable: The data must be adequately readable by end-users and processible by Holistics post-processing.
- Efficient: The data must be stored and processed in efficient data structures so that they are fast to retrieve and process.
With the above goals in mind, below are some special data type handlings in Canal:
Number precision
- Floats: Canal supports upto 64-bit floating-point numbers.
- Decimals: For the "decimal" or "numeric" data types that have a fixed/arbitrary precision (non-floating precision), Canal supports upto decimal(38, 9).
- For PostgreSQL and Redshift:
- This means that a decimal number can only have upto 38 digits, including 29 whole digits and 9 fractional digits.
- Numbers that have more than 29 whole digits will raise an error in Canal.
- Numbers that have more than 9 fractional digits will be rounded to 9 fractional digits.
- This means that a decimal number can only have upto 38 digits, including 29 whole digits and 9 fractional digits.
- For BigQuery:
BIGDECIMAL
andBIGNUMERIC
data are cached are post-processed astext
, meaning they can still be computed on your Data Warehouse and displayed to end-users, but Holistics won't be able to apply visual-level calculations to them.
- Workarounds for decimals that are larger than
decimal(38, 9)
:- Truncate/round to make them smaller: For example, instead of processing in meters, convert your data into kilometers. Canal only operates on the result of your data, so you can still perform big computations first, then convert the result to smaller numbers later before returning the query result.
- Convert into
text
-> cannot apply numeric calculations but can still display them. - Convert into
double
(i.e. 64-bit float) -> lose some precision but can still display and apply numeric calculations.
- For PostgreSQL and Redshift:
Time precision
Holistics only process Time and Timestamp/Datetime values in upto microsecond precision. Values that have higher precisions will be rounded to microsecond precision.
We believe that microsecond precision is adequately precise and efficient for most analytical use cases. But please let us know if it does not suit your needs.
Database-specific Notes
PostgreSQL and Redshift
- Holistics Canal might still work with PostgreSQL < 12, but it is not guaranteed because PostgreSQL versions below 12 are end-of-life (ref).
- See Number precision above.
BigQuery
- When using Holistics Canal, your BigQuery queries on Holistics will always use GoogleSQL (formerly known as StandardSQL) instead of BigQuery's legacy syntax.
- See Number precision above.
Unsupported Databases:
- If you are using another database that is supported by Holistics but has not been supported by Holistics Canal, please let us know via this form.
How to enable Holistics Canal
First, please register via this form and we will enable Holistics Canal in your workspace when it is released.
Then, in your Data Source settings, open Advanced Holistics Settings, check Enable Holistics Canal (and then Save it):
Holistics Canal will be enabled by default in the future when it is stable.