Datameer Administrators can manage Snowflake configuration custom properties on the 'Snowflake Settings' page.
Custom Properties List#
Note: The following applies for data sampling related properties: To achieve best performance, Datameer uses fraction-based SYSTEM | BLOCK sampling without a seed. For further information please refer to here.
|Property Name||Default Value||Description|
|snowflake.data-preview.minimum-probability-in-percent||0.001||Minimum percentage of records sampled from snowflake tables relative to the total record count. Serves as guardrail for tables with a huge amount of records where the total sample size would lead to numeric rounding errors.|
|snowflake.data-preview.sample-size||100000||Approximate number of values sampled from snowflake tables for the preview in the workbench.|
|snowflake.data-preview.sampling-threshold||1000000||Minimum number of table records to trigger the usage of sampling. For snowflake tables with less records full data is used for the preview in the workbench.|
|snowflake.query-timeout||30s||Amount of time (seconds) after which a running snowflake query is cancelled by the system.|
Adding a Custom Property#
Datameer Administrators can access the Custom Properties field where they can add, edit, and delete the custom properties that are configurable for the connection between Datameer and Snowflake.
To add a custom property:
Click on the "Settings" button to access the Admin section and switch to the "Snowflake Settings" page and click on "Snowflake Connection Properties". The configuration field opens.
Enter the required custom property, e.g. 'snowflake.data-preview.sample-size=1000' and confirm with "Apply". Adding a custom property is finished.