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:

1. Create a storage integration
2. Create an external stage
3. Grant access to stage to other roles in Snowflake
4. List objects in a stage
5. Create a format file
6. Read/Query data from external stage without having to create a table
7. 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

Learn how to use Python User-Defined Functions in Snowflake SQL

Using CPR computation for a pool of mortgage loans as an example, this six-minute tutorial succinctly demonstrates how to:

1. Query Snowflake data using SQL
2. Write and execute Python user-defined functions inside Snowflake
3. Compute CDR using Python UDF inside Snowflake SQL

This is this second 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.

Future topics will include:

• External Tables (accessing data without a database)
• 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

Learn how to create a new Snowflake database and upload large loan-level datasets

The first episode of RiskSpan’s Snowflake Tutorial Series has dropped!

This six-minute tutorial succinctly demonstrates how to:

1. Set up a new Snowflake #database
2. Use SnowSQL to load large datasets (28 million #mortgage loans in this example)
3. Use internal staging (without a #cloud provider)

This is this first in what is expected to be a 10-part tutorial series demonstrating how RiskSpan’s Snowflake integration makes mortgage and structured finance analytics easier than ever before.

Future topics will include:

• Executing complex queries using python functions in Snowflake’s SQL
• External Tables (accessing data without a database)
• 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