Can you convert an Easy Morph data pull to a SQL query?

1

Greetings,

Is there a way to extract the native SQL query from an EasyMorph project?

For example in EasyMorph, if I bring in fct_sales and dim_date_tbl from my DB, merge it on dateid, and filter on 2020 could I extract the underlying SQL query?

In this example after I do the data pull in EM I'd be looking to extract something like this:

SELECT * 
FROM fct_sales AS F
LEFT JOIN dim_date_tbl AS DD
ON DD.dateid = F.dateid
WHERE DD.year = '2020'

Im not sure if this is possible but it would be amazing. I'm very new to EM but I love it so far and I apologize if this is a stupid question.

Thanks!

2

Hello @AaronRose, and welcome to the Community!

EasyMorph transforms data in-memory and doesn't have underlying SQL queries. So what's you asking is not possible currently.

1 Like
3

Ok thank you!