What’s changing?
Data Direct offers unfettered access to normalized loan-level data through superQuery, a powerful, web-based SQL Integrated Development Environment (IDE) designed primarily to help data scientists and analysts code faster, improve SQL queries, and multitask with efficiency.
Now, whenever a user cracks a loan tape via Tape Cracker, they can access the cleansed loan data through superQuery. Even more, they can query multiple tapes at once and analyze performance data. Note: Only the most recent version of a loan tape is available.
All Tape Cracker users have a superQuery account. To access your credentials, log in to the Data Direct section of the dv01 web app.
How to:
- Locating loan tapes: Once you’ve logged in to superQuery, navigate to Resources > data-direct to view all cracked loan tapes. Note: Loan tapes will have tape_ appended to the beginning of the file name and the as_of_date to the end.
- Run Query: Click the More icon ⋮ next to your desired tape and select Query to prompt the editor. Run the sample query to easily join multiple tapes. Note: superQuery uses ISO-standard SQL. If you use any variant of SQL, like T-SQL, you may need to adjust your queries to fit the standard syntax.
-- Union multiple tape data together --
with base as (
select
*,
"tape 3" as tape
from
{TAPE3}
union all
select
*,
"tape 4" as tape
from
{TAPE4}
union all
select
*,
"tape 5" as tape
from
{TAPE5}
)
select
tape, count(1) as count
from
base
group by tape
order by tape asc- Visualize Query: Navigate to Chart to present data in different formats, including a bar chart or line graph for time-series performance analysis.
See it in action:
Who is impacted?
All Tape Cracker users
Why is this important?
Unfettered access to loan-level data allows for flexible analysis on cracked loan tapes
Resources