Build Maps & Dashboards with Snowflake: A Step-by-Step Guide

Connect Snowflake directly with Felt for instant maps and performant data dashboards.

Snowflake: Cloud-native data warehouse that separates storage and compute

In the world of geospatial data management, Snowflake has become the tool of choice for many large enterprises for its ability to handle huge data loads. Moreover, it's unique ability to separate compute and storage allows for huge efficiency gains and cost savings. For those working in GIS, Snowflake also natively supports GEOGRAPHY and GEOMETRY columns types, making it very easy to work with geospatial data using the familiar SQL syntax.

Felt: Innovating the Location Data Landscape

At Felt, we're committed to pushing the boundaries of what's possible in geospatial technology. Our platform has been continuously evolving, introducing features that make mapping and spatial analysis more accessible and powerful than ever before. Today, we're thrilled to announce our latest innovation: direct integration with Snowflake.

Book a demo

Connecting Your Snowflake Database to Felt: A Simple Guide

Getting data from Snowflake visualized in Felt is now easier than ever. Here's how you can set it up in just a few steps:

Create a new, read-only user on your Snowflake database for Felt access.
In Felt, click on the Library in the toolbar.
Click "+ New Source" and select "Snowflake".
Enter your connection details, including host, port, database name, and credentials.
Click "Connect", and voilà! You'll see a catalog of your data with previews.
Make it live from the layer preview at a refresh cadence of your choice.

Once connected, you can easily add any of these layers to your spatial dashboards, bringing your database directly into your Felt workspace.

See how easy it is to visualize your Snowflake data in Felt.

Watch now

Unleashing the Power of Your Location Data with Components

But we didn't stop at just connecting your database. Felt's integration with Snowflake unlocks a whole new world of possibilities, including our powerful Components feature. Components allow you to create interactive and informative dashboards that bring your Snowflake data to life.

Build any app or dashboard on top of your Snowflake database.

Here's what you can do:

Statistic Component: Quickly summarize numeric values into essential metrics. Whether you need to show the count of features or calculate sums, averages, minimums, maximums, or medians, this component provides instant insights.
Bar Chart Component: Visualize and compare categories effortlessly. Perfect for comparing sales performance across different regions or visualizing user demographics.
Histogram Component: Identify data patterns and trends by displaying frequency distributions. Great for understanding the spread of data points, such as age distributions or elevation profiles.
Filter Component: Drill down into your data with on-the-fly filtering. Use dropdown menus for categorical data or sliders for numeric ranges, allowing users to focus on the most relevant information.
Time Series Component: Explore spatial trends over time with an intuitive time slider. Ideal for tracking changes in your data across different time periods, from hourly traffic patterns to yearly temperature variations.

Unlike business intelligence tools like Tableau, Felt’s Components were built from the ground up to handle spatial data analysis. These components work seamlessly with your Snowflake data tables, updating in real-time as you pan and zoom your map or apply filters. This dynamic interaction between your database and Felt's visualization tools opens up new avenues for insight and decision-making.

More Than Just a Connection

Felt handles all your formats and use cases.

Our Snowflake integration is designed to make your workflow as smooth as possible:

Live Data Updates: Keep your maps, dashboards, and components in sync with your database. Set up automatic refreshes or update on demand.
Geomatching and Geocoding: Leverage Felt's advanced features to enrich your Snowflake datasets, matching geometries or adding location data to your tables.
Collaborative Mapping: Share your Snowflake layers and interactive dashboards with your team, fostering collaboration and insights across your organization.
Automatic Field Population: Felt intelligently populates fields based on your Snowflake data structure.
Granular Access Control: We're working on an allowlist feature to give you fine-grained control over who can access your Snowflake data within Felt.

By bringing Snowflake and Felt together, we're creating a powerful ecosystem for spatial data analysis and visualization. Whether you're a city planner working with infrastructure data, a researcher analyzing environmental patterns, or a business intelligence expert mapping market trends, this integration opens up new avenues for insight and decision-making.

Stay tuned for more updates as we continue to enhance this integration. We can't wait to see what you'll create with the combined power of Snowflake and Felt!

Ready to supercharge your spatial data analysis? Contact our sales team to learn more about how Felt's Snowflake integration can transform your workflow.

‍