Snowflake is an analytic data warehouse provided as Software-as-a-Service (SaaS). The Snowflake data warehouse uses a SQL database engine with a unique architecture designed for the Cloud.
In Enterprise Data Catalog (EDC) 10.5.0, Informatica has introduced a new version of the Snowflake scanner to be able to better support the Snowflake metadata extraction in the long term. This new version is based on Advanced scanner technology and has the following capabilities:
- Support metadata extraction for code database objects:
- Databases
- Schemas
- Tables (Permanent, Transient)
- Views, Materialized views, Secure views
- Support view to tables lineage extraction leveraging the Informatica Adv. Scanner parsing capabilities enhanced to support Snowflake SQL variations
- Support cross schema/database linking via connection assignment
- Support for profiling, data domain discovery, similarity and value frequency profiling, Unique Key inference
- Auto business term inference
Note: Any enrichments (business term association, title/description/custom attribute value updates, reviews, questions, and answers associated with the object extracted by the old version will not be automatically copied over to the objects extracted with the new version.
- EDC Version should be higher or equal to 10.5.0.1
- Advanced Scanner application Installed and configured
- License including the “Scanner V2 for Snowflake core metadata”
- Basic knowledge of Enterprise Data Catalog (EDC) Advanced Scanner (Metadex) tool
- Access to the Metadex project to create configuration and run jobs
- Understand the configuration of the Snowflake Metadex scanner.
- Understand the prerequisites and permissions for configuring Snowflake Advanced Scanners
- Understand the objects and metadata extracted
- Comprehend the overall process involved in configuring the Snowflake Metadex scanners and the metadata extracted
- Architects
- Developers
- Data Analysts
Ask An Expert
Feature Clarity
Enterprise Data Catalog
Ask An Expert
Configure
Implement
Optimize
Adoption - Technical
Functional
AAE-EDC-002
Disclaimer
- All the topics covered in the Success Accelerators/Ask An Expert sessions are intended for guidance and advisory only. This is implicit and it will not be called out under the scope of each engagement.
- Customers need to include their relevant technical/business team members highlighted in each engagement topic to derive the best out of each engagement.
- Customers need to perform any hands-on work by themselves leveraging the guidance from these engagements.
- Customers need to work with Informatica Global Customer Support for any product bugs/issues and troubleshooting.