...
UltraCart utilizes Google Cloud IAM to limit access to the BigQuery project to only those users on the account that have been granted access to it. UltraCart also utilizes BigQuery column level security to restrict access to certain columns within various tables to specific levels of users. Whenever data is restricted, a SHA-256 hash of the value will be available in another column to be used in queries instead of the underlying PII data. Having this fine grained data access allows a business owner to provide limited access to the valuable corporate data without exposing customer lists, etc. We encourage owners to only grant the lowest level of access possible to achieve the necessary business result.
Data Sets & Streaming
Data warehouses rarely want to see data deleted, BigQuery is no exception, so a traditional strategy of inserts/deletes is not applicable with BigQuery. UltraCart streams the changes into BigQuery tables located in the ultracart_dw_streaming data set. Streaming allows for changes to appear within the data warehouse typically within less than 2 minutes.
| Note |
|---|
Merchant’s should never attempt to query against the tables in the streaming data set. Streaming data sets contain one row per mutation of the object and will lead to unexpected results. |
The other data sets are actually views that turn the streaming tables into a consistent snapshot of the data and also remove columns that are inaccessible due to data security at the column level.
Data Set | Description | Security Level |
|---|---|---|
ultracart_dw | All the tables without any sensitive information. | Level 1 - Standard Access |
ultracart_dw_low | Affiliate information except tax id and software activation codes | Level 2 - Low |
ultracart_dw_medium | PII information for customers | Level 3 - Medium |
ultracart_dw_high | Tax IDs for affiliates and wholesale customers | Level 4 - High |
For merchant using linked account, the parent account will also have a second set of data sets. These are the same security levels, but include information from ALL the linked accounts to make consolidated reporting possible.
Data Set | Description | Security Level |
|---|---|---|
ultracart_dw_linked | All the tables without any sensitive information. | Level 1 - Standard Access |
ultracart_dw_linked_low | Affiliate information except tax id and software activation codes | Level 2 - Low |
ultracart_dw_linked_medium | PII information for customers | Level 3 - Medium |
ultracart_dw_linked_high | Tax IDs for affiliates and wholesale customers | Level 4 - High |
Custom Reports
If your business does not have the technical knowledge to work with SQL or report builder tools, UltraCart Professional Services is available to write custom reports and publish them into your UltraCart account. Please contact support@ultracart.com with your report inquiries.
...