Using External Tables Inside Snowflake to work with Freddie Mac public data (13 million loans across 116 fields)
Using Freddie Mac public loan data as an example, this five-minute tutorial succinctly demonstrates how to:
- Create a storage integration
- Create an external stage
- Grant access to stage to other roles in Snowflake
- List objects in a stage
- Create a format file
- Read/Query data from external stage without having to create a table
- Create and use an external table in Snowflake
This is the third in a 10-part tutorial series demonstrating how RiskSpan’s Snowflake integration makes mortgage and structured finance analytics easier than ever before.
Episode 1, Setting Up a Database and Uploading 28 Million Mortgage Loans, is available here.
Episode 2, Using Python User-Defined Functions in Snowflake SQL, is available here.
Future topics will include:
- OLAP vs OLTP and hybrid tables in Snowflake
- Time Travel functionality, clone and data replication
- Normalizing data and creating a single materialized view
- Dynamic tables data concepts in Snowflake
- Data share
- Data masking
- Snowpark: Data analysis (pandas) functionality in Snowflake