Source - Snowflake

Dataedo has been named a 2020 Gartner Peer Insights Customers' Choice for Metadata Management Solutions. Read our reviews here.

Snowflake + Dataedo = even more value form data

Snowflake is a modern data warehouse built for the cloud. It provides scalability, impeccable performance and support for all your data, including structured and semistructured data. Thanks to that DBAs can focus on high value activities and analyst have a faster access to the data.

Dataedo provides additional layer to Snowflake - metadata management and documentation. It allows you to explain all your tables and columns, document table relationships, visualize the data model, and share everything with your team in convenient, interactive documentation. This makes understanding your databases and querying data easier than ever.

Build a single source of
truth about your data

Further Accelerate BI &
Analytics for All Users

Improve ROI due to better
usage across organization

Take a product tour

Build a data dictionary for your Snowflake data warehouse

Extract data dictionary

Document data model

Auto-update data dictionary

Track changes in schema

Extract data dictionary with a few clicks

Dataedo allows you to connect and scan metadata from multiple data sources and extract data dictionary automatically with just a few clicks. You can quickly export it as a convenient and good looking HTML documentation.

Data dictionary →

Document data model and stored procedures

Dataedo reads stored procedures, user-defined functions and triggers with their script, attributes and parameters, then lets you describe each element and saves in your documentation.

Stored procedures documentation →

Keep data dictionary up to date automatically

Set up automated daily tasks in Windows Scheduler to update schema and generate documentation automatically.

Automate Generation of Database Documentation →

Track changes in schema

Easily track changes in the schema of your databases. Dataedo scans schema of your databases and allows you to track, analyze and comment their changes.

Schema Change Tracking →

Take a product tour

Profile data and analyze data quality in your Snowflake data warehouse

Use sample data to learn what data is stored in your data assets. Dataedo scans all values in selected tables and calculates useful metrics like rows number, percentage of distinct and empty rows. It also shows minimum and maximum values, average, median, span or deviation. This allows you to peak into values itself and identify areas that require improvements.

Take a product tour

Document and visualize relationships in your Snowflake data warehouse

Visualize data model

Import foreign keys

Describe relationships manually

Cross-database relationships

Test new relationships

Visualize data model with ERDs

Visualize your Snowflake databases with ER Diagrams and make them transparent and accessible for everyone. Drag & drop tables to the pane, choose columns to display to understand and explain data model for easier querying, reporting and development.

ER Diagrams →

Import foreign keys

Dataedo reads foreign key constraints from DBMS and adds table relationships to the diagram automatically.

Document Foreign Keys →

Keep data dictionary up to date automatically

It is easy to add relationships in Dataedo data model repository for foreign keys with no FK constraints in the DBMS.

Document relationships manually →

Document and visualize cross-database relationships

Dataedo allows you to define relationships across databases and create cross database ERDs.

Document cross-database relationships →

Verify data integrity with FK Relationship Tester

Verify table relationships with FK Relationship tester. Prevent errors & inconsistencies in data, and save valuable time.

FK Relationship Tester →

Take a product tour

Describe data schema of your Snowflake data warehouse

Organize schema in subject areas

Decode cryptic names

Track Progress

Custom fields

Organize schema in subject areas

Organize complex databases and data environments with subject areas into smaller folders representing a topic, subject area, project etc. to make your data sources more manageable.

Subject Areas →

Decode cryptic names with aliases

Many databases have confusing names of tables and columns. Dataedo helps you fix that issue with the option to add meaningful aliases (titles) for data elements.

Aliases →

Keep data dictionary up to date automatically

Many databases have confusing names of tables and columns. Dataedo helps you fix that issue with the option to add meaningful aliases (titles) for data elements.

Progress tracking →

Add more information with custom fields

Dataedo gives you ability to define custom plain text fields to describe your data. You can define different fields for different elements, like tables, columns, stored procedures etc.

Custom Fields →

Take a product tour

Document and analyze data lineage

Dataedo Desktop

Document data lineage

Connect to Snowflake and import views & tables automatically from dependencies and SQL parsing. You can also create them manually through a simple drag and drop interface. Learn more.

Dataedo Web Catalog

Share data lineage diagrams

Share interactive data lineage diagrams with your team through Dataedo Web Catalog. Understand your data better, easily identify the impact of planned changes, and ensure regulatory compliance through interactive data lineage diagrams. Learn more.

Take a product tour

Discover and classify sensitive data in your Snowflake data warehouse

Scan your databases and find and tag fields holding personal data, so you can know what data you are processing and where to comply with data protection regulations such as GDPR or CCPA.

Dataedo finds fields holding potentially sensitive data automatically from entire data catalog using built-in functions. You and your team can curate metadata tags manually.

Take a product tour

Share complete documentation in convenient format

Dataedo Web Catalog

Self-hosted web portal for self-service data & building data community. Create a place where all people in your organization can go to find, learn about, discuss and contribute their findings about data.

See live sample

Dataedo HTML Docs

Easily export your documentation into lightweight and easily shareable interactive HTML documents. Self-host them on your drive or any web server.

See live sample

PDF & Excel Exports

Additionally, you can quickly export your documentation to PDF and Excel files.

See live sample

Take a product tour

More capabilities

On premises Metadata Repository

Gather all company metadata and allow collaboration in the shared metadata repository.

Metadata scanners for various databases

Connect to your data source, extract data structures and metadata and load them into the repository.

Business Glossary

Build and share a universal glossary of business terms, policies and rules.

Build a community around your Snowflake schema

Data Community allows everyone to share their observations about data through comments, ratings, questions, to-dos, and warnings.

Design database

Easily design new tables and update your database with DDL statements.

Import schema changes

Import changes in structure of your databases in a few simple steps and keep your documentation up to date automatically.

Take a product tour

Why our customers love Dataedo?

"We jump started all of our Data Governance efforts using the tool. We documented key databases quickly and easily and published the information to our analyst community."

Sandra Recca

- Sr. Director

Fitch Ratings, Inc.

"Dataedo is improving my work a lot. With documentation, the learning curve is smaller and I can have more time to work."

Nuno Vieira

- BI Tech Analyst

Hiscox

"Thanks to Dataedo I spent more time figuring out the connection string to the instance than I did running the report. It was a great experience."