Codatum now supports Snowflake connections. In addition to our existing BigQuery support, this highly requested feature allows you to connect to Snowflake, further expanding your organization's data utilization capabilities.
With this integration, you can use all of Codatum's core features including connecting to Snowflake data, managing metadata through catalogs, executing queries via SQL blocks, and sharing analysis results. Just like with BigQuery, you can now fully leverage Snowflake's powerful data processing capabilities.
Why Snowflake?
Snowflake is a rapidly growing data platform that many companies have recently adopted as their data infrastructure. While there are many reasons for its popularity, here are some of its powerful features:
Flexible Scalability:
The separation of compute resources and storage enables scaling according to needs, offering excellent cost efficiency
Rich DDL and SQL Functionality:
Complete data definition and management operations using SQL, enhancing data engineer productivity
Detailed Permission Management:
Fine-grained role-based access control enables appropriate data governance even in complex organizational structures
Analytics Application Development:
Rich features for building data-driven applications, including Streamlit integration
Key Features and Highlights
With this update, all the key features previously available for BigQuery are now also available for Snowflake in Codatum.
Here are the main features available after connecting to Snowflake:
Catalog
Centrally manage and intuitively browse Snowflake's rich metadata. Visually grasp the hierarchical structure of databases, schemas, tables, and views, and instantly check table details and column definitions.
Notebook (SQL Block)
Create analytical documents combining SQL and text. By compiling Snowflake queries and their results into notebooks along with explanatory text and visualizations, you can clearly record and share analysis processes and results.
Query
Support efficient query creation with syntax highlighting and autocomplete features. Queries can be saved and shared/reused in notebooks, enabling more efficient and standardized analytical work.
Setup Instructions
Connecting to your Snowflake account is simple—just enter your organization name, username, and key-pair authentication information. For detailed connection instructions, please refer to:
Benefits of Snowflake x Codatum
The Codatum Snowflake integration offers the following specific benefits:
Fast Ad-hoc Analysis
The combination of Snowflake's excellent query performance and Codatum's notebook functionality significantly improves ad-hoc analysis efficiency. Codatum notebooks provide an optimal environment for iterative analysis work, allowing you to manage code and context in one place.
With Snowflake's fast processing capabilities, you can quickly obtain results from complex queries on large datasets. Combined with notebook functionality, this shortens analysis iteration cycles and helps you derive deeper insights quickly.
Effective Sharing of Analysis Results and Cost Optimization
One of Codatum's key features—rich result-sharing capabilities—complements Snowflake's data analysis flow. By saving analysis results at specific points in time as Reports or Public Links, you can share them with stakeholders without re-executing queries (depending on parameter settings and cache availability).
These results are safely shared in cache across multiple users, eliminating the need to run the same queries repeatedly and reducing Snowflake compute resource usage and costs. For frequently referenced heavy queries, this feature can provide significant ROI improvements.
Enhanced Data Visualization
By combining Snowflake's rich data with Codatum's advanced visualization capabilities, you can easily create meaningful visualizations from raw data. Generate charts and graphs intuitively without technical knowledge, promoting data-driven decision-making across your entire team.
This complementary relationship allows you to maximize the value of your data by combining Snowflake's powerful data processing capabilities with Codatum's user-friendly interface and sharing features. This combination is ideal for organizations looking to cultivate a data-driven culture!
Future Roadmap
We plan to proceed with Snowflake support according to the following schedule:
April 2025: Beta version available, collecting feedback from selected users
May 2025 onwards: General Availability (GA) release planned
Continuing expansion of supported data warehouses in the future
User Support
The Snowflake beta feature is already available. Users who have already signed up can create Snowflake connections directly from the Connection screen.
How to Provide Feedback
Please share your impressions of the beta version and feature requests on the following page:
Support Resources
For detailed setup and usage instructions for Snowflake connections, please refer to the following documentation:
If you have any questions or concerns, please don't hesitate to contact our support team. We will do our best to ensure smooth usage even during the beta period.
Conclusion
By combining Snowflake's powerful data processing engine and robust governance features with Codatum's ad-hoc analysis, intuitive visualization, and efficient sharing capabilities, you can maximize the inherent value of your data.
Please try the beta version and share your opinions with us. We will continue to improve our product based on your feedback to make it even more user-friendly.
