We give utmost priority to the security of your data and ensure that the Snowflake Data Warehouse integration keeps all your data safe from unauthorized access and a variety of other security threats. With the combined security of Salesforce and Snowflake, you can provide governed access to authorized users according to your specific requirements.
At rest and in transit, the platform has a provision for automatic data encryption to maintain the security of your valuable data sets. Features of dynamic data masking and tokenization further ensure the safety of your data.
Improved SQL Analytics
Snowflake Data Warehouse integration helps you avoid service interruptions by providing you with resources for every user in your team and their workload through improved SQL analytics.
The automated platform helps you compute clusters ranging from the extra-small size to 6XL for matching the required demand. It offers you a provision for multi-cluster computing resources for suitable concurrency. Moreover, you get access to charts and SQL analytics via Snowsight – the visualization user interface for Snowflake Data Warehouse.
All our services are aimed at providing you with a seamless cross-cloud experience by integrating two powerful platforms for automating data maintenance and administration.
Get complete automation in data query caching, parsing, planning, and optimization according to your business needs. Receive automated updates on a periodic basis without any scheduled downtime.
Direct Access To Data Cloud
The Snowflake Data Warehouse provides you direct and secure access to the Data Cloud for sharing your live database with your customers and partners. Also, this allows you to connect with a variety of business organizations acting as data provides, data consumers, or data service providers.
With Data Cloud in Snowflake, the users can obtain and share relevant data with thousands of customers and partners through the integrated platform.
Einstein Analytics Output Connector For Snowflake
This is one of the two major tools coming out of the integration between Salesforce and Snowflake. This tool helps you in seamlessly moving your data from Salesforce to Snowflake and combining it with Snowflake Data Warehouse.
This data can then be queried using the AI tools of Salesforce Einstein Analytics and viewed using the software of Tableau data visualization. This brings together a CRM platform and a data management platform in a productive integration, providing a unified experience to the joint users.
Einstein Analytics Direct Data For Snowflake
As another important tool born out of the integration between Salesforce and Snowflake Data Warehouse, it helps Salesforce Einstein users in querying their data stored within Snowflake simply and seamlessly.
The tool also allows users to query their Salesforce CRM data and the data generated by multiple other channels like business applications, mobile applications, IoT devices, web activities, etc.
Snowflake Data Marketplace
Snowflake Data Marketplace is a new platform that helps the users connect data providers with the consumers using Snowflake Secure Data Sharing. Using this platform, users can access a variety of datasets from external platforms and include them in their Snowflake Data Warehouse for querying without the need for transformation.
Data Marketplace provides you with a single location for sourcing all your data if you tend to use different vendors for sourcing, allowing you to obtain data from suitable data providers and from the software vendors you already use.
Snowsight – A Replacement For SQL Worksheets
This is another new platform launched by Snowflake that helps the users in carrying out effective data analysis. It comes with a variety of features and tools for improved data management.
The Schema Browser helps you instantly search across multiple schemas and databases for the required tables, views, and columns having a specific string. Some of the other major tools and features of Snowsight include:
Reports and Dashboards
Sharing and Collaboration Features
If you have been using the classic web interface and have worksheets saved within the same, you can import these worksheets into the new platform of Snowsight without any hassle.
Search Optimization Service
This new feature of Snowflake Data Warehouse helps the users in improving the overall functionality of the specific point lookup queries on larger data tables.
Once you enable this feature on a table, it speeds up equality searches, filtering on any specific columns having large numbers of distinct values. As of now, the search optimization service supports these data types:
DATE, TIME, and TIMESTAMP
VARCHAR (for exact match)
BINARY (for exact match)